Retention of aggregated values only

[Archive] Feature request
1

I suggest adding an option to keep only aggregated values per period and delete raw values after 24 hours (configurable threshold).

Currently, my connected outlets send a value per minute, 24/7 for over a year.
My database reaches 3GB, while it could be a few hundred MB.

2

Isn’t that what the settings in the System section are for? (it’s not 24 hours, but the week should be better already)

image
image602×694 25.2 KB

3

Yes and no.

  • Yes, you can configure data retention here. But this refers to raw sensor data, without being more specific.

  • No, I don’t think keeping only one month of raw logs will allow you to keep all aggregated values (i.e., having a 24-hour aggregate for each day and a 7-day aggregate for each week, all indefinitely or up to a maximum retention value).