WTH can't I easily see what is taking up the diskspace

Sometimes I run into a situation where diskspace is running low and it is really hard to figure out what is using it.

The Storage menu only shows a total value used in percent.
image

Funnily (is that a word?) the menu entry to get into the above menu shows more info with the actual amount of free space.
image

But in the end I am usually not interested in the amount of free space, I would like to know where the used space went. Sometimes it is backups, I have had integrations run wild resulting in logfiles of gigabytes big or addons using more space as expected.

It would be nice to have more insights.
For example like on my phone I get space used by different categories like applications/videos/system etc… and tapping on those categories often takes you to a page to dig in deeper. I think my previous phone (Samsung) had an even better overview, but this is what I have now.

Tapping on Apps gives me this with more detailed info.

For Home Assistant these categories could be system/backups/addons/media

There’s a hacky way to do this through sqlite. I’ve had mixed luck on making the script work, but there’s a way to do it.

Check this link out:

It might not work on newer versions of sqlite but it’s worth a shot. I run this every couple months (or whenever I see a huge jump in backup size) to look for rogue entities.

This does not address the use case, which is file size on disk. DB size is indeed a factor, but only one of multiple, especially in HAOS