![]() ![]() ![]() That or hassio, one or the other but there are add ons for SQL explorers or programs you can download and connect and query the DB if needed. ![]() So we know there is a DB “domain” none as homeassistant using the default docs. There are easy once you get the hang of the syntax. See what all is being written to the database, learn a few basic SQL queries. Like most things in HA, look at your resources also and not just the drive because resources are actually more important. Unless you are doing averages to see how much each is off or not. Whether that is saving energy or using it via smart plugs and possible saving turning the TV on and off (unless they run through those smart plugs, then who needs those power sensors). Most stuff you don’t need to know anything more then 2 days, especially if you keep your recorder and history domains, included-domains (bad idea all around) and any specific entities that you need to keep and don’t keep the rest unless you care and are collecting it for SOME reason. If you pick a just a few to run like that. I do wish there was a way to purge some records at 2 days and other much longer and maybe there is and I am just no aware of it. You can keep some for a year but your DB is probably not going to grow real quick (20 to maybe 30 specific entities, maybe more) but 100, and depending on how much data those entities collect, it will add up rather quickly and use up more resources. You can keep whatever data as long as you want but you have to include whatever entities for so long so doing entire domains more then 30 days would make things grow really quick unless you just pick the entities you want to keep. ![]()
0 Comments
Leave a Reply. |