Clarifications on Query options for Stat panel

Grafana
,
1

  • What Grafana version and what operating system are you using? - Grafana v8.2.1 on Ubuntu 20.04.3 LTS

  • What are you trying to achieve? - Improve performance of Stat panel

  • How are you trying to achieve it?
    Currently my dashboard has close to 120 stat panel (use to show current value of the various network ports) and 2 time series panels. All are set with default values

  • What happened?
    It takes a lot of time to load the data

  • What did you expect to happen?
    I want it to load instantly the latest value in the stat panel

  • Can you copy/paste the configuration(s) that you are having problems with?
    I am not sure, but can i use query options to improve performance of the dashboard. Currently the query options are set to the default value which is as follows
    Max Data points - 1486
    Min Interval - “no Limit”
    Interval - 15s
    Relative time - 1h
    Time shift - 1h

Now with these value when i fire the query in query inspector the query returns 72 data value pairs for one stat panel. Since i need only the latest value does it make sense to reduce max data points to One, If i do that then the internvl option becomes 6h. Now the query inspector returns only 1 data value pair

If i do this for all my stat panels will it improve performance ?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

2

Welcome to the Grafana forum.

My first impression is that 120 stat panels on one dashboard is a lot. Have you tried using a simple table (name of field / series and last value), like this (minus the middle 2 columns and colors)?

image
image892×832 128 KB

3

@grant2 Thanks

I tried using table but seems very difficult for my need for eg: I want to show the latest data rate flow on each of the ports on my router. For this i need to add the send bytes and received bytes data points. When i use table it shows sent bytes and received bytes as different fields. I have to play with some serious set of transformations to achieve this.

Would adding complicated transformation offset the performance advantage of using a table compared to individual panels ?

4

What is your datasource?

5

My datasource is zabbix.

EDIT: I tried using table but i am not able to achieve what i want. Let me show. The following image is my objective what i have done using individual panels per port

Objective
Objective1409×458 172 KB

Now when i try to do the same using tables, the best i am able to do is this

Table
Table1073×581 136 KB

As you can see the layout is all over the place. I try to adjust the table height and it will either cover the data or leave blank rows/spaces. The performance of the tables is better inspite of the numerous transformations, but i wish i could get a layout like what can be achieved by individual panels.