Time since last series data

time
#1

Hello,
I am looking to identify the time elapsed since the last measurement was recorded for a specific series.
We have a server poll response information added to Influxdb, I am looking to display (query via Grafana), time since last poll response.
Appreciate any suggestion on this query. The poll response time (in seconds) is a field in the measurement.

select poll_resp_time from myseries order by desc limit 1
name: myseries
time                    poll_resp_time
----                    --------------
1492785395626340000     1492785395
1 Like
#2

Sounds like you effectively want to be able to do:

select now()-time,poll_resp_time from myseries order by desc limit 1

As far as I know, that’s not possible, as I discovered in this thread: Shift timestamp returned by SELECT query