kill all idle sessions and connections of a Database

 

/*PostgreSQL: Script to kill all idle sessions and connections of a Database*/

———————————————————————————————————–

SELECT pg_terminate_backend(pid)

FROM pg_stat_activity

WHERE datname = ”

AND pid <> pg_backend_pid()

AND state in (‘idle’, ‘idle in transaction’, ‘idle in transaction (aborted)’, ‘disabled’)

AND state_change < current_timestamp – INTERVAL ’15’ MINUTE;