Huge amount of messages from sensor spams database

Configuration Zigbee
1

Hi folks,

does exist a way how to reduce amount of messages from device to database? I’ve bought some Air Quality sensor and it sends update every second for 7 magnitudes (temperature, humidity, co2, formaldehyde, etc…) and it’s causing growing database too fast (approx 1 GB per week). I’d like to use the sensor but have to reduce message amount to one per minute or something like this.

I’ve tried to delete all rows from database but it took too long and HA was frozen during deletion query. So better way is to reduce incoming messages than delete stored ones.

2

You can exclude sensors from the logs in configuration.yaml

recorder:
  exclude:
    entities:
      - sensor.qld_date_and_time
      - sensor.qld_time
      - sensor.qld_date
      - sensor.qld_short_date
      - sensor.date_time_iso
      - sensor.time_utc
      - sensor.solar
      - sensor.aircon
      - sensor.Modbus_PF_A
      - sensor.Modbus_PF_B        
      - sensor.Modbus_PF_C
3

Does it mean it will be display current value without history or what will be the impact to functionality?

4

I’m not sure. the data is certainly still displayed. Try and see.