New here but been using Influxdb for a few years with my HomeAssistant project. The DB has growth to 1.6 GB and I would like to explore the data in statistics fashion where I can see the top offender in size or quantity to adjust the retention.
I’m trying to get familiar with InfluxQL and Flux with “Explore section” but I can’t seem to find a way to extract such reports.
- Top 10 size bytes per Measurement, Tags or Fields.
- Top 10 quantity count per Measurement, Tags or Fields.
Any other stats that can help me understand where this space has been consumed or tools to use is welcome.