opennms=# select * from pg_locks; locktype | database | relation | page | tuple | transactionid | classid | objid | objsubid | transaction | pid | mode | granted ---------------+----------+----------+------+-------+---------------+---------+-------+----------+-------------+------+-----------------+--------- relation | 17671 | 18007 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17778 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17742 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17729 | | | | | | | 242134628 | 4407 | AccessShareLock | t transactionid | | | | | 242134628 | | | | 242134628 | 4407 | ExclusiveLock | t relation | 17671 | 17976 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17814 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17760 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17813 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17734 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18058 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17758 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17764 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18024 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18026 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17789 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17811 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17777 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17969 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17792 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17776 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17977 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17782 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18055 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17812 | | | | | | | 242134628 | 4407 | AccessShareLock | t transactionid | | | | | 242428867 | | | | 242428867 | 6827 | ExclusiveLock | t relation | 17671 | 17998 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17743 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18054 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17745 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17751 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18040 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18042 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17780 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18057 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17759 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18005 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17815 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17809 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17781 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17779 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18006 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 18056 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17810 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17744 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 10328 | | | | | | | 242428867 | 6827 | AccessShareLock | t relation | 17671 | 17741 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17761 | | | | | | | 242134628 | 4407 | AccessShareLock | t relation | 17671 | 17963 | | | | | | | 242134628 | 4407 | AccessShareLock | t (49 rows) opennms=# select * FROM pg_stat_activity; datid | datname | procpid | usesysid | usename | current_query | waiting | query_start | backend_start | client_addr | client_port -------+---------+---------+----------+----------+---------------------------------+---------+-------------------------------+-------------------------------+-------------+------------- 17671 | opennms | 7047 | 16384 | opennms | | f | 2008-03-10 11:49:37.923142-04 | 2008-03-10 11:49:37.91534-04 | 192.168.0.7 | 52561 17671 | opennms | 7051 | 16384 | opennms | | f | 2008-03-10 11:50:53.24273-04 | 2008-03-10 11:50:53.236487-04 | 192.168.0.7 | 55074 17671 | opennms | 7037 | 16384 | opennms | | f | 2008-03-10 11:48:44.065476-04 | 2008-03-10 11:48:19.777253-04 | 192.168.0.7 | 36525 17671 | opennms | 7052 | 16384 | opennms | | f | 2008-03-10 11:55:39.530209-04 | 2008-03-10 11:50:53.318679-04 | 192.168.0.7 | 55932 17671 | opennms | 7053 | 16384 | opennms | | f | 2008-03-10 11:55:39.517832-04 | 2008-03-10 11:50:53.32502-04 | 192.168.0.7 | 36571 17671 | opennms | 7061 | 16384 | opennms | | f | 2008-03-10 11:55:39.512023-04 | 2008-03-10 11:54:48.369535-04 | 192.168.0.7 | 58767 17671 | opennms | 7038 | 16384 | opennms | | f | 2008-03-10 11:48:44.089172-04 | 2008-03-10 11:48:43.943632-04 | 192.168.0.7 | 41465 17671 | opennms | 7054 | 16384 | opennms | | f | 2008-03-10 11:55:39.517967-04 | 2008-03-10 11:50:53.329619-04 | 192.168.0.7 | 39993 17671 | opennms | 7062 | 16384 | opennms | | f | 2008-03-10 11:57:13.941151-04 | 2008-03-10 11:54:48.379236-04 | 192.168.0.7 | 47418 17671 | opennms | 18862 | 16384 | opennms | | f | 2008-03-07 03:50:01.965532-05 | 2008-03-07 03:46:31.101028-05 | 192.168.0.7 | 49451 17671 | opennms | 7063 | 16384 | opennms | | f | 2008-03-10 11:55:39.539547-04 | 2008-03-10 11:54:48.383186-04 | 192.168.0.7 | 33680 17671 | opennms | 7064 | 16384 | opennms | | f | 2008-03-10 11:57:47.139009-04 | 2008-03-10 11:54:48.388038-04 | 192.168.0.7 | 54538 17671 | opennms | 7028 | 16384 | opennms | | f | 2008-03-10 11:45:07.910758-04 | 2008-03-10 11:44:36.4025-04 | 192.168.0.7 | 36016 17671 | opennms | 2025 | 16384 | opennms | | f | 2008-03-09 16:01:34.783945-04 | 2008-03-09 15:55:55.827245-04 | 192.168.0.7 | 57662 17671 | opennms | 7029 | 16384 | opennms | | f | 2008-03-10 11:48:04.947465-04 | 2008-03-10 11:44:36.407197-04 | 192.168.0.7 | 51620 17671 | opennms | 7034 | 16384 | opennms | | f | 2008-03-10 11:47:47.071158-04 | 2008-03-10 11:45:48.249768-04 | 192.168.0.7 | 55879 17671 | opennms | 7039 | 16384 | opennms | | f | 2008-03-10 11:48:47.530249-04 | 2008-03-10 11:48:44.069233-04 | 192.168.0.7 | 59804 17671 | opennms | 15935 | 16384 | opennms | | f | 2008-03-06 17:04:07.423301-05 | 2008-03-06 16:57:04.390454-05 | 192.168.0.7 | 56477 17671 | opennms | 7040 | 16384 | opennms | | f | 2008-03-10 11:48:47.537342-04 | 2008-03-10 11:48:47.533531-04 | 192.168.0.7 | 48466 17671 | opennms | 7041 | 16384 | opennms | | f | 2008-03-10 11:48:47.547672-04 | 2008-03-10 11:48:47.539489-04 | 192.168.0.7 | 32978 17671 | opennms | 7042 | 16384 | opennms | | f | 2008-03-10 11:48:47.627796-04 | 2008-03-10 11:48:47.617471-04 | 192.168.0.7 | 59020 17671 | opennms | 7057 | 16384 | opennms | | f | 2008-03-10 11:55:36.369579-04 | 2008-03-10 11:52:10.900927-04 | 192.168.0.7 | 58946 17671 | opennms | 15780 | 16384 | opennms | | f | 2008-03-06 16:26:34.144591-05 | 2008-03-06 16:25:49.230778-05 | 192.168.0.7 | 40006 17671 | opennms | 7043 | 16384 | opennms | | f | 2008-03-10 11:49:37.92364-04 | 2008-03-10 11:48:47.634947-04 | 192.168.0.7 | 37707 17671 | opennms | 7048 | 16384 | opennms | | f | 2008-03-10 11:50:28.121607-04 | 2008-03-10 11:49:37.924442-04 | 192.168.0.7 | 53899 17671 | opennms | 12723 | 16384 | opennms | | f | 2008-03-06 06:11:08.966288-05 | 2008-03-06 06:10:46.069204-05 | 192.168.0.7 | 47466 17671 | opennms | 7044 | 16384 | opennms | | f | 2008-03-10 11:49:37.903423-04 | 2008-03-10 11:48:47.640244-04 | 192.168.0.7 | 49676 17671 | opennms | 4407 | 16384 | opennms | in transaction | f | 2008-03-10 11:57:32.923368-04 | 2008-03-10 01:19:22.02259-04 | 192.168.0.7 | 51659 17671 | opennms | 27655 | 16384 | opennms | | f | 2008-03-08 12:04:56.500724-05 | 2008-03-08 12:02:52.095537-05 | 192.168.0.7 | 38520 17671 | opennms | 7055 | 16384 | opennms | | f | 2008-03-10 11:55:39.539627-04 | 2008-03-10 11:50:56.884998-04 | 192.168.0.7 | 56967 17671 | opennms | 13158 | 16384 | opennms | | f | 2008-03-06 07:17:13.174144-05 | 2008-03-06 07:17:01.406167-05 | 192.168.0.7 | 55855 17671 | opennms | 6370 | 16384 | opennms | | f | 2008-03-05 09:10:18.90228-05 | 2008-03-05 09:09:25.87448-05 | 192.168.0.7 | 38331 17671 | opennms | 7065 | 16384 | opennms | | f | 2008-03-10 11:57:13.946107-04 | 2008-03-10 11:54:51.553272-04 | 192.168.0.7 | 60781 17671 | opennms | 29548 | 16384 | opennms | | f | 2008-03-04 19:38:07.481611-05 | 2008-03-04 19:37:39.06329-05 | 192.168.0.7 | 33331 17671 | opennms | 7030 | 16384 | opennms | | f | 2008-03-10 11:48:43.940747-04 | 2008-03-10 11:44:39.526478-04 | 192.168.0.7 | 42298 17671 | opennms | 7066 | 16384 | opennms | | f | 2008-03-10 11:57:47.132446-04 | 2008-03-10 11:54:51.556739-04 | 192.168.0.7 | 49770 17671 | opennms | 7045 | 16384 | opennms | | f | 2008-03-10 11:55:39.543711-04 | 2008-03-10 11:48:47.653269-04 | 192.168.0.7 | 40251 17671 | opennms | 29224 | 16384 | opennms | | f | 2008-03-04 18:43:50.771182-05 | 2008-03-04 18:37:38.784278-05 | 192.168.0.7 | 33379 17671 | opennms | 7049 | 16384 | opennms | | f | 2008-03-10 11:55:39.516335-04 | 2008-03-10 11:49:37.928601-04 | 192.168.0.7 | 43269 17671 | opennms | 29236 | 16384 | opennms | | f | 2008-03-08 18:04:16.98659-05 | 2008-03-08 18:04:12.13449-05 | 192.168.0.7 | 49238 17671 | opennms | 29503 | 16384 | opennms | | f | 2008-03-04 19:27:52.870164-05 | 2008-03-04 19:27:39.023816-05 | 192.168.0.7 | 49690 17671 | opennms | 8515 | 16384 | opennms | | f | 2008-03-05 15:57:15.83118-05 | 2008-03-05 15:56:57.802735-05 | 192.168.0.7 | 44235 17671 | opennms | 6827 | 16384 | opennms | select * FROM pg_stat_activity; | f | 2008-03-10 11:57:59.304869-04 | 2008-03-10 10:57:33.544454-04 | | -1 17671 | opennms | 7071 | 10 | postgres | VACUUM public.stpinterface | f | | 2008-03-10 11:57:51.569876-04 | | (44 rows) opennms=# SELECT relation, transaction, pid, mode, granted, relname FROM pg_locks INNER JOIN pg_stat_user_tables ON pg_locks.relation = pg_stat_user_tables.relid WHERE pg_locks.pid='4407'; relation | transaction | pid | mode | granted | relname ----------+-------------+------+-----------------+---------+---------------------------------- 17998 | 242134628 | 4407 | AccessShareLock | t | pathoutage 17745 | 242134628 | 4407 | AccessShareLock | t | snmpinterface 17789 | 242134628 | 4407 | AccessShareLock | t | ifservices 18024 | 242134628 | 4407 | AccessShareLock | t | location_monitors 17729 | 242134628 | 4407 | AccessShareLock | t | node 17761 | 242134628 | 4407 | AccessShareLock | t | ipinterface 17963 | 242134628 | 4407 | AccessShareLock | t | assets 18040 | 242134628 | 4407 | AccessShareLock | t | location_specific_status_changes (8 rows) opennms=#