Give an option to sort entities by the ammount of data they use up in the database #7156
Description
The request
Often I see my used disk space for HA spike due to my home-assistant_v2.db file "exploding", either because I've added a new integration that creates entities that use up a lot of data (either due to their update cycle of their values and/or strings that change very often). My current approach is that after seeing that my db-file is exponentially growing to remeber what integrations/new sensors I've added lately and to exclude them from the recorder. That also (currently) requires an restart of HA to apply the new recorder settings. It would be great to be able to sort my entity registry by "used space", so I can see at a glance which entities cause the problem. This would work very well with this Feature Request: #3803
I would be able to see what entities cause my db-file to explode as well as being able to disable them from the logbook/recorder, ... from the UI with no restart. This would be a massive help and time saver.
The alternatives
As described above, try to remember/look through the histroy page and see what entities cause a lot of data and manually add them one by one to the excluded entities in the recorder-section of my configuration.yaml and restart my HA instance.
Additional information
Just today I've found the next sensor that explodes my database-file:
