SHOW PROCESSLIST

Use the SHOW PROCESSLIST command to display the current workload of the system. The output of this command consists of id, user, host, database, time, and info.

The following table explains the output in detail:

Output	Description
id	The id of the process.
user	The username associated with the process.
host	The host to which the client is connected.
database	The database if one is selected.
time	The elapsed time since the running sql.
info	The statement being executed.

INFO

This command only shows the frontend received processlist now.

Syntax

SHOW PROCESSLIST;
Example
SHOW PROCESSLIST;
------RESULT
Id   | User |      Host       | Database | Time |                 Info
-------+------+-----------------+----------+------+---------------------------------------
 56 | root | 127.0.0.1:57542 | dev      | 6ms  | SELECT c FROM sbtest1 WHERE id=197719
 57 | root | 127.0.0.1:57545 | dev      |      |
 64 | root | 127.0.0.1:57552 | dev      |      |
 67 | root | 127.0.0.1:57554 | dev      |      |
 52 | root | 127.0.0.1:57540 | dev      | 0ms  | SELECT c FROM sbtest1 WHERE id=961513
 16 | root | 127.0.0.1:57054 | dev      | 0ms  | show processlist;
 58 | root | 127.0.0.1:57546 | dev      |      |
 54 | root | 127.0.0.1:57543 | dev      | 3ms  | SELECT c FROM sbtest1 WHERE id=99465
 55 | root | 127.0.0.1:57544 | dev      | 1ms  | SELECT c FROM sbtest1 WHERE id=601879
 53 | root | 127.0.0.1:57541 | dev      |      |
 65 | root | 127.0.0.1:57553 | dev      | 0ms  | SELECT c FROM sbtest1 WHERE id=547609
 61 | root | 127.0.0.1:57549 | dev      | 2ms  | SELECT c FROM sbtest1 WHERE id=394922
 60 | root | 127.0.0.1:57548 | dev      | 4ms  | SELECT c FROM sbtest1 WHERE id=453909
 63 | root | 127.0.0.1:57551 | dev      | 0ms  | SELECT c FROM sbtest1 WHERE id=190594
 62 | root | 127.0.0.1:57550 | dev      | 0ms  | SELECT c FROM sbtest1 WHERE id=128925
 66 | root | 127.0.0.1:57555 | dev      |      |
 59 | root | 127.0.0.1:57547 | dev      | 0ms  | SELECT c FROM sbtest1 WHERE id=772039
(17 rows)
Terminate the process
After using the SHOW PROCESSLIST command to display the running processes, you can terminate the idle process by the KILL command.
Syntax
KILL process_id;
Example
SHOW PROCESSLIST;
------RESULT
 Id | User |      Host       | Database |  Time   |                            Info
----+------+-----------------+----------+---------+------------------------------------------------------------
 0  | root | 127.0.0.1:60858 | dev      | 35363ms | insert into t select i from generate_series(1, 1000000) i;
 1  | root | 127.0.0.1:60935 | dev      | 0ms     | show processlist;
 2  | root | 127.0.0.1:60941 | dev      | 4304ms  | create materialized view mv2 as select * from t;
(3 rows)
KILL 2;
------RESULT

SQL reference

User-defined functions

SHOW PROCESSLIST

Syntax

Example

Terminate the process

Syntax

Example

SQL reference

User-defined functions

​ Syntax

​Example

​Terminate the process

​Syntax

​Example

Syntax

Example

Terminate the process

Syntax

Example