[Postgres Delete Locks] delete all hang queries #postgres #db

snippet.sql

SELECT pg_terminate_backend(b.pid)
from (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') as b
where pid <> pg_backend_pid();