Static Report: This is a self-contained HTML report with all benchmark data embedded. You can host this file on GitHub Pages or any static hosting service. The latest commit is highlighted with a Latest badge.
10
Total Commits
10
Benchmark Queries
33.45ms
Avg Query Time
2025-08-19 21:12
Last Updated
Average Latency by Query and Commit
P95 Latency by Query and Commit
Query Performance Overview
Query | Previous Commit | Latest Commit | Change | Status |
---|---|---|---|---|
Simple Filter q1_simple_filter |
32.70ms | 32.65ms | -0.15% | Stable |
Group By Aggregations q2_group_aggregations |
32.99ms | 31.89ms | -3.32% | Stable |
Time Window Aggregation q3_time_window |
33.37ms | 35.50ms | +6.38% | Regressed |
Complex Multi-condition Filter q4_complex_filter |
33.34ms | 48.11ms | +44.29% | Regressed |
Percentile Calculations q5_percentiles |
33.21ms | 45.45ms | +36.85% | Regressed |
Distinct Operations q6_distinct_count |
33.36ms | 45.05ms | +35.05% | Regressed |
Top-N with Sorting q7_top_n_sorting |
33.08ms | 33.47ms | +1.18% | Stable |
Self Join q8_self_join |
33.61ms | 32.41ms | -3.56% | Stable |
Window Functions q9_window_functions |
33.48ms | 31.75ms | -5.17% | Improved |
Subquery with Aggregation q10_subquery |
33.89ms | 33.34ms | -1.61% | Stable |
Detailed Performance Metrics
Query | Commit | Execution Time (ms) | |||||||
---|---|---|---|---|---|---|---|---|---|
Avg | Min | Max | Median | P70 | P80 | P90 | P95 | ||
Group By Aggregations
q2_group_aggregations |
93412c7b
2025-08-19 21:12:26 |
31.89 | 30.55 | 37.54 | 31.75 | 32.01 | 32.20 | 32.53 | 33.08 |
4c7c045b
2025-08-19 15:13:48 |
32.99 | 30.61 | 43.11 | 32.76 | 33.10 | 33.34 | 33.93 | 35.57 | |
afc0537d
2025-08-19 15:04:49 |
32.56 | 30.69 | 41.29 | 32.42 | 32.97 | 33.29 | 33.74 | 34.41 | |
f27b103d
2025-08-19 15:03:00 |
31.70 | 29.54 | 40.94 | 31.63 | 32.17 | 32.45 | 32.78 | 33.34 | |
638dc46b
2025-08-20 02:03:32 |
31.67 | 29.52 | 36.91 | 31.58 | 32.09 | 32.38 | 32.70 | 33.17 | |
944d8c0f
2025-08-19 22:58:40 |
34.88 | 30.77 | 43.45 | 33.67 | 36.04 | 37.91 | 39.69 | 40.69 | |
06547bef
2025-08-19 22:52:58 |
34.13 | 31.62 | 47.95 | 33.87 | 34.93 | 35.39 | 36.46 | 37.25 | |
1d4d74be
2025-08-19 06:34:51 |
31.88 | 30.01 | 39.14 | 31.59 | 32.13 | 32.51 | 33.15 | 34.27 | |
3eceedcd
2025-08-19 15:23:04 |
32.71 | 30.05 | 41.83 | 32.00 | 33.02 | 33.86 | 35.90 | 37.30 | |
92d516cc
2025-08-18 13:04:58 |
31.41 | 30.00 | 36.95 | 31.22 | 31.58 | 31.89 | 32.38 | 33.16 | |
Complex Multi-condition Filter
q4_complex_filter |
93412c7b
2025-08-19 21:12:26 |
48.11 | 29.65 | 287.81 | 47.59 | 51.00 | 52.78 | 55.86 | 64.71 |
4c7c045b
2025-08-19 15:13:48 |
33.34 | 32.18 | 38.96 | 33.22 | 33.44 | 33.60 | 33.96 | 34.55 | |
afc0537d
2025-08-19 15:04:49 |
33.49 | 31.36 | 39.93 | 33.42 | 33.92 | 34.20 | 34.61 | 35.35 | |
f27b103d
2025-08-19 15:03:00 |
32.36 | 30.38 | 41.48 | 32.25 | 32.81 | 33.11 | 33.60 | 34.05 | |
638dc46b
2025-08-20 02:03:32 |
32.46 | 30.77 | 39.02 | 32.34 | 32.88 | 33.15 | 33.52 | 34.20 | |
944d8c0f
2025-08-19 22:58:40 |
34.74 | 31.55 | 49.49 | 34.14 | 35.06 | 36.27 | 37.93 | 39.20 | |
06547bef
2025-08-19 22:52:58 |
33.47 | 30.81 | 45.45 | 33.22 | 33.48 | 33.71 | 34.45 | 35.34 | |
1d4d74be
2025-08-19 06:34:51 |
33.85 | 31.12 | 45.15 | 33.33 | 34.11 | 34.68 | 36.68 | 37.93 | |
3eceedcd
2025-08-19 15:23:04 |
32.60 | 30.67 | 39.77 | 32.26 | 32.77 | 33.29 | 34.04 | 34.88 | |
92d516cc
2025-08-18 13:04:58 |
32.40 | 30.78 | 40.68 | 32.15 | 32.54 | 32.83 | 33.44 | 34.31 | |
Window Functions
q9_window_functions |
93412c7b
2025-08-19 21:12:26 |
31.75 | 30.40 | 39.72 | 31.47 | 31.79 | 32.15 | 32.98 | 33.69 |
4c7c045b
2025-08-19 15:13:48 |
33.48 | 32.27 | 40.28 | 33.34 | 33.61 | 33.82 | 34.19 | 34.62 | |
afc0537d
2025-08-19 15:04:49 |
33.75 | 31.72 | 39.84 | 33.69 | 34.17 | 34.41 | 34.85 | 35.25 | |
f27b103d
2025-08-19 15:03:00 |
32.64 | 30.69 | 39.27 | 32.52 | 33.10 | 33.38 | 33.95 | 34.85 | |
638dc46b
2025-08-20 02:03:32 |
32.83 | 30.83 | 39.08 | 32.76 | 33.31 | 33.59 | 34.05 | 34.61 | |
944d8c0f
2025-08-19 22:58:40 |
32.79 | 30.92 | 38.85 | 32.70 | 33.30 | 33.51 | 33.88 | 34.44 | |
06547bef
2025-08-19 22:52:58 |
35.07 | 31.67 | 48.09 | 34.62 | 35.32 | 36.28 | 37.98 | 39.12 | |
1d4d74be
2025-08-19 06:34:51 |
33.23 | 31.06 | 48.41 | 32.96 | 33.59 | 33.96 | 34.60 | 35.76 | |
3eceedcd
2025-08-19 15:23:04 |
32.49 | 30.67 | 44.84 | 32.15 | 32.61 | 33.05 | 33.83 | 34.54 | |
92d516cc
2025-08-18 13:04:58 |
32.22 | 30.74 | 40.64 | 32.00 | 32.32 | 32.64 | 33.24 | 33.98 | |
Subquery with Aggregation
q10_subquery |
93412c7b
2025-08-19 21:12:26 |
33.34 | 30.48 | 47.18 | 32.48 | 33.81 | 34.69 | 36.72 | 38.22 |
4c7c045b
2025-08-19 15:13:48 |
33.89 | 32.54 | 41.41 | 33.70 | 33.97 | 34.19 | 34.59 | 35.39 | |
afc0537d
2025-08-19 15:04:49 |
34.15 | 32.15 | 42.19 | 34.08 | 34.55 | 34.78 | 35.19 | 35.92 | |
f27b103d
2025-08-19 15:03:00 |
33.00 | 31.01 | 41.96 | 32.93 | 33.42 | 33.68 | 34.19 | 34.82 | |
638dc46b
2025-08-20 02:03:32 |
33.05 | 31.09 | 38.55 | 32.97 | 33.57 | 33.81 | 34.21 | 34.67 | |
944d8c0f
2025-08-19 22:58:40 |
33.28 | 31.18 | 47.47 | 33.13 | 33.68 | 33.96 | 34.49 | 35.28 | |
06547bef
2025-08-19 22:52:58 |
34.98 | 32.33 | 42.02 | 34.54 | 35.18 | 36.00 | 38.13 | 39.37 | |
1d4d74be
2025-08-19 06:34:51 |
33.20 | 31.26 | 40.63 | 32.98 | 33.49 | 33.85 | 34.28 | 35.20 | |
3eceedcd
2025-08-19 15:23:04 |
32.87 | 31.19 | 39.48 | 32.57 | 33.04 | 33.51 | 34.32 | 34.90 | |
92d516cc
2025-08-18 13:04:58 |
33.01 | 31.16 | 40.88 | 32.66 | 33.24 | 33.71 | 34.45 | 35.45 | |
Simple Filter
q1_simple_filter |
93412c7b
2025-08-19 21:12:26 |
32.65 | 31.20 | 37.51 | 32.50 | 32.78 | 32.99 | 33.37 | 34.01 |
4c7c045b
2025-08-19 15:13:48 |
32.70 | 30.81 | 38.07 | 32.68 | 33.16 | 33.40 | 33.80 | 34.43 | |
afc0537d
2025-08-19 15:04:49 |
32.85 | 30.98 | 38.45 | 32.75 | 33.34 | 33.62 | 34.03 | 34.51 | |
f27b103d
2025-08-19 15:03:00 |
32.07 | 30.03 | 41.33 | 31.92 | 32.50 | 32.80 | 33.32 | 34.03 | |
638dc46b
2025-08-20 02:03:32 |
32.18 | 30.30 | 39.58 | 32.03 | 32.62 | 32.94 | 33.35 | 33.80 | |
944d8c0f
2025-08-19 22:58:40 |
33.04 | 30.88 | 40.32 | 32.95 | 33.45 | 33.77 | 34.31 | 35.06 | |
06547bef
2025-08-19 22:52:58 |
34.43 | 31.98 | 56.91 | 33.71 | 34.90 | 35.93 | 37.37 | 38.24 | |
1d4d74be
2025-08-19 06:34:51 |
32.27 | 30.58 | 40.55 | 31.97 | 32.43 | 32.85 | 33.56 | 34.25 | |
3eceedcd
2025-08-19 15:23:04 |
32.74 | 30.36 | 43.11 | 32.11 | 32.90 | 33.55 | 35.26 | 37.01 | |
92d516cc
2025-08-18 13:04:58 |
32.01 | 30.44 | 37.78 | 31.78 | 32.18 | 32.53 | 33.14 | 34.00 | |
Time Window Aggregation
q3_time_window |
93412c7b
2025-08-19 21:12:26 |
35.50 | 30.15 | 175.52 | 32.63 | 33.11 | 35.28 | 46.77 | 52.28 |
4c7c045b
2025-08-19 15:13:48 |
33.37 | 32.13 | 39.27 | 33.24 | 33.47 | 33.67 | 34.02 | 34.48 | |
afc0537d
2025-08-19 15:04:49 |
33.36 | 31.24 | 39.28 | 33.24 | 33.75 | 34.03 | 34.57 | 35.54 | |
f27b103d
2025-08-19 15:03:00 |
32.25 | 30.34 | 40.12 | 32.12 | 32.71 | 33.00 | 33.50 | 33.96 | |
638dc46b
2025-08-20 02:03:32 |
32.79 | 30.33 | 43.78 | 32.36 | 32.98 | 33.29 | 35.04 | 37.04 | |
944d8c0f
2025-08-19 22:58:40 |
35.63 | 31.42 | 44.66 | 34.31 | 36.32 | 38.89 | 41.07 | 41.84 | |
06547bef
2025-08-19 22:52:58 |
35.16 | 32.26 | 43.17 | 34.74 | 36.00 | 37.10 | 38.61 | 39.53 | |
1d4d74be
2025-08-19 06:34:51 |
32.27 | 30.69 | 39.49 | 32.05 | 32.44 | 32.72 | 33.23 | 33.86 | |
3eceedcd
2025-08-19 15:23:04 |
32.87 | 30.63 | 46.02 | 32.25 | 32.93 | 33.61 | 34.80 | 37.08 | |
92d516cc
2025-08-18 13:04:58 |
32.16 | 30.61 | 45.62 | 31.95 | 32.31 | 32.59 | 33.18 | 33.90 | |
Percentile Calculations
q5_percentiles |
93412c7b
2025-08-19 21:12:26 |
45.45 | 28.87 | 195.06 | 46.56 | 48.70 | 50.36 | 53.17 | 54.87 |
4c7c045b
2025-08-19 15:13:48 |
33.21 | 31.83 | 41.84 | 33.05 | 33.29 | 33.48 | 33.91 | 34.76 | |
afc0537d
2025-08-19 15:04:49 |
33.06 | 31.10 | 38.39 | 33.00 | 33.49 | 33.76 | 34.16 | 34.71 | |
f27b103d
2025-08-19 15:03:00 |
32.14 | 30.31 | 40.42 | 31.99 | 32.53 | 32.86 | 33.27 | 33.89 | |
638dc46b
2025-08-20 02:03:32 |
32.28 | 30.44 | 38.12 | 32.19 | 32.73 | 32.96 | 33.37 | 34.12 | |
944d8c0f
2025-08-19 22:58:40 |
33.38 | 31.11 | 41.13 | 33.22 | 33.68 | 34.04 | 34.69 | 35.83 | |
06547bef
2025-08-19 22:52:58 |
33.83 | 32.11 | 40.53 | 33.30 | 33.89 | 34.60 | 35.96 | 37.23 | |
1d4d74be
2025-08-19 06:34:51 |
32.93 | 30.80 | 39.32 | 32.66 | 33.28 | 33.72 | 34.43 | 35.71 | |
3eceedcd
2025-08-19 15:23:04 |
32.26 | 30.41 | 53.02 | 31.88 | 32.44 | 32.93 | 33.82 | 34.37 | |
92d516cc
2025-08-18 13:04:58 |
32.10 | 30.34 | 37.66 | 31.93 | 32.26 | 32.54 | 33.14 | 33.75 | |
Distinct Operations
q6_distinct_count |
93412c7b
2025-08-19 21:12:26 |
45.05 | 29.79 | 178.49 | 46.03 | 48.46 | 50.09 | 53.03 | 56.10 |
4c7c045b
2025-08-19 15:13:48 |
33.36 | 31.90 | 48.54 | 33.13 | 33.38 | 33.59 | 34.04 | 35.22 | |
afc0537d
2025-08-19 15:04:49 |
33.33 | 31.39 | 40.87 | 33.22 | 33.73 | 33.97 | 34.47 | 35.13 | |
f27b103d
2025-08-19 15:03:00 |
32.42 | 30.20 | 42.73 | 32.34 | 32.86 | 33.09 | 33.54 | 34.26 | |
638dc46b
2025-08-20 02:03:32 |
32.55 | 30.45 | 46.93 | 32.39 | 32.96 | 33.25 | 33.83 | 34.66 | |
944d8c0f
2025-08-19 22:58:40 |
33.15 | 31.01 | 42.79 | 32.99 | 33.44 | 33.75 | 34.44 | 35.54 | |
06547bef
2025-08-19 22:52:58 |
33.16 | 31.15 | 45.81 | 32.72 | 33.25 | 34.00 | 34.77 | 35.93 | |
1d4d74be
2025-08-19 06:34:51 |
33.52 | 30.97 | 44.21 | 33.15 | 33.82 | 34.32 | 35.54 | 36.71 | |
3eceedcd
2025-08-19 15:23:04 |
32.19 | 30.60 | 38.37 | 31.90 | 32.33 | 32.74 | 33.62 | 34.15 | |
92d516cc
2025-08-18 13:04:58 |
32.45 | 30.49 | 54.80 | 32.07 | 32.70 | 33.12 | 33.85 | 34.74 | |
Top-N with Sorting
q7_top_n_sorting |
93412c7b
2025-08-19 21:12:26 |
33.47 | 30.12 | 466.37 | 32.26 | 33.34 | 34.37 | 36.07 | 37.96 |
4c7c045b
2025-08-19 15:13:48 |
33.08 | 31.51 | 39.84 | 32.93 | 33.22 | 33.38 | 33.70 | 34.12 | |
afc0537d
2025-08-19 15:04:49 |
33.18 | 31.15 | 41.70 | 33.12 | 33.58 | 33.84 | 34.29 | 35.02 | |
f27b103d
2025-08-19 15:03:00 |
32.19 | 30.21 | 37.43 | 32.18 | 32.62 | 32.87 | 33.31 | 33.81 | |
638dc46b
2025-08-20 02:03:32 |
32.49 | 30.16 | 39.21 | 32.44 | 32.96 | 33.28 | 33.73 | 34.53 | |
944d8c0f
2025-08-19 22:58:40 |
32.82 | 30.75 | 43.27 | 32.70 | 33.17 | 33.45 | 34.00 | 34.82 | |
06547bef
2025-08-19 22:52:58 |
34.50 | 31.17 | 46.97 | 34.11 | 34.82 | 36.03 | 37.57 | 38.78 | |
1d4d74be
2025-08-19 06:34:51 |
33.36 | 30.56 | 43.39 | 32.97 | 33.75 | 34.37 | 35.82 | 37.52 | |
3eceedcd
2025-08-19 15:23:04 |
32.52 | 30.51 | 49.22 | 32.11 | 32.73 | 33.24 | 34.04 | 35.12 | |
92d516cc
2025-08-18 13:04:58 |
32.08 | 30.36 | 41.43 | 31.74 | 32.20 | 32.60 | 33.39 | 34.34 | |
Self Join
q8_self_join |
93412c7b
2025-08-19 21:12:26 |
32.41 | 29.79 | 42.42 | 31.87 | 32.80 | 33.40 | 34.33 | 35.42 |
4c7c045b
2025-08-19 15:13:48 |
33.61 | 32.31 | 40.14 | 33.46 | 33.75 | 33.93 | 34.32 | 34.86 | |
afc0537d
2025-08-19 15:04:49 |
33.67 | 31.83 | 39.21 | 33.63 | 34.11 | 34.41 | 34.77 | 35.07 | |
f27b103d
2025-08-19 15:03:00 |
32.57 | 30.54 | 40.82 | 32.48 | 33.03 | 33.31 | 33.74 | 34.26 | |
638dc46b
2025-08-20 02:03:32 |
32.70 | 30.58 | 39.54 | 32.68 | 33.25 | 33.50 | 33.94 | 34.43 | |
944d8c0f
2025-08-19 22:58:40 |
34.30 | 30.96 | 48.09 | 33.65 | 34.77 | 35.77 | 37.50 | 38.89 | |
06547bef
2025-08-19 22:52:58 |
35.48 | 32.21 | 46.90 | 34.89 | 35.80 | 36.74 | 38.44 | 39.54 | |
1d4d74be
2025-08-19 06:34:51 |
33.71 | 31.27 | 43.04 | 33.36 | 34.15 | 34.69 | 36.00 | 36.96 | |
3eceedcd
2025-08-19 15:23:04 |
32.62 | 30.84 | 39.78 | 32.32 | 32.78 | 33.26 | 34.03 | 34.67 | |
92d516cc
2025-08-18 13:04:58 |
32.45 | 30.90 | 40.42 | 32.15 | 32.51 | 32.82 | 33.67 | 34.46 |
Recent Commits
Commit Hash | Timestamp | Avg Performance | Status |
---|---|---|---|
93412c7b
Latest
|
2025-08-19 21:12:26 | 36.96 ms | Regressed |
4c7c045b
|
2025-08-19 15:13:48 | 33.30 ms | Stable |
afc0537d
|
2025-08-19 15:04:49 | 33.34 ms | Stable |
f27b103d
|
2025-08-19 15:03:00 | 32.34 ms | Stable |
638dc46b
|
2025-08-20 02:03:32 | 32.50 ms | Stable |
944d8c0f
|
2025-08-19 22:58:40 | 33.80 ms | Stable |
06547bef
|
2025-08-19 22:52:58 | 34.42 ms | Stable |
1d4d74be
|
2025-08-19 06:34:51 | 33.02 ms | Stable |
3eceedcd
|
2025-08-19 15:23:04 | 32.59 ms | Stable |
92d516cc
|
2025-08-18 13:04:58 | 32.23 ms | Stable |
Generated on 2025-08-19 21:12 | 10 commits analyzed | 10 queries benchmarked | 1,000,000 rows dataset | 1,000 iterations per query