Understanding the Energy Card
I started exploring the data with SQLite Web.
- Is there an “overall” explanation around, how the recorder works and how statistics are calculated (and recorded)? I couldn’t find such obvious information myself.
- Is the flow like this?
states(like snapshot values, real “recording”) →statistics_short_term(5 min) →statistics(1 h) - Because in the statistics_short_term
- What does the Energy Card pick up of these? I couldn’t see a
metadata_idthat looks like originating from the dashboard directly. Has the Energy Card any influence on the mechanismstates→statistics_short_term? - If I would be able to find the exact “wrong” values in
statesand replace or delete them, wouldstatistics_short_termandstatisticsbe recalculated?
DB and Recorder - Home Assistant stuff:
As I started looking closer to this DB stuff and reading some posts like this Energy dashboard not showing historical data - #5 by wouter_klaassen, etc.
- I am afraid to continue with SQLite, I reached already 3.4GB
- Cascade delete is nice, but doesn’t work in the SQLite web client directly: Statistics - Fix Issue - large amount of data
- So I consider switching to MariaDB, I read already this page Recorder - Home Assistant, but what can be recommended?
- I run HA in a VM on my Synology
- I could run MariaDB natively on the Synology and use an external SSD for the storage => stressing my spinning HD less
- Migrating home assistant database from sqlite to mariadb - #34 by fversteegen
Should I start a new thread for the DB migration part (MariaDB outside HA)?