postgresql一些排查sql

-- 查看PostgreSQL当前链接数
SELECT count(*) AS connection_count FROM pg_stat_activity;

-- 查看PostgreSQL最大连接数量
SHOW max_connections;

-- 查看PostgreSQL 数据库连接数量
SELECT * FROM pg_stat_activity;

-- 正在执行的 SQL 语句
SELECT pid, query FROM pg_stat_activity WHERE state = 'active';

-- 查看执行耗时较长的 SQL 语句
SELECT pid, query, state, now() - query_start AS execution_time
FROM pg_stat_activity
WHERE state = 'active' AND now() - query_start > INTERVAL '1 second';

-- 用于列出所有运行时间超过1秒的活动查询
SELECT pid, query, state, now() - query_start AS execution_time
FROM pg_stat_activity
WHERE state = 'active' AND now() - query_start > INTERVAL '1 second';

-- 精准地终止该查询（谨慎使用！！！）
SELECT pg_terminate_backend(<pid>);
-- 样例：SELECT pg_terminate_backend(123456);