Energy Management - full data reset?

[Colwilliamsnz (Colin Williams)]

I’ve fiddled so much wth this over the last few hours, adding energy support to a third party solar inverter component. Accordingly the data in the graphs is incomplete/garbage. Does anyone know how to clean out the database and effectively start from scratch now that I have it working as it should?

[nickrout]

Afaik stop ha. Delete the contents /config/.storage/energy. Start ha.

[Colwilliamsnz (Colin Williams)]

Seems risky A bit more digging got me to this post…a little further down he explains how to use SQLLite Web to expunge the “dirty” records. Worked a treat

Energy Management in Home Assistant

For those wanting to dig a little further into their Energy visualisation not working, you can use the “SQLite Web” addon to look under the covers at the statistics and how it works. It appears some entities from plugins will have all the appropriate attributes to appear in here, if yours aren’t, check the posts above that mention last_reset: attributes: last_reset: '1970-01-01T00:00:00+00:00' To get started, you will need to install the SQLite Web addon and open it…

[Protechtedd (Andrew)]

This process worked for me to ninja-delete a specific days worth of data due to a haywire sensor.

Just a nutshell for anyone who might want to take an easier route and simply delete all the energy data of a specific day, this query will work:

DELETE
FROM "statistics"
WHERE "created" like '2021-09-16%'

Of course change the date itself, but leave the % symbol, as it is the wildcard (since the timestamp is always different).

You can delete only a specific sensor instead of a whole day by more closely following the post linked above.

[monotonus]

This only deletes the dashboard to start from scratch. The long term statistics will remain and appear again after you add the sensor again.

[jayjay_seal]

This seems indeed the solution. If you want to start from scratch delete all rows (truncate) from statistics and statistics_meta. (stop HA before and start after the truncate)

Though… it i hope it does not starts reading from 0kwh now… as it would calculate from a 0kwh meter reading… this is almost never the case for most users…

Oh well… 2 hours wait now

[jayjay_seal]

It worked like a charm

[tomy137 (Thomas)]

Hello ! Sorry to revive this old topic, but it seems to be the right place to ask:

Does this solution force Home Assistant to recompile old data?

I mean, if all data are in the state table, and if I delete the folder and drop the statistics tables, will Home Assistant compile past days’ data? If not, do you know how to force it to do so?

My statistics data are incomplete and/or corrupted, and I want to recompile to start afresh with clean data.

Thanks in advance!