Skip to content

Snippets

Public
Snippet $149 authored by irul

Terminate postgres backend

terminate.sql
Raw Download
1 2 3 4 5 6 7 8 9 10 11 12 13 14 
SELECT *
FROM pg_stat_activity
WHERE datname = 'db_name'
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; -- You can set your own interval


SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'db_name'
AND pid <> pg_backend_pid()
AND state in ('idle', 'idle in transaction', 'idle in transaction (aborted)', 'disabled')
AND state_change < current_timestamp - INTERVAL '1' MINUTE;