psql-kill-longrunning-queries.sql

WITH longrunners AS (
       SELECT pid, age(query_start, clock_timestamp()), query_start, usename, query
       FROM pg_stat_activity
       WHERE
           now() - query_start > '3 minutes'::interval
       AND
           query NOT ILIKE '%vacuum%'
       ORDER BY query_start desc
)
SELECT pg_cancel_backend(pid)
--- SELECT pg_terminal_backend(pid) if they do not yield
FROM longrunners;