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)