madmax=# select * from pg_locks;
   locktype    | database | relation | page  | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction |  pid  |       mode       | granted
---------------+----------+----------+-------+-------+------------+---------------+---------+-------+----------+--------------------+-------+------------------+---------
 relation      |  1397730 |  1398075 |       |       |            |               |         |       |          | 63/15761           | 11157 | RowExclusiveLock | t      
 relation      |  1397730 |  1398075 |       |       |            |               |         |       |          | 4/10902            |  6421 | RowExclusiveLock | t      
 tuple         |  1397730 |  1398075 | 33783 |    38 |            |               |         |       |          | 63/15761           | 11157 | ExclusiveLock    | t      
 virtualxid    |          |          |       |       | 63/15761   |               |         |       |          | 63/15761           | 11157 | ExclusiveLock    | t      
 virtualxid    |          |          |       |       | 4/10902    |               |         |       |          | 4/10902            |  6421 | ExclusiveLock    | t      
 relation      |  1397730 |  1397973 |       |       |            |               |         |       |          | 63/15761           | 11157 | AccessShareLock  | t      
 relation      |  1397730 |  1398733 |       |       |            |               |         |       |          | 4/10902            |  6421 | AccessShareLock  | t      
 relation      |  1397730 |  1397973 |       |       |            |               |         |       |          | 4/10902            |  6421 | AccessShareLock  | t      
 relation      |  1397730 |    10969 |       |       |            |               |         |       |          | 64/26597           | 15370 | AccessShareLock  | t      
 relation      |  1397730 |  1397891 |       |       |            |               |         |       |          | 4/10902            |  6421 | AccessShareLock  | t      
 relation      |  1397730 |  1397891 |       |       |            |               |         |       |          | 63/15761           | 11157 | AccessShareLock  | t      
 transactionid |          |          |       |       |            |      39773877 |         |       |          | 63/15761           | 11157 | ShareLock        | f      
 relation      |  1397730 |  1398783 |       |       |            |               |         |       |          | 4/10902            |  6421 | RowExclusiveLock | t      
 relation      |  1397730 |  1398783 |       |       |            |               |         |       |          | 63/15761           | 11157 | RowExclusiveLock | t      
 transactionid |          |          |       |       |            |      39773877 |         |       |          | 4/10902            |  6421 | ExclusiveLock    | t      
 relation      |  1397730 |  1398737 |       |       |            |               |         |       |          | 4/10902            |  6421 | AccessShareLock  | t      
 virtualxid    |          |          |       |       | 64/26597   |               |         |       |          | 64/26597           | 15370 | ExclusiveLock    | t      
 relation      |  1397730 |  1398737 |       |       |            |               |         |       |          | 63/15761           | 11157 | AccessShareLock  | t      
 relation      |  1397730 |  1398939 |       |       |            |               |         |       |          | 4/10902            |  6421 | AccessShareLock  | t      
 transactionid |          |          |       |       |            |      39783847 |         |       |          | 63/15761           | 11157 | ExclusiveLock    | t      
 relation      |  1397730 |  1398939 |       |       |            |               |         |       |          | 63/15761           | 11157 | AccessShareLock  | t
 relation      |  1397730 |  1398761 |       |       |            |               |         |       |          | 63/15761           | 11157 | AccessShareLock  | t
 relation      |  1397730 |  1397882 |       |       |            |               |         |       |          | 4/10902            |  6421 | AccessShareLock  | t
 relation      |  1397730 |  1398938 |       |       |            |               |         |       |          | 4/10902            |  6421 | AccessShareLock  | t
 relation      |  1397730 |  1398938 |       |       |            |               |         |       |          | 63/15761           | 11157 | AccessShareLock  | t
 relation      |  1397730 |  1398735 |       |       |            |               |         |       |          | 4/10902            |  6421 | AccessShareLock  | t
 relation      |  1397730 |  1398761 |       |       |            |               |         |       |          | 4/10902            |  6421 | AccessShareLock  | t
(27 rows)