-
Problem report
-
Resolution: Fixed
-
Critical
-
6.0.19rc1, 6.4.4rc1
-
RHEl8
Database hardware:
- 64 cores
- 512GB of RAM
- PostgreSQL 15.3
- TimescaleDB 2.10.3
- all-flash array
- Zabbix 6.2
-
S24-W30/31, S24-W32/33, S24-W34/35, S24-W36/37, S24-W38/39, S24-W40/41
-
4
Steps to reproduce:
- use Zabbix in a highly dynamic environment with 1-5m update interval for LLD
Table size:
item_tag | 11 GB | 11745476608
Result:
Database is overloaded with:
... 3912902 | postgres | 2023-06-21 14:50:46.778289+02 | 00:05:45.154366 | SELECT tag,value,itemid FROM item_tag WHERE (itemid IN (46869,46870,46872,46873,46875,46876,46880,46881,46883,46884,46885 ,46886,46887,46893,46894,46895,46896,46897,46898,46899,46900,46901,46902,46903,46904,46905,46906,46907,46908,46909,46910,46911,46912,46913,46914,46920,46922,47229,47230,47232,47233,47235,47236,47240,47 241,47243,47244,47245,47246,47247,47253,47254,47255,47256,47257,47258,47259,47260,47261,47262,47263,47264,47265,47266,47267,47268,47269,47270,47271,47272,47273,47274,47280,47282,47469,47470,47472,47473 ,47475,47476,47480,47481,47483,47484,47485,47486,47487,47493,47494,47495,47496,47497,47498,47499,47500,47501,47502,47503,47504,47505,47506,47507,47508,47509,47510,47511,47512,47513,47514,47520,47522,47 709,47710,47712,47713,47715,47716,47720,47721,47723,47724,47725,47726,47727,47733,47734,47735,47736,47737,47738,47739,47740,47741,47742,47743,47744,47745,47746,47747,47748,47749,47750,47751,47752,47753 ,47754,47760,47762,48069,48070,48072,48073,48075,48076,48080,48081,48083,48084,48085,48086,48087,4 | active | | 3885483 | postgres | 2023-06-21 14:44:28.192753+02 | 00:12:03.739902 | SELECT tag,value,itemid FROM item_tag WHERE (itemid IN (5660883,5660884,5660885,5660886,5660887,5660888,5660889,5660890,5 660891,5660892,5660893,5660894,5660895,5660896,5660897,5660898,5660899,5660900,5660901,5660902,5660903,5660904,5660905,5660906,5660907,5660908,5660909,5660910,5660914,5660915,5660916,5660917,5660918,56 60919,5660920,5660921,5660922,5660924,5660925,5660926,5660927,5660928,5660929,5660930,5660931,5660932,5660938,5660939,5660940,5660950,5660952,5661045,5661046,5661047,5661048,5661049,5661050,5661051,566 1052,5661053,5661054,5661055,5661056,5661057,5661058,5661059,5661060,5661061,5661062,5661063,5661064,5661065,5661066,5661067,5661068,5661069,5661070,5661071,5661072,5661076,5661077,5661078,5661079,5661 080,5661081,5661082,5661083,5661084,5661086,5661087,5661088,5661089,5661090,5661091,5661092,5661093,5661094,5661100,5661101,5661102,5661112,5661114,5666729,5666730,5666731,5666732,5666733,5666734,56667 35,5666736,5666737,5666738,5666739,5666740,5666741,5666742,5666751,5666752,5666753,5666754,5666755 | active ...
Expected:
Do not create heavy SQL for the database on internal tasks.
