PostgreSQL 13 清理idle进程

1. 简介

近期发现postgres数据库调优修改数据库连接数之后, 任然还是会把连接数占满

查询postgres数据库当前连接数

select count(*) from pg_stat_activity;

清理idle连接

SELECT pg_terminate_backend(pid) FROM pg_stat_activity
WHERE pid != pg_backend_pid()
AND state in ('idle','idle in transaction','idle in transaction (aborted)', 'disabled')