查看所有连接的用户:
select * from pg_stat_activity;
查看连接总数:
select count(*) from pg_stat_activity;
--显示系统允许的最大连接数
show max_connections;
--显示系统保留的用户数
show superuser_reserved_connections ;
--按照用户分组查看
select usename, count(*) from pg_stat_activity group by usename order by count(*) desc;