--查看当前进程
select * from pg_stat_activity order by application_name desc;
--拼接取消查询、结束进程字符串
select 'select pg_cancel_backend('''|| pid ||''');select pg_terminate_backend( '''|| pid ||''');' from pg_stat_activity;
-- 结束进程
SELECT pg_terminate_backend(pid)
-- 取消查询
SELECT pg_cancel_backend(pid)