Skip to main content
Version: Nightly

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.