How to get series count from measurement?

1

“SHOW SERIES FROM measurement_name” can show all the series.If the count of series is over 60,000,the browser is slow.So,I only know the count of series from measurement.

2

If you use Grafana you can use a query like this

SELECT mean(“numSeries”) FROM “_internal”.“monitor”.“database” WHERE (“database” =~ /^$Databases$/) AND $timeFilter GROUP BY time($__interval) fill(null)

You could change the database part to a hard typed value or if you have multiple DB’s then you could use a Grafana template variable.

You would find that specific piece of info from the database measurement.

Hope that helps

PS: you don’t need grafana, it’s just what i use. You could access the same information using Chronograf

Phil