I use influxDB.
when i run the below query i am supposed to get 6 values(Since telegraf agent colllects data once every 10seconds 1 minute = 6 data points) but i am getting 2399 values
select http_response_code from http_response where host = ‘server’ and time > now() - 1m
the query is fetching data for the past 6 hours, can anyone help me why this is happening and how can i fix this issue.
desired output: now() - 1m should display only 6 data-points
current output: now() - 1m displays last 6 hurs and 1 minute of data
While when i give time it is showing me my desired output. query below
time > ‘2018-06-07T11:15:00Z’ and time < ‘2018-06-07T11:16:00Z’;