– 查询当前连接
select * from pg_stat_activity;
–查询最大连接数
show max_connections;
– 释放空闲连接
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE state=‘idle’;
postgre通过sql释放空闲连接
最新推荐文章于 2024-07-09 06:54:42 发布
– 查询当前连接
select * from pg_stat_activity;
–查询最大连接数
show max_connections;
– 释放空闲连接
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE state=‘idle’;