Skip to content

Instantly share code, notes, and snippets.

@marcelolebre

marcelolebre/terminate_active_locks.sql

Created August 19, 2017 08:52
Show Gist options
  • Save marcelolebre/c34f7455f1494cb620f361f080d50e25 to your computer and use it in GitHub Desktop.
Save marcelolebre/c34f7455f1494cb620f361f080d50e25 to your computer and use it in GitHub Desktop.
Download ZIP
Terminate locks on Postgres
Raw
terminate_active_locks.sql
select pg_terminate_backend(pid) from active_locks;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment