Performance and SQL monitoring details - ApsaraDB for OceanBase

On the performance and SQL monitoring details page of a tenant, you can view basic information about the tenant and the monitoring data such as SQL execution status.

View performance and SQL monitoring data

By default, the Performance and SQL tab displays the number of sessions and the execution frequency and response time of general SQL statements in the last hour. You can specify a time period or click fields in a chart to filter the data to view.

The following table describes the performance metrics.

Note

You can click the question mark (?) next to a monitoring metric to view its details.

Monitoring item	Metric	Description
QPS	sql_all_count sql_delete_count sql_insert_count sql_other_count sql_replace_count sql_select_count sql_update_count	The number of a specific type of SQL statements processed per second. Unit: times/s.
Response time	sql_all_rt sql_delete_rt sql_insert_rt sql_other_rt sql_replace_rt sql_select_rt sql_update_rt	The average time consumed to process an SQL statement of a specific type. Unit: μs.
Sessions	all_session active_session	The number of all or active sessions in the tenant database.
SQL execution plans	sql_local_count sql_distribute_count sql_remote_count	The number of executions of a specific type of execution plans. Unit: times/s.
Number of wait events per second	wait_event_count system_event_internal_total_waits system_event_io_total_waits system_event_latch_total_waits system_event_other_total_waits system_event_row_lock_wait_total_waits system_event_sync_rpc_total_waits	The number of a specific type of wait events per second. Unit: times/s.
Average wait time of a wait event	system_event_internal_time_waited system_event_io_total_waits system_event_latch_total_waits system_event_other_total_waits system_event_row_lock_wait_total_waits system_event_sync_rpc_total_waits wait_event_rt	The average wait time of a wait event of a specific type. Unit: μs.
Number of SQL queries entering or exiting the queue per second	request_dequeue_count request_enqueue_count	The number of requests entering or exiting the queue per second. Unit: times/s.
Wait time of an SQL query in a queue	request_queue_time	The wait time of an SQL query in a queue. Unit: μs.
CPU utilization	ob_cpu_percent	The CPU utilization of the tenant. Unit: %.
MEMStore usage	memstore_percent	The MemStore usage of the tenant. Unit: %.
Time consumed in receiving and sending RPC packets	rpc_packet_in_rt rpc_packet_out_rt	The average time consumed in sending or receiving an RPC packet. Unit: μs.
RPC packet throughput per unit time	rpc_packet_in rpc_packet_out	The data amount of RPC packets that are sent and received per unit time. Unit: KB.
Number of open cursors	opened_cursors_count	The number of open cursors.