is it recognized that v2 with flux it tremendously slower than v1 in fetching data?
There are two influxd servers running on same type of machine (AWS t2.xlarge) with same data pushed. Data is one series of 4Hz samples.
from(bucket: "<bucket>") |> range(start: 2020-10-09T08:52:47Z, stop:2020-10-16T08:52:47Z) |> filter(fn: (r) => r._measurement == "<measurement>" and r._field == "<field>" ) |> aggregateWindow( every: 5m0s, fn: mean )
takes 18seconds for fetch 2017 rows
SELECT mean(<field>) FROM <measurement> WHERE time >= now() - 7d GROUP BY time(5m) fill(null)
tasks 3.2seconds for fetching 2017 rows
Both process about 2M points. 3s vs 18s! How comes?