cancel old queries

cancel_old_queries.sql

SELECT
  pg_cancel_backend(pid),
  now()-pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now()-pg_stat_activity.query_start) > interval '1 day';
SELECT pg_sleep(30);
SELECT
  pg_terminate_backend(pid),
  now()-pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now()-pg_stat_activity.query_start) > interval '1 day';