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

opennms=# select datname,procpid,current_query FROM pg_stat_activity;
 datname | procpid | current_query
---------+---------+---------------
 opennms |   11030 | <IDLE>
 opennms |    9810 | <IDLE>
 opennms |    9809 | <IDLE>
 opennms |    3210 | <IDLE>
 opennms |    3208 | <IDLE>
 opennms |   23327 | <IDLE>
 opennms |   11031 | <IDLE>
 opennms |   11032 | <IDLE>
 opennms |    4044 | <IDLE>
 opennms |    9811 | <IDLE>
 opennms |    1566 | <IDLE>
 opennms |    1567 | <IDLE>
 opennms |   14525 | <IDLE>
 opennms |    9812 | <IDLE>
 opennms |   13568 | <IDLE>
 opennms |   15681 | <IDLE>
 opennms |   15682 | <IDLE>
 opennms |   11033 | <IDLE>
 opennms |     467 | <IDLE>
 opennms |    1568 | <IDLE>
 opennms |    5055 | <IDLE>
 opennms |   15686 | <IDLE>
 opennms |    9813 | <IDLE>
 opennms |    9814 | <IDLE>
 opennms |    9815 | <IDLE>
 opennms |    9659 | <IDLE>
 opennms |    1569 | <IDLE>
 opennms |    3215 | <IDLE>
 opennms |   11034 | <IDLE>
 opennms |    9816 | <IDLE>
 opennms |    9038 | <IDLE>
 opennms |   28041 | <IDLE>
 opennms |   23335 | <IDLE>
 opennms |   28032 | <IDLE>
 opennms |    1570 | <IDLE>
 opennms |   30742 | <IDLE>
 opennms |    9661 | <IDLE>
 opennms |    3216 | <IDLE>
 opennms |    9820 | <IDLE>
 opennms |   19895 | <IDLE>
 opennms |    1571 | <IDLE>
 opennms |    3218 | <IDLE>
 opennms |    9662 | <IDLE>
 opennms |    3219 | <IDLE>
 opennms |   14526 | <IDLE>
 opennms |    1572 | <IDLE>
 opennms |   14528 | <IDLE>
 opennms |    9821 | <IDLE>
 opennms |    8742 | <IDLE>
 opennms |    8743 | <IDLE>
 opennms |   17567 | <IDLE>
 opennms |   17679 | <IDLE>
 opennms |   21915 | <IDLE>
(53 rows)

opennms=#