postgre通过sql释放空闲连接

– 查询当前连接
select * from pg_stat_activity;
–查询最大连接数
show max_connections;
– 释放空闲连接
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE state=‘idle’;