Monitoring metrics|V3.3.1|OceanBase Cloud Platform|OCP docs|Distributed Database

This topic describes the monitoring metrics in OceanBase Cloud Platform (OCP), including their meanings and how they are calculated.

Category	Metric	Description	Calculation expression
QPS	sql_all_count	The number of statements processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
QPS	sql_select_count	The number of Select statements processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
QPS	sql_insert_count	The number of Insert statements processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
QPS	sql_update_count	The number of Update statements processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
QPS	sql_replace_count	The number of Replace statements processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
QPS	sql_delete_count	The number of Delete statements processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Response time	sql_all_rt	The average processing time of each SQL statement on the server.	(sum(rate(sysstat_value{metric_group="sysstat",stat_id="40003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40007",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40009",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)) /(sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
Response time	sql_select_rt	The average processing time of each Select statement on the server.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Response time	sql_insert_rt	The average processing time of each Insert statement on the server.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Response time	sql_update_rt	The average processing time of each Update statement on the server.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40007",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Response time	sql_replace_rt	The average processing time of each Replace statement on the server.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Response time	sql_delete_rt	The average processing time of each Delete statement on the server.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40009",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Active sessions	active_session	The number of active sessions.	sum(active_sessions{metric_group="all_virtual_processlist",@LABELS}) by (@GBLABELS)
SQL execution plan	sql_local_count	The number of local execution plans processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40010",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
SQL execution plan category	sql_remote_count	The number of remote execution plans processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40011",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
SQL execution plan category	sql_distributed_count	The number of distributed execution plans processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40012",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Wait event	wait_event_count	The average number of wait events per second.	sum(rate(total_waits{metric_group="waitevent",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Waiting for event time	wait_event_rt	The average wait time of a wait event.	sum(rate(time_wait{metric_group="waitevent",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(total_waits{metric_group="waitevent",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request queue	request_queue_count	The average number of SQL statements queued up per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="20001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Time waiting in request queue	request_queue_time	The average waiting time of an SQL statement in a queue.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="20002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="20001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
TPS	transaction_count	The number of transactions processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Transaction response time	transaction_rt	The average processing time of each transaction on the server.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="30005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Number of transaction logs	trans_commit_log_count	The number of transaction logs submitted per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Transaction log volume	clog_trans_log_total_size	The total size of transaction logs submitted per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="80057",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Transaction log time consumption	trans_commit_log_sync_rt	The average time spent on each synchronization of transaction logs over the network.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="30001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Lock wait	memstore_write_lock_succ_count	The number of write lock wait successes.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60021",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Lock wait	memstore_write_lock_fail_count	The number of write lock wait failures.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60022",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Wait for lock time	memstore_write_lock_wait_time	The average wait time of each write lock.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60023",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / (sum(rate(sysstat_value{metric_group="sysstat",stat_id="60021",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="60022",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
MEMStore	total_memstore_used	The total MemStore size.	sum(sysstat_value{metric_group="sysstat",stat_id="130001",@LABELS}) by (@GBLABELS) / 1048576
MEMStore	active_memstore_used	The total size of active MemStores.	sum(sysstat_value{metric_group="sysstat",stat_id="130000",@LABELS}) by (@GBLABELS) / 1048576
IOPS	io_read_count	The number of reads from SSStore per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
IOPS	io_write_count	The number of writes to SSStore per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O time	io_read_rt	The average time spent on each SSStore read.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="60000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O Time	io_write_rt	The average time spent on each SSStore write.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="60003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O throughput	io_read_size	The amount of data read from SSStore per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O throughput	io_write_size	The amount of data written to SSStore per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Cache size	block_cache_size	The size of the block cache.	sum(cache_size{metric_group="all_virtual_kvcache_info",cache_name="user_block_cache",@LABELS}) by (@GBLABELS) / 1048576
Cache size	row_cache_size	The size of the row cache.	sum(cache_size{metric_group="all_virtual_kvcache_info",cache_name="user_row_cache",@LABELS}) by (@GBLABELS) / 1048576
Cache size	plan_cache_size	The size of the plan cache.	sum(mem_used{metric_group="plan_cache_stat",@LABELS}) by (@GBLABELS) / 1048576
Cache retrieval rate	block_cache_hit_ratio	The hit rate of the block cache.	100 * 1 / (1 + sum(rate(sysstat_value{metric_group="sysstat",stat_id="50009",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="50008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
Cache retrieval rate	row_cache_hit_ratio	The hit rate of the row cache.	100 * 1 / (1 + sum(rate(sysstat_value{metric_group="sysstat",stat_id="50001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="50000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
Cache retrieval rate	plan_cache_hit_ratio	The hit rate of the plan cache.	100 * sum(rate(hit_count{metric_group="plan_cache_stat",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(access_count{metric_group="plan_cache_stat",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
QPS	sql_all_count	The number of SQL statements processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Query response time	sql_all_rt	The average processing time of each SQL statement on the server.	(sum(rate(sysstat_value{metric_group="sysstat",stat_id="40003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40007",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40009",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)) /(sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
TPS	transaction_count	The number of transactions processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Transaction response time	transaction_rt	The average processing time of each transaction on the server.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="30005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Active sessions	active_session	The number of active sessions.	sum(active_sessions{metric_group="all_virtual_processlist",@LABELS}) by (@GBLABELS)
Time waiting in request queue	request_queue_time	The average waiting time of an SQL statement in a queue.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="20002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="20001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Linux system load	load1	The average system load in the last 1 minute.	avg(node_load1{@LABELS}) by (@GBLABELS)
Linux system load	load5	The average system load in the last 5 minutes.	avg(node_load5{@LABELS}) by (@GBLABELS)
Linux system load	load15	The average system load in the last 15 minutes.	avg(node_load15{@LABELS}) by (@GBLABELS)
CPU utilization	cpu_percent	The CPU utilization.	100 * (1 - sum(rate(node_cpu_seconds_total{mode="idle", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(node_cpu_seconds_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
Memory	memory_used	The size of the physical memory used.	(avg(node_memory_MemTotal_bytes{@LABELS}) by (@GBLABELS) - avg(node_memory_MemFree_bytes{@LABELS}) by (@GBLABELS) - avg(node_memory_Cached_bytes{@LABELS}) by (@GBLABELS) - avg(node_memory_Buffers_bytes{@LABELS}) by (@GBLABELS)) / 1073741824
Memory	memory_buffers	The size of the kernel buffer cache.	avg(node_memory_Buffers_bytes{@LABELS}) by (@GBLABELS) / 1073741824
Memory	memory_free	The size of the available physical memory.	avg(node_memory_MemFree_bytes{@LABELS}) by (@GBLABELS) / 1073741824
IOPS	io_read	The number of reads per second.	avg(rate(node_disk_reads_completed_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
IOPS	io_write	The number of writes per second.	avg(rate(node_disk_writes_completed_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O time	io_read_time	The average time spent on each I/O read.	1000000 * avg(rate(node_disk_read_time_seconds_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O time	io_write_time	The average time spent on each I/O write.	1000000 * avg(rate(node_disk_write_time_seconds_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O throughput	io_read_byte	The amount of data read each time.	avg(rate(node_disk_read_bytes_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / 1048576
I/O throughput	io_write_byte	The amount of data written each time.	avg(rate(node_disk_written_bytes_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / 1048576
Network throughput	net_recv	The amount of data received per second.	avg(rate(node_network_receive_bytes_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / 1048576
Network throughput	net_send	The amount of data sent per second.	avg(rate(node_network_transmit_bytes_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / 1048576
Number of transaction logs	trans_commit_log_count	The number of transaction logs committed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Transaction log volume	clog_trans_log_total_size	The total size of transaction logs committed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="80057",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Transaction log time consumption	clog_write_disk_rt	The average time spent on writing transaction logs to the disk each time.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="80041",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="80040",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Transaction log time consumption	trans_commit_log_sync_rt	The average time spent on each synchronization of transaction logs over the network.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="30001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
IOPS	io_read_count	The number of reads from SSStore per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
IOPS	io_write_count	The number of writes to SSStore per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O time	io_read_rt	The average time spent on each SSStore read.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="60000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O time	io_write_rt	The average time spent on each SSStore write.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="60003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O throughput	io_read_size	The amount of data read from SSStore per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O throughput	io_write_size	The amount of data written to SSStore per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="60005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
CPU utilization	cpu_percent	The CPU utilization.	100 * (1 - sum(rate(node_cpu_seconds_total{mode="idle", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(node_cpu_seconds_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
QPS	sql_all_count	The number of SQL statements processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Query response time	sql_all_rt	The average processing time of each SQL statement on the server.	(sum(rate(sysstat_value{metric_group="sysstat",stat_id="40003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40007",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40009",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)) /(sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
Active sessions	active_session	The number of active sessions.	sum(active_sessions{metric_group="all_virtual_processlist",@LABELS}) by (@GBLABELS)
QPS	sql_all_count	The number of statements processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
TPS	transaction_count	The number of transactions processed per second.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
SQL response time	sql_all_rt	The average processing time of each SQL statement on the server.	(sum(rate(sysstat_value{metric_group="sysstat",stat_id="40003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40007",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40009",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)) /(sum(rate(sysstat_value{metric_group="sysstat",stat_id="40002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40004",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40008",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="40000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
Transaction response time	transaction_rt	The average processing time of each transaction on the server.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="30006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="30005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Active sessions	active_session	The number of active sessions.	sum(active_sessions{metric_group="all_virtual_processlist",@LABELS}) by (@GBLABELS)
Event waiting_count	wait_event_count	The average number of wait events per second.	sum(rate(total_waits{metric_group="waitevent",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Event waiting time	wait_event_rt	The average wait time of a wait event.	sum(rate(time_wait{metric_group="waitevent",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(total_waits{metric_group="waitevent",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Capacity_tables	table_count	The number of tables.	max(table_count{metric_group="all_table",@LABELS}) by (@GBLABELS)
Capacity_partitions	partition_count	The number of partitions.	sum(partition_count{metric_group="all_meta_table",@LABELS}) by (@GBLABELS)
Transaction log time consumption	clog_write_disk_rt	The average time spent on writing transaction logs to the disk each time.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="80041",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="80040",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
MEMStore	major_freeze_trigger	The threshold that triggers a major compaction.	sum(sysstat_value{metric_group="sysstat",stat_id="130002",@LABELS}) by (@GBLABELS) / 1048576
MEMStore	memstore_limit	The upper limit of the total size of all MemStores.	sum(sysstat_value{metric_group="sysstat",stat_id="130004",@LABELS}) by (@GBLABELS) / 1048576
Linux system load	load1	The average system load in the last 1 minute.	avg(node_load1{@LABELS}) by (@GBLABELS)
Linux system load	load5	The average system load in the last 5 minutes.	avg(node_load5{@LABELS}) by (@GBLABELS)
Linux system load	load15	The average system load in the last 15 minutes.	avg(node_load15{@LABELS}) by (@GBLABELS)
CPU utilization	cpu_percent	The CPU utilization.	100 * (1 - sum(rate(node_cpu_seconds_total{mode="idle", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(node_cpu_seconds_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS))
IOPS	io_read	The number of reads per second.	avg(rate(node_disk_reads_completed_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
IOPS	io_write	The number of writes per second.	avg(rate(node_disk_writes_completed_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O time	io_read_time	The average read time per second.	1000000 * avg(rate(node_disk_read_time_seconds_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O time	io_write_time	The average write time per second.	1000000 * avg(rate(node_disk_write_time_seconds_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
I/O throughput	io_read_byte	The amount of data read each time.	avg(rate(node_disk_read_bytes_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / 1048576
I/O throughput	io_write_byte	The amount of data written each time.	avg(rate(node_disk_written_bytes_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / 1048576
Network throughput	net_recv	The amount of data received per second.	avg(rate(node_network_receive_bytes_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / 1048576
Network throughput	net_send	The amount of data sent per second.	avg(rate(node_network_transmit_bytes_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / 1048576
Memory	memory_used	The size of the physical memory used.	(avg(node_memory_MemTotal_bytes{@LABELS}) by (@GBLABELS) - avg(node_memory_MemFree_bytes{@LABELS}) by (@GBLABELS) - avg(node_memory_Cached_bytes{@LABELS}) by (@GBLABELS) - avg(node_memory_Buffers_bytes{@LABELS}) by (@GBLABELS)) / 1073741824
Memory	memory_buffers	The size of the kernel buffer cache.	avg(node_memory_Buffers_bytes{@LABELS}) by (@GBLABELS) / 1073741824
Memory	memory_free	The size of the available physical memory.	avg(node_memory_MemFree_bytes{@LABELS}) by (@GBLABELS) / 1073741824
Disk	host_disk_used	The size of used space in the disk partition.	sum(host_partition_volume_used{@LABELS}) by (@GBLABELS)
transaction	transaction_total	The number of transactions per second.	sum(rate(odp_transaction_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_commit	The number of COMMIT requests per second.	sum(rate(odp_sql_request_total{sqltype="COMMIT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_delete	The number of DELETE requests per second.	sum(rate(odp_sql_request_total{sqltype="DELETE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_insert	The number of INSERT requests per second.	sum(rate(odp_sql_request_total{sqltype="INSERT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_large	The number of large requests per second.	sum(rate(odp_sql_request_total{sqlLarge = "large", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_select	The number of SELECT requests per second.	sum(rate(odp_sql_request_total{sqltype="SELECT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_sequence	The number of SEQUENCE requests per second.	sum(rate(odp_sql_request_total{sqltype="SEQUENCE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_slow	The number of slow queries per second.	sum(rate(odp_sql_request_total{slowQuery = "true", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_update	The number of UPDATE requests per second.	sum(rate(odp_sql_request_total{sqltype="UPDATE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_others	The number of other requests per second.	sum(rate(odp_sql_request_total{sqltype="OTHERS", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
connection_client	current_session_client	The number of connected clients.	sum(odp_current_session{sessionType="client",@LABELS}) by (@GBLABELS)
connection_server	current_session_server	The number of server connections.	sum(odp_current_session{sessionType="server",@LABELS}) by (@GBLABELS)
sql_response_time	request_cost_commit	The average time spent on handling each COMMIT request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="COMMIT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="COMMIT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_delete	The average time spent on handling each DELETE request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="DELETE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="DELETE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_insert	The average time spent on handling each INSERT request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="INSERT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="INSERT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_prepare_send_request_time	The average time spent on preparing for sending each request.	sum(rate(odp_sql_cost_total{timeType="prepare", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_server_process_request_time	The average request processing time by the server.	sum(rate(odp_sql_cost_total{timeType="server", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_select	The average time spent on handling each SELECT request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="SELECT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="SELECT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_sequence	The average time spent on handling each SEQUENCE request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="SEQUENCE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="SEQUENCE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_update	The average time spent on handling each UPDATE request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="UPDATE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="UPDATE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_others	The average time spent on handling other requests.	sum(rate(odp_sql_cost_total{sqltype="OTHERS", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="OTHERS", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
error_package	elogs_total_error	The average number of error logs per second.	sum(rate(odp_elogs_total{logType = "error",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
error_package	elogs_total_warn	The average number of warn logs per second.	sum(rate(odp_elogs_total{logType = "warn",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_hit	The average number of route table hits per second.	sum(rate(odp_entry_total{routeHit="true",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_partition	The average number of partition entry queries per second.	sum(rate(odp_entry_total{entryType="partition_entry",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_route	The average number of route entry queries per second.	sum(rate(odp_entry_total{entryType="route",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_success	The average number of successful route table queries per second.	sum(rate(odp_entry_total{routeResult="true",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_table	The average number of table entry queries per second.	sum(rate(odp_entry_total{entryType="table_entry",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
net_request_bytes	request_byte_client_request	The size of client request in bytes.	sum(rate(odp_request_byte{sessionType="client",transType="request",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
net_request_bytes	request_byte_client_response	The size of client response in bytes.	sum(rate(odp_request_byte{sessionType="client",transType="response",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
net_request_bytes	request_byte_server_request	The size of server request in bytes.	sum(rate(odp_request_byte{sessionType="server",transType="request",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
net_request_bytes	request_byte_server_response	The size of server response in bytes.	sum(rate(odp_request_byte{sessionType="server",transType="response",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Transaction	transaction_total	The number of transactions per second.	sum(rate(odp_transaction_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_commit	The number of COMMIT requests per second.	sum(rate(odp_sql_request_total{sqltype="COMMIT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_delete	The number of DELETE requests per second.	sum(rate(odp_sql_request_total{sqltype="DELETE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_insert	The number of INSERT requests per second.	sum(rate(odp_sql_request_total{sqltype="INSERT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_large	The number of large requests per second.	sum(rate(odp_sql_request_total{sqlLarge = "large", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_select	The number of SELECT requests per second.	sum(rate(odp_sql_request_total{sqltype="SELECT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_sequence	The number of SEQUENCE requests per second.	sum(rate(odp_sql_request_total{sqltype="SEQUENCE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_slow	The number of slow queries per second.	sum(rate(odp_sql_request_total{slowQuery = "true", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_update	The number of UPDATE requests per second.	sum(rate(odp_sql_request_total{sqltype="UPDATE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
Request	request_total_others	The number of other requests per second.	sum(rate(odp_sql_request_total{sqltype="OTHERS", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
connection_client	current_session_client	The number of connected clients.	sum(odp_current_session{sessionType="client",@LABELS}) by (@GBLABELS)
connection_server	current_session_server	The number of server connections.	sum(odp_current_session{sessionType="server",@LABELS}) by (@GBLABELS)
sql_response_time	request_cost_commit	The average time spent on handling each COMMIT request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="COMMIT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="COMMIT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_delete	The average time spent on handling each DELETE request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="DELETE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="DELETE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_insert	The average time spent on handling each INSERT request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="INSERT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="INSERT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_prepare_send_request_time	The average time spent on preparing for sending each request.	sum(rate(odp_sql_cost_total{timeType="prepare", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_server_process_request_time	The average request processing time by the server.	sum(rate(odp_sql_cost_total{timeType="server", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_select	The average time spent on handling each SELECT request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="SELECT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="SELECT", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_sequence	The average time spent on handling each SEQUENCE request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="SEQUENCE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="SEQUENCE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_update	The average time spent on handling each UPDATE request.	sum(rate(odp_sql_cost_total{timeType="total",sqltype="UPDATE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="UPDATE", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
sql_response_time	request_cost_others	The average time spent on handling other requests.	sum(rate(odp_sql_cost_total{sqltype="OTHERS", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) / sum(rate(odp_sql_request_total{sqltype="OTHERS", @LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
error_package	elogs_total_error	The average number of error logs per second.	sum(rate(odp_elogs_total{logType = "error",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
error_package	elogs_total_warn	The average number of warn logs per second.	sum(rate(odp_elogs_total{logType = "warn",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_hit	The average number of route table hits per second.	sum(rate(odp_entry_total{routeHit="true",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_partition	The average number of partition entry queries per second.	sum(rate(odp_entry_total{entryType="partition_entry",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_route	The average number of route entry queries per second.	sum(rate(odp_entry_total{entryType="route",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_success	The average number of successful route table queries per second.	sum(rate(odp_entry_total{routeResult="true",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
route_table	entry_total_table	The average number of table entry queries per second.	sum(rate(odp_entry_total{entryType="table_entry",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
net_request_bytes	request_byte_client_request	The size of client request in bytes.	sum(rate(odp_request_byte{sessionType="client",transType="request",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
net_request_bytes	request_byte_client_response	The size of client response in bytes.	sum(rate(odp_request_byte{sessionType="client",transType="response",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
net_request_bytes	request_byte_server_request	The size of server request in bytes.	sum(rate(odp_request_byte{sessionType="server",transType="request",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
net_request_bytes	request_byte_server_response	The size of server response in bytes.	sum(rate(odp_request_byte{sessionType="server",transType="response",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
CPU utilization	ob_cpu_percent	The CPU utilization of the tenant.	100 * sum(sysstat_value{metric_group="sysstat",stat_id="140006",@LABELS}) by (@GBLABELS) / sum(sysstat_value{metric_group="sysstat",stat_id="140005",@LABELS}) by (@GBLABELS)
MEMStore	tenant_memory_usage_percent	The percentage of MemStore usage by the tenant.	100 * avg(mem_used{metric_group="tenant_memory_info",@LABELS}) by (@GBLABELS) / avg(mem_hold{metric_group="tenant_memory_info",@LABELS}) by (@GBLABELS)'
RPC package throughput	rpc_packet_in_bytes	The amount of data in bytes of RPC packets received per unit time.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="20001",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
RPC package throughput	rpc_packet_out_bytes	The amount of data in bytes of RPC packets sent per unit time.	sum(rate(sysstat_value{metric_group="sysstat",stat_id="10003",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
RPC packet response time	rpc_packet_in_rt	The average time in microseconds for receiving an RPC packet.	(sum(rate(sysstat_value{metric_group="sysstat",stat_id="10005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="10006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="10000",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)
RPC packet response time	rpc_packet_out_rt	The average time in microseconds for sending an RPC packet.	(sum(rate(sysstat_value{metric_group="sysstat",stat_id="10005",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS) + sum(rate(sysstat_value{metric_group="sysstat",stat_id="10006",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)) / sum(rate(sysstat_value{metric_group="sysstat",stat_id="10002",@LABELS}[@INTERVAL]) by (@GBLABELS)) by (@GBLABELS)

Customer Stories

Documentation

Community Edition

Enterprise Edition

Monitoring metrics