Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- postgres=# SELECT * FROM pg_locks WHERE NOT GRANTED;
- locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath
- ---------------+-----------+-----------+------+-------+------------+---------------+---------+-------+----------+--------------------+------+---------------+---------+----------
- transactionid | | | | | | 379312946 | | | | 104/18755 | 1663 | ShareLock | f | f
- transactionid | | | | | | 379312946 | | | | 97/12635 | 1644 | ShareLock | f | f
- tuple | 327012182 | 327015270 | 7 | 38 | | | | | | 34/69791 | 1405 | ExclusiveLock | f | f
- transactionid | | | | | | 379312946 | | | | 30/44324 | 1397 | ShareLock | f | f
- tuple | 327012182 | 327015270 | 7 | 38 | | | | | | 53/33819 | 1560 | ExclusiveLock | f | f
- transactionid | | | | | | 379312946 | | | | 103/9891 | 1653 | ShareLock | f | f
- tuple | 327012182 | 327015270 | 7 | 38 | | | | | | 79/21280 | 1415 | ExclusiveLock | f | f
- tuple | 327012182 | 327015270 | 7 | 38 | | | | | | 98/13543 | 1649 | ExclusiveLock | f | f
- transactionid | | | | | | 379312946 | | | | 75/18769 | 1406 | ShareLock | f | f
- tuple | 327012182 | 327015270 | 7 | 38 | | | | | | 81/15864 | 1411 | ExclusiveLock | f | f
- transactionid | | | | | | 379312946 | | | | 102/46363 | 1661 | ShareLock | f | f
- (11 rows)
Add Comment
Please, Sign In to add comment
