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

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)

Was this Article Helpful?

Thanks For Your Feedback!