Skip to main content

SHOW PROCESSLIST

The Databend process list indicates the operations currently being performed by the set of threads executed within the server.

The SHOW PROCESSLIST statement is one source of process information.

Syntax

SHOW PROCESSLIST

Examples

SHOW PROCESSLIST;
+--------------------------------------+-------+-----------------+------+-------+----------+-------------------------------------------------+--------------+------------------------+-------------------------+-------------------------+--------------------------+---------------------+------+
| id | type | host | user | state | database | extra_info | memory_usage | dal_metrics_read_bytes | dal_metrics_write_bytes | scan_progress_read_rows | scan_progress_read_bytes | mysql_connection_id | time |
+--------------------------------------+-------+-----------------+------+-------+----------+-------------------------------------------------+--------------+------------------------+-------------------------+-------------------------+--------------------------+---------------------+------+
| c1152483-de11-4375-bfe3-a35ad2ae9311 | MySQL | 127.0.0.1:57636 | root | Query | default | select sum(number) from numbers(10000000000000) | 0 | 0 | 0 | 816930000 | 6535440000 | 9 | 4 |
| ed21393e-6b6b-4efe-b333-1643f531e8ac | MySQL | 127.0.0.1:57637 | root | Query | system | show processlist | 0 | 0 | 0 | 0 | 0 | 10 | 0 |
+--------------------------------------+-------+-----------------+------+-------+----------+-------------------------------------------------+--------------+------------------------+-------------------------+-------------------------+--------------------------+---------------------+------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today