数据仓库服务 GAUSSDB(DWS)-服务器信号函数:pgxc_terminate_query(queryId int)

时间:2024-09-05 10:31:57

pgxc_terminate_query(queryId int)

描述:终止当前集群下正在执行的查询。该函数8.1.2及以上版本支持。

返回值类型:boolean

示例:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
SELECT query_id FROM pgxc_stat_activity;
    query_id       
-----------------
 72339069014638631
(1 rows)

SELECT pgxc_terminate_query(72339069014638631);
 pgxc_terminate_query 
----------------------
 t
(1 row)
support.huaweicloud.com/sqlreference-910-dws/dws_06_0055.html