执行中的sql定位及kill

查询sql状态

SELECT datname,

       pid,

   query,

       client_addr,

       query_start,

       now() - query_start AS query_duration,

       waiting,

       state

  FROM pg_stat_activity

 WHERE pid <> pg_backend_pid() and datname = 'tpcdsdb'

 ORDER BY query_duration DESC;

kill进程

1、取消后台操作，回滚未提交事物 (select);

SELECT pg_cancel_backend(PID); 

2、中断session，回滚未提交事物(select、update、delete、drop);

SELECT pg_terminate_backend(PID);