If you use the Home Assistant MariaDB add-on, this tip will show you how to query the database so see what Home Assistant entity states are triggering the most, filling up your database.
What were going to do:
Paste the code below into the SQL query box:
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.
What were going to do:
- Install the phMyAdmin add-on for MariaDB.
- Query the MariaDB database.
- See what entity state changes have the most action.
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.
Comments
Post a Comment