Get the total number measurements and display the number of rows

i’m new to Influx and i used relational databases in the past a lot.
I could not find a way to get the total number of measurements in a database.
I found out show measurements… but unfortunately no total numbers…
And related question, in relational databases, when you perform a query from their native CLI, i can get the total number which is quite useful…is there anything similar with Influxdb (some configuration parameter?)

As of 1.3, there isn’t a way to query the number of measurements. However, if you’re just looking to get a count on Linux / Unix, it can be done with the CLI + shell script. E.g.,

influx -database telegraf -execute "show series" | tail -n +3 | awk -F, '{print $1}' | uniq | wc -l
1 Like