Outdated Version

You are viewing an older version of this section. View current production version.

SHOW PROCESSLIST

Shows details about currently running threads.

Syntax

SHOW PROCESSLIST

Remarks

  • This command can be run on any SingleStore 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             |
+----+------+-----------------+------+---------+------+-------+------------------+
| 19 | root | localhost:33790 | test | Query   | 1118 | NULL  | SHOW PROCESSLIST |
+----+------+-----------------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)