SHOW PROCESSLIST
Descriptionβ
Displays the thread that the user is running.
This command can only display the connection information of the current FE.
If you need to view the connection information of the entire cluster, you need to add a session variable:
SET SHOW_ALL_FE_CONNECTION = TRUE;
Syntaxβ
SHOW [FULL] PROCESSLIST
Optional Parametersβ
1. FULL
Indicates whether to view the connection information of other users
Return Valueβ
column | Instructions |
---|---|
CurrentConnected | Whether the connection is current |
Id | The unique identification of this thread |
User | The user who started this thread |
Host | The IP address and port number of the client sending the request are recorded |
LoginTime | Time to establish a connection |
Catalog | In which data directory is the command currently executed |
Db | On which database is the command being executed? If no database is specified, the value is NULL |
Command | The command that the thread is executing at this moment |
Time | Time when the previous command is submitted to the current status, in seconds |
State | State of thread |
QueryId | ID of the current query statement |
Info | Generally, the statement executed by the thread is recorded, and only the first 100 characters are displayed by default |
Common Command types are as follows:
column | Instructions |
---|---|
Query | The thread is executing a statement |
Sleep | Waiting for the client to send it an execution statement |
Quit | The thread is exiting |
Kill | Executing the kill statement |
Access Control Requirementsβ
The user who executes this SQL command must have at least the following permissions:
Privilege | Object | Notes |
---|---|---|
ADMIN_PRIV | DATABASE | If you want to view the connection information of other users, you need the ADMIN permission |
Examplesβ
SHOW PROCESSLIST
+------------------+------+------+-----------------+---------------------+----------+------+---------+------+-------+-----------------------------------+-----------------------+
| CurrentConnected | Id | User | Host | LoginTime | Catalog | Db | Command | Time | State | QueryId | Info |
+------------------+------+------+-----------------+---------------------+----------+------+---------+------+-------+-----------------------------------+-----------------------+
| Yes | 0 | root | 127.0.0.1:34650 | 2025-01-21 12:01:02 | internal | test | Query | 0 | OK | c84e397193a54fe7-bbe9bc219318b75e | select 1 |
| | 1 | root | 127.0.0.1:34776 | 2025-01-21 12:01:07 | internal | | Sleep | 29 | EOF | 886ffe2894314f50-8dd73a6ca06699e4 | show full processlist |
+------------------+------+------+-----------------+---------------------+----------+------+---------+------+-------+-----------------------------------+-----------------------+