Grafana dashboards not working for long range queries

Grafana Dashboards
1
  • What Grafana version and what operating system are you using?

Grafana v10.0.2 (b2bbe10fbc) , OS:- Red Hat Enterprise Linux 8

  • What are you trying to achieve?

Querying/accessing data for beyond 30 days through Grafana UI

  • What happened?
    Dashboards are not rendered, only works when opened in edit mode.

  • What did you expect to happen?

dashboards should be rendered seamless

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

Welcome to forum @asokdaya

What is the datasource you are querying?

3

Prometheus

4

what happens if you ran that same query in prometheus querying tool(s)

5

it loads fine.

6

save your dashboard, leave it, come back and hit refresh. also check your browser’s web console for any errors.

7

image
image1646×508 44.1 KB

in edit mode

image
image1257×278 37.6 KB

9

@yosiasz please let me know if you want me to check anything

10

Use time aggregated data and not raw data.

11

@jangaraj could you please let me know where I can set this

12

In your query. Please calculate how many datapoints you have for 120days

13

@jangaraj Did not set any value, it is set to default.
**
image
**

14

Let me predict it for you. Let’s say you are collecting metric every minute, so 120 days = 120 * 24 * 60 = 172800 datapoints - how can you visualize line with 172800 points on display with 4k pixels width (let’s assume you have 4k monitor)? Do you see that point?
So you should rather use time aggregation so your query will generate for example one datapoint per day (e.g. average value for that day) => only 120 datapoints will be generated.

15

ok, can this be resolved by downsampling data

16

It depends. Time aggregation is not downsampling. You can still have raw data if you need them. that’s not possible with downsampling.

BTW:

17

thank you @jangaraj - I will test this out and get back