Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- nailgun=> SELECT relation::regclass, * FROM pg_locks WHERE virtualtransaction='2/52';
- relation | locktype | database | relation | PAGE | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath
- ----------------------+---------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-----+---------------------+---------+----------
- nodes_mac_key | relation | 244167 | 1728505 | | | | | | | | 2/52 | 906 | AccessShareLock | t | t
- _hostname_cluster_uc | relation | 244167 | 1727790 | | | | | | | | 2/52 | 906 | AccessShareLock | t | t
- nodes_uuid_key | relation | 244167 | 1726580 | | | | | | | | 2/52 | 906 | AccessShareLock | t | t
- nodes_pkey | relation | 244167 | 1726576 | | | | | | | | 2/52 | 906 | AccessShareLock | t | t
- nodes | relation | 244167 | 1726569 | | | | | | | | 2/52 | 906 | RowShareLock | t | t
- | virtualxid | | | | | 2/52 | | | | | 2/52 | 906 | ExclusiveLock | t | t
- nodes | tuple | 244167 | 1726569 | 9 | 9 | | | | | | 2/52 | 906 | AccessExclusiveLock | t | f
- | transactionid | | | | | | 210881 | | | | 2/52 | 906 | ShareLock | f | f
- (8 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement