A quick video to show you how to see what entity state changes are filling up your Home Assistant database if you're using the MariaDB add-on. Sorry about the soft voice. Was very late at night. :)


Paste the code below into the SQL query box:
select entity_id,count(*) from states group by entity_id order by count(*) desc;

And if you're using the internal home-assistant_v2.db instead, you can use the SQLite Web add-on to achieve the same thing.

Help the channel by checking out my invention here:
Amazon USA [ Ссылка ]
Amazon Canada [ Ссылка ]
Amazon UK [ Ссылка ]

Oooh, and if you liked this video, please give it a thumbs up.

свернуть