Skip to content

Instantly share code, notes, and snippets.

@mayhem
Created July 30, 2012 00:44
Show Gist options
  • Save mayhem/3202996 to your computer and use it in GitHub Desktop.
Save mayhem/3202996 to your computer and use it in GitHub Desktop.
musicbrainz_db_20110516=# select * from pg_locks;
locktype | database | relation | page | tuple | virtualxid | transactionid | classid | obji
d | objsubid | virtualtransaction | pid | mode | granted
---------------+----------+----------+------+-------+-------------+---------------+---------+------
---+----------+--------------------+-------+---------------------+---------
relation | 1416385 | 1600597 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600580 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1514671 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
relation | 1416385 | 1514394 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 2720901 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600578 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600602 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1599242 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1515005 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600591 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1514866 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600626 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
virtualxid | | | | | 234/4600511 | | |
| | 234/4600511 | 705 | ExclusiveLock | t
relation | 1416385 | 2504517 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
virtualxid | | | | | 184/6445888 | | |
| | 184/6445888 | 32665 | ExclusiveLock | t
relation | 1416385 | 1514874 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 2720864 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 2504518 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600624 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1599228 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 2504526 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600596 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1600598 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 2720859 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1600590 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600601 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1599252 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1514988 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600612 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600615 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
virtualxid | | | | | 145/4905397 | | |
| | 145/4905397 | 716 | ExclusiveLock | t
relation | 1416385 | 2858145 | | | | | |
| | 85/5713022 | 579 | AccessExclusiveLock | t
virtualxid | | | | | 189/6412491 | | |
| | 189/6412491 | 551 | ExclusiveLock | t
relation | 1416385 | 2720861 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600629 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 2856551 | | | | | |
| | 85/5713022 | 579 | AccessExclusiveLock | t
relation | 1416385 | 2504515 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 10985 | | | | | |
| | 145/4905397 | 716 | AccessShareLock | t
relation | 1416385 | 1600551 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
relation | 1416385 | 1600611 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1599236 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600582 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 1515076 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
relation | 1416385 | 1599274 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 2720852 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 2720906 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1515005 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1515056 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600626 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1514412 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1514975 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
object | 1416385 | | | | | | 1247 | 28565
53 | 0 | 85/5713022 | 579 | AccessExclusiveLock | t
relation | 1416385 | 1599206 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1514400 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600589 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1599076 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1599194 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
transactionid | | | | | | 471528155 | |
| | 85/5713022 | 579 | ExclusiveLock | t
relation | 1416385 | 2720891 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600601 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600491 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1599252 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1600584 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 2504517 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
virtualxid | | | | | 265/5145315 | | |
| | 265/5145315 | 745 | ExclusiveLock | t
object | 0 | | | | | | 1260 | 163
84 | 0 | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1599242 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600602 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1600593 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1599212 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 2504518 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 1600597 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1514858 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1514894 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 1515065 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1514988 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1514926 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1654562 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600601 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1599208 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600598 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 2720859 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600596 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
object | 1416385 | | | | | | 1247 | 28565
52 | 0 | 85/5713022 | 579 | AccessExclusiveLock | t
relation | 1416385 | 1599280 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
relation | 1416385 | 1599276 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 2720915 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600493 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 2720864 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600561 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
relation | 1416385 | 1600627 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600523 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
relation | 1416385 | 2720907 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600492 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1600626 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 2504517 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1515005 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600579 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 2720852 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600614 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
relation | 1416385 | 1600602 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1599236 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1599082 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1514791 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
relation | 1416385 | 1599074 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1599166 | | | | | |
| | 265/5145315 | 745 | AccessShareLock | t
relation | 1416385 | 2720861 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1515056 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 1599252 | | | | | |
| | 189/6412491 | 551 | AccessShareLock | t
relation | 1416385 | 1600491 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1684018 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1599204 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 2720897 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1599274 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 1599076 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1600583 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 1600592 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
virtualxid | | | | | 85/5713022 | | |
| | 85/5713022 | 579 | ExclusiveLock | t
relation | 1416385 | 1514400 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
relation | 1416385 | 1600611 | | | | | |
| | 184/0 | 32665 | AccessShareLock | t
relation | 1416385 | 1600629 | | | | | |
| | 85/5713022 | 579 | AccessShareLock | t
relation | 1416385 | 1514975 | | | | | |
| | 234/4600511 | 705 | AccessShareLock | t
(122 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment