UI interface to manage my HA database / recorder settings

[hmmbob]

Describe your core improvement

I now need to run some manual SQL commands to figure out that my Wifi RSSI sensors got haywire and filled up the DB a lot. I was able to reduce diskspace size from 2GB to 1.1GB by just removing some unnecessary recorded items.

I'd like to have a user interface that will show me core information about my database, including which entities are using most diskspace and options to exclude entities from recorder through the frontend.

Current limitations

There are only limited options in HA to manage the DB size, most of them only for expert use and involving manual connecting to the DB.

Technical benefits

Reduced diskspace usage from DB
Less overhead in DB queries

Additional context

A first iteration could be just showing which entities are hitting the recorder most, so one could easily exclude them from recording.

[hugoleosp]

There was an idea from someone suggesting to create an option for each entity called "days to live" and after the specific number of days, it would automatically purge the old data of thar specific entity.

Most of the sensores are not important to keep for more than a few days, actually I believe very few sensores are really needed for long term.

https://community.home-assistant.io/t/recorder-retention-period-by-entity/267849/52

[twcau]

Also asked for, and fleshed out in more detail here: https://github.com/orgs/home-assistant/discussions/2899