Skip to main content
Version: 3.0

SHOW PROCESSLIST

Description

Lists the operations currently being performed by threads executing within the server. The current version of StarRocks only supports listing queries.

Syntax

SHOW [FULL] PROCESSLIST

Parameter

ParameterRequiredDescription
FULLNoIf you specify this parameter, the complete SQL statement will be displayed. Otherwise, only the first 100 characters of the statement are displayed.

Return

ReturnDescription
IdConnection ID.
UserThe name of the user who runs the operation.
HostThe hostname of the client which runs the operation.
DbThe name of the database where the operation is executed.
CommandThe type of the command.
ConnectionStartTimeTime when the connection starts.
TimeThe time (in second) since the operation has entered the current state.
StateThe state of the operation.
InfoThe command that the operation is executing.

Usage note

If the current user is root, this statement lists the operations of all users in the cluster. Otherwise, only operations of the current user are listed.

Example

Example 1: lists the operations state via the user root.

SHOW PROCESSLIST;
+------+------+---------------------+-------+---------+---------------------+------+-------+------------------+
| Id | User | Host | Db | Command | ConnectionStartTime | Time | State | Info |
+------+------+---------------------+-------+---------+---------------------+------+-------+------------------+
| 0 | root | x.x.x.x:xxxx | tpcds | Query | 2022-10-09 19:58:25 | 0 | OK | SHOW PROCESSLIST |
+------+------+---------------------+-------+---------+---------------------+------+-------+------------------+