Backup grown fom 400 MB to 1,3 GB within weeks

[francisp (Francis)]

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…

How to reduce your database size and extend the life of your SD card

Target audience: anyone who uses an installation on flash memory like a Raspberry Pi with an SD card or an SSD drive, or anyone who wishes to reduce the database size for better performance. Flash memory can process a finite number of writes before it fails. As such it is desirable to limit frequency and size of the stored data. Home Assistant stores a lot of data about events (example: light.office just turned on) and state changes (example: sun.sun changed to below_horizon). This allows it, …