Postgresql 连接数相关

select min_val, max_val from pg_settings where name='max_connections';

show max_connections;

select count(1) from pg_stat_activity;

select * from pg_stat_activity;

select client_addr,datname,pid,application_name,state from pg_stat_activity order by client_addr;

select max_conn-now_conn as resi_conn from (select setting::int8 as max_conn,(select count(*) from pg_stat_activity) as now_conn from pg_settings where name = 'max_connections') t;