Home-assistant_v2.db adds tables 'states_temp_1234567890'

[MichaelODK (Michael Ørnsholt)]

Hi
I have a problem with my home-assistant_v2.db database, which grows…
Currently around 26GB, and my home-assistant_v2.db-wal mostly around 13GB.

I have noticed that my home-assistant_v2.db table-list increases with tables called ‘states_temp_1234567890’ (timestamp I guess).
Have tried to delete these, but thety slowly comes again.

Suspect there is something corrupt in the DB, but don’t know how to fix/repair.

Running on VM in proxmox.

Any suggestions?

[tom_l]

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

Preamble: @tom_l is the original author of this community guide. He proposed an analytical approach to decide for each entity_id whether to include or exclude it from the underlying database. @mbuscher suggested to go after the entities most often updated in the database, and exclude only those. Both approaches are now included in this community guide. 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 re…

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…