Ok, so I just enabled the new utility meter for my dutch smart meter. So far all green but… how can I now keep track of the history ‘forever’ for this component? Is that at all possible in HA or do I (for now) need to push these new sensors to influxdb (or any other external database) and use a different tool to keep track of my daily/weekly/monthly/yearly powerusage?
I set the recorder to record only 3 days as HA starts to hang/crash if I store more days… probably because our DSMR updates every few seconds which blows up the internal db of HA very quickly.
I’ve setup mariadb recently but if I touch the history button in HA, than it will never respond and loads go over 33! That page is seriously dangerous and should be disabled
I just disabled the recording of the original utility sensors and now only record the new sensors created by this component. Lets see how that runs. But should HA be able to record (and retrieve) years of data?
I see (I think), but how do I store the extracted data for their respective period in the Db? I mean how do I set it in the template sensor automatically that the extracted last_period is e.g. 2019 January, February and so on in case on a monthly cycled utility_meter.sensor?
@dgomes, could you please give me a hint on this? I understand the extraction of the last_period, but can’t figure out how to record the history for the different cycles (daily, monthly).