Performance
Use query plans and representative measurements to decide what to aggregate, index, or tune. Start with the records a report actually reads.
Measured at scale
The 5M-event query benchmark records 84 ms median for all six annual overview reports, with comparisons enabled. It includes filtered reports, p95 timings, query plans, and the raw samples from the running dashboard.
Recommended investigation
Read query planning, choose index paths where appropriate, and measure the result with benchmarking.
In this section
Rollups and query planning
Understand why some reports read a few aggregate rows while others scan event history.
ExploreSecondary indexes and backfilling
Accelerate selected filtered queries with explicit ordered indexes.
ExploreIngestion and storage tuning
Balance ingestion, query latency, memory, and disk for a real workload.
ExploreBenchmarking
Compare ingestion and reporting performance with reproducible workloads.
Explore5M-event query benchmark
Measured annual overview and filtered-query performance, with plans and raw timing samples.
ExploreContinue exploring
Check operational settings before applying tuning changes to an existing dataset. Index changes may involve startup work and limited historical coverage.