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