For those devices that are very chatty you can specifically exclude them from being stored in the database. I then created template sensors that let me filter the results so I’m not spamming the database, only storing data I want. I do find the mm-wave sensors to be particularly bad, but I’ve also found Tuya-based air quality sensors to spam the logs too.
Ooh, how do you exclude from the db?
Recorder integration: https://www.home-assistant.io/integrations/recorder/
The simplest way in configuration.yaml is something like:
recorder:
exclude:
entities:
- sensor.chatty1
- sensor.chatty2
Thank you
Just out of curiosity: is it that bad if the database is larger? I love to have some history especially for my temperature sensors.
I have two temperature sensors and keep their data, but I was getting a tonne of spam from my presence sensors which meant that my database was 2GB and growing. That level of IO would quickly kill my SD.
homeassistant
Home Assistant is open source home automation that puts local control and privacy first. Powered by a worldwide community of tinkerers and DIY enthusiasts. Perfect to run on a Raspberry Pi or a local server. Available for free at home-assistant.io