Huge Database Size

[abumgardnerabc]

I’m new to all of this, only had HA up for a few weeks, not really even configured everything, but my database is over 30GB. Is this normal? What is the easiest way to control it/correct it?

[paddy0174 (Patrick)]

Take a look here at this excellent community guide:

How to keep your recorder database size under control

Note: This guide was written for an earlier version of Home Assistant (around 2021). Since then, changes have happened, but this guide hasn’t been updated (yet). Please be aware your Home Assistant version can be slightly different, and thus you need to adapt yourself the instructions from this guide. Introduction This is yet another guide on: How to view the size of your database. How to figure out which entities are using too much space. And how to filter them out. I’m running Home Assi…

[AaronCake]

Unfortunately this is normal and will continue to be a ticking time bomb in every Home Assistant installation until the database is redesigned properly.

Until then, the guide posted above is a good one on how to exclude unneeded entities from the recorder, and set an aggressive purge interval on the database.

Home Assistant treats a relational database like a flat file and with every state update dumps several hundred bytes of unnecessary data, storing it all as an uncompressible, unqueryable JSON mess.

[abumgardnerabc]

I tried the above. I have it steady about 31GB, I had another odd situation yesterday where it was using about 22 GB of ram, lol. I have it running on Hyper-V. Still trying to figure these bugs out.