locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ---------------+----------+----------+------+-------+-------------+---------------+---------+-------+----------+--------------------+---------+-----------------+---------+----------+-----------+-------+-----------+---------+------------+----------+-----------+------------------+--------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+------------+---------------------+-------------+--------------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------- relation | 16385 | 42874672 | | | | | | | | 101/743510 | 2490371 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42874670 | | | | | | | | 101/743510 | 2490371 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42874663 | | | | | | | | 101/743510 | 2490371 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42158243 | | | | | | | | 101/743510 | 2490371 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42158252 | | | | | | | | 101/743510 | 2490371 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42158250 | | | | | | | | 101/743510 | 2490371 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 20772 | | | | | | | | 101/743510 | 2490371 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 17440 | | | | | | | | 101/743510 | 2490371 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 17434 | | | | | | | | 101/743510 | 2490371 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend virtualxid | | | | | 101/743510 | | | | | 101/743510 | 2490371 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 16802 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 16801 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 16799 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17433 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17432 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17431 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17430 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17429 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17428 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17427 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17426 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17424 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 16786 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 17409 | | | | | | | | 92/32018195 | 2490426 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend virtualxid | | | | | 92/32018195 | | | | | 92/32018195 | 2490426 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490426 | | 16384 | zabbix_db | | x.x.x.x | | 47304 | 2023-01-13 10:03:31.53181+01 | 2023-01-13 10:03:32.126578+01 | 2023-01-13 10:03:32.133565+01 | 2023-01-13 10:03:32.134999+01 | Client | ClientRead | idle in transaction | | | | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.eventid IN (95178121,95244580,95248466,95253917,95254131,95959353,95960443,95962038,95962859,107681694,108654844,110293332,110413104,110978828,110979476,112319170,112326515,115678170,115841322,118476746,122003870,126351621,126352013,126453840,129151240,129154935,129154936,129155090,129155251,129157899,129158781,129160615,129258164,129259745,129260994,129266337,132334849,138179398,139090756,139344022,139606929,143020265,144951544,145908563,151056601,151222770,151222779,151222841,151223551,151224561,151224659,151224697,151224963,151225139,151226049,151227131,151227370,151228603,151229152,151230144,151230196,151230699,151231254,151231391,151231435,151231616,151231617,151231698,151232194,151232813,151232878,151486778,153541147,157601509,158649621,159346232,159380654,159382447,159387794,159461682,159465607,159493739,159496755,162808765,162812968,164644325,164649 | client backend relation | 16385 | 12435 | | | | | | | | 102/408992 | 2490431 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490431 | | 10 | postgres | psql | | | -1 | 2023-01-13 10:03:32.113773+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.13261+01 | | | active | | 615029202 | | SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid; | client backend relation | 16385 | 12290 | | | | | | | | 102/408992 | 2490431 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490431 | | 10 | postgres | psql | | | -1 | 2023-01-13 10:03:32.113773+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.13261+01 | | | active | | 615029202 | | SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid; | client backend virtualxid | | | | | 102/408992 | | | | | 102/408992 | 2490431 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490431 | | 10 | postgres | psql | | | -1 | 2023-01-13 10:03:32.113773+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.13261+01 | | | active | | 615029202 | | SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid; | client backend relation | 16385 | 42874682 | | | | | | | | 93/23759449 | 2490359 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42874680 | | | | | | | | 93/23759449 | 2490359 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42874673 | | | | | | | | 93/23759449 | 2490359 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42158253 | | | | | | | | 93/23759449 | 2490359 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42158262 | | | | | | | | 93/23759449 | 2490359 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42158260 | | | | | | | | 93/23759449 | 2490359 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 20774 | | | | | | | | 93/23759449 | 2490359 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 17448 | | | | | | | | 93/23759449 | 2490359 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 17442 | | | | | | | | 93/23759449 | 2490359 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend virtualxid | | | | | 93/23759449 | | | | | 93/23759449 | 2490359 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42874682 | | | | | | | | 100/1310151 | 2490236 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42874680 | | | | | | | | 100/1310151 | 2490236 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42874673 | | | | | | | | 100/1310151 | 2490236 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42158253 | | | | | | | | 100/1310151 | 2490236 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42158262 | | | | | | | | 100/1310151 | 2490236 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 42158260 | | | | | | | | 100/1310151 | 2490236 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 20774 | | | | | | | | 100/1310151 | 2490236 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 17448 | | | | | | | | 100/1310151 | 2490236 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 17442 | | | | | | | | 100/1310151 | 2490236 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend virtualxid | | | | | 100/1310151 | | | | | 100/1310151 | 2490236 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend relation | 16385 | 17615 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 17614 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 17612 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 35779955 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16468 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16467 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16466 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16465 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16464 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16462 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 17600 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16433 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16802 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16801 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16799 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 16786 | | | | | | | | 63/2490191 | 4086598 | AccessShareLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend virtualxid | | | | | 63/2490191 | | | | | 63/2490191 | 4086598 | ExclusiveLock | t | t | | 16385 | zabbix_db | 4086598 | | 16384 | zabbix_db | | y.y.y.y | | 54100 | 2023-01-05 09:54:36.899055+01 | 2023-01-13 10:03:32.116572+01 | 2023-01-13 10:03:32.138531+01 | 2023-01-13 10:03:32.138921+01 | Client | ClientRead | idle in transaction | | | | select h.host,h.hostid,h.proxy_hostid,a.host_metadata,a.listen_ip,a.listen_dns,a.listen_port,a.flags,a.autoreg_hostid from hosts h left join autoreg_host a on a.proxy_hostid=h.proxy_hostid and a.host=h.host where h.host in ('SITSPO41AQ01','DFCN35F1S1','SCOEVC2131','SBRVIT2001','SCABOGA1AQ01','SCAMQGA2AQ01','SUSSTR052') | client backend relation | 16385 | 42874672 | | | | | | | | 94/17797473 | 2490197 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42874670 | | | | | | | | 94/17797473 | 2490197 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42874663 | | | | | | | | 94/17797473 | 2490197 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42158243 | | | | | | | | 94/17797473 | 2490197 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42158252 | | | | | | | | 94/17797473 | 2490197 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 42158250 | | | | | | | | 94/17797473 | 2490197 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 20772 | | | | | | | | 94/17797473 | 2490197 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 17440 | | | | | | | | 94/17797473 | 2490197 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 16385 | 17434 | | | | | | | | 94/17797473 | 2490197 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend virtualxid | | | | | 94/17797473 | | | | | 94/17797473 | 2490197 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend virtualxid | | | | | 39/2357770 | | | | | 39/2357770 | 4086574 | ExclusiveLock | t | t | | 16385 | zabbix_db | 4086574 | | 16384 | zabbix_db | | y.y.y.y | | 54052 | 2023-01-05 09:54:36.741848+01 | 2023-01-13 10:03:32.127728+01 | 2023-01-13 10:03:32.138955+01 | 2023-01-13 10:03:32.138958+01 | | | active | | 615029202 | | insert into history (itemid,clock,ns,value) values (672069,1673600608,83966979,0),(672070,1673600608,83966979,0.10456333333333333),(870347,1673600608,83966979,0),(870348,1673600608,83966979,0.10715333333333334),(988110,1673600610,486050751,0),(988710,1673600610,481925000,45.727041),(988711,1673600610,481925000,54.272959),(990810,1673600610,470660426,55.891627),(991110,1673600610,471384727,0.78357200000000005),(991710,1673600610,419052928,0),(995010,1673600610,474059634,0.18326100000000001),(996210,1673600610,361874336,3.337914),(996510,1673600610,351669070,77.144998999999999),(996810,1673600610,350479355,0),(1000410,1673600611,194168784,0),(1001910,1673600610,767273069,0),(1002810,1673600610,801643984,0),(1004310,1673600610,359512776,5),(1005210,1673600610,385299049,4630.0975900000003),(1008210,1673600610,769734699,8.1304429999999996),(1010610,1673600610,367627825,1.9173720000000001),(1012110,1673600610,366332027,1.7821819999999999),(1012410,1673600610,391415451,0.0010349999999999999),(1024364,1673600608,839 | client backend relation | 16385 | 42158262 | | | | | | | | 95/13541120 | 2490365 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490365 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469102+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475961+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42158253 | | | | | | | | 95/13541120 | 2490365 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490365 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469102+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475961+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42874680 | | | | | | | | 95/13541120 | 2490365 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490365 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469102+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475961+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42874673 | | | | | | | | 95/13541120 | 2490365 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490365 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469102+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475961+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker virtualxid | | | | | 95/13541120 | | | | | 95/13541120 | 2490365 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490365 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469102+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475961+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42158262 | | | | | | | | 98/3002366 | 2490368 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490368 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.477301+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.483379+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42158253 | | | | | | | | 98/3002366 | 2490368 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490368 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.477301+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.483379+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42874680 | | | | | | | | 98/3002366 | 2490368 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490368 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.477301+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.483379+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42874673 | | | | | | | | 98/3002366 | 2490368 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490368 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.477301+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.483379+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker virtualxid | | | | | 98/3002366 | | | | | 98/3002366 | 2490368 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490368 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.477301+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.483379+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42158262 | | | | | | | | 97/4523765 | 2490367 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490367 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469607+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.476122+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42158253 | | | | | | | | 97/4523765 | 2490367 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490367 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469607+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.476122+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42874680 | | | | | | | | 97/4523765 | 2490367 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490367 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469607+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.476122+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42874673 | | | | | | | | 97/4523765 | 2490367 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490367 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469607+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.476122+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker virtualxid | | | | | 97/4523765 | | | | | 97/4523765 | 2490367 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490367 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469607+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.476122+01 | | | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42158262 | | | | | | | | 96/8155933 | 2490366 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490366 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469371+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475978+01 | IPC | BtreePage | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42158253 | | | | | | | | 96/8155933 | 2490366 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490366 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469371+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475978+01 | IPC | BtreePage | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42874680 | | | | | | | | 96/8155933 | 2490366 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490366 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469371+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475978+01 | IPC | BtreePage | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 16385 | 42874673 | | | | | | | | 96/8155933 | 2490366 | AccessShareLock | t | t | | 16385 | zabbix_db | 2490366 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469371+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475978+01 | IPC | BtreePage | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker virtualxid | | | | | 96/8155933 | | | | | 96/8155933 | 2490366 | ExclusiveLock | t | t | | 16385 | zabbix_db | 2490366 | 2490359 | 16384 | zabbix_db | | | | | 2023-01-13 10:03:07.469371+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.475978+01 | IPC | BtreePage | active | | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | parallel worker relation | 0 | 2676 | | | | | | | | 102/408992 | 2490431 | AccessShareLock | t | f | | 16385 | zabbix_db | 2490431 | | 10 | postgres | psql | | | -1 | 2023-01-13 10:03:32.113773+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.13261+01 | | | active | | 615029202 | | SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid; | client backend transactionid | | | | | | 615036839 | | | | 93/23759449 | 2490359 | ExclusiveLock | t | f | | 16385 | zabbix_db | 2490359 | | 16384 | zabbix_db | | x.x.x.x | | 47206 | 2023-01-13 10:03:07.196464+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457004+01 | 2023-01-13 10:03:07.457014+01 | | | active | 615036839 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend transactionid | | | | | | 615033344 | | | | 100/1310151 | 2490236 | ExclusiveLock | t | f | | 16385 | zabbix_db | 2490236 | | 16384 | zabbix_db | | x.x.x.x | | 47094 | 2023-01-13 10:02:35.249801+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952558+01 | 2023-01-13 10:02:35.952567+01 | | | active | 615033344 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history_uint h WHERE (h.itemid IN (358296,912420,914128,914140,914152,914164,914176,914188,914200,914212,914224,914236,914248,914268,914356,914368,914380,914783,915889,915913,915937,916084,916169,916267,916318,916563,916826,916956,917538,917554,917566,917578,917590,917653,917862,917947,917971,918011,918479,918504,919167,919207,919368,920228,920260,920398,920470,920550,921691,921763,925880,925900,925920,925984,929777,931423,931876,931896,931900,931928,931932,931944,931964,931968,932355,932359,932375,932395,932411,932432,932996,933045,933072,933513,933954,933987,934014,934038,934062,934077,934699,935070,935082,935094,935190,935286,935361,935466,935490,935563,935587,936584,936629,936777,936789,936801,936903,936932,937033,937047,937083,937095,937767,937821,937841,937857,938883,939434,939507,939531,939765,939785,939833,939853,939877,939901,939925,939961,939979,939999,940178,940206,940233,940324,940350,940391,940399,940503,940510,940551,940558,940583,940608,940632,940732 | client backend transactionid | | | | | | 615036907 | | | | 101/743510 | 2490371 | ExclusiveLock | t | f | | 16385 | zabbix_db | 2490371 | | 16384 | zabbix_db | | x.x.x.x | | 47214 | 2023-01-13 10:03:08.583232+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319067+01 | 2023-01-13 10:03:09.319075+01 | | | active | 615036907 | 615022798 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 0 | 1262 | | | | | | | | 102/408992 | 2490431 | AccessShareLock | t | f | | 16385 | zabbix_db | 2490431 | | 10 | postgres | psql | | | -1 | 2023-01-13 10:03:32.113773+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.13261+01 | | | active | | 615029202 | | SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid; | client backend relation | 0 | 2672 | | | | | | | | 102/408992 | 2490431 | AccessShareLock | t | f | | 16385 | zabbix_db | 2490431 | | 10 | postgres | psql | | | -1 | 2023-01-13 10:03:32.113773+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.13261+01 | | | active | | 615029202 | | SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid; | client backend relation | 0 | 2677 | | | | | | | | 102/408992 | 2490431 | AccessShareLock | t | f | | 16385 | zabbix_db | 2490431 | | 10 | postgres | psql | | | -1 | 2023-01-13 10:03:32.113773+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.13261+01 | | | active | | 615029202 | | SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid; | client backend transactionid | | | | | | 615029202 | | | | 94/17797473 | 2490197 | ExclusiveLock | t | f | | 16385 | zabbix_db | 2490197 | | 16384 | zabbix_db | | x.x.x.x | | 47046 | 2023-01-13 10:02:27.311792+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712487+01 | 2023-01-13 10:02:27.712498+01 | | | active | 615029202 | 615017046 | | SELECT h.itemid, MAX(h.clock) AS clock FROM history h WHERE (h.itemid IN (342978,912380,912462,912743,912804,912865,912926,912987,913048,913109,913170,913231,913292,913353,913548,913609,913670,914422,914483,914544,914605,914666,914727,915984,916061,916130,916454,916524,916609,916686,916747,916872,916933,917052,917122,917183,917244,917420,918300,918361,918440,918549,918671,919011,919072,919273,919476,919537,920175,920343,925030,925091,925206,925690,926716,926882,926943,927065,927126,927187,927248,927309,927370,927431,927492,927601,927662,927723,927784,927845,927906,927967,928082,928204,928265,929094,929155,929216,929277,929338,929420,929481,929542,929603,929664,929746,929819,929880,929941,930002,930117,930178,930617,930678,930739,930800,930861,931027,931088,931149,931210,931271,932010,932125,932186,932308,932477,932538,932599,932660,932721,932782,932843,932904,932965,933229,933290,933351,933412,933473,933579,933640,933701,933762,933823,934119,934180,934241,934302,934432,934554,934615,934676,934741,934802,9348 | client backend relation | 0 | 1260 | | | | | | | | 102/408992 | 2490431 | AccessShareLock | t | f | | 16385 | zabbix_db | 2490431 | | 10 | postgres | psql | | | -1 | 2023-01-13 10:03:32.113773+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.13261+01 | | | active | | 615029202 | | SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid; | client backend relation | 0 | 2671 | | | | | | | | 102/408992 | 2490431 | AccessShareLock | t | f | | 16385 | zabbix_db | 2490431 | | 10 | postgres | psql | | | -1 | 2023-01-13 10:03:32.113773+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.132609+01 | 2023-01-13 10:03:32.13261+01 | | | active | | 615029202 | | SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid; | client backend