My home assistant DB is very large, how to check its content (and then reduce it)?

[123 (Taras)]

You can also exclude event_types:

Allow services to be excluded from Recorder: and the database

Thanks, it seems to work great. Only state changes recorded. It would be nice to have an include filter as well so I can just include state_changes instead of excluding everything else. recorder: db_url: mysql+pymysql://hass:[email protected]/HOMEBASE include: domains: - sensor - switch - shell_command - binary_sensor - input_text - light - script # - device_tracker exclude: entities: - sensor.time event_types: …

I provide examples of SQL statements to purge unwanted entries from the database in this post:

History-graph shows old unit of measurement

You can use a tool like DB Browser for SQLite to modify Home Assistant’s database file. Before editing home-assistant_v2.db, I suggest you shutdown Home Assistant (so it doesn’t attempt to update the database while you’re tinkering with it) and make a backup copy just in case your modifications corrupt the database. The table you want is called states. Select the Browse Data tab then select Table: states. Click the entity_id heading to sort on it. The best way to select and delete records is …