Note
- This view is available starting with V4.3.5 for V4.3.x.
- This view is available starting with V4.2.2 for V4.2.x.
Purpose
The DBA_WR_SQLSTAT view displays basic performance statistics of SQL statements executed in the current tenant. Each SQL statement is represented as a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). The columns with _DELTA in their names indicate the incremental values from the last WR snapshot collection to the current time.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SNAP_ID | bigint(20) | NO | Snapshot ID |
| SVR_IP | varchar(46) | NO | Node IP |
| SVR_PORT | bigint(20) | NO | Node port number |
| SQL_ID | varchar(32) | NO | SQL statement ID |
| PLAN_HASH | bigint(20) unsigned | NO | Hash value of the execution plan |
| PLAN_ID | bigint(20) | NO | Execution plan ID |
| PLAN_TYPE | bigint(20) | NO | For SQL plan caching, this column indicates the plan type:
For PL object caching, this column indicates the type of the PL object:
|
| MODULE | varchar(64) | YES | The application module when the statement was first parsed. |
| ACTION | varchar(64) | YES | The application action when the statement was first parsed. |
| PARSING_DB_ID | bigint(20) | NO | Database ID when the statement was parsed. |
| PARSING_DB_NAME | varchar(128) | NO | Database name when the statement was parsed. |
| PARSING_USER_ID | bigint(20) | NO | User ID when the statement was parsed. |
| EXECUTIONS_TOTAL | bigint(20) | NO | Total number of executions of the plan in the plan cache. |
| EXECUTIONS_DELTA | bigint(20) | NO | Increment of the total number of executions of the plan in the plan cache. |
| DISK_READS_TOTAL | bigint(20) | NO | Total number of disk reads. |
| DISK_READS_DELTA | bigint(20) | NO | Increment of the total number of disk reads. |
| BUFFER_GETS_TOTAL | bigint(20) | NO | Total number of logical reads from the cache. |
| BUFFER_GETS_DELTA | bigint(20) | NO | Increment of the total number of logical reads from the cache. |
| ELAPSED_TIME_TOTAL | bigint(20) | NO | Total time consumed by the statement. For parallel execution, this value is the sum of the values for each execution thread. |
| ELAPSED_TIME_DELTA | bigint(20) | NO | Increment of the time consumed by the statement. |
| CPU_TIME_TOTAL | bigint(20) | NO | Total CPU time consumed. |
| CPU_TIME_DELTA | bigint(20) | NO | Increment of the total CPU time consumed. |
| CCWAIT_TOTAL | bigint(20) | NO | Total time consumed by concurrency-related wait events. |
| CCWAIT_DELTA | bigint(20) | NO | Increment of the total time consumed by concurrency-related wait events. |
| USERIO_WAIT_TOTAL | bigint(20) | NO | Total time consumed by I/O waits. |
| USERIO_WAIT_DELTA | bigint(20) | NO | Increment of the total time consumed by I/O waits. |
| APWAIT_TOTAL | bigint(20) | NO | Total time consumed by application-related wait events. |
| APWAIT_DELTA | bigint(20) | NO | Increment of the total time consumed by application-related wait events. |
| PHYSICAL_READ_REQUESTS_TOTAL | bigint(20) | NO | Total number of physical read requests. |
| PHYSICAL_READ_REQUESTS_DELTA | bigint(20) | NO | Increment of the total number of physical read requests. |
| PHYSICAL_READ_BYTES_TOTAL | bigint(20) | NO | Total number of bytes read. |
| PHYSICAL_READ_BYTES_DELTA | bigint(20) | NO | Increment of the total number of bytes read. |
| WRITE_THROTTLE_TOTAL | bigint(20) | NO | Total time when write throttling occurs during MemStore writes. |
| WRITE_THROTTLE_DELTA | bigint(20) | NO | Increment of the total time when write throttling occurs during MemStore writes. |
| ROWS_PROCESSED_TOTAL | bigint(20) | NO | Total number of rows processed by the statement. |
| ROWS_PROCESSED_DELTA | bigint(20) | NO | The incremental number of rows processed by the statement. |
| MEMSTORE_READ_ROWS_TOTAL | bigint(20) | NO | The total number of rows read from the MemStore. |
| MEMSTORE_READ_ROWS_DELTA | bigint(20) | NO | The incremental number of rows read from the MemStore. |
| MINOR_SSSTORE_READ_ROWS_TOTAL | bigint(20) | NO | The total number of rows read from the MINOR SSStore. |
| MINOR_SSSTORE_READ_ROWS_DELTA | bigint(20) | NO | The incremental number of rows read from the MINOR SSStore. |
| MAJOR_SSSTORE_READ_ROWS_TOTAL | bigint(20) | NO | The total number of rows read from the MAJOR SSStore. |
| MAJOR_SSSTORE_READ_ROWS_DELTA | bigint(20) | NO | The incremental number of rows read from the MAJOR SSStore. |
| RPC_TOTAL | bigint(20) | NO | The total number of RPC requests. |
| RPC_DELTA | bigint(20) | NO | The incremental number of RPC requests. |
| FETCHES_TOTAL | bigint(20) | NO | The total number of result set fetches. |
| FETCHES_DELTA | bigint(20) | NO | The incremental number of result set fetches. |
| RETRY_TOTAL | bigint(20) | NO | The total number of SQL retries. |
| RETRY_DELTA | bigint(20) | NO | The incremental number of SQL retries. |
| PARTITION_TOTAL | bigint(20) | NO | The total number of partitions scanned by the SQL statement. |
| PARTITION_DELTA | bigint(20) | NO | The incremental number of partitions scanned by the SQL statement. |
| NESTED_SQL_TOTAL | bigint(20) | NO | The total number of nested SQL statements executed. Each time a sub-SQL statement is executed, the value increases by 1. |
| NESTED_SQL_DELTA | bigint(20) | NO | The incremental number of nested SQL statements executed. |
| SOURCE_IP | varchar(46) | NO | The IP address of the request source. |
| SOURCE_PORT | bigint(20) | NO | The port number of the request source. |
| ROUTE_MISS_TOTAL | bigint(20) | NO | The total number of times that the request partition is not hit since the OBServer was started
Note
|
| ROUTE_MISS_DELTA | bigint(20) | NO | The number of times that the request partition is not hit since the last WR snapshot was collected
Note
|
| FIRST_LOAD_TIME | timestamp(6) | YES | The time when the plan was generated
Note
|
| PLAN_CACHE_HIT_TOTAL | bigint(20) | NO | The total number of times that the plan cache was hit since the OBServer was started
Note
|
| PLAN_CACHE_HIT_DELTA | bigint(20) | NO | The number of times that the plan cache was hit since the last WR snapshot was collected
Note
|
| MUTI_QUERY_TOTAL | bigint(20) | NO | The number of times that the SQL statement is in a multi-query since the execution plan was generated
NoteFor V4.6.x, this column is available starting with V4.6.0. |
| MUTI_QUERY_DELTA | bigint(20) | NO | The number of times that the SQL statement is in a multi-query since the last WR snapshot was collected
NoteFor V4.6.x, this column is available starting with V4.6.0. |
| MUTI_QUERY_BATCH_TOTAL | bigint(20) | NO | The number of times that the SQL batch is executed since the execution plan was generated
NoteFor V4.6.x, this column is available starting with V4.6.0. |
| MUTI_QUERY_BATCH_DELTA | bigint(20) | NO | The number of times the SQL batch has been executed since the last WR snapshot was collected.
NoteFor V4.6.x, this column was introduced starting from V4.6.0. |
| FULL_TABLE_SCAN_TOTAL | bigint(20) | NO | The number of full table scans performed by the SQL since the execution plan was generated.
NoteFor V4.6.x, this column was introduced starting from V4.6.0. |
| FULL_TABLE_SCAN_DELTA | bigint(20) | NO | The number of full table scans performed by the SQL since the last WR snapshot was collected.
NoteFor V4.6.x, this column was introduced starting from V4.6.0. |
| ERROR_COUNT_TOTAL | bigint(20) | NO | The number of errors reported by the SQL since the execution plan was generated.
NoteFor V4.6.x, this column was introduced starting from V4.6.0. |
| ERROR_COUNT_DELTA | bigint(20) | NO | The number of errors reported by the SQL since the last WR snapshot was collected.
NoteFor V4.6.x, this column was introduced starting from V4.6.0. |
| SAMPLE_TIME | timestamp(6) | NO | The time when the SQLSTAT snapshot was written to disk. In one WR snapshot interval, the SQLSTAT snapshot may be written to disk multiple times.
NoteFor V4.6.x, this column was introduced starting from V4.6.0. |
| LATEST_ACTIVE_TIME | timestamp(6) | YES | The last active time of the plan corresponding to the SQL ID and plan hash on a node.
NoteFor V4.6.x, this column was introduced starting from V4.6.0. |
Sample query
Query the basic performance statistics of SQL statements executed in the current tenant and display the first record.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_WR_SQLSTAT LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
SNAP_ID: 1
SVR_IP: xx.xx.xx.xx
SVR_PORT: 2882
SQL_ID: 01058E374A5EF26873BA4D99C4A74582
PLAN_HASH: 5547575357486659143
PLAN_TYPE: 0
MODULE: NULL
ACTION: NULL
PARSING_DB_ID: 0
PARSING_DB_NAME:
PARSING_USER_ID: 0
EXECUTIONS_TOTAL: 1
EXECUTIONS_DELTA: 1
DISK_READS_TOTAL: 0
DISK_READS_DELTA: 0
BUFFER_GETS_TOTAL: 0
BUFFER_GETS_DELTA: 0
ELAPSED_TIME_TOTAL: 1423
ELAPSED_TIME_DELTA: 1423
CPU_TIME_TOTAL: 0
CPU_TIME_DELTA: 0
CCWAIT_TOTAL: 0
CCWAIT_DELTA: 0
USERIO_WAIT_TOTAL: 0
USERIO_WAIT_DELTA: 0
APWAIT_TOTAL: 0
APWAIT_DELTA: 0
PHYSICAL_READ_REQUESTS_TOTAL: 0
PHYSICAL_READ_REQUESTS_DELTA: 0
PHYSICAL_READ_BYTES_TOTAL: 0
PHYSICAL_READ_BYTES_DELTA: 0
WRITE_THROTTLE_TOTAL: 0
WRITE_THROTTLE_DELTA: 0
ROWS_PROCESSED_TOTAL: 0
ROWS_PROCESSED_DELTA: 0
MEMSTORE_READ_ROWS_TOTAL: 0
MEMSTORE_READ_ROWS_DELTA: 0
MINOR_SSSTORE_READ_ROWS_TOTAL: 0
MINOR_SSSTORE_READ_ROWS_DELTA: 0
MAJOR_SSSTORE_READ_ROWS_TOTAL: 0
MAJOR_SSSTORE_READ_ROWS_DELTA: 0
RPC_TOTAL: 0
RPC_DELTA: 0
FETCHES_TOTAL: 0
FETCHES_DELTA: 0
RETRY_TOTAL: 0
RETRY_DELTA: 0
PARTITION_TOTAL: 1
PARTITION_DELTA: 1
NESTED_SQL_TOTAL: 0
NESTED_SQL_DELTA: 0
SOURCE_IP: xx.xx.xx.xx
SOURCE_PORT: 2882
ROUTE_MISS_TOTAL: 0
ROUTE_MISS_DELTA: 0
FIRST_LOAD_TIME: 2026-02-24 17:52:04.125057
PLAN_CACHE_HIT_TOTAL: 0
PLAN_CACHE_HIT_DELTA: 0
MUTI_QUERY_TOTAL: 0
MUTI_QUERY_DELTA: 0
MUTI_QUERY_BATCH_TOTAL: 0
MUTI_QUERY_BATCH_DELTA: 0
FULL_TABLE_SCAN_TOTAL: 0
FULL_TABLE_SCAN_DELTA: 0
ERROR_COUNT_TOTAL: 0
ERROR_COUNT_DELTA: 0
SAMPLE_TIME: 2026-02-24 17:52:04.000000
LATEST_ACTIVE_TIME: 2026-02-24 17:52:04.155783
1 row in set (0.153 sec)