KILL
Function
Terminates a specified connection or an SQL statement executed under the connection.
Precautions
- The KILL syntax is valid in both non-thread pool mode and thread pool mode.
- Generally, this parameter is used together with the Id column in the query result of SHOW PROCESSSLIST.
- It can also be used together with SELECT sessionid from pg_stat_activity WHERE (filtering condition).
Syntax
KILL [CONNECTION | QUERY] processlist_id
Parameter Description
-
CONNECTION
When the CONNECTION keyword is used to modify the KILL statement, the effect is the same as that of KILL processlist_id, and the current connection is terminated.
-
QUERY
When the QUERY keyword is used to modify the KILL statement, the SQL statement executed by the current connection is terminated, and the connection itself is not affected.
-
processlist_id
Connection ID.
Examples
--Check the current connection.
openGauss=# show processlist;
Id | Pid | QueryId | UniqueSqlId | User | Host | db | Command |
BackendStart | XactStart | Time | State | Info
-----------------+-----------------+-------------------+-------------+-----------+------+----------+------------------------+---
----------------------------+-------------------------------+--------+--------+----------------------------------------
139653370304256 | 139653370304256 | 0 | 0 | opengauss | | postgres | ApplyLauncher | 20
22-06-21 16:46:19.656076+08 | | | |
139653319255808 | 139653319255808 | 0 | 0 | opengauss | | postgres | Asp | 20
22-06-21 16:46:19.728521+08 | | 1 | active |
139653336483584 | 139653336483584 | 0 | 0 | opengauss | | postgres | PercentileJob | 20
22-06-21 16:46:19.728527+08 | | 8 | active |
139653302175488 | 139653302175488 | 0 | 0 | opengauss | | postgres | statement flush thread | 20
22-06-21 16:46:19.728558+08 | | 508507 | idle |
139653198239488 | 139653198239488 | 0 | 0 | opengauss | | postgres | WorkloadMonitor | 20
22-06-21 16:46:19.750133+08 | | | |
139653181298432 | 139653181298432 | 0 | 0 | opengauss | | postgres | WLMArbiter | 20
22-06-21 16:46:19.750976+08 | | | |
139653215110912 | 139653215110912 | 0 | 0 | opengauss | | postgres | workload | 20
22-06-21 16:46:19.754504+08 | 2022-06-21 16:46:19.769585+08 | 508507 | active | WLM fetch collect info from data nodes
139653421840128 | 139653421840128 | 0 | 0 | opengauss | | postgres | JobScheduler | 20
22-06-27 10:00:54.754007+08 | | 0 | active |
139653044328192 | 139653044328192 | 48976645947655327 | 1772643515 | opengauss | -1 | dolphin | gsql | 20
22-06-27 14:00:53.163338+08 | 2022-06-27 14:01:26.794658+08 | 0 | active | show processlist;
139653027546880 | 139653027546880 | 48976645947655326 | 1775585557 | opengauss | -1 | postgres | gsql | 20
22-06-27 14:01:03.969962+08 | 2022-06-27 14:01:19.967521+08 | 7 | active | select pg_sleep(100);
(10 rows)
--SQL statement for terminating the 139653027546880 connection
openGauss=# kill query 139653027546880;
result
--------
t
(1 row)
--The connection status of 139653027546880 in the processlist is changed to idle.
openGauss=# show processlist;
Id | Pid | QueryId | UniqueSqlId | User | Host | db | Command |
BackendStart | XactStart | Time | State | Info
-----------------+-----------------+-------------------+-------------+-----------+------+----------+------------------------+---
----------------------------+-------------------------------+--------+--------+----------------------------------------
139653370304256 | 139653370304256 | 0 | 0 | opengauss | | postgres | ApplyLauncher | 20
22-06-21 16:46:19.656076+08 | | | |
139653319255808 | 139653319255808 | 0 | 0 | opengauss | | postgres | Asp | 20
22-06-21 16:46:19.728521+08 | | 0 | active |
139653336483584 | 139653336483584 | 0 | 0 | opengauss | | postgres | PercentileJob | 20
22-06-21 16:46:19.728527+08 | | 5 | active |
139653302175488 | 139653302175488 | 0 | 0 | opengauss | | postgres | statement flush thread | 20
22-06-21 16:46:19.728558+08 | | 508573 | idle |
139653198239488 | 139653198239488 | 0 | 0 | opengauss | | postgres | WorkloadMonitor | 20
22-06-21 16:46:19.750133+08 | | | |
139653181298432 | 139653181298432 | 0 | 0 | opengauss | | postgres | WLMArbiter | 20
22-06-21 16:46:19.750976+08 | | | |
139653215110912 | 139653215110912 | 0 | 0 | opengauss | | postgres | workload | 20
22-06-21 16:46:19.754504+08 | 2022-06-21 16:46:19.769585+08 | 508573 | active | WLM fetch collect info from data nodes
139653421840128 | 139653421840128 | 0 | 0 | opengauss | | postgres | JobScheduler | 20
22-06-27 10:00:54.754007+08 | | 1 | active |
139653044328192 | 139653044328192 | 48976645947655329 | 1772643515 | opengauss | -1 | dolphin | gsql | 20
22-06-27 14:00:53.163338+08 | 2022-06-27 14:02:33.180256+08 | 0 | active | show processlist;
139653027546880 | 139653027546880 | 0 | 0 | opengauss | -1 | postgres | gsql | 20
22-06-27 14:01:03.969962+08 | | 11 | idle | select pg_sleep(100);
(10 rows)
--Terminate the connection to 139653027546880.
openGauss=# kill 139653027546880;
result
--------
t
(1 row)
--Alternatively, run the following command:
openGauss=# kill connection 139653027546880;
result
--------
t
(1 row)
--The connection does not exist in the processlist.
openGauss=# show processlist;
Id | Pid | QueryId | UniqueSqlId | User | Host | db | Command |
BackendStart | XactStart | Time | State | Info
-----------------+-----------------+-------------------+-------------+-----------+------+----------+------------------------+---
----------------------------+-------------------------------+--------+--------+----------------------------------------
139653370304256 | 139653370304256 | 0 | 0 | opengauss | | postgres | ApplyLauncher | 20
22-06-21 16:46:19.656076+08 | | | |
139653319255808 | 139653319255808 | 0 | 0 | opengauss | | postgres | Asp | 20
22-06-21 16:46:19.728521+08 | | 1 | active |
139653336483584 | 139653336483584 | 0 | 0 | opengauss | | postgres | PercentileJob | 20
22-06-21 16:46:19.728527+08 | | 7 | active |
139653302175488 | 139653302175488 | 0 | 0 | opengauss | | postgres | statement flush thread | 20
22-06-21 16:46:19.728558+08 | | 508696 | idle |
139653198239488 | 139653198239488 | 0 | 0 | opengauss | | postgres | WorkloadMonitor | 20
22-06-21 16:46:19.750133+08 | | | |
139653181298432 | 139653181298432 | 0 | 0 | opengauss | | postgres | WLMArbiter | 20
22-06-21 16:46:19.750976+08 | | | |
139653215110912 | 139653215110912 | 0 | 0 | opengauss | | postgres | workload | 20
22-06-21 16:46:19.754504+08 | 2022-06-21 16:46:19.769585+08 | 508696 | active | WLM fetch collect info from data nodes
139653421840128 | 139653421840128 | 0 | 0 | opengauss | | postgres | JobScheduler | 20
22-06-27 10:00:54.754007+08 | | 1 | active |
139653044328192 | 139653044328192 | 48976645947655331 | 1772643515 | opengauss | -1 | dolphin | gsql | 20
22-06-27 14:00:53.163338+08 | 2022-06-27 14:04:35.418518+08 | 0 | active | show processlist;
(9 rows)