opennms=# select datname,procpid,current_query FROM pg_stat_activity;
 datname | procpid | current_query
---------+---------+---------------
 opennms |   30721 | <IDLE>
 opennms |   21741 | <IDLE>
 opennms |    8857 | <IDLE>
 opennms |    8855 | <IDLE>
 opennms |   21742 | <IDLE>
 opennms |   32094 | <IDLE>
 opennms |   30723 | <IDLE>
 opennms |   28803 | <IDLE>
 opennms |   21744 | <IDLE>
 opennms |     679 | <IDLE>
 opennms |   13723 | <IDLE>
 opennms |   13724 | <IDLE>
 opennms |   21745 | <IDLE>
 opennms |   15684 | <IDLE>
 opennms |   23340 | <IDLE>
 opennms |     715 | <IDLE>
 opennms |     684 | <IDLE>
 opennms |   13726 | <IDLE>
 opennms |   13727 | <IDLE>
 opennms |   16417 | <IDLE>
 opennms |     718 | <IDLE>
 opennms |   16418 | <IDLE>
 opennms |    5782 | <IDLE>
 opennms |    5781 | <IDLE>
 opennms |   23341 | <IDLE>
 opennms |   32095 | <IDLE>
 opennms |   23343 | <IDLE>
 opennms |   32012 | <IDLE>
 opennms |   13731 | <IDLE>
 opennms |   32240 | <IDLE>
 opennms |    2706 | <IDLE>
 opennms |    2707 | <IDLE>
 opennms |    8858 | <IDLE>
 opennms |    2708 | <IDLE>
 opennms |    5783 | <IDLE>
 opennms |    2709 | <IDLE>
 opennms |   23019 | <IDLE>
 opennms |   15297 | <IDLE>
 opennms |    8859 | <IDLE>
 opennms |   13732 | <IDLE>
 opennms |   12633 | <IDLE>
 opennms |    2712 | <IDLE>
 opennms |   32047 | <IDLE>
 opennms |   32245 | <IDLE>
 opennms |    2713 | <IDLE>
 opennms |   28804 | <IDLE>
 opennms |   13735 | <IDLE>
 opennms |    8862 | <IDLE>
 opennms |    8863 | <IDLE>
 opennms |    6325 | <IDLE>
 opennms |   23345 | <IDLE>
 opennms |    7314 | <IDLE>
(52 rows)

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

opennms=#