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 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.

You can view the following information:

• SQL

  Performance metric	Metric name in English	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	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, such as DDL, DCL, and DTL statements, processed per second Number of Replace statements processed per secondt Number of Select statements processed per second Number of Update statements processed per second
  SQL 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, such as DDL, DCL, and DTL statements 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 Number of sessions
  SQL Execution Plans	sql_distributed_count sql_local_count sql_remote_count	times/s	Number of distributed execution plans processed per second Number of local executions processed per second Number of remote execution plans processed per second
  Number of Execution Events in a State	ob_sql_event	count	Number of execution events in a state Note For more information about the supported states, see the monitoring page.

• Events

  Performance metric	Metric name in English	Unit	Description
  Number of Waiting Events per Second	wait_event_count	times/s	Number of waiting events per second Note For more information about the supported states, see the monitoring page.
  Average Waiting Time	wait_event_rt	ms	Average response time of read requests Note For more information about the supported states, see the monitoring page.
  Number of SQL Requests Entered into the Waiting Queue per Second	request_dequeue_count request_enqueue_count	times/s	Number of requests dequeued from the processing queue Number of requests enqueued into the processing queue
  Request Queue Time	request_queue_time	μs	Waiting time of SQL requests in the waiting queue
  Number of Waiting Events	ob_waitevent_count	count	Number of waiting events

• System Resources

  Performance metric	Metric name in English	Unit	Description
  CPU Usage of the Tenant	ob_cpu_percent	%	CPU usage of the tenant threads
  MEMStore Usage Percentage	memstore_percent	%	MEMStore usage percentage
  Number of Open Cursors	opened_cursors_count	count	Number of open cursors

• Storage Resources

  Performance metric	Metric name in English	Unit	Description
  OceanBase Tenant Memory Usage	ob_tenant_memory_percent	%	Memory usage of the OB tenant.

• RPC

  Metric	Metric Name	Unit	Description
  Rpc packet receive and send time	rpc_packet_in_rt rpc_packet_out_rt	μs	Average time spent on receiving an RPC packet Average time spent on sending an RPC packet
  Rpc packet receive and send data volume per unit time	rpc_packet_in rpc_packet_out	byte	RPC packet receive throughput RPC packet send throughput

• Database status

  Metric	Metric Name	Unit	Description
  Database working time	ob_worktime ob_foreground_worktime ob_background_worktime	s	Database working time Database foreground working time Database background working time
  Database non-idle waiting time	ob_no_idle_waiting_time ob_foreground_no_idle_waiting_time ob_background_no_idle_waiting_time	ms	Database non-idle waiting time Database foreground non-idle waiting time Database background non-idle waiting time
  Number of waiting events in a certain state	ob_waitevent_count ob_foreground_waitevent_count ob_background_waiteven_count	Count	Number of waiting events in a certain state in the database Number of waiting events in a certain state in the database foreground Number of waiting events in a certain state in the database background
  Replica delay	ob_clog_ls_max_replayed_scn	ms	Replica delay