View performance and SQL monitoring details

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

Procedure

1. Log in to the OceanBase Cloud console.

2. In the left-side navigation pane, click Instances.

3. On the Instances page, find the target cluster instance and click the expand icon next to the instance name.

4. Find the target tenant and click the tenant name.

5. On the Overview page of the tenant, click Metrics in the left-side navigation pane.

6. By default, the Performance and SQL tab automatically appears and shows the monitoring data in the last hour.

   The following table shows the performance metrics that you can view.

   Metric	Metric name	Unit	Description
   QPS	sql_all_count sql_delete_count sql_insert_count sql_other_count sql_replace_count sql_select_count sql_update_count	times/s	The number of SQL statements processed per second. The number of DELETE statements processed per second. The number of INSERT statements processed per second. The number of other statements that are processed per second, such as data definition language (DDL), data control language (DCL), and data transaction language (DTL) statements. The number of REPLACE statements processed per second. The number of SELECT statements processed per second. The number of UPDATE statements processed per second.
   Response Time (avg)	sql_all_rt sql_delete_rt sql_insert_rt sql_other_rt sql_replace_rt sql_select_rt sql_update_rt	ms	The average time spent in processing an SQL statement. The average time spent in processing a DELETE statement. The average time spent in processing an INSERT statement. The average time spent in processing another type of statement such as a DDL, DCL, or DTL statement. The average time spent in processing a REPLACE statement. The average time spent in processing a SELECT statement. The average time spent in processing an UPDATE statement.
   Response Time (P90)	sql_all_rt_p90 sql_delete_rt_p90 sql_insert_rt_p90 sql_other_rt_p90 sql_replace_rt_p90 sql_select_rt_p90 sql_update_rt_p90	ms	Currently, the data displayed supports the P90 percentile, meaning 90% of requests have a response time below this value. The average time spent in processing an SQL statement. The average time spent in processing a DELETE statement. The average time spent in processing an INSERT statement. The average time spent in processing another type of statement such as a DDL, DCL, or DTL statement. The average time spent in processing a REPLACE statement. The average time spent in processing a SELECT statement. The average time spent in processing an UPDATE statement.
   Response Time (P95)	sql_all_rt_p95 sql_delete_rt_p95 sql_insert_rt_p95 sql_other_rt_p95 sql_replace_rt_p95 sql_select_rt_p95 sql_update_rt_p95	ms	Currently, the data displayed supports the P95 percentile, meaning 95% of requests have a response time below this value. The average time spent in processing an SQL statement. The average time spent in processing a DELETE statement. The average time spent in processing an INSERT statement. The average time spent in processing another type of statement such as a DDL, DCL, or DTL statement. The average time spent in processing a REPLACE statement. The average time spent in processing a SELECT statement. The average time spent in processing an UPDATE statement.
   Response Time (P99)	sql_all_rt_p99 sql_delete_rt_p99 sql_insert_rt_p99 sql_other_rt_p99 sql_replace_rt_p99 sql_select_rt_p99 sql_update_rt_p99	ms	Currently, the data displayed supports the P99 percentile, meaning 99% of requests have a response time below this value. The average time spent in processing an SQL statement. The average time spent in processing a DELETE statement. The average time spent in processing an INSERT statement. The average time spent in processing another type of statement such as a DDL, DCL, or DTL statement. The average time spent in processing a REPLACE statement. The average time spent in processing a SELECT statement. The average time spent in processing an UPDATE statement.
   TPS	transaction_commit_count transaction_count transaction_rollback_count transaction_timeout_count	times/s	Transaction commits per second TPS Rolled back transactions per second Timed-out transactions per second
   Average Transaction Processing Time	transaction_commit_rt transaction_rollback_rt transaction_rt	μs	Average transaction commit latency Average transaction rollback latency Average transaction processing time
   Sessions	active_session all_session	N/A	The number of active sessions. The total number of sessions.
   SQL Execution Plan Type	sql_distributed_count sql_local_count sql_remote_count	times/s	The number of distributed execution plans processed per second. The number of local execution plans processed per second. The number of remote execution plans processed per second.
   Events Waited per Second	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 wait_event_count	times/s	The number of internal wait events that occur per second. The number of I/O wait events that occur per second. The number of latch wait events that occur per second. The number of other types of wait events that occur per second. The number of lock wait events that occur per second. The number of synchronization remote procedure call (RPC) wait events that occur per second. The number of wait events per second.
   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	μs	The average response time of a read request.
   Requests Enqueued and Dequeued per Second	request_dequeue_count request_enqueue_count	times/s	The number of requests exiting the queue. The number of requests entering the queue.
   SQL Request Queue Time	request_queue_time	μs	The wait time of an SQL query in a queue.
   Tenant CPU Usage Rate	ob_cpu_percent	%	The percentage of CPU resources used by tenant threads.
   MemStore Usage Percentage	memstore_percent	%	The MemStore usage.
   RPC Packet Transmission Time	rpc_packet_in_rt rpc_packet_out_rt	μs	The average time spent in receiving an RPC packet. The average time spent in sending an RPC packet.
   Data Volume of RPC Packets per Unit Time	rpc_packet_in rpc_packet_out	Byte	The RPC packet receiving throughput. The RPC packet sending throughput.
   Open Cursor Count	opened_cursors_count	N/A	The number of open cursors.
   Slow SQL Queries	slow_sql_count	N/A	The number of queries.
   Number of waiting events in a specific state for the database	ob_waiteven_count ob_foreground_waitevent_count ob_background_waiteven_count	N/A	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.
   Number of Events in a Specific State	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	N/A	The number of execution events in a specific state in the tenant. The number of execution events in the PARSE state in the tenant. The number of execution events in the PL PARSE state the tenant. The number of execution events in the PLAN CACHE state in the tenant. The number of execution events in the SQL OPTIMIZE state in the tenant. The number of execution events in the SQL EXECUTION state in the tenant. The number of execution events in the PX EXECUTION state in the tenant. The number of execution events in the SEQUENCE LOAD state in the tenant.