SingleStore DB

SHOW PROCESSLIST

Shows details about currently running threads.

Syntax
SHOW PROCESSLIST;
Remarks
  • This command can be run on any SingleStore DB node (see Node Requirements for SingleStore DB Commands).

  • This command exposes a formatted subset of data in the information_schema.processlist table. Additionally, SHOW PROCESSLIST output may truncate data from this table. To see all possible fields and the complete field text, query the information_schema.processlist table directly.

  • The Info column’s data is affected by whether the global variable show_query_parameters is set to ON or OFF. By default, show_query_parameters is set to ON, which results in Info field containing the plain text of a query, including query parameters. If show_query_parameters is set to OFF, the Info field will only contain the parameterized query text.

  • show_query_parameters is used in cases when access to sensitive data–in this case, query parameters–needs to be restricted. If this variable is set to OFF, parameters will be hidden. This can be set only at startup, not during runtime; it must be set in the memsql.cnf, followed by a system restart.

Output

Column

Description

Id

Process ID

User

User associated with this process

Host

Host name or IP address and port number

db

Name of SingleStore DB database

Command

Type of command associated with this process

Time

Time (in seconds)

State

Process state

Info

Additional information about this process, including the query text

Example
SHOW PROCESSLIST;
+----+------+-----------------+------+---------+------+-------+------------------+----------+
| Id | User | Host            | db   | Command | Time | State | Info             | RPC Info |
+----+------+-----------------+------+---------+------+-------+------------------+----------+
| 19 | root | localhost:33790 | test | Query   | 1118 | NULL  | SHOW PROCESSLIST | {}       |
+----+------+-----------------+------+---------+------+-------+------------------+----------+
1 row in set (0.00 sec)

Notice

The RPC Info column has been removed starting in version 7.5.