View performance and SQL monitoring details

On the Performance and SQL tab 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.

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

   

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

   Metric	Metric name	Unit	Description
   Single Operation QPS	single_kv_delete_count single_kv_insert_count single_kv_select_count single_kv_update_count single_kv_insert_or_update_count single_kv_replace_count single_kv_increment_count single_kv_append_count single_kv_all_count	times/s	Average number of single deletes per second Average number of single inserts per second Average number of single selects per second Average number of single updates per second Average number of single insert-or-updates per second Average number of single replaces per second Average number of single increments per second Average number of single appends per second Average number of all single operations per second
   Single Operation Response Time	single_kv_delete_rt single_kv_insert_rt single_kv_select_rt single_kv_update_rt single_kv_insert_or_update_rt single_kv_increment_rt single_kv_append_rt single_kv_all_rt	μs	Average response time of single deletes Average response time of single inserts Average response time of single selects Average response time of single updates Average response time of single insert-or-updates Average response time of single increments Average response time of single appends Average response time of all single operations
   Batch Operation QPS	multi_kv_delete_count multi_kv_insert_count multi_kv_select_count multi_kv_update_count multi_kv_insert_or_update_count multi_kv_replace_count multi_kv_increment_count multi_kv_append_count multi_kv_all_count	times/s	Average number of batch deletes per second Average number of batch inserts per second Average number of batch selects per second Average number of batch updates per second Average number of batch insert-or-updates per second Average number of batch replaces per second Average number of batch increments per second Average number of batch appends per second Average number of all batch operations per second
   Batch Operation Response Time	multi_kv_delete_rt multi_kv_insert_rt multi_kv_select_rt multi_kv_update_rt multi_kv_insert_or_update_rt multi_kv_replace_rt multi_kv_increment_rt multi_kv_append_rt multi_kv_all_rt	μs	Average response time of batch deletes Average response time of batch inserts Average response time of batch selects Average response time of batch updates Average response time of batch insert-or-updates Average response time of batch replaces Average response time of batch increments Average response time of batch appends Average response time of all batch operations
   Average Rows in Batch Operations	multi_kv_delete_row multi_kv_insert_row multi_kv_select_row multi_kv_update_row multi_kv_insert_or_update_row multi_kv_replace_row multi_kv_increment_row multi_kv_append_row multi_kv_all_row	count	Average rows in batch deletes Average rows in batch inserts Average rows in batch selects Average rows in batch updates Average rows in batch insert-or-updates Average rows in batch replaces Average rows in batch increments Average rows in batch appends Average rows in all batch operations
   Mixed Batch Operation QPS	batch_kv_select_count batch_kv_hybrid_count batch_kv_all_count	times/s	Average number of mixed batch selects per second Average number of mixed batch hybrid operations per second Average number of all mixed batch operations per second
   Mixed Batch Operation Response Time	batch_kv_select_rt batch_kv_hybrid_rt batch_kv_all_rt	μs	Average response time of mixed batch selects Average response time of mixed batch hybrid operations Average response time of all mixed batch operations
   Average Rows in Mixed Batch Operations	batch_kv_select_row batch_kv_hybrid_row batch_kv_all_row	count	Average rows in mixed batch selects Average rows in mixed batch hybrid operations Average rows in all mixed batch operations
   Query QPS	query_kv_select_count	times/s	Average number of queries per second
   Query Response Time	query_kv_select_rt	μs	Average response time of queries
   Average Rows in Queries	query_kv_select_row	count	Average number of rows in queries
   Query and Mutate QPS	query_and_muate_kv_select_count	times/s	Average number of query-and-mutate operations per second
   Query and Mutate Response Time	query_and_muate_kv_select_rt	μs	Average response time of query-and-mutate operations
   Average Rows in Query and Mutate	query_and_muate_kv_select_row	count	Average number of rows in query-and-mutate operations
   SQL QPS	sql_all_count sql_delete_count sql_insert_count sql_other_count sql_replace_count sql_select_count sql_update_count	times/s	Number of SQL statements processed per second Number of DELETE statements processed per second Number of INSERT statements processed per second Number of other statements (DDL, DCL, DTL) processed per second Number of REPLACE statements processed per second Number of SELECT statements processed per second Number of UPDATE statements processed per second
   Response Time	sql_all_rt sql_delete_rt sql_insert_rt sql_other_rt sql_replace_rt sql_select_rt sql_update_rt	ms	Average processing time of SQL statements Average processing time of DELETE statements Average processing time of INSERT statements Average processing time of other statements (DDL, DCL, DTL) Average processing time of REPLACE statements Average processing time of SELECT statements Average processing time of UPDATE statements
   Sessions	active_session all_session	count	Number of active sessions Total number of sessions
   SQL Execution Plan Type	sql_distributed_count sql_local_count sql_remote_count	times/s	Number of distributed execution plans per second Number of local execution plans per second Number of remote execution plans per second
   Wait Events 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	Number of internal wait events per second Number of I/O wait events per second Number of latch wait events per second Number of other wait events per second Number of lock wait events per second Number of sync RPC wait events per second Total number of wait events per second
   Average Wait Time	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	Average response time of read requests
   Queue Operations per Second	request_dequeue_count request_enqueue_count	times/s	Number of requests dequeued from processing queue Number of requests enqueued to processing queue
   Queue Wait Time	request_queue_time	μs	Wait time of SQL requests in queue
   Tenant CPU Usage	ob_cpu_percent	%	CPU usage of tenant threads
   MemStore Usage	memstore_percent	%	MemStore usage percentage
   RPC Packet Processing Time	rpc_packet_in_rt rpc_packet_out_rt	μs	Average time to receive RPC packets Average time to send RPC packets
   RPC Packet Throughput	rpc_packet_in rpc_packet_out	byte	Incoming RPC packet throughput Outgoing RPC packet throughput
   Open Cursors	opened_cursors_count	count	Number of open cursors
   Database Work Time	ob_worktime ob_foreground_worktime ob_background_worktime	μs	Total database work time Database foreground work time Database background work time
   Database Non-Idle Wait Time	ob_no_idle_waiting_time ob_foreground_no_idle_waiting_time ob_background_no_idle_waiting_time	μs	Total database non-idle wait time Database foreground non-idle wait time Database background non-idle wait time
   Database Wait Events	ob_waiteven_count ob_foreground_waitevent_count ob_background_waiteven_count	count	Number of wait events in tenant database Number of wait events in tenant database foreground Number of wait events in tenant database background
   Database Execution Events	ob_sql_event etc.	count	Number of execution events in specific states Note For a detailed list of supported states, refer to the monitoring page.
   Slow SQL Count	slow_sql_count	count	Number of slow SQL queries