Skip to content

Instantly share code, notes, and snippets.

@chriskacerguis

chriskacerguis/gist:de6464f83b84c308d4b1d16f14ccf95c

Created July 1, 2016 20:52
Show Gist options
  • Save chriskacerguis/de6464f83b84c308d4b1d16f14ccf95c to your computer and use it in GitHub Desktop.
Save chriskacerguis/de6464f83b84c308d4b1d16f14ccf95c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT l.*,a.*
FROM pg_locks l
JOIN pg_stat_activity a USING (pid)
WHERE NOT granted;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment