Skip to content

Instantly share code, notes, and snippets.

@stultus

stultus/postgress_locks.txt

Created December 18, 2019 14:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save stultus/fd14681647c940e204cba681b7ea2ee8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save stultus/fd14681647c940e204cba681b7ea2ee8 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. stultus created this gist Dec 18, 2019.
    3 changes: 3 additions & 0 deletions postgress_locks.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    SELECT t.relname, l.locktype, page, virtualtransaction, pid, mode, granted
    FROM pg_locks l, pg_stat_all_tables t
    WHERE l.relation = t.relid ORDER BY relation asc;