testdb=# SELECT * FROM pg_locks; locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath ---------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+------------------+---------+---------- relation | 16458 | 16459 | | | | | | | | 4/1232 | 19671 | RowExclusiveLock | t | t virtualxid | | | | | 4/1232 | | | | | 4/1232 | 19671 | ExclusiveLock | t | t relation | 16458 | 16459 | | | | | | | | 3/1404 | 19670 | RowShareLock | t | t relation | 16458 | 16459 | | | | | | | | 3/1404 | 19670 | RowExclusiveLock | t | t virtualxid | | | | | 3/1404 | | | | | 3/1404 | 19670 | ExclusiveLock | t | t relation | 16458 | 16459 | | | | | | | | 5/694 | 19673 | RowExclusiveLock | t | t virtualxid | | | | | 5/694 | | | | | 5/694 | 19673 | ExclusiveLock | t | t relation | 16458 | 11090 | | | | | | | | 2/4 | 16248 | AccessShareLock | t | t virtualxid | | | | | 2/4 | | | | | 2/4 | 16248 | ExclusiveLock | t | t transactionid | | | | | | 133499 | | | | 4/1232 | 19671 | ShareLock | f | f tuple | 16458 | 16459 | 0 | 8 | | | | | | 4/1232 | 19671 | ExclusiveLock | t | f transactionid | | | | | | 133498 | | | | 4/1232 | 19671 | ExclusiveLock | t | f transactionid | | | | | | 133499 | | | | 3/1404 | 19670 | ExclusiveLock | t | f tuple | 16458 | 16459 | 0 | 8 | | | | | | 3/1404 | 19670 | ExclusiveLock | f | f tuple | 16458 | 16459 | 0 | 8 | | | | | | 5/694 | 19673 | ExclusiveLock | f | f transactionid | | | | | | 133500 | | | | 5/694 | 19673 | ExclusiveLock | t | f (16 rows)