Count number of measurements of a bucket

[AnonymousWebHacker]

I was searching all the documentation (forgive me if I didn’t find it) and I couldn’t find a way to make a request to the database, and it would return, for example, the number of measurements that a bucket has.

Found a related question

Get the total number measurements and display the number of rows

Hello 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?) thanks

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

Which gives a solution from flux cli (terminal) which is good information, but generally I want to ask influxdb directly for this information

[scott]

@AnonymousWebHacker What version of InfluxDB are you using?

[ebabeshko]

@AnonymousWebHacker

make a request to the database, and it would return, for example, the number of measurements that a bucket has

For InfluxDB 2 and flux that’s pretty easy to do:

import "influxdata/influxdb/schema"

schema.measurements(bucket: "example-bucket")
|> count()