Common statistical events|V4.2.1| docs|Distributed Database

Common statistical events

Last Updated：2023-12-25 08:49:40 Updated

Overview

This topic provides an overview of some statistical event information stored in the V$SYSSTAT view. These statistical data can help identify and troubleshoot performance issues. The V$SESSTAT view provides statistical event information for each session. Statistical event information is only valid for the current connected session, and when a session is disconnected, all the statistical event information for that session is updated in the V$SESSTAT view: the values of statistical event information are cleared, and new values are generated for the next session connection. Many statistical events are associated with internal implementations, so they may be subject to changes or removals. Please refer to the actual situation for specific details.

View statistical events

You can use an SQL statement to display all statistical events and their types in alphabetical order in the sys tenant. Here is an example:

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

Common statistical events

Event name	Description	The ID of the statistical event.	Event class
rpc packet in	The cumulative number of RPC packets sent to the current OBServer node.	10000	1
rpc packet in bytes	The cumulative size of RPC packets sent to the current OBServer node.	10001	1
rpc packet out	The cumulative number of RPC packets sent by the current OBServer node.	10002	1
rpc packet out bytes	The cumulative size of RPC packets sent by the current OBServer node.	10003	1
rpc net delay	The cumulative delay from PRC packet sending to receiving, excluding the packet decoding time.	10005	1
rpc net frame delay	The cumulative delay from PRC packet sending to receiving, including the packet decoding time.	10006	1
request dequeue count	The cumulative number of requests popped from the tenant queue.	20001	2
request queue time	The cumulative request queuing time.	20002	2
trans commit log sync time	The total duration for synchronizing the majority of commit logs (clogs).	30000	4
trans commit log sync count	The total number of clogs.	30001	4
trans commit log submit count	The total number of logs committed by transactions.	30002	4
trans start count	The total number of started transactions.	30005	4
trans total used time	The total time spent in executing transactions.	30006	4
trans rollback count	The total number of transactions rolled back.	null	4
trans rollback time	The total time spent in rolling back transactions.	null	4
sql select count	The number of times that the `SELECT` statement is executed.	40000	8
sql select time	The total time spent in executing the `SELECT` statement.	40001	8
sql insert count	The number of `INSERT` statement executions.	40002	8
sql insert time	The total time spent in executing 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 spent in executing the `REPLACE` statement.	40005	8
sql update count	The number of `UPDATE` statement executions.	40006	8
sql update time	The total time spent in executing 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 spent in executing 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 row cache hits.	50,000	16
row cache miss	The number of row cache misses.	50001	16
block cache hit	The number of microblock cache hits.	50008	16
block cache miss	The number of microblock cache misses.	50009	16
io read count	The number of I/O reads.	60000	32
io read delay	The I/O read delay.	60001	32
io read bytes	The size in bytes of data involved in I/O reads.	60002	32
io write count	The number of I/O writes.	60003	32
io write delay	The I/O write delay.	60004	32
io write bytes	The size in bytes of data involved in I/O writes.	60005	32
memstore apply count	The number of write operations performed on the MemTable.	60012	32
memstore apply succ count	The number of successful write operations performed on the MemTable.	60013	32
memstore apply fail count	The number of failed write operations performed on the MemTable.	60014	32
memstore read lock succ count	The number of successful snapshot read checks performed on rows.	60019	32
memstore read lock fail count	The number of failed snapshot read checks performed on rows.	60020	32
memstore write lock succ count	The number of row locks added successfully.	60021	32
memstore write lock fail count	The number of row locks failed to add.	60022	32
memstore wait write lock time	The time spent in waiting for row locks.	60023	32
memstore wait read lock time	The time spent in waiting for snapshot reads.	60024	32
storage read row count	The number of rows read from the storage.	60031	32
io read queue delay	The I/O queue read delay.	60039	32
ssstore read row count	The number of rows read from the SSTable.	60057	32
backup io read delay	The delay in calling the backup I/O read interface.	60012	32
backup io write delay	The delay in calling the backup I/O write interface.	60013	32
cos io read delay	The delay in calling the COS Get interface.	60014	32
cos io write delay	The delay in calling the COS Put interface.	60015	32
clog trans log total size	The sum of the MemTable mutator size and the value of `trans_header`.	80057	256
active memstore used	The size of memory occupied by the active MemTable. The value may be large.	130000	32
total memstore used	The total size of memory occupied by all MemTables.	130001	32
major freeze trigger	The threshold of memory used by MemTables that triggers a major freeze.	130002	32
memstore limit	The total memory available for MemTables.	130004	32
max memory size	The `max_memory` value corresponding to the tenant memory specification.	140002	64
memory usage	The total memory actually used by the tenant.	140003	64
max cpus	The maximum CPU utilization available for the tenant, which is the value of `max_cpu` multiplied by 100.	140005	64
cpu usage	The current CPU utilization of the tenant.	140006	64