Kill all queries that have been running for more than a minute in a Postgres datavase

terminator.sql

select pg_terminate_backend(pid)
from (
  SELECT
      pid
  FROM pg_stat_activity
     WHERE query <> '<insufficient privilege>'
     AND state <> 'idle'
     AND pid <> pg_backend_pid()
     AND query_start < now() - interval '1 minute'
     ORDER BY query_start DESC) t;