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

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

opennms=# select datname,procpid,current_query FROM pg_stat_activity;
 datname | procpid | current_query
---------+---------+---------------
 opennms |   10340 | <IDLE>
(1 row)

opennms=# select datname,procpid,current_query FROM pg_stat_activity;
 datname | procpid | current_query
---------+---------+---------------
 opennms |   10340 | <IDLE>
(1 row)

opennms=#