Calculating duration between a start and end event

2020-07-09 07:58发布

问题:

I have two write points for InfluxDB, one is the start and the other is the end. I just need to determine the duration between those two events, and make queries around it. InfluxDB has difference() aggregate method, but it doesn't work on the time meta field.

Is supplying a custom timestamp value the only way to accomplish this?

回答1:

If you write only the mentioned two entries then you can follow the below steps -

  1. Limit the result to two (Eg: select * from timeseries limit 2)
  2. Extract the time from the result set
  3. Take the difference between the time


回答2:

As per "Can I perform mathematical operations against timestamps?"

No:

"Currently, it is not possible to execute mathematical operators against timestamp values in InfluxDB. Most time calculations must be carried out by the client receiving the query results."

and yes, maybe:

The function ELAPSED() returns the difference between subsequent timestamps in a single field.

So it depends on the shape of your data.



标签: influxdb