search

grafana / grafana-zabbix

Zabbix plugin for Grafana dashboard
http://play.grafana-zabbix.org
Apache License 2.0
2.07k stars 458 forks source link

Slow graph load using annotations #439

Open h1tman23 opened 7 years ago

h1tman23 commented 7 years ago

I'm submitting a ...

Software Versions

Grafana Zabbix Grafana-Zabbix Plugin
4.4.1 3.0.10 3.5.1

If I use annotations in dashboard it takes considerably more time to load the graph. In this particular situation with annotations graph loads in 3-4s, without annotations it loads instantly.

With annotations: annotations

Without annotations: without_annotations

Time interval 5min or 24 hours does not have any effect. What could couse this problem? I tried annotations with other doashboards and noticed that it loads faster. Such problem I noticed only with one dashboard.

alexanderzobnin commented 7 years ago

@h1tman23 can you show me your annotation query? And network request/response.

h1tman23 commented 7 years ago

Annotation query: annotation_query

Do you need this network request/response? request_time

alexanderzobnin commented 7 years ago

Yes, this one which loaded in 3.84 sec

h1tman23 commented 7 years ago

Please tell how to make network request/response. Above picture not enough?

alexanderzobnin commented 7 years ago

Just click on the particular query and look at Headers and Preview tabs:

screenshot from 2017-07-27 22 06 11

h1tman23 commented 7 years ago

Headers: headers

Preview: preview

Do you need to expand results?

alexanderzobnin commented 7 years ago

Yes, please, expand it. Is it that big query?

h1tman23 commented 7 years ago

One expanded query: preview1

alexanderzobnin commented 7 years ago

Seems, you have too many triggers on this host. All these triggers should be loaded first, then events filtered by the triggerid.

h1tman23 commented 7 years ago

This host has ~950 triggers. Maybe you have any advice how to speed up this?

alexanderzobnin commented 7 years ago

I should make some optimizations for this case, not sure you can solve it on your side.

h1tman23 commented 7 years ago

Thanks, It would be great to have this place improved in future.

github-actions[bot] commented 2 months ago

This issue has been automatically marked as stale because it has not had activity in the last 2 years. It will be closed in 60 days if no further activity occurs. Please feel free to leave a comment if you believe the issue is still relevant. Thank you for your contributions!