Home Assistant MariaDB Inspection with phpMyAdmin

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 https://amzn.to/2PuOgGs
Amazon Canada https://amzn.to/3cp3tTk
Amazon UK https://amzn.to/396hu6n

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