Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How many points in an InfluxDB measurement?

Tags:

count

influxdb

Since there is no way to delete points by field values in InfluxDB, I'd like to get a count of all the points, SELECT INTO excluding the points with unwanted values, then get a count of the second measurement.

However,

SELECT COUNT(*) FROM measurement1

returns an array of counts for each field and tag, which doesn't tell me how many data points there are total.

like image 209
Dan Dascalescu Avatar asked Nov 09 '22 08:11

Dan Dascalescu


1 Answers

It seems there is currently no way to do this without knowing a name of a column/value that is present in all points.

Although time is always present in all points, it is unfortunately not possible to do count(time) for now, either.

This issue addresses the problem, but it is closed and a bit outdated. Someone should open a new one because the problem is still there.

like image 108
Bloke Avatar answered Nov 15 '22 10:11

Bloke