Postgresql查询连接会话，结束连接会话操作

-- 查询数据库空闲连接会话
select 'select pg_terminate_backend('||pid||');' as terminate_script
      ,datname,pid,application_name,state,client_addr,query
from pg_stat_activity
where state = 'idle'
and usename = 'postgres'
order by client_addr;

-- 结束会话
SELECT pg_terminate_backend(1620);


-- 结束非当前账号的连接会话
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.pid IS NOT NULL
AND pg_stat_activity.usename NOT IN ('postgres');
	

-- 查询所有会话
SELECT
    pid,
    usename,
    datname,
    client_addr,
    client_hostname,
    client_port,
    backend_start,
    query_start,
    state,
    query
FROM
    pg_stat_activity;