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

Common statistical events

Last Updated：2024-04-19 08:42:49 Updated

Overview

This topic describes some statistical events in the V$SYSSTAT view. You can use these statistics to identify and rectify performance issues. The V$SESSTAT view can display statistical event information for every session. The statistical event information is valid only for the currently connected session. When a session is disconnected, all statistical event information of the session is cleared from the V$SESSTAT view. New values are generated after the next session is connected. Many statistical events are associated with internal implementation, and therefore may be deleted or changed. The actual statistical events shall prevail.

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	Event ID	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 RPC packet sending to receiving, excluding the packet decoding time.	10005	1
rpc net frame delay	The cumulative delay from RPC 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.	30009	4
trans rollback time	The total time spent in rolling 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 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
DB time	The total amount of active time of the database, which is an accumulative value of the CPU time and non-idle wait time.	200001	3072
DB CPU	The CPU time consumed by the database in the active state.	200002	3072
background elapsed time	The total amount of time spent on background process execution.	200005	3072
background cpu time	The CPU time consumed by background processes.	200006	3072
non idle wait time	The amount of non-idle wait time, namely, the total amount of time elapsed when the session is in the wait but not idle state.	200010	3072
idle wait time	The amount of idle wait time, namely, the total amount of time elapsed when the session is in the idle wait state.	200011	3072
background database time	The total amount of time spent by background processes in executing database operations.	200012	3072
background database non-idle wait time	The amount of time spent by background processes in executing database operations in the non-idle wait state.	200013	3072
background database idle wait time	The amount of time spent by background processes in executing database operations in the idle wait state.	200014	3072
concurrency wait total time	The total amount of wait time caused by concurrency issues, such as the wait time caused by resource locking.	220001	3072
user io wait total time	The total amount of time waited by user processes for the I/O operations, such as data reads from or data writes to the disk, to complete.	220002	3072
application wait total time	The total amount of wait time caused by the application code, such as the lock waits caused by row-level locking or explicit lock commands.	2200013	3072