search

elastic / kibana

Your window into the Elastic Stack
https://www.elastic.co/products/kibana
Other
19.6k stars 8.21k forks source link

[Lens] Research how smaller time intervals may impact performance #185749

Open teresaalvarezsoler opened 4 months ago

teresaalvarezsoler commented 4 months ago

Problem Currently, our default time intervals for time series data are often too wide for users to spot spikes and lows in their metrics. We want to research how much we can lower these intervals without impacting the loading time of the charts.

Time range selected Actual intervals Ideal intervals
Last 15m 30 secs (30 buckets) 15 secs (60 buckets)
Last 1 hour 1 min (60b) 20 secs (120b)
Last day 30 mins (48b) 5 mins (288b)
Last 2 days 1 hour (48) 10 mins (288b)
Last week 3 hours (56) 1 hour (168)
Last month 12 hours (60) 4 hours (180)
Last year 7 days (52) 1 day (365)

We should test performance using a similar dashboard as our SREs main dashboard [Compute] Hosts Overview (~40 panels with dozens of series).

elasticmachine commented 4 months ago

Pinging @elastic/kibana-visualizations (Team:Visualizations)

teresaalvarezsoler commented 2 weeks ago

We agreed with @markov00 it doesn't make sense to investigate this topic for DSL, we should wait until Lens is powered by ES|QL to figured out the best time interval size https://github.com/elastic/kibana/issues/192075