Features
Query Benchmarking
Benchmark queries by running them multiple times and collecting timing stats
Query Benchmarking
Run a query multiple times to collect accurate performance statistics, eliminating variance from single-run measurements.
Running a Benchmark
- Write your query in the editor
- Click the Benchmark button in the toolbar (stopwatch icon)
- Select the number of iterations:
| Iterations | Use Case |
|---|---|
| 10 | Quick check |
| 50 | Moderate confidence |
| 100 | High confidence |
| 500 | Detailed profiling |
- The benchmark runs and collects timing data for each iteration
Results
After completion, you see:
- Average - Mean execution time
- P90 - 90th percentile (90% of runs were faster than this)
- P95 - 95th percentile
- P99 - 99th percentile
Use benchmarking to compare query performance before and after adding an index or rewriting a query. The percentile values help you understand worst-case behavior, not just average.