PostgreSQL查看正在执行的任务并强制结束的操作方法

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>'

ORDER BY

   lap DESC;

SELECT

  pid,

  datname AS db,

  query_start AS start,

  now() - query_start AS lap,

  query

FROM pg_stat_activity

WHERE state <> 'idle' and query not like '%pg_stat_activity%'

  and (now() - query_start) > interval '10 seconds';