Common statistics events|V4.1.0| docs|Distributed Database

Common statistics events

Last Updated：2025-12-05 07:13:32 Updated

Overview

This topic describes the statistics events stored in the V$SYSSTAT view. These statistics can help identify and resolve performance issues. The V$SESSTAT view displays the statistics events of each session. The statistics events of a session are cleared when the session disconnects, and then generated again for the next connected session. Some statistics events are associated with internal implementations and can be modified or dropped. Any modification or drop will take effect as long as it does not violate any applicable laws or regulations or contractual agreements.

Query statistics events

You can execute the following SQL statement in the system tenant to display statistics events and their types in alphabetical order:

obclient> SELECT name FROM v$statname ORDER BY name;

Common statistics events

Statistics event	Description	Statistics event ID	Statistics event type
rpc packet in	The cumulative number of RPC packets received by this OBServer node.	10000	1
rpc packet in bytes	The cumulative size of RPC packets received by this OBServer node.	10001	1
rpc packet out	The cumulative number of RPC packets sent by this OBServer node.	10002	1
rpc packet out bytes	The cumulative size of RPC packets sent by this OBServer node.	10003	1
rpc net delay	The cumulative latency of RPCs from sending to receiving (excluding decode time).	10005	1
rpc net frame delay	The cumulative latency of RPCs from sending to receiving (including decode time).	10006	1
request dequeue count	The cumulative number of requests popped from the tenant queue.	20001	2
request queue time	The cumulative time that requests spend in the queue.	20002	2
trans commit log sync time	The total time taken to synchronize commit logs to the majority.	30000	4
trans commit log sync count	The total number of commit logs synchronized.	30001	4
trans commit log submit count	The total number of logs submitted in transactions.	30002	4
trans start count	The total number of transactions started.	30005	4
trans total used time	The total time taken to execute transactions.	30006	4
trans rollback count	The total number of transactions rolled back.	30009	4
trans rollback time	The total time taken to roll back transactions.	30010	4
sql select count	The number of times that the SELECT statement is executed.	40000	8
sql select time	The total time taken to execute the SELECT statement.	40001	8
sql insert count	The number of times that the INSERT statement is executed.	40002	8
sql insert time	The total time taken to execute the INSERT statement.	40003	8
sql replace count	The number of times that the REPLACE statement is executed.	40004	8
sql replace time	The total time taken to execute the REPLACE statement.	40005	8
sql update count	The number of times that the UPDATE statement is executed.	40006	8
sql update time	The total time taken to execute the UPDATE statement.	40007	8
sql delete count	The number of times that the DELETE statement is executed.	40008	8
sql delete time	The total time taken to execute the DELETE statement.	40009	8
sql local count	The number of times that the LOCAL statement is executed.	40010	8
sql remote count	The number of times that the REMOTE statement is executed.	40011	8
sql distributed count	The number of times that the DISTRIBUTED statement is executed.	40012	8
row cache hit	The number of times that the row cache is hit.	50000	16
row cache miss	The number of times that the row cache misses.	50001	16
block cache hit	The number of times that the microblock cache is hit.	50008	16
block cache miss	The number of times that the microblock cache misses.	50009	16
io read count	The number of read I/O operations.	60000	32
io read delay	The latency of read I/O operations.	60001	32
io read bytes	The size of data involved in read I/O operations.	60002	32
io write count	The number of write I/O operations.	60003	32
io write delay	The latency of write I/O operations.	60004	32
io write bytes	The size of data involved in write I/O operations.	60005	32
memstore apply count	The number of write operations performed by MemTables.	60012	32
memstore apply succ count	The number of successful write operations performed by MemTables.	60013	32
memstore apply fail count	The number of failed write operations performed by MemTables.	60014	32
memstore row count	Not used.	60015	32
memstore read lock succ count	The number of successful snapshot read checks on rows.	60019	32
memstore read lock fail count	The number of failed snapshot read checks on rows.	60020	32
memstore write lock succ count	The number of successful row locks.	60021	32
memstore write lock fail count	The number of failed row locks.	60022	32
memstore wait write lock time	The duration of waiting for row locks.	60023	32
memstore wait read lock time	The duration of waiting for snapshot reads.	60024	32
storage read row count	The number of rows read from storage.	60031	32
io read queue delay	The latency of the read I/O queue.	60039	32
ssstore read row count	The number of rows read from SSTables.	60057	32
backup io read delay	The latency of calling the backup read I/O API.	69012	32
backup io write delay	The latency of calling the backup write I/O API.	69013	32
cos io read delay	The latency of calling the COS Get API.	69014	32
cos io write delay	The latency of calling the COS Put API.	69015	32
clog write count	The number of times that clogs are written to disk.	80040	256
clog write time	The time taken to write clogs to disk.	80041	256
clog trans log total size	The sum of the mutator size of MemTables and the size of trans_header.	80057	256
active memstore used	The memory usage of active MemTables. (The value may be inflated.)	130000	32
total memstore used	The memory usage of total MemTables.	130001	32
major freeze trigger	The memory limit that triggers a freeze of MemTables.	130002	32
memstore limit	The total memory available to MemTables.	130004	32
max memory size	The max_memory value of the tenant.	140002	64
memory usage	The total memory used by the tenant.	140003	64
max cpus	The value of max_cpu × 100 of the tenant.	140005	64
cpu usage	The value of actual CPU usage × 100 of the tenant.	140006	64