I try to understand why my database is that big :
state_attributes as 14 953 851 rows
states as 16 224 289 rows
my recorder config :
db_url: !secret mariadb_url
purge_keep_days: 30
commit_interval: 20exclude:
domains:
- updater
- camera
- input_text
entity_globs:
- sensor.sun_next_*
entities:
- sensor.last_boot # Comes from ‘systemmonitor’ sensor platform
- sensor.date
- sensor.time_online
- sensor.time
- sensor.time_zone
do you have any suggestions or idea of something i could do to improve the situations ?
i’ll be glad to delete some stuf from the database but i don’t want to corrupt it.
hope you can help
thank you