Skip to content

Instantly share code, notes, and snippets.

@avshyz avshyz/snippet.sql

Last active Jun 30, 2020
Embed
What would you like to do?
[Postgres Delete Locks] delete all hang queries #postgres #db
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();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.