Cacher is the code snippet organizer for pro developers

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

SELECT pg_cancel_backend(__pid__);