Skip to main content
Version: Nightly

PROCESS_LIST

The PROCESS_LIST table provides a view of all running queries in GreptimeDB cluster.

NOTE

It's intentionally to have a different table name than MySQL's PROCESSLIST because it has a very different set of columns.

USE INFORMATION_SCHEMA;
DESC PROCESS_LIST;

The output is as follows:

+-----------------+----------------------+------+------+---------+---------------+
| Column | Type | Key | Null | Default | Semantic Type |
+-----------------+----------------------+------+------+---------+---------------+
| id | String | | NO | | FIELD |
| catalog | String | | NO | | FIELD |
| schemas | String | | NO | | FIELD |
| query | String | | NO | | FIELD |
| client | String | | NO | | FIELD |
| frontend | String | | NO | | FIELD |
| start_timestamp | TimestampMillisecond | | NO | | FIELD |
| elapsed_time | DurationMillisecond | | NO | | FIELD |
+-----------------+----------------------+------+------+---------+---------------+

Fields in the PROCESS_LIST table are described as follows:

  • id: The ID of query.
  • catalog: The catalog name of the query.
  • schemas: The schema name in which client issues the query.
  • query: The query statement.
  • client: Client information, including client address and channel.
  • frontend: On which frontend instance the query is running.
  • start_timestamp: The start timestamp of query.
  • elapsed_time: How long the query has been running.
NOTE

You can also use SHOW [FULL] PROCESSLIST statement as an alternative to querying from INFORMATION_SCHEMA.PROCESS_LIST table.

Terminating a query

When identified a running query from PROCESS_LIST table, you can terminate the query using KILL <PROCESS_ID> statement, where the <PROCESS_ID> is the id field in PROCESS_LIST table.

mysql> select * from process_list;
+-----------------------+----------+--------------------+----------------------------+------------------------+---------------------+----------------------------+-----------------+
| id | catalog | schemas | query | client | frontend | start_timestamp | elapsed_time |
+-----------------------+----------+--------------------+----------------------------+------------------------+---------------------+----------------------------+-----------------+
| 112.40.36.208/7 | greptime | public | SELECT * FROM some_very_large_table | mysql[127.0.0.1:34692] | 112.40.36.208:4001 | 2025-06-30 07:04:11.118000 | 00:00:12.002000 |
+-----------------------+----------+--------------------+----------------------------+------------------------+---------------------+----------------------------+-----------------+

KILL '112.40.36.208/7';
Query OK, 1 row affected (0.00 sec)