If you’re running Home Assistant on a Raspberry Pi or other flash-based storage, you’ve likely noticed the database growing over time. This growth can impact performance and shorten the lifespan of your SD card or SSD. In this guide, we’ll explore how to manage and reduce your database size while maintaining essential functionality.
Why Database Size Matters
Flash memory has a finite number of write cycles. By limiting the amount of data stored, you can extend the life of your storage and improve system performance. Home Assistant records a variety of events, including state changes and automation triggers. While this data is useful for insights and automation, not all of it may be necessary for your setup.
Controlling What Gets Recorded
The Recorder component allows you to exclude or include specific domains or entities. For example, if you don’t need the history of your lights or switches, you can exclude them from the database. This is done in your configuration.yaml file:
yaml
recorder:
exclude:
domains:
- light
- switch
entities:
- sensor.temperature
Reducing Logbook Data
The Logbook component can also be configured to exclude certain entities or domains. This ensures that only relevant events appear in your activity feed:
yaml
logbook:
exclude:
domains:
- sensor
- binary_sensor
entities:
- automation.example
Using the DBStats Add-on
For those on Home Assistant OS, the DBStats add-on provides detailed analytics about your database usage. It helps identify the most ‘chatty’ entities, allowing you to make informed decisions about what to exclude.
Analytical Approach
If you prefer a hands-on method, you can list all entities in your system and evaluate which ones contribute the most to your database growth. This can be done using the Developer Tools or by creating a script to export entity data. Once you have the list, prioritize keeping only the data that provides real value to your setup.
Final Tips
- Regular Backups: Ensure you have a reliable backup strategy to preserve important data before making changes.
- Testing: After adjusting your recorder settings, monitor your database growth to ensure the changes are effective.
- Automation: Use automation to clean up old data or archive it to an external storage solution.
By taking control of your database settings, you can significantly reduce its size, improve system performance, and extend the life of your hardware. Let’s work together to optimize our setups for efficiency and longevity!