Dashboard takes a lot time (about 30 mins) to auto refresh

I am using Grafana Version 11.2.2 and Windows OS.

I have created table like dashboard using text option. HTML, CSS, JS us used. The value for the table comes from the variable. There are 560 variables. Each variable fetches data from the flux query.

  • Sample flux query:
    from(bucket: “XYZ”)
    |> range(start:vtimeRangeStart,stop:v.timeRangeStop)
    |> filter(fn: (r) => r[“_measurement”] == “TriggerParam”)
    |> filter(fn: (r) => r[“field”] == “VISION1_TRG_POSITION”)
    |> filter(fn:(r) => r[“host”] == “NNDC01”)
    |> last()

The table is designed like this:

TAB SENSOR MAX ${TAB_SENSOR_MAX_C01}

There are pre determined values for the table. Whenever the lastest data is pulled and it does not match, the data is displayed in different color (red). When it matches, it is displayed in green.

And whenever the value changes, the new value and old value is shown with the timestamp.

Row and column highlight is also used.

These are all achieved using JS.

Values are collected by telegraf and stored in influxDB. Using the flux query, the dashboard displays the latest data. The dashboard is set to auto refresh every 1 hr.

The dashboard works fine. But the problem is after 1 hour, when it auto refresh, it takes about 30 min to completely load.

I want to find if there is a way to fix the issue of slow auto refresh.

welcome to forum @sndpred

please post a line protocol sample of your data?

I am using InfluxDB UI. Is it okay if i post screenshot of csv file ?

probably best to post the line protocol to see what design approach you used. tags are indexed fields are not. so this can have a marked effect on the speed of things.