opennms=# select * from pg_locks ;
   locktype    | database | relation | page | tuple | transactionid | classid | objid | objsubid | transaction |  pid  |      mode       | granted
---------------+----------+----------+------+-------+---------------+---------+-------+----------+-------------+-------+-----------------+---------
 transactionid |          |          |      |       |     229438292 |         |       |          |   229438292 | 13758 | ExclusiveLock   | t
 relation      |    19710 |    10342 |      |       |               |         |       |          |   229438292 | 13758 | AccessShareLock | t
(2 rows)

opennms=#