1、查询数据库配置的最大连接数:
select setting from pg_catalog.pg_settings where "name" ='max_connections';
2、查询数据库当前连接信息:
select datname ,pid ,usename ,query_start ,wait_event ,wait_event_type ,state ,query from pg_catalog.pg_stat_activity order by query_start desc ;
3、杀死连接:
select pg_cancel_backend(pid);
4、查询当前使用的连接数
select count(*) from pg_catalog.pg_stat_activity ;
5、查询当前空余连接数:
select setting::int2 -(select count(*) from pg_catalog.pg_stat_activity) from pg_catalog.pg_settings where "name" ='max_connections';
6、设置空闲事务的最大空闲时间。当值为0时,关闭超时:
show idle_in_transaction_session_timeout;
7、查询cpu使用情况:top