PostgreSQL 连接信息查询
所属分类 PostgreSQL
浏览量 714
psql: FATAL: 53300: remaining connection slots are reserved for non-replication superuser connections
普通用户的连接已满,保留用于非复制的超级用户连接
psql: FATAL: 53300: sorry, too many clients already
数据库连接已满,无法建立新的连接
查询当前所有连接的状态
select datname,pid,application_name,state from pg_stat_activity;
select datname,pid,application_name,state,query from pg_stat_activity;
查看当前连接数
select count(*) from pg_stat_activity
查看最大连接数
show max_connections
select setting from pg_settings where name = 'max_connections'
查看数据库剩余连接数
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;
查看为超级用户保留的连接数
show superuser_reserved_connections;
按照用户分组查看
select usename, count(*) from pg_stat_activity group by usename order by count(*) desc;
结束连接
select pg_terminate_backend(pidxxx)
结束 idle 的连接
select pg_terminate_backend(pid) from pg_stat_activity where state='idle';
select count(1) from pg_stat_activity where state='idle';
上一篇
下一篇
go 单引号 双引号 反引号
GO json 序列化与反序列化
protobuf3二进制数据转java对象
temporal 代码阅读记录
temporal namespace 信息获取 关键代码及堆栈信息
go.sum 生成