[PostgreSQL] idle 세션 모두 정리하기

SELECT pg_terminate_backend(pid) FROM pg_stat_activity
WHERE datname = 'databasename'
AND pid <> pg_backend_pid()
AND state in ('idle');

 

ref : https://stackoverflow.com/questions/30931683/how-to-kill-the-idle-connection-in-postgresql