# MV\_PROCESSLIST

This view contains information about currently running threads on a cluster for all nodes. Alternatively, `information_schema.PROCESSLIST` shows this information per node. This information is surfaced by the [SHOW PROCESSLIST](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-processlist.md) command.

| Column Name            | Description                                                                                                                                                     |
| ---------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `NODE_ID`              | The`ID`of the node a given process is being run on.                                                                                                             |
| `ID`                   | The unique`ID`of a given process.                                                                                                                               |
| `USER`                 | The user who issued the process command.                                                                                                                        |
| `HOST`                 | The hostname or IP address from which the connection originated.                                                                                                |
| `DB`                   | The related database.                                                                                                                                           |
| `COMMAND`              | The type of command associated with this process.                                                                                                               |
| `TIME`                 | The runtime, in seconds.                                                                                                                                        |
| `STATE`                | The state of a given process.                                                                                                                                   |
| `INFO`                 | Additional information about a given process, including the query text.                                                                                         |
| `FUNCTION_NAME`        | The name of the calling Stored Procedure, if the process was called by a Stored Procedure.                                                                      |
| `RPC_INFO`             | Low level information about this process shown as a JSON string.                                                                                                |
| `PLAN_ID`              | The`ID`of the related query plan for a given process.                                                                                                           |
| `TRANSACTION_STATE`    | `running`if there is an open transaction and a query running.`open`if there is an open transaction with no query running.`NULL`if there is no open transaction. |
| `ROW_LOCKS_HELD`       | The number of[row locks](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/row-locking.md)being held.                                       |
| `PARTITION_LOCKS_HELD` | The column is deprecated, as are partition level locks. The value for this column is always 0.                                                                  |
| `LWPID`                | The native OS thread ID (lightweight process ID).                                                                                                               |
| `RESOURCE_POOL`        | The resource pool a given process is drawing from.                                                                                                              |
| `DRAINING`             | Specifies if the current connection is draining.                                                                                                                |
| `REASON_FOR_QUEUEING`  | The reason a given process is queued.                                                                                                                           |
| `DAC_CONNECTION`       | Specifies if the current connection is a Dedicated Admin Connection (DAC).                                                                                      |
| `IP_ADDRESS`           | IP address of the connection.                                                                                                                                   |

***

Modified at: February 27, 2026

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-processlist/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-processlist/)

(An index of the documentation is available at /llms.txt)