查看执行的sql: SELECT procpid,start,now() - start AS lap,current_query FROM (SELECT backendid,pg_stat_get_backend_pid(S.backendid) AS procpid,pg_stat_get_backend_activity_start(S.backendid) AS start,pg_stat_get_backend_activity(S.backendid) AS current_query FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S ) AS S WHERE current_query <> '<IDLE>'; 杀掉进程有两种方式: 第一种是: SELECT pg_cancel_backend(PID);
这种方式只能kill select查询,对update、delete 及DML不生效。 第二种是: SELECT pg_terminate_backend(PID); 这种可以kill掉各种操作(select、update、delete、drop等)操作 |
|