srch

I wrote a little guide about my config with PostgreSQL for short-term data and influxDB for long-term data, integrated into Home Assistant here.

02.12.2019 · My understanding is that rather than trying to remove entries, repack creates a fresh file, then deletes the old database, replacing it with the new. Sure enough, I spot home-assistant_v2.db-wal ramping up in size until about 4Gb, then going back to zero. So, I considered that 4Gb must simply be the size for 14 days worth of data for my sensors.

My home-assistant.db is up to 400MB and constantly growing. Should I worry about its size? What's stored in there anyway?

My home-assistant database is flooded, and there seems no good way to ... To reduce the DB size, I only include entities for which I really ...

When the home-assistant_v2.db file reaches about 2Gb, updates to my tabs get very slow. It can take 10 seconds to refresh.

Database size? Hey guys, I'm about to start my home automation setup (once finals are over) and was wondering if I could get away with keeping my database on my SSD. I would like to setup a cron job that archive the older stuff to a HDD and to GCP Coldline storage.

The larger the database, the slower Home Assistant will run, ... I also think database systems (such as SQLite) tend to rarely shrink their ...

Update: only use includes or excludes for history or logbook. Do not use a mix of both in the one integration. The logic is completely busted. The recorder seems ok to mix includes and excludes. 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 …

16.09.2018 · Hey guys, Keep running into the following problem, even from older to current versions of HomeAssistant. My HomeAssistant database files keep getting very large >100mb. When this happens, I can’t restart home assistant…

16.05.2016 · My home-assistant.db is up to 400MB and constantly growing. Should I worry about its size? What’s stored in there anyway? (My backups don’t like how the file keeps changing as it is read so I may have to tweak them) Is there a way to purge it? Note: I do NOT have the history component enabled, but I DO have the logbook component enabled.

Couple of things which really made the database large were: device trackers especially when using Ubiquiti Unifi. TP-Link smart switches. Weather data. Assuming you're using the default standard flat file database for Home Assistant get your hands on SQLite Browser. You can then look at the database and see what's taking up so much space.

change directory to config cd ~/config · open sqlite shell sqlite3 home-assistant_v2.db · enter the following commands in the shell: .header on .

Database - Home Assistant Database Home Assistant uses database to store events and parametersis for history and tracking. The default database used is SQLite and the database file is stored in your configuration directory (e.g., <path to config dir>/home-assistant_v2.db ); however, other databases can be used.

My HomeAssistant database files keep getting very large >100mb. ... I've compressed the tables a few months back. if I recall the event ...

Automatically purge the database every night at 04:12 local time. Purging keeps the database from growing indefinitely, which takes up ...

The Home Assistant database can get huge! Luckily there is a tool you can use to purge the contents of the database. You can filter what you send to the database, and even change how long it stores the data with the purge_keep_days setting. Delete old backups.

Instructions on how to configure the data recorder for Home Assistant. 1 Like. firstof9 (firstof9) June 30, 2020, 10:14pm #63.

The influxdb integration makes it possible to transfer all state changes to an external InfluxDB database. See the official installation documentation for how to set up an InfluxDB database, or there is a community add-on available.. Additionally, you can now make use of an InfluxDB 2.0 installation with this integration. See the official installation instructions for how to set up an …

Home Assistant stores a lot of data about events (example: ... We can also control which entities are read from the database when selecting ...