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 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.
`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 being held.
`PARTITION_LOCKS_HELD`	The column is deprecated, as are partition level locks. The value for this column is always 0.
`RESOURCE_POOL`	The resource pool a given process is drawing from.
`REASON_FOR_QUEUEING`	The reason a given process is queued.

Last modified: July 30, 2024

Was this article helpful?