Backup size: Logger and System_Log settings

My backups are quite big at around 7.5GB.

I have tried to reduce the size using

system_log:
  max_entries: 500

logger:
  default: error

I suspect it is the History that is the culprit.

  • Is there a way to determine what represents the largest size in a backup?
  • Is there a way to exclude the History from the backup?

Thanks for the info. That helped a lot.

However, I must be doing something else incorrectly because the entity_id is not being recorded. See the screenshot from SQLite below.

The configuration.yaml contains these lines:

recorder:
  purge_keep_days: 5
  commit_interval: 20
  exclude:
    domains:
      - automation
      - update
    entity_globs:
      - sensor.sun*
      - weather.*
    entities:
      - sensor.date
      - sensor.last_boot # Comes from 'systemmonitor' sensor platform
      - sun.sun # Don't record sun data
    event_types:
      - call_service # Don't record service calls

system_log:
  max_entries: 500

logger:
  default: error

Any suggestions?

The database schema has changed since that was written, so the SQL queries are out of date. There are some updated ones here: