postgre 连接数

– 查询当前连接
select * from pg_stat_activity;

- 当前总共正在使用的连接数

select count(1) from pg_stat_activity;

-查询当前所有连接的状态

select datname,pid,application_name,state from pg_stat_activity;
–查询最大连接数
show max_connections;
– 释放空闲连接
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE state='idle';

-修改最大链接数据

alter system set max_connections=1000;
参考资料：https://blog.csdn.net/qq_34817440/article/details/121449322
             https://blog.csdn.net/qq_42455809/article/details/112770416