Utility Meeter - missing history [SOLVED]

Configuration
1

Hello Im using daily UM to calc energy consumption per power plug - works great.
But I just noticed I can see max 10 last days there

i guess this is because it stores every minute tick so very likely some process protects DB space
Is there any way to prevent this data? I just need store total day value

obraz
obraz1662×375 32.6 KB

2

The default setting for the database is to keep 10 days of data.

See: Recorder - Home Assistant

Increasing this beyond a month or so will have performance issues on all but the smallest of systems.

For long term data storage (i.e. years) there are better options.

3

Thanks. So what is option to proeserve this data?
Should I migrate to other DB (eg postgres) and do copy my own ?

4

OK Ive found this data IS STORED in Long term statistic data table in DB…
But by some reasson HA controls doesnt read from there

Ive found also custom:apexcharts-card - can read it if you add below to cfg.
This resolves my problem

statistics:
  type: state
  period: day
  align: end