rendered paste bodyopennms=# 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=#