pgsql停止正在执行的任务

查询所有正在执行的任务

--查询任务
SELECT 
datname,pid,query
FROM pg_stat_activity
WHERE state = 'active'
--and datname = 'jnnew'
;
--取消任务
SELECT 
pg_cancel_backend(pid)
FROM pg_stat_activity
WHERE state = 'active'
--and datname = 'jnnew'

强制终止任务

SELECT 
pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE state = 'active'
--and datname = 'jnnew'
;