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

Common statistics events

Last Updated：2025-12-02 02:50:56 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. Then, new statistics events are generated when the next session connects. Some statistics events are related to internal implementations and may be changed or dropped without notice.

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 ID	Statistics 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 dequeued from the tenant queue with POP.	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.	30001	4
trans commit log submit count	The total number of logs committed 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 micro-block cache is hit.	50008	16
block cache miss	The number of times that the micro-block 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 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 trans log total size	The sum of the MemTable mutator size and the trans_header size.	80057	256
active memstore used	The memory usage of active MemTables. (May be larger than the actual value.)	130000	32
total memstore used	The memory usage of all 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 memory size specified in the max_memory parameter 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 CPU usage of the tenant × 100.	140006	64
DB time	The total duration of database activity, which is the sum of the CPU time and the non-idle wait time.	200001	3072
DB CPU	The duration of CPU consumption during database activity.	200002	3072
background elapsed time	The total duration of background process execution.	200005	3072
background cpu time	The duration of CPU consumption by background processes.	200006	3072
non idle wait time	The total duration of non-idle waits, which is the total duration of waits other than idle waits.	200010	3072
idle wait time	The total duration of idle waits.	200011	3072
background database time	The total duration of database operations performed by background processes.	200012	3072
background database non-idle wait time	The total duration of non-idle waits during which background processes perform database operations.	200013	3072
background database idle wait time	The total duration of idle waits during which background processes perform database operations.	200014	3072
concurrency wait total time	The total wait time caused by concurrency issues, such as resource locking.	220001	3072
user io wait total time	The total wait time of user processes in I/O operations (such as data reading and data writing to disk).	220002	3072
application wait total time	The total wait time caused by user application code, such as row-level locking or explicit locking commands.	2200013	3072