Database states table confusion

Configuration Z-Wave
1

My database states table looks normal except there’s a huge number of entries for {“entity_id”: (the part in bold is what’s shown as the name of the column).

If I show the table like this:

sqlite3 -line /volume1/docker/homeassistant/config/home-assistant_v2.db 'select * from states'|grep entity_id|awk '{print $3}'|sort |uniq -c |sort -n|tail -20
 150000 {"entity_id":

If I delete my database, the number climbs rapidly and I have no idea where it’s coming from. Any suggestions?

2

entity_id is an attribute of at least groups. So when a group’s state changes, it will generate an entry that contains “entity_id”. You might want to figure out how to filter those out, or just ignore them.