# How to get series count from measurement?

**URL:** <https://community.influxdata.com/t/how-to-get-series-count-from-measurement/4492>\
**Category:** Systems\
**Tags:** influxdb\
**Created:** [March 23, 2018, 7:00am UTC](https://community.influxdata.com/t/how-to-get-series-count-from-measurement/4492 "2018-03-23T07:00:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![maj](https://avatars.discourse-cdn.com/v4/letter/m/4491bb/32.png) [@maj](https://community.influxdata.com/u/maj)\
**Post date:** [March 23, 2018, 7:00am UTC](https://community.influxdata.com/t/how-to-get-series-count-from-measurement/4492/1 "2018-03-23T07:00:54Z")

</div>

“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.

---

<div class="post-metadata">

**Author:** ![philb](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/philb/32/1805_2.png) [@philb](https://community.influxdata.com/u/philb)\
**Post date:** [March 23, 2018, 11:37am UTC](https://community.influxdata.com/t/how-to-get-series-count-from-measurement/4492/2 "2018-03-23T11:37:11Z")

</div>

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