Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays data types such as RESPONSE TIME histograms for Prometheus monitoring.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| RESPONSE_TIME | bigint(14) | NO | The response time. |
| COUNT | bigint(14) | NO | The number of requests within the response time. |
| TOTAL | bigint(14) | NO | The total response time of requests. |
Sample query
Query the RESPONSE TIME histogram under the current tenant.
obclient[test]> SELECT * FROM information_schema.information_schema.QUERY_RESPONSE_TIME;
The query result is as follows:
+----------------+----------+---------------+--------+-----------+
| SVR_IP | SVR_PORT | RESPONSE_TIME | COUNT | TOTAL |
+----------------+----------+---------------+--------+-----------+
| 172.xx.xxx.xxx | 2882 | 1 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 10 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 100 | 699903 | 41179133 |
| 172.xx.xxx.xxx | 2882 | 1000 | 659849 | 115135926 |
| 172.xx.xxx.xxx | 2882 | 10000 | 8881 | 24131188 |
| 172.xx.xxx.xxx | 2882 | 100000 | 570 | 12560344 |
| 172.xx.xxx.xxx | 2882 | 1000000 | 15 | 2826919 |
| 172.xx.xxx.xxx | 2882 | 10000000 | 1 | 1214148 |
| 172.xx.xxx.xxx | 2882 | 100000000 | 1 | 10403360 |
| 172.xx.xxx.xxx | 2882 | 1000000000 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 10000000000 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 100000000000 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 1000000000000 | 0 | 0 |
+----------------+----------+---------------+--------+-----------+
13 rows in set