de=# SELECT * FROM pg_locks;
   locktype    | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid  |       mode       | granted
---------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+------+------------------+---------
 relation      |    18801 |    20333 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    10985 |      |       |            |               |         |       |          | 7/27               | 6492 | AccessShareLock  | t
 virtualxid    |          |          |      |       | 7/27       |               |         |       |          | 7/27               | 6492 | ExclusiveLock    | t
 relation      |    18801 |    20013 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20329 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20391 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20007 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20001 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20390 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20339 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 virtualxid    |          |          |      |       | 5/9        |               |         |       |          | 5/9                | 3728 | ExclusiveLock    | t
 relation      |    18801 |    20317 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20019 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20398 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20389 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 virtualxid    |          |          |      |       | 6/601815   |               |         |       |          | 6/601815           | 6272 | ExclusiveLock    | t
 relation      |    18801 |    20025 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20337 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    19983 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    19977 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    19995 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    19971 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20031 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20393 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20125 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20341 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20335 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 transactionid |          |          |      |       |            |      13836733 |         |       |          | 6/601815           | 6272 | ExclusiveLock    | t
 relation      |    18801 |    20331 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20397 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20394 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20396 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20319 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20321 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20392 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20388 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    19989 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    20323 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
 relation      |    18801 |    53814 |      |       |            |               |         |       |          | 6/601815           | 6272 | RowExclusiveLock | t
 relation      |    18801 |    20395 |      |       |            |               |         |       |          | 5/9                | 3728 | AccessShareLock  | t
(40 rows)