Cardinality of single tags in measurements

image
Dear Community,
I’m trying to identify which Measurement/Tag is making my InfluxDB (OSS 1.8.4) “explode”. The problem is that I have almost 7000 measurements and open one by one using explore function of Chronograf is therefore not feasible (the cardinality is around 30M, I have to cut it down to 10M or less)
I’m looking for the queries that provide the information, in order to put them into a python script, but those I’ve tried so far still make my DB “explode”.

Have you ever tried something like that, or do you know where I can find those queries, or other useful suggestions?

Kind regards,
BG