摘要: SELECT procpid, start, now() - start AS lap, current_query FROM (SELECT backendid, pg_stat_get_backend_pid(S.backendid) AS procpid, pg_stat_get_backen 阅读全文
posted @ 2018-01-09 10:39 553490191 阅读(13028) 评论(0) 推荐(2) 编辑
摘要: kill方式是杀掉进程,但是有时候需要取消相关SQL语句,采用以下方式:查看哪些SQL语句正在执行,语句如下:SELECT datname,procpid,query_start, current_query,waiting,client_addr FROM pg_stat_activity WHE 阅读全文
posted @ 2018-01-09 10:38 553490191 阅读(2015) 评论(0) 推荐(0) 编辑