Information Schema QUERY_RESPONSE_TIME Table
Description
The Information Schema QUERY_RESPONSE_TIME
table contains information about queries that take a long time to execute . It is only available if the QUERY_RESPONSE_TIME plugin has been installed.
It contains the following columns:
Column
Description
Column
Description
TIME
Time interval
COUNT
Count of queries falling into the time interval
TOTAL
Total execution time of all queries for this interval
See QUERY_RESPONSE_TIME plugin for a full description.
The table is not a standard Information Schema table, and is a MariaDB extension.
SHOW QUERY_RESPONSE_TIME is available as an alternative for retrieving the data.
Example
SELECT * FROM information_schema.QUERY_RESPONSE_TIME;
+----------------+-------+----------------+
| TIME | COUNT | TOTAL |
+----------------+-------+----------------+
| 0.000001 | 0 | 0.000000 |
| 0.000010 | 17 | 0.000094 |
| 0.000100 | 4301 0.236555 |
| 0.001000 | 1499 | 0.824450 |
| 0.010000 | 14851 | 81.680502 |
| 0.100000 | 8066 | 443.635693 |
| 1.000000 | 0 | 0.000000 |
| 10.000000 | 0 | 0.000000 |
| 100.000000 | 1 | 55.937094 |
| 1000.000000 | 0 | 0.000000 |
| 10000.000000 | 0 | 0.000000 |
| 100000.000000 | 0 | 0.000000 |
| 1000000.000000 | 0 | 0.000000 |
| TOO LONG | 0 | TOO LONG |
+----------------+-------+----------------+
This page is licensed: CC BY-SA / Gnu FDL
PreviousInformation Schema QUERY_CACHE_INFO TableNextInformation Schema REFERENTIAL_CONSTRAINTS Table
Last updated
Was this helpful?