Note
This view is available starting with V1.4.
Purpose
This view displays the statistics of the current tenant on the current OBServer node.
In this view:
STATISTIC#: indicates the serial number of a statistic. The serial number of the same statistic may change across different OBServer node versions.STAT_ID: indicates the ID of a statistic. The ID of the same statistic remains consistent across different OBServer node versions.
Note
To use this view, you must enable monitoring, that is, set the enable_perf_event parameter to True.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | The tenant ID. |
| SVR_IP | varchar(46) | NO | The IP address of the server on which the information resides. |
| SVR_PORT | bigint(20) | NO | The port number of the server on which the information resides. |
| STATISTIC# | bigint(20) | NO | The index of the statistic. |
| NAME | varchar(64) | NO | The name of the statistic. |
| CLASS | bigint(20) | NO | The type to which the statistic belongs. |
| VALUE | bigint(20) | NO | The value of the statistic. |
| VALUE_TYPE | varchar(16) | NO | The type of the statistic value. Valid values:
|
| STAT_ID | bigint(20) | NO | The ID of the statistic. |
Sample query
Query the statistics of the current tenant on the current node, and display the first 10 records.
obclient [oceanbase]> SELECT * FROM oceanbase.V$SYSSTAT LIMIT 10;
The query result is as follows:
+--------+----------------+----------+------------+-----------------------+-------+------------+------------+---------+
| CON_ID | SVR_IP | SVR_PORT | STATISTIC# | NAME | CLASS | VALUE | VALUE_TYPE | STAT_ID |
+--------+----------------+----------+------------+-----------------------+-------+------------+------------+---------+
| 1002 | 11.xxx.xxx.xxx | 28825 | 0 | rpc packet in | 1 | 11466228 | ADD_VALUE | 10000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 1 | rpc packet in bytes | 1 | 4307176881 | ADD_VALUE | 10001 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 2 | rpc packet out | 1 | 22931199 | ADD_VALUE | 10002 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 3 | rpc packet out bytes | 1 | 6647402391 | ADD_VALUE | 10003 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 4 | rpc deliver fail | 1 | 0 | ADD_VALUE | 10004 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 5 | rpc net delay | 1 | 777626920 | ADD_VALUE | 10005 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 6 | rpc net frame delay | 1 | 2112541 | ADD_VALUE | 10006 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 7 | mysql packet in | 1 | 329 | ADD_VALUE | 10007 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 8 | mysql packet in bytes | 1 | 18639 | ADD_VALUE | 10008 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 9 | mysql packet out | 1 | 6597 | ADD_VALUE | 10009 |
+--------+----------------+----------+------------+-----------------------+-------+------------+------------+---------+
10 rows in set
References
Query the statistics of a session:
Query the definitions of all statistics: V$STATNAME
For more information about statistics, see Common statistics.