Grafana issues queries with WHERE time >= now() - 1h
to show the last hour’s worth of data. Problem is, that doesn’t return anything, unless I say something like WHERE time >= now() - 7h
for data I’ve just generated.
Just wondering if a time zone offset is off, somewhere? I’m at UTC offset -7. A SELECT
query that does return values lists 1594693072000000000
in the time column, which was the current time in nanoseconds since epoch in UTC at the time that event was generated: 2020-07-14T02:17:52Z