Repository navigation
chore: Update to df55-based df-d and fix api changes - #6015
Merged
Merged
Conversation
Contributor
Author
|
The regress tests show a few dynamic filters being dropped. I'm not sure if that's the correct behavior or something I messed up. The other piece to pay close attention to the the replacement of |
stuhood
force-pushed
the
rj.use-df55-dfd
branch
from
August 21, 2026 15:59
e574cfc to
0a98191
Compare
stuhood
added
cherry-pick/0.25.x
github-actions
Bot
removed
the
benchmark-stackoverflow
![github-actions[bot]](https://avatars.githubusercontent.com/in/15368?s=60&v=4){kind=small}
Contributor
There was a problem hiding this comment.
pg_search 'stackoverflow (bm25)' (100k rows)
Details
| Benchmark suite | Current: d94844a | Previous: ef3e38b | Ratio |
|---|---|---|---|
stackoverflow_posts_idx build time |
0.014318716766666666 min |
0.014390912733333334 min |
0.99 |
stackoverflow_posts_idx index size |
90 MB |
90 MB |
1 |
badges_idx build time |
0.08323251551666666 min |
0.08254509783333333 min |
1.01 |
badges_idx index size |
253 MB |
253 MB |
1 |
comments_idx build time |
0.0059339576666666664 min |
0.005906422683333333 min |
1.00 |
comments_idx index size |
36 MB |
36 MB |
1 |
users_idx build time |
0.0030673566666666666 min |
0.0030087881833333334 min |
1.02 |
users_idx index size |
16 MB |
16 MB |
1 |
aggregate_topk_count |
32.4233942 mean ms (±0.078 ms) |
31.919379100000004 mean ms (±0.032 ms) |
1.02 |
aggregate_topk_count - alternative 1 |
30.677802800000002 mean ms (±0.097 ms) |
30.195650199999996 mean ms (±0.189 ms) |
1.02 |
bucket-expr-filter |
4.3605683 mean ms (±0.016 ms) |
4.362580400000001 mean ms (±0.013 ms) |
1.00 |
bucket-expr-filter - alternative 1 |
4.462983100000001 mean ms (±0.010 ms) |
4.4283711 mean ms (±0.015 ms) |
1.01 |
bucket-numeric-filter |
3.2352853 mean ms (±0.019 ms) |
3.260488 mean ms (±0.020 ms) |
0.99 |
bucket-numeric-filter - alternative 1 |
7.0608239 mean ms (±0.301 ms) |
6.8156485 mean ms (±0.075 ms) |
1.04 |
bucket-numeric-filter - alternative 2 |
6.985614100000001 mean ms (±0.092 ms) |
6.946046999999998 mean ms (±0.083 ms) |
1.01 |
bucket-numeric-filter - alternative 3 |
6.812839100000001 mean ms (±0.037 ms) |
6.904680600000001 mean ms (±0.108 ms) |
0.99 |
bucket-numeric-nofilter |
14.038408099999998 mean ms (±0.041 ms) |
13.9476762 mean ms (±0.024 ms) |
1.01 |
bucket-numeric-nofilter - alternative 1 |
6.6651369 mean ms (±0.126 ms) |
6.3513745 mean ms (±0.034 ms) |
1.05 |
bucket-numeric-nofilter - alternative 2 |
6.878123499999999 mean ms (±0.136 ms) |
7.044018899999999 mean ms (±0.924 ms) |
0.98 |
bucket-numeric-nofilter - alternative 3 |
6.5158317 mean ms (±0.037 ms) |
6.368468099999999 mean ms (±0.058 ms) |
1.02 |
bucket-string-filter |
74.03447740000001 mean ms (±0.220 ms) |
74.9456772 mean ms (±0.524 ms) |
0.99 |
bucket-string-filter - alternative 1 |
13.053504800000002 mean ms (±0.053 ms) |
12.5429262 mean ms (±0.096 ms) |
1.04 |
bucket-string-filter - alternative 2 |
15.841011400000003 mean ms (±0.038 ms) |
15.056591200000003 mean ms (±0.078 ms) |
1.05 |
bucket-string-filter - alternative 3 |
11.2291782 mean ms (±0.046 ms) |
10.8392371 mean ms (±0.098 ms) |
1.04 |
bucket-string-nofilter |
178.66692419999998 mean ms (±0.540 ms) |
178.22186150000002 mean ms (±0.406 ms) |
1.00 |
bucket-string-nofilter - alternative 1 |
41.4029479 mean ms (±0.105 ms) |
41.8080301 mean ms (±0.113 ms) |
0.99 |
bucket-string-nofilter - alternative 2 |
69.5760755 mean ms (±0.106 ms) |
66.85105390000001 mean ms (±0.381 ms) |
1.04 |
bucket-string-nofilter - alternative 3 |
67.4922837 mean ms (±0.501 ms) |
64.8933601 mean ms (±0.631 ms) |
1.04 |
cardinality |
3.051169899999999 mean ms (±0.019 ms) |
3.2224108 mean ms (±0.171 ms) |
0.95 |
cardinality - alternative 1 |
3.2015099 mean ms (±0.015 ms) |
3.2158918 mean ms (±0.022 ms) |
1.00 |
cardinality - alternative 2 |
7.0116134 mean ms (±0.064 ms) |
6.8448098 mean ms (±0.151 ms) |
1.02 |
cardinality - alternative 3 |
6.817062699999999 mean ms (±0.045 ms) |
6.6612137 mean ms (±0.049 ms) |
1.02 |
cardinality - alternative 4 |
6.759790799999999 mean ms (±0.040 ms) |
6.620563 mean ms (±0.048 ms) |
1.02 |
cardinality - alternative 5 |
6.8426156 mean ms (±0.021 ms) |
6.8304855 mean ms (±0.022 ms) |
1.00 |
cardinality - alternative 6 |
13.321256600000002 mean ms (±0.100 ms) |
13.1469326 mean ms (±0.085 ms) |
1.01 |
cardinality - alternative 7 |
33.140814199999994 mean ms (±0.408 ms) |
33.0308807 mean ms (±0.306 ms) |
1.00 |
cardinality - alternative 8 |
7.2446455 mean ms (±0.048 ms) |
7.1395067 mean ms (±0.050 ms) |
1.01 |
cardinality - alternative 9 |
7.183289499999999 mean ms (±0.039 ms) |
7.1494844 mean ms (±0.088 ms) |
1.00 |
count-filter |
2.964295 mean ms (±0.020 ms) |
2.9482027000000004 mean ms (±0.016 ms) |
1.01 |
count-filter - alternative 1 |
6.8609429 mean ms (±0.037 ms) |
6.691986099999999 mean ms (±0.098 ms) |
1.03 |
count-filter - alternative 2 |
6.832435199999999 mean ms (±0.027 ms) |
6.704526400000001 mean ms (±0.077 ms) |
1.02 |
count-filter - alternative 3 |
2.0570359 mean ms (±0.009 ms) |
2.0574739 mean ms (±0.039 ms) |
1.00 |
count-nofilter |
5.8537482 mean ms (±0.042 ms) |
5.5778471000000005 mean ms (±0.081 ms) |
1.05 |
count-nofilter - alternative 1 |
5.8635043 mean ms (±0.047 ms) |
5.773061899999999 mean ms (±0.085 ms) |
1.02 |
count-nofilter - alternative 2 |
5.8597883 mean ms (±0.053 ms) |
5.6928007 mean ms (±0.050 ms) |
1.03 |
count-nofilter - alternative 3 |
0.4853611 mean ms (±0.009 ms) |
0.48300610000000005 mean ms (±0.006 ms) |
1.00 |
filtered-highcard |
3.1345338999999997 mean ms (±0.011 ms) |
3.1457649 mean ms (±0.018 ms) |
1.00 |
filtered-lowcard |
3.1300871 mean ms (±0.017 ms) |
3.1435421999999997 mean ms (±0.010 ms) |
1.00 |
highlighting |
3.928611899999999 mean ms (±0.015 ms) |
3.9148896 mean ms (±0.013 ms) |
1.00 |
join_aggregate_count |
20.4448859 mean ms (±0.087 ms) |
19.5447709 mean ms (±0.066 ms) |
1.05 |
join_aggregate_count - alternative 1 |
34.028765699999994 mean ms (±1.672 ms) |
32.7824615 mean ms (±0.801 ms) |
1.04 |
join_aggregate_count - alternative 2 |
44.549436299999996 mean ms (±0.084 ms) |
43.911208800000004 mean ms (±0.125 ms) |
1.01 |
join_aggregate_date_histogram |
47.9467716 mean ms (±0.088 ms) |
47.52390610000001 mean ms (±0.140 ms) |
1.01 |
join_aggregate_date_histogram - alternative 1 |
48.4855368 mean ms (±0.207 ms) |
47.24357040000001 mean ms (±0.084 ms) |
1.03 |
join_aggregate_date_histogram - alternative 2 |
48.420555699999994 mean ms (±0.086 ms) |
47.2112417 mean ms (±0.107 ms) |
1.03 |
join_aggregate_groupby |
24.310987800000003 mean ms (±0.083 ms) |
23.232363900000003 mean ms (±0.030 ms) |
1.05 |
join_aggregate_groupby - alternative 1 |
39.9305983 mean ms (±2.685 ms) |
40.3604684 mean ms (±3.003 ms) |
0.99 |
join_aggregate_groupby - alternative 2 |
50.9519945 mean ms (±0.168 ms) |
50.3731487 mean ms (±0.102 ms) |
1.01 |
join_aggregate_multi |
20.9155419 mean ms (±0.062 ms) |
20.4724232 mean ms (±0.074 ms) |
1.02 |
join_aggregate_multi - alternative 1 |
33.058487 mean ms (±0.391 ms) |
32.77676079999999 mean ms (±0.285 ms) |
1.01 |
join_aggregate_multi - alternative 2 |
45.56279290000001 mean ms (±0.048 ms) |
45.0348196 mean ms (±0.432 ms) |
1.01 |
join_aggregate_sort |
61.163929200000005 mean ms (±0.154 ms) |
59.38296620000001 mean ms (±0.129 ms) |
1.03 |
join_aggregate_sort - alternative 1 |
80.8594433 mean ms (±7.063 ms) |
79.680387 mean ms (±4.710 ms) |
1.01 |
join_aggregate_sort - alternative 2 |
61.71674420000001 mean ms (±0.376 ms) |
63.04525279999999 mean ms (±0.095 ms) |
0.98 |
join_aggregate_topk_count |
23.4092401 mean ms (±0.102 ms) |
22.682515700000003 mean ms (±0.047 ms) |
1.03 |
join_aggregate_topk_count - alternative 1 |
65.4959345 mean ms (±0.378 ms) |
65.6063747 mean ms (±1.863 ms) |
1.00 |
join_aggregate_topk_count - alternative 2 |
76.17955239999999 mean ms (±0.089 ms) |
75.95211650000002 mean ms (±0.106 ms) |
1.00 |
join_aggregate_window_facet |
98.7940316 mean ms (±0.089 ms) |
98.07161190000002 mean ms (±0.103 ms) |
1.01 |
join_aggregate_window_facet - alternative 1 |
99.6588958 mean ms (±0.080 ms) |
98.53897350000003 mean ms (±0.080 ms) |
1.01 |
join_aggregate_window_facet - alternative 2 |
99.2714151 mean ms (±0.094 ms) |
98.035852 mean ms (±0.111 ms) |
1.01 |
join_distinct_parent_sort |
174.3206403 mean ms (±38.745 ms) |
151.8372885 mean ms (±39.385 ms) |
1.15 |
join_distinct_parent_sort - alternative 1 |
138.3318686 mean ms (±7.472 ms) |
132.5130705 mean ms (±5.587 ms) |
1.04 |
join_distinct_parent_sort - alternative 2 |
186.1271861 mean ms (±23.822 ms) |
174.9371244 mean ms (±0.210 ms) |
1.06 |
join_foreign_filter_local_sort |
16.701535600000003 mean ms (±0.163 ms) |
16.4856093 mean ms (±0.220 ms) |
1.01 |
join_foreign_filter_local_sort - alternative 1 |
30.9083869 mean ms (±0.121 ms) |
30.452669499999995 mean ms (±0.202 ms) |
1.01 |
join_foreign_filter_local_sort - alternative 2 |
38.55706450000001 mean ms (±0.069 ms) |
39.5271539 mean ms (±0.779 ms) |
0.98 |
join_hierarchical_content-no-scores-large |
11.719487700000002 mean ms (±0.866 ms) |
11.3249888 mean ms (±0.202 ms) |
1.03 |
join_hierarchical_content-no-scores-large - alternative 1 |
39.57428779999999 mean ms (±0.888 ms) |
38.2896276 mean ms (±0.719 ms) |
1.03 |
join_hierarchical_content-no-scores-large - alternative 2 |
66.1048373 mean ms (±0.170 ms) |
66.26201360000002 mean ms (±0.087 ms) |
1.00 |
join_hierarchical_content-no-scores-small |
10.9950334 mean ms (±0.393 ms) |
11.190475199999998 mean ms (±0.096 ms) |
0.98 |
join_hierarchical_content-no-scores-small - alternative 1 |
38.771799300000005 mean ms (±0.791 ms) |
37.9568395 mean ms (±0.784 ms) |
1.02 |
join_hierarchical_content-no-scores-small - alternative 2 |
64.7094996 mean ms (±0.166 ms) |
64.23014180000001 mean ms (±0.078 ms) |
1.01 |
join_hierarchical_content-scores-large |
17.317892699999998 mean ms (±0.060 ms) |
16.7758877 mean ms (±0.047 ms) |
1.03 |
join_hierarchical_content-scores-large - alternative 1 |
15.6680984 mean ms (±0.130 ms) |
15.411304300000001 mean ms (±0.101 ms) |
1.02 |
join_hierarchical_content-scores-large - alternative 2 |
20.505141599999998 mean ms (±0.073 ms) |
20.1371301 mean ms (±0.077 ms) |
1.02 |
join_hierarchical_content-scores-large - alternative 3 |
20.6629102 mean ms (±0.100 ms) |
20.0140886 mean ms (±0.061 ms) |
1.03 |
join_hierarchical_content-scores-small |
14.631514000000001 mean ms (±0.087 ms) |
14.278861500000001 mean ms (±0.052 ms) |
1.02 |
join_hierarchical_content-scores-small - alternative 1 |
17.8397509 mean ms (±0.123 ms) |
17.7486911 mean ms (±0.110 ms) |
1.01 |
join_hierarchical_content-scores-small - alternative 2 |
17.9745907 mean ms (±0.102 ms) |
17.7385035 mean ms (±0.167 ms) |
1.01 |
join_permissioned_search |
18.227992699999998 mean ms (±0.136 ms) |
18.020689800000003 mean ms (±0.137 ms) |
1.01 |
join_permissioned_search - alternative 1 |
45.2802498 mean ms (±1.491 ms) |
44.72297699999999 mean ms (±1.188 ms) |
1.01 |
join_permissioned_search - alternative 2 |
57.459864800000005 mean ms (±0.311 ms) |
57.663581199999996 mean ms (±0.072 ms) |
1.00 |
join_semi_filter |
11.155348499999999 mean ms (±0.039 ms) |
11.1572195 mean ms (±0.043 ms) |
1.00 |
join_semi_filter - alternative 1 |
29.199014200000004 mean ms (±0.326 ms) |
28.944399599999997 mean ms (±0.180 ms) |
1.01 |
join_semi_filter - alternative 2 |
45.4245654 mean ms (±0.071 ms) |
42.50075149999999 mean ms (±0.055 ms) |
1.07 |
join_semi_filter - alternative 3 |
12.356905600000001 mean ms (±0.052 ms) |
12.058156900000002 mean ms (±0.042 ms) |
1.02 |
join_top_k-score-desc-high-selectivity |
18.717652199999996 mean ms (±0.016 ms) |
18.065641300000003 mean ms (±0.051 ms) |
1.04 |
join_top_k-score-desc-high-selectivity - alternative 1 |
43.388670299999994 mean ms (±0.959 ms) |
42.0462554 mean ms (±1.601 ms) |
1.03 |
join_top_k-score-desc-high-selectivity - alternative 2 |
47.5243076 mean ms (±0.488 ms) |
47.2550452 mean ms (±0.080 ms) |
1.01 |
paging-string-max |
6.7642178 mean ms (±0.068 ms) |
6.5061870000000015 mean ms (±0.130 ms) |
1.04 |
paging-string-median |
6.674235800000001 mean ms (±0.041 ms) |
6.4241298 mean ms (±0.044 ms) |
1.04 |
paging-string-min |
6.6532094 mean ms (±0.060 ms) |
6.385421900000001 mean ms (±0.039 ms) |
1.04 |
regex-and-heap |
14.6643866 mean ms (±0.108 ms) |
14.695550399999998 mean ms (±0.049 ms) |
1.00 |
sum-int-filter |
4.1621052999999995 mean ms (±0.014 ms) |
4.1400115 mean ms (±0.014 ms) |
1.01 |
sum-int-filter - alternative 1 |
7.035603900000001 mean ms (±0.041 ms) |
6.7402766 mean ms (±0.036 ms) |
1.04 |
sum-numeric15-filter |
7.6883751 mean ms (±0.024 ms) |
7.621044700000001 mean ms (±0.030 ms) |
1.01 |
sum-numeric15-filter - alternative 1 |
21.2620122 mean ms (±0.349 ms) |
21.434902700000002 mean ms (±0.214 ms) |
0.99 |
sum-numeric78-filter |
13.413080899999997 mean ms (±0.027 ms) |
13.335468 mean ms (±0.026 ms) |
1.01 |
sum-numeric78-filter - alternative 1 |
22.156451099999998 mean ms (±0.268 ms) |
21.148753 mean ms (±0.253 ms) |
1.05 |
top_k-agg-avg |
2.9772982999999997 mean ms (±0.017 ms) |
2.9410357999999994 mean ms (±0.018 ms) |
1.01 |
top_k-agg-bucket-string |
2.9462413999999995 mean ms (±0.019 ms) |
2.9290675999999998 mean ms (±0.008 ms) |
1.01 |
top_k-agg-count |
2.8948726999999996 mean ms (±0.015 ms) |
2.9079157999999996 mean ms (±0.022 ms) |
1.00 |
top_k-compound |
3.1768077999999997 mean ms (±0.011 ms) |
3.1991705999999995 mean ms (±0.013 ms) |
0.99 |
top_k-numeric-highcard |
3.0049859000000003 mean ms (±0.008 ms) |
3.045201 mean ms (±0.016 ms) |
0.99 |
top_k-numeric-lowcard |
2.9910474 mean ms (±0.009 ms) |
3.0322399 mean ms (±0.018 ms) |
0.99 |
top_k-score-asc-high-selectivity |
3.4637445999999996 mean ms (±0.011 ms) |
3.4601789000000003 mean ms (±0.008 ms) |
1.00 |
top_k-score-asc-high-selectivity - alternative 1 |
3.4676142 mean ms (±0.014 ms) |
3.4422066 mean ms (±0.010 ms) |
1.01 |
top_k-score-asc-medium-selectivity |
3.3395444000000003 mean ms (±0.008 ms) |
3.3211993 mean ms (±0.008 ms) |
1.01 |
top_k-score-asc-medium-selectivity - alternative 1 |
3.3382841000000005 mean ms (±0.013 ms) |
3.310991499999999 mean ms (±0.012 ms) |
1.01 |
top_k-score-asc |
3.145445 mean ms (±0.009 ms) |
3.1679481999999997 mean ms (±0.010 ms) |
0.99 |
top_k-score-asc - alternative 1 |
3.1474299 mean ms (±0.008 ms) |
3.1669886000000003 mean ms (±0.010 ms) |
0.99 |
top_k-score-desc-high-selectivity |
3.0765339999999997 mean ms (±0.013 ms) |
3.0099317999999995 mean ms (±0.009 ms) |
1.02 |
top_k-score-desc-high-selectivity - alternative 1 |
3.0820983999999996 mean ms (±0.012 ms) |
3.0027217999999998 mean ms (±0.013 ms) |
1.03 |
top_k-score-desc-medium-selectivity |
2.9173416999999997 mean ms (±0.015 ms) |
2.8997865000000003 mean ms (±0.012 ms) |
1.01 |
top_k-score-desc-medium-selectivity - alternative 1 |
2.9080160999999998 mean ms (±0.012 ms) |
2.9162151 mean ms (±0.010 ms) |
1.00 |
top_k-score-desc-tiebreaker |
3.2996787 mean ms (±0.012 ms) |
3.2954111 mean ms (±0.011 ms) |
1.00 |
top_k-score-desc-tiebreaker - alternative 1 |
3.2924327 mean ms (±0.008 ms) |
3.2675495000000003 mean ms (±0.010 ms) |
1.01 |
top_k-score-desc |
2.8579183 mean ms (±0.015 ms) |
2.8438611000000003 mean ms (±0.012 ms) |
1.00 |
top_k-score-desc - alternative 1 |
2.8525381 mean ms (±0.009 ms) |
2.8351814 mean ms (±0.012 ms) |
1.01 |
top_k-score-multi-term-asc |
9.1927454 mean ms (±0.011 ms) |
9.2703713 mean ms (±0.021 ms) |
0.99 |
top_k-score-multi-term-asc - alternative 1 |
9.206665000000001 mean ms (±0.019 ms) |
9.258694 mean ms (±0.026 ms) |
0.99 |
top_k-score-multi-term-desc |
8.9141197 mean ms (±0.014 ms) |
8.9526557 mean ms (±0.015 ms) |
1.00 |
top_k-score-multi-term-desc - alternative 1 |
8.9240365 mean ms (±0.013 ms) |
8.9884483 mean ms (±0.022 ms) |
0.99 |
top_k-string |
3.0641787000000003 mean ms (±0.011 ms) |
3.0634942 mean ms (±0.045 ms) |
1.00 |
This comment was automatically generated by workflow using github-action-benchmark.
Contributor
There was a problem hiding this comment.
pg_search 'stackoverflow (bm25)' (1m rows)
Details
| Benchmark suite | Current: d94844a | Previous: ef3e38b | Ratio |
|---|---|---|---|
stackoverflow_posts_idx build time |
0.12935616288333335 min |
0.12916135531666667 min |
1.00 |
stackoverflow_posts_idx index size |
803 MB |
803 MB |
1 |
badges_idx build time |
0.21594474586666665 min |
0.21654302513333334 min |
1.00 |
badges_idx index size |
547 MB |
547 MB |
1 |
comments_idx build time |
0.046298786566666666 min |
0.046271203999999996 min |
1.00 |
comments_idx index size |
282 MB |
282 MB |
1 |
users_idx build time |
0.010531742399999999 min |
0.010580022616666665 min |
1.00 |
users_idx index size |
59 MB |
59 MB |
1 |
aggregate_topk_count |
225.5829882 mean ms (±0.413 ms) |
226.4498998 mean ms (±1.526 ms) |
1.00 |
aggregate_topk_count - alternative 1 |
63.962915900000006 mean ms (±0.575 ms) |
63.486358599999996 mean ms (±0.595 ms) |
1.01 |
bucket-expr-filter |
24.8248572 mean ms (±0.179 ms) |
24.7883165 mean ms (±0.121 ms) |
1.00 |
bucket-expr-filter - alternative 1 |
25.150020299999998 mean ms (±0.201 ms) |
24.919116599999995 mean ms (±0.136 ms) |
1.01 |
bucket-numeric-filter |
9.3838408 mean ms (±0.029 ms) |
9.3278146 mean ms (±0.018 ms) |
1.01 |
bucket-numeric-filter - alternative 1 |
7.314532100000001 mean ms (±0.101 ms) |
7.2432411000000005 mean ms (±0.141 ms) |
1.01 |
bucket-numeric-filter - alternative 2 |
7.481009900000001 mean ms (±0.070 ms) |
7.434262000000001 mean ms (±0.084 ms) |
1.01 |
bucket-numeric-filter - alternative 3 |
7.1997686000000005 mean ms (±0.066 ms) |
7.0694975 mean ms (±0.082 ms) |
1.02 |
bucket-numeric-nofilter |
40.271713899999995 mean ms (±0.031 ms) |
40.0389484 mean ms (±0.099 ms) |
1.01 |
bucket-numeric-nofilter - alternative 1 |
8.9734497 mean ms (±0.101 ms) |
8.876188 mean ms (±0.077 ms) |
1.01 |
bucket-numeric-nofilter - alternative 2 |
10.272753599999998 mean ms (±0.056 ms) |
10.217285299999999 mean ms (±0.051 ms) |
1.01 |
bucket-numeric-nofilter - alternative 3 |
8.273678 mean ms (±0.056 ms) |
8.2642303 mean ms (±0.114 ms) |
1.00 |
bucket-string-filter |
186.9834278 mean ms (±0.338 ms) |
184.435084 mean ms (±0.275 ms) |
1.01 |
bucket-string-filter - alternative 1 |
22.5596156 mean ms (±0.092 ms) |
22.418118299999996 mean ms (±0.029 ms) |
1.01 |
bucket-string-filter - alternative 2 |
28.723760400000003 mean ms (±0.059 ms) |
28.6880875 mean ms (±0.044 ms) |
1.00 |
bucket-string-filter - alternative 3 |
17.4594322 mean ms (±0.030 ms) |
17.4446964 mean ms (±0.054 ms) |
1.00 |
bucket-string-nofilter |
445.12441229999996 mean ms (±0.540 ms) |
446.3798854999999 mean ms (±0.667 ms) |
1.00 |
bucket-string-nofilter - alternative 1 |
70.5853533 mean ms (±0.107 ms) |
69.9061133 mean ms (±0.512 ms) |
1.01 |
bucket-string-nofilter - alternative 2 |
111.0152329 mean ms (±0.695 ms) |
110.32732109999999 mean ms (±0.675 ms) |
1.01 |
bucket-string-nofilter - alternative 3 |
95.4761784 mean ms (±0.843 ms) |
95.702662 mean ms (±0.982 ms) |
1.00 |
cardinality |
8.554260100000002 mean ms (±0.015 ms) |
8.578710500000001 mean ms (±0.014 ms) |
1.00 |
cardinality - alternative 1 |
9.158392899999999 mean ms (±0.025 ms) |
9.1036489 mean ms (±0.040 ms) |
1.01 |
cardinality - alternative 2 |
7.574117200000001 mean ms (±0.750 ms) |
7.1544555 mean ms (±0.100 ms) |
1.06 |
cardinality - alternative 3 |
7.310031100000001 mean ms (±0.077 ms) |
7.087307300000001 mean ms (±0.069 ms) |
1.03 |
cardinality - alternative 4 |
6.956918499999999 mean ms (±0.060 ms) |
6.7968091 mean ms (±0.086 ms) |
1.02 |
cardinality - alternative 5 |
34.794557600000005 mean ms (±0.060 ms) |
34.6347635 mean ms (±0.049 ms) |
1.00 |
cardinality - alternative 6 |
173.5011761 mean ms (±0.959 ms) |
172.40638889999997 mean ms (±0.657 ms) |
1.01 |
cardinality - alternative 7 |
365.1405467000001 mean ms (±1.874 ms) |
381.4248785 mean ms (±1.649 ms) |
0.96 |
cardinality - alternative 8 |
9.426806000000003 mean ms (±0.071 ms) |
9.257317400000002 mean ms (±0.075 ms) |
1.02 |
cardinality - alternative 9 |
9.134795599999999 mean ms (±0.093 ms) |
9.344695499999998 mean ms (±0.706 ms) |
0.98 |
count-filter |
7.2828167 mean ms (±0.054 ms) |
7.058309400000001 mean ms (±0.024 ms) |
1.03 |
count-filter - alternative 1 |
7.285247499999999 mean ms (±0.044 ms) |
7.3364407 mean ms (±0.111 ms) |
0.99 |
count-filter - alternative 2 |
7.4027528999999985 mean ms (±0.104 ms) |
7.268105100000001 mean ms (±0.035 ms) |
1.02 |
count-filter - alternative 3 |
2.1087812 mean ms (±0.010 ms) |
2.1014375999999997 mean ms (±0.009 ms) |
1.00 |
count-nofilter |
11.542144600000002 mean ms (±0.059 ms) |
11.584324399999996 mean ms (±0.041 ms) |
1.00 |
count-nofilter - alternative 1 |
8.0716717 mean ms (±0.067 ms) |
8.0546042 mean ms (±0.080 ms) |
1.00 |
count-nofilter - alternative 2 |
8.1135201 mean ms (±0.086 ms) |
8.0558811 mean ms (±0.089 ms) |
1.01 |
count-nofilter - alternative 3 |
0.4783373 mean ms (±0.008 ms) |
0.481953 mean ms (±0.008 ms) |
0.99 |
filtered-highcard |
3.4978413 mean ms (±0.013 ms) |
3.4969379000000003 mean ms (±0.016 ms) |
1.00 |
filtered-lowcard |
3.4059752000000003 mean ms (±0.015 ms) |
3.3760194000000006 mean ms (±0.016 ms) |
1.01 |
highlighting |
4.4240159 mean ms (±0.016 ms) |
4.404689899999999 mean ms (±0.012 ms) |
1.00 |
join_aggregate_count |
120.13947150000001 mean ms (±0.642 ms) |
118.09774390000003 mean ms (±0.500 ms) |
1.02 |
join_aggregate_count - alternative 1 |
56.278156100000004 mean ms (±0.324 ms) |
55.48364079999999 mean ms (±0.419 ms) |
1.01 |
join_aggregate_count - alternative 2 |
98.1049403 mean ms (±0.104 ms) |
92.1319322 mean ms (±0.103 ms) |
1.06 |
join_aggregate_date_histogram |
297.49680449999994 mean ms (±0.567 ms) |
295.6569865 mean ms (±0.329 ms) |
1.01 |
join_aggregate_date_histogram - alternative 1 |
296.706559 mean ms (±0.921 ms) |
295.68997500000006 mean ms (±0.574 ms) |
1.00 |
join_aggregate_date_histogram - alternative 2 |
297.3329022 mean ms (±0.540 ms) |
295.7873524 mean ms (±1.376 ms) |
1.01 |
join_aggregate_groupby |
144.1367025 mean ms (±0.197 ms) |
143.09685810000002 mean ms (±0.664 ms) |
1.01 |
join_aggregate_groupby - alternative 1 |
72.9357909 mean ms (±1.053 ms) |
73.5393165 mean ms (±0.865 ms) |
0.99 |
join_aggregate_groupby - alternative 2 |
114.93047390000001 mean ms (±0.281 ms) |
109.9625593 mean ms (±0.343 ms) |
1.05 |
join_aggregate_multi |
126.8217834 mean ms (±0.256 ms) |
126.23938410000002 mean ms (±0.232 ms) |
1.00 |
join_aggregate_multi - alternative 1 |
61.3870997 mean ms (±0.632 ms) |
60.87744940000001 mean ms (±0.650 ms) |
1.01 |
join_aggregate_multi - alternative 2 |
103.83972069999997 mean ms (±0.450 ms) |
97.6084185 mean ms (±0.101 ms) |
1.06 |
join_aggregate_sort |
853.6720822999999 mean ms (±0.739 ms) |
859.4155858999999 mean ms (±1.252 ms) |
0.99 |
join_aggregate_sort - alternative 1 |
133.9884872 mean ms (±2.060 ms) |
133.7081832 mean ms (±0.918 ms) |
1.00 |
join_aggregate_sort - alternative 2 |
210.81658299999998 mean ms (±0.414 ms) |
203.2693219 mean ms (±1.155 ms) |
1.04 |
join_aggregate_topk_count |
142.44286599999998 mean ms (±0.687 ms) |
142.8030267 mean ms (±0.198 ms) |
1.00 |
join_aggregate_topk_count - alternative 1 |
197.76052969999998 mean ms (±23.343 ms) |
208.24312840000002 mean ms (±0.381 ms) |
0.95 |
join_aggregate_topk_count - alternative 2 |
147.5623205 mean ms (±0.671 ms) |
143.4086963 mean ms (±0.106 ms) |
1.03 |
join_aggregate_window_facet |
905.8127761 mean ms (±1.274 ms) |
904.5464129 mean ms (±0.596 ms) |
1.00 |
join_aggregate_window_facet - alternative 1 |
904.7769624999999 mean ms (±0.504 ms) |
904.8154882000001 mean ms (±0.521 ms) |
1.00 |
join_aggregate_window_facet - alternative 2 |
903.9390231000001 mean ms (±0.900 ms) |
904.9848685999999 mean ms (±0.419 ms) |
1.00 |
join_distinct_parent_sort |
322.16642250000007 mean ms (±38.376 ms) |
367.98525929999994 mean ms (±49.666 ms) |
0.88 |
join_distinct_parent_sort - alternative 1 |
1107.9354629 mean ms (±234.756 ms) |
1328.2567771999998 mean ms (±178.791 ms) |
0.83 |
join_distinct_parent_sort - alternative 2 |
568.4147815000001 mean ms (±3.362 ms) |
548.4910587 mean ms (±2.786 ms) |
1.04 |
join_foreign_filter_local_sort |
46.53023470000001 mean ms (±0.881 ms) |
45.810006 mean ms (±0.532 ms) |
1.02 |
join_foreign_filter_local_sort - alternative 1 |
48.87912909999999 mean ms (±1.291 ms) |
49.54393819999999 mean ms (±2.597 ms) |
0.99 |
join_foreign_filter_local_sort - alternative 2 |
60.2596901 mean ms (±0.860 ms) |
58.850542499999996 mean ms (±0.095 ms) |
1.02 |
join_hierarchical_content-no-scores-large |
77.0025606 mean ms (±0.654 ms) |
76.0259688 mean ms (±0.604 ms) |
1.01 |
join_hierarchical_content-no-scores-large - alternative 1 |
64.4734521 mean ms (±1.482 ms) |
65.053236 mean ms (±3.758 ms) |
0.99 |
join_hierarchical_content-no-scores-large - alternative 2 |
113.53863589999999 mean ms (±0.451 ms) |
113.771625 mean ms (±0.392 ms) |
1.00 |
join_hierarchical_content-no-scores-small |
29.546007999999993 mean ms (±0.353 ms) |
29.152500099999997 mean ms (±0.192 ms) |
1.01 |
join_hierarchical_content-no-scores-small - alternative 1 |
60.200822900000006 mean ms (±1.886 ms) |
63.64832939999999 mean ms (±2.582 ms) |
0.95 |
join_hierarchical_content-no-scores-small - alternative 2 |
112.24290680000001 mean ms (±0.250 ms) |
111.7685471 mean ms (±0.229 ms) |
1.00 |
join_hierarchical_content-scores-large |
36.59437040000001 mean ms (±0.075 ms) |
36.2986647 mean ms (±0.068 ms) |
1.01 |
join_hierarchical_content-scores-large - alternative 1 |
20.8885104 mean ms (±0.088 ms) |
20.5237387 mean ms (±0.179 ms) |
1.02 |
join_hierarchical_content-scores-large - alternative 2 |
39.9797845 mean ms (±0.106 ms) |
39.537353499999995 mean ms (±0.079 ms) |
1.01 |
join_hierarchical_content-scores-large - alternative 3 |
39.86490919999999 mean ms (±0.071 ms) |
39.6601971 mean ms (±0.059 ms) |
1.01 |
join_hierarchical_content-scores-small |
37.2527662 mean ms (±0.224 ms) |
36.7608658 mean ms (±0.142 ms) |
1.01 |
join_hierarchical_content-scores-small - alternative 1 |
40.363758999999995 mean ms (±0.247 ms) |
40.1791342 mean ms (±0.111 ms) |
1.00 |
join_hierarchical_content-scores-small - alternative 2 |
40.117716300000005 mean ms (±0.107 ms) |
39.868159 mean ms (±0.342 ms) |
1.01 |
join_permissioned_search |
52.0349237 mean ms (±0.311 ms) |
51.651676099999996 mean ms (±0.257 ms) |
1.01 |
join_permissioned_search - alternative 1 |
64.6390218 mean ms (±2.030 ms) |
61.4352746 mean ms (±0.921 ms) |
1.05 |
join_permissioned_search - alternative 2 |
81.15817059999999 mean ms (±0.556 ms) |
81.51908720000002 mean ms (±0.098 ms) |
1.00 |
join_semi_filter |
38.3243619 mean ms (±0.074 ms) |
37.19819510000001 mean ms (±0.057 ms) |
1.03 |
join_semi_filter - alternative 1 |
39.052561499999996 mean ms (±1.803 ms) |
42.027547899999995 mean ms (±8.852 ms) |
0.93 |
join_semi_filter - alternative 2 |
76.82001000000001 mean ms (±0.077 ms) |
76.07160340000001 mean ms (±0.084 ms) |
1.01 |
join_semi_filter - alternative 3 |
15.674460400000001 mean ms (±0.167 ms) |
15.607587999999998 mean ms (±0.160 ms) |
1.00 |
join_top_k-score-desc-high-selectivity |
100.89120729999999 mean ms (±0.130 ms) |
99.14378389999999 mean ms (±0.150 ms) |
1.02 |
join_top_k-score-desc-high-selectivity - alternative 1 |
41.3496194 mean ms (±0.965 ms) |
41.4439456 mean ms (±1.112 ms) |
1.00 |
join_top_k-score-desc-high-selectivity - alternative 2 |
83.4809029 mean ms (±0.739 ms) |
82.35372290000001 mean ms (±0.477 ms) |
1.01 |
paging-string-max |
6.701325300000001 mean ms (±0.122 ms) |
6.680636099999999 mean ms (±0.127 ms) |
1.00 |
paging-string-median |
8.839789 mean ms (±0.073 ms) |
8.8253631 mean ms (±0.071 ms) |
1.00 |
paging-string-min |
8.362454799999998 mean ms (±0.215 ms) |
8.110129399999998 mean ms (±0.060 ms) |
1.03 |
regex-and-heap |
86.41384559999999 mean ms (±0.114 ms) |
85.9260587 mean ms (±0.120 ms) |
1.01 |
sum-int-filter |
14.467212900000002 mean ms (±0.029 ms) |
14.684519999999997 mean ms (±0.033 ms) |
0.99 |
sum-int-filter - alternative 1 |
7.595187899999999 mean ms (±0.107 ms) |
7.4649065 mean ms (±0.049 ms) |
1.02 |
sum-numeric15-filter |
48.64926880000001 mean ms (±0.077 ms) |
49.2585859 mean ms (±0.070 ms) |
0.99 |
sum-numeric15-filter - alternative 1 |
23.857881499999998 mean ms (±2.547 ms) |
22.4419885 mean ms (±0.317 ms) |
1.06 |
sum-numeric78-filter |
101.2068448 mean ms (±0.115 ms) |
101.5427701 mean ms (±0.181 ms) |
1.00 |
sum-numeric78-filter - alternative 1 |
25.570169100000005 mean ms (±0.101 ms) |
25.9777962 mean ms (±0.276 ms) |
0.98 |
top_k-agg-avg |
5.549711199999999 mean ms (±0.027 ms) |
5.533522999999999 mean ms (±0.027 ms) |
1.00 |
top_k-agg-bucket-string |
5.1684152 mean ms (±0.013 ms) |
5.2448148 mean ms (±0.026 ms) |
0.99 |
top_k-agg-count |
5.595195500000001 mean ms (±0.015 ms) |
5.612741199999999 mean ms (±0.023 ms) |
1.00 |
top_k-compound |
3.4812361000000003 mean ms (±0.014 ms) |
3.4984651000000007 mean ms (±0.010 ms) |
1.00 |
top_k-numeric-highcard |
3.2655383999999996 mean ms (±0.016 ms) |
3.290416799999999 mean ms (±0.014 ms) |
0.99 |
top_k-numeric-lowcard |
3.2584262 mean ms (±0.012 ms) |
3.2762907999999995 mean ms (±0.010 ms) |
0.99 |
top_k-score-asc-high-selectivity |
4.7019724 mean ms (±0.005 ms) |
4.7506433999999995 mean ms (±0.011 ms) |
0.99 |
top_k-score-asc-high-selectivity - alternative 1 |
4.6926415 mean ms (±0.017 ms) |
4.7512733 mean ms (±0.017 ms) |
0.99 |
top_k-score-asc-medium-selectivity |
4.2582322 mean ms (±0.013 ms) |
4.3019723 mean ms (±0.021 ms) |
0.99 |
top_k-score-asc-medium-selectivity - alternative 1 |
4.261139900000001 mean ms (±0.013 ms) |
4.2861177 mean ms (±0.018 ms) |
0.99 |
top_k-score-asc |
3.8329174999999998 mean ms (±0.010 ms) |
3.8456778 mean ms (±0.019 ms) |
1.00 |
top_k-score-asc - alternative 1 |
3.8285593000000007 mean ms (±0.014 ms) |
3.8512141 mean ms (±0.011 ms) |
0.99 |
top_k-score-desc-high-selectivity |
3.2967038000000004 mean ms (±0.010 ms) |
3.3467822 mean ms (±0.011 ms) |
0.99 |
top_k-score-desc-high-selectivity - alternative 1 |
3.2895963000000004 mean ms (±0.012 ms) |
3.3450429999999995 mean ms (±0.009 ms) |
0.98 |
top_k-score-desc-medium-selectivity |
3.2279361 mean ms (±0.009 ms) |
3.2566132000000003 mean ms (±0.013 ms) |
0.99 |
top_k-score-desc-medium-selectivity - alternative 1 |
3.2274713999999998 mean ms (±0.010 ms) |
3.2597356 mean ms (±0.012 ms) |
0.99 |
top_k-score-desc-tiebreaker |
4.2266428000000005 mean ms (±0.013 ms) |
4.2690222 mean ms (±0.009 ms) |
0.99 |
top_k-score-desc-tiebreaker - alternative 1 |
4.2420505 mean ms (±0.020 ms) |
4.262966799999999 mean ms (±0.012 ms) |
1.00 |
top_k-score-desc |
3.1086655999999997 mean ms (±0.012 ms) |
3.1768065 mean ms (±0.011 ms) |
0.98 |
top_k-score-desc - alternative 1 |
3.0954764 mean ms (±0.014 ms) |
3.172906 mean ms (±0.008 ms) |
0.98 |
top_k-score-multi-term-asc |
10.563060199999999 mean ms (±0.025 ms) |
10.6330773 mean ms (±0.028 ms) |
0.99 |
top_k-score-multi-term-asc - alternative 1 |
10.5391924 mean ms (±0.010 ms) |
10.618007500000001 mean ms (±0.015 ms) |
0.99 |
top_k-score-multi-term-desc |
9.713181 mean ms (±0.033 ms) |
9.903648400000002 mean ms (±0.011 ms) |
0.98 |
top_k-score-multi-term-desc - alternative 1 |
9.698274700000002 mean ms (±0.012 ms) |
9.912596099999998 mean ms (±0.013 ms) |
0.98 |
top_k-string |
3.4476044999999997 mean ms (±0.016 ms) |
3.4449712000000003 mean ms (±0.008 ms) |
1.00 |
This comment was automatically generated by workflow using github-action-benchmark.
Codecov Report❌ Patch coverage is ❌ Your patch check has failed because the patch coverage (32.87%) is below the target coverage (80.00%). You can increase the patch coverage or adjust the target coverage. Additional details and impacted files@@ Coverage Diff @@
## main #6015 +/- ##
==========================================
+ Coverage 78.25% 78.54% +0.28%
==========================================
Files 228 226 -2
Lines 63927 63624 -303
==========================================
- Hits 50029 49974 -55
+ Misses 13898 13650 -248
🚀 New features to boost your workflow:
|
Contributor
There was a problem hiding this comment.
pg_search 'stackoverflow (bm25)' (20m rows)
Details
| Benchmark suite | Current: d94844a | Previous: ef3e38b | Ratio |
|---|---|---|---|
stackoverflow_posts_idx build time |
2.5676640776333333 min |
2.56718218895 min |
1.00 |
stackoverflow_posts_idx index size |
14798 MB |
14798 MB |
1 |
badges_idx build time |
0.42152578318333334 min |
0.42693439678333334 min |
0.99 |
badges_idx index size |
979 MB |
979 MB |
1 |
comments_idx build time |
0.9506821821833333 min |
0.9557037657333333 min |
0.99 |
comments_idx index size |
5050 MB |
5051 MB |
1.00 |
users_idx build time |
0.03870103571666667 min |
0.03912556415 min |
0.99 |
users_idx index size |
181 MB |
181 MB |
1 |
aggregate_topk_count |
4157.6630153 mean ms (±2.268 ms) |
4347.2033007 mean ms (±2.745 ms) |
0.96 |
aggregate_topk_count - alternative 1 |
1086.0354982000001 mean ms (±39.015 ms) |
1055.5486341 mean ms (±54.988 ms) |
1.03 |
bucket-expr-filter |
261.4371397 mean ms (±0.269 ms) |
257.0536154 mean ms (±0.108 ms) |
1.02 |
bucket-expr-filter - alternative 1 |
260.8407687 mean ms (±0.265 ms) |
257.0026016 mean ms (±0.174 ms) |
1.01 |
bucket-numeric-filter |
54.22541 mean ms (±0.078 ms) |
54.3674908 mean ms (±0.065 ms) |
1.00 |
bucket-numeric-filter - alternative 1 |
12.4565356 mean ms (±0.239 ms) |
12.2718229 mean ms (±0.057 ms) |
1.02 |
bucket-numeric-filter - alternative 2 |
14.6027353 mean ms (±0.086 ms) |
14.613688999999997 mean ms (±0.059 ms) |
1.00 |
bucket-numeric-filter - alternative 3 |
11.2777484 mean ms (±0.080 ms) |
11.2298273 mean ms (±0.038 ms) |
1.00 |
bucket-numeric-nofilter |
361.7820667 mean ms (±0.132 ms) |
362.78998490000004 mean ms (±0.114 ms) |
1.00 |
bucket-numeric-nofilter - alternative 1 |
57.053234999999994 mean ms (±0.054 ms) |
57.71009140000001 mean ms (±0.072 ms) |
0.99 |
bucket-numeric-nofilter - alternative 2 |
81.6404568 mean ms (±0.104 ms) |
81.9306858 mean ms (±0.063 ms) |
1.00 |
bucket-numeric-nofilter - alternative 3 |
44.90812140000001 mean ms (±0.043 ms) |
45.263945899999996 mean ms (±0.051 ms) |
0.99 |
bucket-string-filter |
299.1542174 mean ms (±0.366 ms) |
304.3340733 mean ms (±0.763 ms) |
0.98 |
bucket-string-filter - alternative 1 |
32.2733951 mean ms (±0.033 ms) |
32.525427099999995 mean ms (±0.060 ms) |
0.99 |
bucket-string-filter - alternative 2 |
41.923310099999995 mean ms (±0.065 ms) |
42.5419534 mean ms (±0.038 ms) |
0.99 |
bucket-string-filter - alternative 3 |
23.8295265 mean ms (±0.043 ms) |
24.158359799999996 mean ms (±0.087 ms) |
0.99 |
bucket-string-nofilter |
813.3165409999999 mean ms (±0.670 ms) |
815.0931684 mean ms (±0.747 ms) |
1.00 |
bucket-string-nofilter - alternative 1 |
102.40477200000001 mean ms (±0.115 ms) |
102.77473499999999 mean ms (±0.182 ms) |
1.00 |
bucket-string-nofilter - alternative 2 |
156.8380533 mean ms (±0.275 ms) |
159.0485254 mean ms (±0.580 ms) |
0.99 |
bucket-string-nofilter - alternative 3 |
120.03883950000002 mean ms (±1.177 ms) |
121.9923939 mean ms (±0.576 ms) |
0.98 |
cardinality |
117.41354340000001 mean ms (±0.137 ms) |
117.97740079999998 mean ms (±0.074 ms) |
1.00 |
cardinality - alternative 1 |
52.29897989999999 mean ms (±0.060 ms) |
52.5034167 mean ms (±0.101 ms) |
1.00 |
cardinality - alternative 2 |
12.333600800000001 mean ms (±0.044 ms) |
12.3112069 mean ms (±0.058 ms) |
1.00 |
cardinality - alternative 3 |
12.3186619 mean ms (±0.082 ms) |
12.2681845 mean ms (±0.048 ms) |
1.00 |
cardinality - alternative 4 |
8.9565347 mean ms (±0.043 ms) |
8.9166669 mean ms (±0.044 ms) |
1.00 |
cardinality - alternative 5 |
253.372919 mean ms (±0.849 ms) |
254.6272053 mean ms (±0.663 ms) |
1.00 |
cardinality - alternative 6 |
4484.0263698 mean ms (±3.398 ms) |
4660.396072500001 mean ms (±7.500 ms) |
0.96 |
cardinality - alternative 7 |
5418.7937382 mean ms (±5.959 ms) |
5425.564808699999 mean ms (±5.262 ms) |
1.00 |
cardinality - alternative 8 |
37.91537459999999 mean ms (±0.062 ms) |
37.874334999999995 mean ms (±0.074 ms) |
1.00 |
cardinality - alternative 9 |
35.23596870000001 mean ms (±0.031 ms) |
35.1132895 mean ms (±0.029 ms) |
1.00 |
count-filter |
25.178187299999998 mean ms (±0.067 ms) |
25.368945999999998 mean ms (±0.039 ms) |
0.99 |
count-filter - alternative 1 |
16.4869401 mean ms (±0.051 ms) |
16.6526579 mean ms (±0.061 ms) |
0.99 |
count-filter - alternative 2 |
16.503622800000006 mean ms (±0.044 ms) |
16.668578200000002 mean ms (±0.066 ms) |
0.99 |
count-filter - alternative 3 |
2.6848764 mean ms (±0.012 ms) |
2.718348399999999 mean ms (±0.012 ms) |
0.99 |
count-nofilter |
127.02060420000001 mean ms (±0.218 ms) |
127.15421410000002 mean ms (±0.163 ms) |
1.00 |
count-nofilter - alternative 1 |
55.34670719999999 mean ms (±0.086 ms) |
55.422594000000004 mean ms (±0.077 ms) |
1.00 |
count-nofilter - alternative 2 |
55.33043680000001 mean ms (±0.080 ms) |
55.4187585 mean ms (±0.118 ms) |
1.00 |
count-nofilter - alternative 3 |
0.4676188 mean ms (±0.007 ms) |
0.4762908 mean ms (±0.009 ms) |
0.98 |
filtered-highcard |
2.1043763999999996 mean ms (±0.012 ms) |
1.8936282000000002 mean ms (±0.021 ms) |
1.11 |
filtered-lowcard |
1.7921721000000002 mean ms (±0.014 ms) |
1.7938990000000001 mean ms (±0.032 ms) |
1.00 |
highlighting |
4.3035037 mean ms (±0.031 ms) |
4.1841409 mean ms (±0.005 ms) |
1.03 |
join_aggregate_count |
2404.2135675 mean ms (±4.769 ms) |
2439.1444808000006 mean ms (±9.742 ms) |
0.99 |
join_aggregate_count - alternative 1 |
588.3550488999999 mean ms (±20.935 ms) |
590.7693363999999 mean ms (±20.720 ms) |
1.00 |
join_aggregate_count - alternative 2 |
1000.9629740999999 mean ms (±0.373 ms) |
1026.8591702 mean ms (±0.778 ms) |
0.97 |
join_aggregate_date_histogram |
6339.2978422 mean ms (±23.969 ms) |
6339.4544377 mean ms (±32.282 ms) |
1.00 |
join_aggregate_date_histogram - alternative 1 |
6331.2830522 mean ms (±38.042 ms) |
6331.172393100001 mean ms (±24.490 ms) |
1.00 |
join_aggregate_date_histogram - alternative 2 |
6326.1921241 mean ms (±24.133 ms) |
6317.0606112 mean ms (±21.685 ms) |
1.00 |
join_aggregate_groupby |
2688.9360859 mean ms (±4.113 ms) |
2712.1609755 mean ms (±6.962 ms) |
0.99 |
join_aggregate_groupby - alternative 1 |
818.6030866 mean ms (±25.056 ms) |
807.1121827 mean ms (±20.866 ms) |
1.01 |
join_aggregate_groupby - alternative 2 |
1170.8850364 mean ms (±0.981 ms) |
1194.0158998000002 mean ms (±4.276 ms) |
0.98 |
join_aggregate_multi |
2485.2588519000005 mean ms (±7.465 ms) |
2522.2767450999995 mean ms (±5.173 ms) |
0.99 |
join_aggregate_multi - alternative 1 |
685.6657882000001 mean ms (±25.025 ms) |
676.5030512000001 mean ms (±25.909 ms) |
1.01 |
join_aggregate_multi - alternative 2 |
1052.7156836999998 mean ms (±0.659 ms) |
1083.9314491 mean ms (±1.165 ms) |
0.97 |
join_aggregate_sort |
24462.1133732 mean ms (±11.080 ms) |
24567.9611412 mean ms (±36.666 ms) |
1.00 |
join_aggregate_sort - alternative 1 |
2271.9551518000003 mean ms (±29.931 ms) |
2258.4208695 mean ms (±20.249 ms) |
1.01 |
join_aggregate_sort - alternative 2 |
3639.0090840999997 mean ms (±4.273 ms) |
3757.4326715 mean ms (±2.604 ms) |
0.97 |
join_aggregate_topk_count |
2748.8861265 mean ms (±6.189 ms) |
2775.9008721 mean ms (±6.540 ms) |
0.99 |
join_aggregate_topk_count - alternative 1 |
1012.1292276 mean ms (±38.405 ms) |
967.2885047 mean ms (±37.948 ms) |
1.05 |
join_aggregate_topk_count - alternative 2 |
1293.8966132 mean ms (±1.404 ms) |
1314.6228833999999 mean ms (±2.196 ms) |
0.98 |
join_aggregate_window_facet |
17886.820476200002 mean ms (±33.100 ms) |
17935.336412 mean ms (±31.771 ms) |
1.00 |
join_aggregate_window_facet - alternative 1 |
17901.782834699996 mean ms (±32.607 ms) |
17909.6188948 mean ms (±23.742 ms) |
1.00 |
join_aggregate_window_facet - alternative 2 |
17920.125769000002 mean ms (±29.284 ms) |
18010.6628638 mean ms (±25.550 ms) |
0.99 |
join_distinct_parent_sort |
2206.8869577 mean ms (±37.015 ms) |
2291.8204792999995 mean ms (±45.669 ms) |
0.96 |
join_distinct_parent_sort - alternative 1 |
4574.9111311 mean ms (±28.587 ms) |
4493.689027400001 mean ms (±22.102 ms) |
1.02 |
join_distinct_parent_sort - alternative 2 |
4763.067250499999 mean ms (±34.757 ms) |
4657.299566400001 mean ms (±154.198 ms) |
1.02 |
join_foreign_filter_local_sort |
153.83121369999998 mean ms (±1.730 ms) |
158.629125 mean ms (±3.138 ms) |
0.97 |
join_foreign_filter_local_sort - alternative 1 |
193.9740738 mean ms (±36.964 ms) |
193.275998 mean ms (±37.149 ms) |
1.00 |
join_foreign_filter_local_sort - alternative 2 |
185.7619986 mean ms (±0.624 ms) |
173.1838459 mean ms (±0.491 ms) |
1.07 |
join_hierarchical_content-no-scores-large |
370.7256726 mean ms (±7.936 ms) |
386.2981812 mean ms (±10.590 ms) |
0.96 |
join_hierarchical_content-no-scores-large - alternative 1 |
124.11065560000002 mean ms (±0.965 ms) |
124.46846359999999 mean ms (±1.024 ms) |
1.00 |
join_hierarchical_content-no-scores-large - alternative 2 |
349.1053269 mean ms (±0.988 ms) |
350.3254822 mean ms (±0.313 ms) |
1.00 |
join_hierarchical_content-no-scores-small |
83.403711 mean ms (±0.687 ms) |
84.901483 mean ms (±0.213 ms) |
0.98 |
join_hierarchical_content-no-scores-small - alternative 1 |
121.97742860000001 mean ms (±0.796 ms) |
121.3229912 mean ms (±1.217 ms) |
1.01 |
join_hierarchical_content-no-scores-small - alternative 2 |
346.5986937 mean ms (±0.665 ms) |
345.3018091 mean ms (±0.953 ms) |
1.00 |
join_hierarchical_content-scores-large |
403.87015040000006 mean ms (±1.191 ms) |
394.4594392 mean ms (±0.978 ms) |
1.02 |
join_hierarchical_content-scores-large - alternative 1 |
101.1227062 mean ms (±0.243 ms) |
98.8079389 mean ms (±0.355 ms) |
1.02 |
join_hierarchical_content-scores-large - alternative 2 |
406.4534375 mean ms (±1.161 ms) |
395.02830350000005 mean ms (±0.576 ms) |
1.03 |
join_hierarchical_content-scores-large - alternative 3 |
407.9497791 mean ms (±1.091 ms) |
400.6749615 mean ms (±0.780 ms) |
1.02 |
join_hierarchical_content-scores-small |
169.05068110000002 mean ms (±1.021 ms) |
170.7969636 mean ms (±0.873 ms) |
0.99 |
join_hierarchical_content-scores-small - alternative 1 |
175.2402377 mean ms (±0.658 ms) |
173.8605066 mean ms (±0.518 ms) |
1.01 |
join_hierarchical_content-scores-small - alternative 2 |
176.24743489999997 mean ms (±1.167 ms) |
173.66529379999997 mean ms (±0.793 ms) |
1.01 |
join_permissioned_search |
458.12074739999997 mean ms (±0.609 ms) |
448.87489530000005 mean ms (±1.123 ms) |
1.02 |
join_permissioned_search - alternative 1 |
414.8127828 mean ms (±23.128 ms) |
410.6016649 mean ms (±24.039 ms) |
1.01 |
join_permissioned_search - alternative 2 |
290.94895660000003 mean ms (±0.357 ms) |
286.7633828 mean ms (±0.189 ms) |
1.01 |
join_semi_filter |
564.8008963999999 mean ms (±2.662 ms) |
556.6013312 mean ms (±1.330 ms) |
1.01 |
join_semi_filter - alternative 1 |
95.42550899999999 mean ms (±22.460 ms) |
91.33760829999999 mean ms (±7.359 ms) |
1.04 |
join_semi_filter - alternative 2 |
148.0545472 mean ms (±0.195 ms) |
155.69650310000003 mean ms (±0.231 ms) |
0.95 |
join_semi_filter - alternative 3 |
46.03711869999999 mean ms (±0.063 ms) |
45.360051399999996 mean ms (±0.120 ms) |
1.01 |
join_top_k-score-desc-high-selectivity |
2718.9221433 mean ms (±24.557 ms) |
2642.0909185 mean ms (±21.661 ms) |
1.03 |
join_top_k-score-desc-high-selectivity - alternative 1 |
60.7275301 mean ms (±5.776 ms) |
59.760499800000005 mean ms (±5.624 ms) |
1.02 |
join_top_k-score-desc-high-selectivity - alternative 2 |
461.1089839 mean ms (±0.636 ms) |
495.6084162 mean ms (±0.665 ms) |
0.93 |
paging-string-max |
6.8191919 mean ms (±0.061 ms) |
6.881492 mean ms (±0.213 ms) |
0.99 |
paging-string-median |
14.6945872 mean ms (±0.138 ms) |
14.7031903 mean ms (±0.045 ms) |
1.00 |
paging-string-min |
14.0019384 mean ms (±0.102 ms) |
13.8715666 mean ms (±0.117 ms) |
1.01 |
regex-and-heap |
2446.8560352 mean ms (±24.484 ms) |
2423.1154951 mean ms (±21.585 ms) |
1.01 |
sum-int-filter |
41.2557358 mean ms (±0.088 ms) |
40.9167142 mean ms (±0.082 ms) |
1.01 |
sum-int-filter - alternative 1 |
17.6150022 mean ms (±0.070 ms) |
17.5323906 mean ms (±0.066 ms) |
1.00 |
sum-numeric15-filter |
132.33735420000002 mean ms (±0.114 ms) |
132.7012724 mean ms (±0.108 ms) |
1.00 |
sum-numeric15-filter - alternative 1 |
46.4874012 mean ms (±0.320 ms) |
46.0634999 mean ms (±0.588 ms) |
1.01 |
sum-numeric78-filter |
276.93058379999997 mean ms (±0.492 ms) |
274.7923248 mean ms (±0.387 ms) |
1.01 |
sum-numeric78-filter - alternative 1 |
106.2104957 mean ms (±0.386 ms) |
106.15512650000001 mean ms (±0.154 ms) |
1.00 |
top_k-agg-avg |
16.455920600000002 mean ms (±0.146 ms) |
16.100192799999995 mean ms (±0.095 ms) |
1.02 |
top_k-agg-bucket-string |
15.2830434 mean ms (±0.070 ms) |
15.000553799999997 mean ms (±0.082 ms) |
1.02 |
top_k-agg-count |
16.7172246 mean ms (±0.061 ms) |
16.6433829 mean ms (±0.363 ms) |
1.00 |
top_k-compound |
6.341777799999999 mean ms (±0.021 ms) |
6.162614100000001 mean ms (±0.023 ms) |
1.03 |
top_k-numeric-highcard |
5.7258574 mean ms (±0.015 ms) |
5.719312400000001 mean ms (±0.011 ms) |
1.00 |
top_k-numeric-lowcard |
5.7692378 mean ms (±0.022 ms) |
5.699565 mean ms (±0.020 ms) |
1.01 |
top_k-score-asc-high-selectivity |
14.185265699999999 mean ms (±0.247 ms) |
13.982006799999999 mean ms (±0.129 ms) |
1.01 |
top_k-score-asc-high-selectivity - alternative 1 |
24.786023400000005 mean ms (±0.045 ms) |
24.650156000000003 mean ms (±0.037 ms) |
1.01 |
top_k-score-asc-medium-selectivity |
13.282898499999998 mean ms (±0.092 ms) |
13.021079199999999 mean ms (±0.066 ms) |
1.02 |
top_k-score-asc-medium-selectivity - alternative 1 |
18.928048999999998 mean ms (±0.052 ms) |
18.8922798 mean ms (±0.033 ms) |
1.00 |
top_k-score-asc |
12.724239299999999 mean ms (±0.173 ms) |
12.548191200000002 mean ms (±0.098 ms) |
1.01 |
top_k-score-asc - alternative 1 |
14.8394764 mean ms (±0.047 ms) |
14.806674199999998 mean ms (±0.052 ms) |
1.00 |
top_k-score-desc-high-selectivity |
4.784750799999999 mean ms (±0.015 ms) |
4.7880292 mean ms (±0.024 ms) |
1.00 |
top_k-score-desc-high-selectivity - alternative 1 |
4.757571799999999 mean ms (±0.018 ms) |
4.751183600000001 mean ms (±0.036 ms) |
1.00 |
top_k-score-desc-medium-selectivity |
4.531569500000001 mean ms (±0.031 ms) |
4.5809366 mean ms (±0.011 ms) |
0.99 |
top_k-score-desc-medium-selectivity - alternative 1 |
4.40946 mean ms (±0.018 ms) |
4.388600800000001 mean ms (±0.009 ms) |
1.00 |
top_k-score-desc-tiebreaker |
9.9413865 mean ms (±0.068 ms) |
9.960001100000001 mean ms (±0.027 ms) |
1.00 |
top_k-score-desc-tiebreaker - alternative 1 |
9.8764036 mean ms (±0.056 ms) |
9.8675778 mean ms (±0.035 ms) |
1.00 |
top_k-score-desc |
4.5429965 mean ms (±0.012 ms) |
4.438435 mean ms (±0.015 ms) |
1.02 |
top_k-score-desc - alternative 1 |
4.6172471 mean ms (±0.041 ms) |
4.3962966 mean ms (±0.009 ms) |
1.05 |
top_k-score-multi-term-asc |
18.010223200000002 mean ms (±0.118 ms) |
17.7834805 mean ms (±0.146 ms) |
1.01 |
top_k-score-multi-term-asc - alternative 1 |
32.914491399999996 mean ms (±0.060 ms) |
32.7059286 mean ms (±0.071 ms) |
1.01 |
top_k-score-multi-term-desc |
16.119580399999997 mean ms (±0.116 ms) |
15.873933 mean ms (±0.144 ms) |
1.02 |
top_k-score-multi-term-desc - alternative 1 |
17.944172199999997 mean ms (±0.044 ms) |
18.2890784 mean ms (±0.047 ms) |
0.98 |
top_k-string |
7.453551300000001 mean ms (±0.068 ms) |
7.5601581 mean ms (±0.040 ms) |
0.99 |
This comment was automatically generated by workflow using github-action-benchmark.
Collaborator
|
It looks like the lost filters are due to apache/datafusion#24045, and necessary for correctness. They don't impact our benchmarks, so this looks good to land. |
philippemnoel
approved these changes
Aug 21, 2026
stuhood
force-pushed
the
rj.use-df55-dfd
branch
from
August 21, 2026 18:56
d94844a to
202c056
Compare
Contributor
|
Created backport PR for
Please cherry-pick the changes locally and resolve any conflicts. git fetch origin backport-6015-to-0.25.x
git worktree add --checkout .worktree/backport-6015-to-0.25.x backport-6015-to-0.25.x
cd .worktree/backport-6015-to-0.25.x
git reset --hard HEAD^
git cherry-pick -x ff880e56c7a137931e7073e29c14007ca0aabe5a |
stuhood
pushed a commit
that referenced
this pull request
Aug 21, 2026
stuhood
pushed a commit
that referenced
this pull request
Aug 21, 2026
# Description Backport of #6015 to `0.25.x`. --------- Co-authored-by: RJ Barman <[email protected]> Co-authored-by: paradedb-github-app[bot] <282009505+paradedb-github-app[bot]@users.noreply.github.com>
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
What
Update to
datafusion-55.Tests
Benchmarks are neutral.
Regress tests show some lost dynamic filters due to apache/datafusion#24045, which is necessary for correctness.