查看postgrasql正在执行的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>‘
ORDER BY
    lap DESC;


procpid：进程id
start：进程开始时间
lap：经过时间
current_query：执行中的sql
怎样停止正在执行的sql
SELECT pg_cancel_backend( 进程id );
或者用系统函数
kill -9 进程id ;

查看postgrasql正在执行的sql语句

原文：https://www.cnblogs.com/han-guang-xue/p/11906918.html