SHOW TRANSACTION ISOLATION LEVEL; – 事务隔离级别
show max_connections; – 设置的最大连接数
select count(1) from pg_stat_activity where usesysid = 17553; – 当前连接数
SELECT datname,pid,usesysid,usename,application_name,client_addr,client_port,state,query FROM pg_stat_activity WHERE usesysid = 17553 ORDER BY client_addr; – 当前所有连接信息
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE state = ‘idle’; – 杀掉空闲连接
SELECT pg_backend_pid(); – 当前查询进程id
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 <> ‘
