Trying to view a representation of 10 months of high-resolution data, but query just crashes

1

I performed my first downsampling of higher resolution data, 1-3sec ->1min, and I am trying to compare the output downsampled data to the original dataset to ensure there are no gaps.

The problem I am running into is I am new to InfluxDB and apparently I don’t know how to properly display a representative profile of the high-resolution data because despite trying a number of methods the query either crashes or truncates.

Is there a better way to go about this?

This the query I am using: (v1.8)

from(bucket: “homeassistant/autogen”)
|> range(start: 0)
|> filter(fn: (r) => r.entity_id == “circuit_1_power”)
|> filter(fn: (r) => r._value >= 0)
|> aggregateWindow(every: 1m, fn: mean)
|> yield(name: “original”

2

It’s tough to say why it’s crashing, but I have had similar experiences when I try to aggregate years of data. Perhaps try changing your range function so that you are looking at 60 or 90 day periods.

3

I never tought that you could use range start: 0 :thinking: I agree with grant, use a fixed smaller interval or a relative one -2y for example.

Other thing to consider is that if you are using data explorer on the web browser there is a limit before the web browser crashes or becomes slow and unusable because the ammount of data.

So pulling everything at once is not always viable.