Hello!
We have an issue with Zabbix Server 5.0.12 and underlying PostgreSQL-13.3
There come slow queries (more than 10 min) doing stuff like:
SELECT h.* FROM history h WHERE (h.itemid IN (<some_list_of_item_ids>) OR h.itemid IN (<some__another_list_of_item_ids>) OR h.itemid IN .... and so on.
Last investigating showed 5 simultaneous backends (except for parallel workers) with that query.
Such events cause Zabbix Server performance decrease and sometimes Zabbix Server fails during it.
Could someone please explain what Zabbix component generates such queries and how to improve/fix that.
Thanks in advance!
We have an issue with Zabbix Server 5.0.12 and underlying PostgreSQL-13.3
There come slow queries (more than 10 min) doing stuff like:
SELECT h.* FROM history h WHERE (h.itemid IN (<some_list_of_item_ids>) OR h.itemid IN (<some__another_list_of_item_ids>) OR h.itemid IN .... and so on.
Last investigating showed 5 simultaneous backends (except for parallel workers) with that query.
Such events cause Zabbix Server performance decrease and sometimes Zabbix Server fails during it.
Could someone please explain what Zabbix component generates such queries and how to improve/fix that.
Thanks in advance!