SingleStore Managed Service

information_schema.MV_PROCESSLIST

This table 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 of the related node.

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.