View 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 p99_sql_all_rt	The average time consumed to process an SQL statement of each specific type, and the average time consumed to process SQL statements at the 99th percentile. Unit: ms.
Number of Sessions	all_session active_session	The number of all or active sessions in the tenant database.
SQL Execution Plan Type	sql_local_count sql_distribute_count sql_remote_count	The number of executions of a specific type of execution plans. Unit: times/s.
Events Waited 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 per 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.
Requests Enqueued and Dequeued per Second	request_dequeue_count request_enqueue_count	The number of requests entering or exiting the queue per second. Unit: times/s.
SQL Request Queue Time	request_queue_time	The wait time of an SQL query in a queue. Unit: μs.
CPU Utilization of Tenant	ob_cpu_percent	The CPU utilization of the tenant. Unit: %.
MemStore Usage	memstore_percent	The MemStore usage of the tenant. Unit: %.
RPC Packet Transmission Time	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.
Open Cursor Count	opened_cursors_count	The number of open cursors.
Wait Events in Specific State in Database	ob_waiteven_count ob_foreground_waitevent_count ob_background_waiteven_count	The number of wait events in a specific state in the database of the tenant. The number of wait events in a specific state in the database frontend of the tenant. The number of wait events in a specific state in the database backend of the tenant.
Execution Events in Specific State in Database	ob_sql_event ob_sql_event_in_parse ob_sql_event_in_pl_parse ob_sql_event_in_plan_cache ob_sql_event_in_sql_optimize ob_sql_event_in_sql_execution ob_sql_event_in_px_execution ob_sql_event_in_sequence_load	The number of execution events in a specific state in the database of the tenant. The number of execution events in the PARSE state of the tenant. The number of execution events in the PL PARSE state of the tenant. The number of execution events in the PLAN CACHE state of the tenant. The number of execution events in the SQL OPTIMIZE state of the tenant. The number of execution events in the SQL EXECUTION state of the tenant. The number of execution events in the PX EXECUTION state of the tenant. The number of execution events in the SEQUENCE LOAD state of the tenant.
Slow SQL Statements	slow_sql_count	The number of slow SQL statements.