Home-assistant_v2.db growing exponentially

As of 10 days ago my entire HA backup was less than 100MBs.

I just noticed that my home-assistant_v2.db is now 1.7GBs.

Should I go ahead and panic?

100MB is pretty small, whereas 1-2GB is “normal”. So assuming your purge_keep_days is still at the default of 10 days, it shouldn’t get any bigger if it’s entity state causing the growth. So I’d wait and see what happens. If it doesn’t grow and the size bothers you, you can use a SQL addon to locate which entity is causing the usage and perhaps exclude it from the recorder, but this is more complicated.

If it continues to grow, it might be something else like files you’re storing in config or share or media, for example.

You could use one of the SSH addons along with du -hs /folder/to/check to see folder sizes.

1 Like