Note
This view is available starting with V4.2.1.
Overview
Displays the names of system statistics for all tenants.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| CLUSTER_ID | bigint(20) | NO | Cluster ID |
| TENANT_ID | bigint(20) | NO | Tenant ID |
| STAT_ID | bigint(20) | NO | Statistical Item ID |
| STAT_NAME | varchar(64) | NO | Statistical Item Name |
Sample query
Query the names of system statistics for all tenants and display the first record.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_WR_STATNAME LIMIT 1;
The query result is as follows:
+------------+-----------+---------+---------------+
| CLUSTER_ID | TENANT_ID | STAT_ID | STAT_NAME |
+------------+-----------+---------+---------------+
| 10001 | 1 | 10000 | rpc packet in |
+------------+-----------+---------+---------------+
1 row in set (0.051 sec)