Finding and killing long running PostgreSQL queries

kill-long-running-queries.sql

-- List all long-running queries

SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';


-- Soft kill query by process ID

SELECT pg_cancel_backend(<pid of the process>);

-- Hard kill query by process ID

SELECT pg_terminate_backend(<pid of the process>);