Hey, I was looking at my DB size and noticed there is around 4mio state changes logged in the last 10 days which seems a lot to me. I ran some SQL queries on the mariaDB instance and found some high numbers: SELECT states.metadata_id, states_meta.entity_id, COUNT(*) FROM states, states_me…

The “state” table hold both “last_changed” and “last_updated”. The former records when the state was last changed and the latter when the state or any attribute changed (or it’s the other way around; I don’t have a mnemonic to remember which is which). So I guess any attribute change also create a …

Could it be the battery and/or LQI attributes updating?

There are a few attributes that are probably changing, such as power, energy and LQI and I would expect these to be logged, but not the switch state. If attribute is updated is entity state also logged as “new” state?

I don’t know the schema well enough to say, but it certainly looks that way.

I guess that is the reason for such a big database. Interesting as I don’t have much devices, wonder how big DBs are for users with 100+ devices.

I have thousands. I keep 7 days and it is about 1.5GB. I use excludes extensively. [image] How to reduce your database size and extend the life of your SD card Community Guides Preamble: @tom_l is the original author of this community guide. He proposed an analytical appr…

Lots of states changes logged for devices where state doesn't change

Configuration

tom_l May 11, 2023, 12:30pm 7

I have thousands. I keep 7 days and it is about 1.5GB. I use excludes extensively.