Hi, My Influxdb with HomeAssistant is more than 1.6GB and would like to get a report of what is consuming so much space to do some cleanup/maintenance and adjust the retention on some measurement or tags (if possible) or exclusion as need it.
Is there a tool or way to get statistic report on database performance like overall size, top measurement or tags “offender” in quantity and size?
I presume it may be possible via influxql but I can’t find the right syntax.
Any help or suggestion will be welcome.
PS: Maybe adding a new Category: Configuration -> Database