influxdata / influxdata/influxdb
aggregateWindow with first/last is very slow
- Dominant language
- Rust
- Stars
- 31.7k
- Forks
- 3.7k
- Avg merge
- 13h 37m
- Merged PRs (30d)
- 8
Description
syntax: group |> aggregateWindow， when use with mean|avg|sum，the reponse is very fast，but slow with frist|last。
I note that when use with mean|avg|sum， it will use a pushdown pattern，but frist|last doesn't
use with sum|mean|avg
use with frist|last
os: windows server
version: influxdb 2.5
Contributor guide
Research direction
Start by reproducing the reported aggregateWindow behavior on InfluxDB 2.5 using comparable queries with mean, avg, sum, first, and last. Inspect how pushdown is handled for these aggregations; done means the first/last behavior and its performance impact are explained and covered by an appropriate regression test.
Written by the indexing model from the issue text.
Assessment
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100