kill long running pg locks

kill-long-pg-locks.sql

WITH active_long_connections AS (
    SELECT pid, now() - backend_start AS duration
    FROM pg_stat_activity 
    WHERE state = 'active' 
    AND pid <> pg_backend_pid()
)
SELECT 
    pid, 
    duration, 
    pg_terminate_backend(pid) AS terminated
FROM active_long_connections
WHERE duration > interval '5 minutes';