InfluxDB: Write values less frequent

[samuelg (Samuel)]

Hi there,

I have a question regarding InfluxDB.

I have some sensors providing a load of data with a high frequency (~2 datapoints/second). As I use Influxdb only for long term analysis, I don’t need this high time resolution and would be very happy if only every 30minutes a value would be written to the database.

I stumbled upon this thread which does this but from the other direction:

InfluxDB - Setup to Compress Data older than 6 Months / 2 Years

Inspired by this Thread https://community.home-assistant.io/t/influxdb-1-8-setup-one-continuous-query-for-whole-database/292242/4 , where i find the idea really good but it did not work for me. EDIT: The threadstarter of above thread also replied and said it’s working. I cannot double check this since i don’t use influxdb anymore. For don’t having all the hassle with cronjobs or anything else, you might want to try that first. If this works for you, it would be the cleanest way and the way it …

All values are written to the database and filtered after some time.

But in my case it would be sufficient to just write less values to the database in the first place.

Do you have an idea or recommendation?

Best regards
Sammy

[madface (Mike)]

As far as i know your Integration has to support to write less datapoints.
A workaround could be to make a filtered new sensor and record this to influxdb, take a look here:

Filter

Maybe the throttle Filter could be the right one. Disadvantage is only one data point ist recorded and the rest of them will get lost

[samuelg (Samuel)]

Thanks a lot. Actually it seems easier to compress the data later. So I will try this.