A very large .db file: How to disable the logbook for everything?

Configuration
1

Hello. I have got a problem with my home-assistant_v2.db file. It’s over 5GB now.
I assume that my electrical outlets on Wi-Fi are sending too much data.

I would like to disable logging for everything, except the things that I manually include. Could somebody please help me to create a config file for the logbook with everything disabled, and the old entries removed?

2 
recorder:
  db_url: mysql://my_db_location
  purge_keep_days: 7
  include:
    entities:
      - binary_sensor.remote_ui
      - cover.garage_door
      - input_datetime.lc_cr_light_delayed_off_time
      - device_tracker.toyota_tacoma
      - etc

ther old entries should purge themselves after whatever your purge setting is.

1 Like