Created
July 30, 2012 00:44
-
-
Save mayhem/3202996 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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