blog/pg指令记录.md

title	tags	categories	date
pg指令记录	postgres	笔记	2023-05-23 15:55:31

1. pg查询慢查询进程

-- 查询进程
SELECT C.procpid, C.START, C.lap, C.current_query
FROM
  (SELECT pg_stat_get_backend_pid (S.backendid) AS procpid,
          pg_stat_get_backend_activity_start (S.backendid) AS START,
          now() - pg_stat_get_backend_activity_start (S.backendid) AS lap,
          pg_stat_get_backend_activity (S.backendid) AS current_query
   FROM
     (SELECT pg_stat_get_backend_idset () AS backendid) AS S) AS C
WHERE current_query <> '<IDLE>'
  AND lap > '00:00:10'
ORDER BY start DESC;

2. pg杀死进程

-- 杀进程
SELECT pg_terminate_backend(25278);

3. 重新跑脚本