slow_queries

The slow_queries table contains the slow queries of GreptimeDB:

USE greptime_private;

SELECT * FROM slow_queries;

The output is as follows:

+------+-----------+---------------------------------------------+-----------+----------------------------+--------------+-------------+---------------------+---------------------+
| cost | threshold | query                                       | is_promql | timestamp                  | promql_range | promql_step | promql_start        | promql_end          |
+------+-----------+---------------------------------------------+-----------+----------------------------+--------------+-------------+---------------------+---------------------+
|    2 |         0 | irate(process_cpu_seconds_total[1h])        |         1 | 2025-05-14 13:59:36.368575 |     86400000 |     3600000 | 2024-11-24 00:00:00 | 2024-11-25 00:00:00 |
|   22 |         0 | SELECT * FROM greptime_private.slow_queries |         0 | 2025-05-14 13:59:44.844201 |            0 |           0 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 |
+------+-----------+---------------------------------------------+-----------+----------------------------+--------------+-------------+---------------------+---------------------+

• cost: The cost of the query in milliseconds.
• threshold: The threshold of the query in milliseconds.
• query: The query string. It can be SQL or PromQL.
• is_promql: Whether the query is a PromQL query.
• timestamp: The timestamp of the query.
• promql_range: The range of the query. Only used when is_promql is true.
• promql_step: The step of the query. Only used when is_promql is true.
• promql_start: The start time of the query. Only used when is_promql is true.
• promql_end: The end time of the query. Only used when is_promql is true.

You can refer to the Slow Query documentation for more details.