> For the complete documentation index, see [llms.txt](https://docs.starrocks.io/llms.txt). This page is also available as Markdown at its `.md` URL.

# SHOW PROCESSLIST

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

tip

This operation does not require privileges.

## Syntax[​](#syntax "Direct link to Syntax")

```sql
SHOW [FULL] PROCESSLIST

```

## Parameter[​](#parameter "Direct link to Parameter")

| Parameter | Required | Description                                                                                                                                           |
| --------- | -------- | ----------------------------------------------------------------------------------------------------------------------------------------------------- |
| FULL      | No       | If you specify this parameter, the complete SQL statement will be displayed. Otherwise, only the first 100 characters of the statement are displayed. |

## Return[​](#return "Direct link to Return")

| Return              | Description                                                                  |
| ------------------- | ---------------------------------------------------------------------------- |
| Server              | Server ID.                                                                   |
| Id                  | Connection ID.                                                               |
| User                | The name of the user who runs the operation.                                 |
| Host                | The hostname of the client which runs the operation.                         |
| Db                  | The name of the database where the operation is executed.                    |
| Command             | The type of the command.                                                     |
| ConnectionStartTime | Time when the connection starts.                                             |
| Time                | The time (in second) since the operation has entered the current state.      |
| State               | The state of the operation.                                                  |
| Info                | The command that the operation is executing.                                 |
| IsPending           | Whether the query is pending in the queue. Valid values: `true` and `false`. |
| Warehouse           | The name of the warehouse where the query is executed.                       |
| CNGroup             | The name of the compute node group where the query is run.                   |
| Catalog             | The name of the catalog.                                                     |
| QueryId             | The qury ID if the Command is "Query".                                       |

## Usage note[​](#usage-note "Direct link to 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.

The `IsPending`, `Warehouse`, and `CNGroup` fields provide additional information about query execution in warehouse environments:

* `IsPending`: Shows whether a query is waiting in the queue (`true`) or actively executing (`false`)
* `Warehouse`: Displays the warehouse name where the query is being executed
* `CNGroup`: Shows the compute node group name responsible for executing the query

## Example[​](#example "Direct link to Example")

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

```sql
SHOW PROCESSLIST\G

*************************** 6. row ***************************
         ServerName: starrocks-fe_9010_1782850099498
                 Id: 33560554
               User: root
               Host: 172.18.0.4:54818
                 Db:
            Command: Query
ConnectionStartTime: 2026-07-02 01:21:14
               Time: 0
              State: OK
               Info: show processlist
          IsPending: false
          Warehouse: default_warehouse
            CNGroup:
            Catalog: default_catalog
            QueryId: 019f1eb3-246c-7899-ab3e-40a018645bba

```