dictvm/gist:419ad2f443826784cfbcc2ff5766104e

Created November 15, 2017 09:09

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dictvm/419ad2f443826784cfbcc2ff5766104e.js"></script>
Save dictvm/419ad2f443826784cfbcc2ff5766104e to your computer and use it in GitHub Desktop.

Download ZIP

Count Series in InfluxDB

Raw

gistfile1.txt

influx -database '$DATABASE' -format 'csv' -execute 'SHOW SERIES' | grep -v "name,_id,host" | wc -l

alexgdmx commented Aug 13, 2018 •

edited

Loading

> select * from _internal.."database" where "database"=~/YOUR DATABASE NAME/ order by time desc limit 1
name: database
time                 database hostname     numMeasurements numSeries
----                 -------- --------     --------------- ---------
2018-08-13T16:11:50Z prime    4eba75b72aae 5               7336
>

don't forget quote "database" since is reserved word and is used as measurement name and tag(column) name

turtlemonvh commented Dec 19, 2018

For pre-1.4: https://docs.influxdata.com/influxdb/v1.2/troubleshooting/frequently-asked-questions/#how-can-i-query-for-series-cardinality
For post-1.4: https://docs.influxdata.com/influxdb/v1.5/query_language/spec/#show-series-cardinality

saranglakare commented Mar 1, 2020

Thanks for this! It was really useful.

I think better way to give the database name (that worked for me) was:

select * from _internal.."database" where "database"='DATABASE_NAME' order by time desc limit 1

jwongz commented Apr 18, 2020

good

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment