posgtres_long_running_query.sql

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';

-- can take a few minutes
SELECT pg_cancel_backend(__pid__);

-- effectively kill -9, need to be careful
SELECT pg_terminate_backend(__pid__);