SHOW PROCESSLIST

Output	Description
worker_id	The id of the worker running the process.
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.

Output

Description

worker_id

The id of the worker running the process.

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.

This command only shows the frontend received processlist now.

Example

SHOW PROCESSLIST;
------RESULT
 Worker Id | Id  | User |      Host       | Database |  Time  |         Info          
-----------+-----+------+-----------------+----------+--------+-----------------------
 2         | 2:0 | root | 127.0.0.1:50447 | dev      | 4114ms | SELECT pg_sleep(3600)
 3         | 3:1 | root | 127.0.0.1:50457 | dev      | 6ms    | SHOW PROCESSLIST
 3         | 3:0 | root | 127.0.0.1:50453 | dev      | 2844ms | SELECT pg_sleep(3600)
(3 rows)

Terminate the process

After using the SHOW PROCESSLIST command to display the running processes, you can terminate them by the KILL command.

Syntax

KILL id;

Example

SHOW PROCESSLIST;
------RESULT
 Worker Id | Id  | User |      Host       | Database |  Time  |         Info          
-----------+-----+------+-----------------+----------+--------+-----------------------
 2         | 2:0 | root | 127.0.0.1:50447 | dev      | 4114ms | SELECT pg_sleep(3600)
 3         | 3:1 | root | 127.0.0.1:50457 | dev      | 6ms    | SHOW PROCESSLIST
 3         | 3:0 | root | 127.0.0.1:50453 | dev      | 2844ms | SELECT pg_sleep(3600)
(3 rows)

KILL '2:0';
------RESULT
KILL

KILL '3:0';
------RESULT
KILL

SHOW PROCESSLIST;
------RESULT
 Worker Id | Id  | User |      Host       | Database | Time |       Info       
-----------+-----+------+-----------------+----------+------+------------------
 2         | 2:0 | root | 127.0.0.1:50447 | dev      |      | 
 3         | 3:1 | root | 127.0.0.1:50457 | dev      | 2ms  | SHOW PROCESSLIST
 3         | 3:0 | root | 127.0.0.1:50453 | dev      |      | 
(3 rows)

SQL reference

Python SDK

User-defined functions

Syntax

Example

Terminate the process

Syntax

Example

​Syntax

​Example

​Terminate the process

​Syntax

​Example

Syntax

Example

Terminate the process

Syntax

Example