Group By Delay Query

[arovah]

Dear Colleagues,

I have one of query from https://www.youtube.com/watch?v=BSzjrlotRA4&t=1259s to checking Zabbix Proxy Performance Issue , currently i have issue about delay graph of zabbix monitoring.
Probably from you able to explain this function of query below :

select count(*), delay from items where flags = 1 group by delay order by count(*) desc;

What's mean flags = 1 ?
Really appreciate for your any comment and reply :-)

Thank You.

[Glencoe]

Hi, where flags = 1 means you're querying discovery rules.

[arovah]

hi Glencoe.

Thank you for your reply, what's impact if i set interval duration longer before, example existing 1 hour then i setup 2 hour in the discovery rules ?
If i have total hosts and item like below, how many interval duration can i set in discover rules ?

Number of hosts (enabled/disabled/templates) 17736	16903 / 706 / 127
Number of items (enabled/disabled/not supported) 1432344	1348313 / 42306 / 41725
Number of triggers (enabled/disabled [problem/ok]) 715747	693939 / 21808 [30106 / 663833]

Thank you

[arovah]

hi cyber

Thank you for your reply, if i run the query result on below :

zabbix=# select count(*), delay from items where flags = 1 group by delay order by count (*) desc;
count | delay
-------+-------
13000 | 3600
2817 | 1h
3 | 2h
2 | 6h
1 | 60m
1 | 1m
(6 rows)

Wheter changes delay or duration discovery rules , for example : 2817 | 1h -> 1h changed to be 6h it can fixed the delay graph ?
What's impact after change the host duration discovery rules?

Thank you

[arovah]

ok thank you Cyber

[cyber]

Impact is, that your discoveries are running with longer interval, of course lowering the impact to whole system. But discovery intervals really depend on how often your infra changes and how much is it ok for you to wait... Sometimes it might be absolutely ok to run discovery once a week, sometimes once a day... sometimes you may need 1h interval or even smaller delay...So it is up to you, do you want to discover new things in 1h or in one week...

[arovah]

Impact is, that your discoveries are running with longer interval, of course lowering the impact to whole system. But discovery intervals really depend on how often your infra changes and how much is it ok for you to wait... Sometimes it might be absolutely ok to run discovery once a week, sometimes once a day... sometimes you may need 1h interval or even smaller delay...So it is up to you, do you want to discover new things in 1h or in one week...

Thank you cyber , it's very clear :-)