Dandandan commented on PR #21092:
URL: https://github.com/apache/datafusion/pull/21092#issuecomment-4105663247
> 🤖: Benchmark completed
>
> Details
>
> ```
> group
adamd_simplify-ctx-builder main
> -----
-------------------------- ----
> logical_aggregate_with_join 1.03 657.5±3.26µs
? ?/sec 1.00 636.2±1.97µs ? ?/sec
> logical_plan_struct_join_agg_sort 1.00 288.5±2.07µs
? ?/sec 1.00 287.2±3.67µs ? ?/sec
> logical_select_all_from_1000 1.00 10.3±0.04ms
? ?/sec 1.09 11.2±0.04ms ? ?/sec
> logical_select_one_from_700 1.05 437.7±3.14µs
? ?/sec 1.00 417.7±1.63µs ? ?/sec
> logical_trivial_join_high_numbered_columns 1.04 387.6±1.27µs
? ?/sec 1.00 372.3±0.83µs ? ?/sec
> logical_trivial_join_low_numbered_columns 1.04 374.5±2.28µs
? ?/sec 1.00 358.5±2.71µs ? ?/sec
> physical_intersection 1.00 871.2±3.65µs
? ?/sec 1.78 1554.3±4.49µs ? ?/sec
> physical_join_consider_sort 1.00 1468.0±3.74µs
? ?/sec 1.50 2.2±0.01ms ? ?/sec
> physical_join_distinct 1.05 368.2±12.55µs
? ?/sec 1.00 349.7±1.77µs ? ?/sec
> physical_many_self_joins 1.00 10.6±0.03ms
? ?/sec 1.18 12.5±0.04ms ? ?/sec
> physical_plan_clickbench_all 1.00 150.5±1.27ms
? ?/sec 1.34 201.3±2.02ms ? ?/sec
> physical_plan_clickbench_q1 1.00 1686.6±11.55µs
? ?/sec 1.26 2.1±0.01ms ? ?/sec
> physical_plan_clickbench_q10 1.00 2.6±0.02ms
? ?/sec 1.42 3.6±0.02ms ? ?/sec
> physical_plan_clickbench_q11 1.00 2.7±0.02ms
? ?/sec 1.52 4.1±0.03ms ? ?/sec
> physical_plan_clickbench_q12 1.00 2.8±0.02ms
? ?/sec 1.49 4.2±0.03ms ? ?/sec
> physical_plan_clickbench_q13 1.00 2.5±0.02ms
? ?/sec 1.49 3.7±0.02ms ? ?/sec
> physical_plan_clickbench_q14 1.00 2.7±0.07ms
? ?/sec 1.52 4.1±0.09ms ? ?/sec
> physical_plan_clickbench_q15 1.00 2.5±0.02ms
? ?/sec 1.49 3.8±0.04ms ? ?/sec
> physical_plan_clickbench_q16 1.00 2.2±0.02ms
? ?/sec 1.46 3.2±0.03ms ? ?/sec
> physical_plan_clickbench_q17 1.00 2.2±0.01ms
? ?/sec 1.46 3.3±0.05ms ? ?/sec
> physical_plan_clickbench_q18 1.00 2.0±0.01ms
? ?/sec 1.29 2.6±0.02ms ? ?/sec
> physical_plan_clickbench_q19 1.00 2.6±0.01ms
? ?/sec 1.39 3.6±0.04ms ? ?/sec
> physical_plan_clickbench_q2 1.00 2.1±0.01ms
? ?/sec 1.29 2.7±0.01ms ? ?/sec
> physical_plan_clickbench_q20 1.00 1729.2±14.25µs
? ?/sec 1.22 2.1±0.01ms ? ?/sec
> physical_plan_clickbench_q21 1.00 2.1±0.01ms
? ?/sec 1.33 2.8±0.01ms ? ?/sec
> physical_plan_clickbench_q22 1.00 2.7±0.02ms
? ?/sec 1.46 3.9±0.03ms ? ?/sec
> physical_plan_clickbench_q23 1.00 2.9±0.02ms
? ?/sec 1.44 4.2±0.06ms ? ?/sec
> physical_plan_clickbench_q24 1.00 3.9±0.03ms
? ?/sec 1.22 4.8±0.02ms ? ?/sec
> physical_plan_clickbench_q25 1.00 2.2±0.03ms
? ?/sec 1.54 3.4±0.03ms ? ?/sec
> physical_plan_clickbench_q26 1.00 2.0±0.01ms
? ?/sec 1.42 2.9±0.02ms ? ?/sec
> physical_plan_clickbench_q27 1.00 2.2±0.02ms
? ?/sec 1.55 3.5±0.01ms ? ?/sec
> physical_plan_clickbench_q28 1.00 2.9±0.03ms
? ?/sec 1.51 4.4±0.04ms ? ?/sec
> physical_plan_clickbench_q29 1.00 3.2±0.04ms
? ?/sec 1.46 4.6±0.07ms ? ?/sec
> physical_plan_clickbench_q3 1.00 2.0±0.02ms
? ?/sec 1.23 2.5±0.02ms ? ?/sec
> physical_plan_clickbench_q30 1.00 19.4±0.13ms
? ?/sec 1.06 20.7±0.41ms ? ?/sec
> physical_plan_clickbench_q31 1.00 3.0±0.02ms
? ?/sec 1.46 4.4±0.06ms ? ?/sec
> physical_plan_clickbench_q32 1.00 3.0±0.02ms
? ?/sec 1.47 4.4±0.07ms ? ?/sec
> physical_plan_clickbench_q33 1.00 2.5±0.02ms
? ?/sec 1.41 3.6±0.05ms ? ?/sec
> physical_plan_clickbench_q34 1.00 2.2±0.02ms
? ?/sec 1.46 3.2±0.02ms ? ?/sec
> physical_plan_clickbench_q35 1.00 2.3±0.01ms
? ?/sec 1.46 3.3±0.02ms ? ?/sec
> physical_plan_clickbench_q36 1.00 2.7±0.02ms
? ?/sec 1.44 3.9±0.03ms ? ?/sec
> physical_plan_clickbench_q37 1.00 3.2±0.02ms
? ?/sec 1.42 4.6±0.04ms ? ?/sec
> physical_plan_clickbench_q38 1.00 3.3±0.02ms
? ?/sec 1.42 4.6±0.05ms ? ?/sec
> physical_plan_clickbench_q39 1.00 3.1±0.02ms
? ?/sec 1.30 4.0±0.02ms ? ?/sec
> physical_plan_clickbench_q4 1.00 1809.3±7.30µs
? ?/sec 1.21 2.2±0.01ms ? ?/sec
> physical_plan_clickbench_q40 1.00 3.8±0.05ms
? ?/sec 1.25 4.7±0.05ms ? ?/sec
> physical_plan_clickbench_q41 1.00 3.2±0.03ms
? ?/sec 1.30 4.2±0.06ms ? ?/sec
> physical_plan_clickbench_q42 1.00 3.2±0.02ms
? ?/sec 1.30 4.1±0.05ms ? ?/sec
> physical_plan_clickbench_q43 1.00 3.4±0.04ms
? ?/sec 1.28 4.4±0.03ms ? ?/sec
> physical_plan_clickbench_q44 1.00 1915.4±8.81µs
? ?/sec 1.19 2.3±0.02ms ? ?/sec
> physical_plan_clickbench_q45 1.00 1900.0±8.45µs
? ?/sec 1.20 2.3±0.02ms ? ?/sec
> physical_plan_clickbench_q46 1.00 2.3±0.01ms
? ?/sec 1.37 3.2±0.02ms ? ?/sec
> physical_plan_clickbench_q47 1.00 3.3±0.02ms
? ?/sec 1.43 4.7±0.04ms ? ?/sec
> physical_plan_clickbench_q48 1.00 3.4±0.02ms
? ?/sec 1.47 5.0±0.06ms ? ?/sec
> physical_plan_clickbench_q49 1.00 3.6±0.02ms
? ?/sec 1.44 5.2±0.04ms ? ?/sec
> physical_plan_clickbench_q5 1.00 1995.3±7.24µs
? ?/sec 1.24 2.5±0.01ms ? ?/sec
> physical_plan_clickbench_q50 1.00 3.5±0.02ms
? ?/sec 1.19 4.1±0.05ms ? ?/sec
> physical_plan_clickbench_q51 1.00 2.5±0.02ms
? ?/sec 1.40 3.5±0.03ms ? ?/sec
> physical_plan_clickbench_q6 1.00 1996.5±7.61µs
? ?/sec 1.25 2.5±0.02ms ? ?/sec
> physical_plan_clickbench_q7 1.00 1688.7±6.08µs
? ?/sec 1.22 2.1±0.01ms ? ?/sec
> physical_plan_clickbench_q8 1.00 2.3±0.01ms
? ?/sec 1.31 3.0±0.04ms ? ?/sec
> physical_plan_clickbench_q9 1.00 2.4±0.02ms
? ?/sec 1.49 3.6±0.02ms ? ?/sec
> physical_plan_struct_join_agg_sort 1.00 1807.1±16.28µs
? ?/sec 1.70 3.1±0.00ms ? ?/sec
> physical_plan_tpcds_all 1.00 1017.3±2.72ms
? ?/sec 1.83 1858.8±7.10ms ? ?/sec
> physical_plan_tpch_all 1.00 62.4±0.13ms
? ?/sec 1.98 123.3±1.54ms ? ?/sec
> physical_plan_tpch_q1 1.00 2.0±0.00ms
? ?/sec 1.40 2.8±0.03ms ? ?/sec
> physical_plan_tpch_q10 1.00 3.8±0.04ms
? ?/sec 1.86 7.0±0.06ms ? ?/sec
> physical_plan_tpch_q11 1.00 3.4±0.02ms
? ?/sec 2.43 8.2±0.07ms ? ?/sec
> physical_plan_tpch_q12 1.00 1775.0±7.36µs
? ?/sec 1.66 2.9±0.02ms ? ?/sec
> physical_plan_tpch_q13 1.00 1385.6±24.67µs
? ?/sec 2.13 3.0±0.00ms ? ?/sec
> physical_plan_tpch_q14 1.00 1810.7±23.47µs
? ?/sec 1.55 2.8±0.02ms ? ?/sec
> physical_plan_tpch_q16 1.00 2.3±0.02ms
? ?/sec 2.21 5.0±0.09ms ? ?/sec
> physical_plan_tpch_q17 1.00 2.7±0.02ms
? ?/sec 1.98 5.4±0.06ms ? ?/sec
> physical_plan_tpch_q18 1.00 2.6±0.02ms
? ?/sec 2.21 5.9±0.11ms ? ?/sec
> physical_plan_tpch_q19 1.00 3.3±0.01ms
? ?/sec 1.53 5.1±0.02ms ? ?/sec
> physical_plan_tpch_q2 1.00 5.7±0.02ms
? ?/sec 2.12 12.1±0.09ms ? ?/sec
> physical_plan_tpch_q20 1.00 3.2±0.01ms
? ?/sec 2.43 7.9±0.05ms ? ?/sec
> physical_plan_tpch_q21 1.00 4.0±0.03ms
? ?/sec 2.48 10.0±0.20ms ? ?/sec
> physical_plan_tpch_q22 1.00 2.8±0.01ms
? ?/sec 2.25 6.3±0.12ms ? ?/sec
> physical_plan_tpch_q3 1.00 2.6±0.02ms
? ?/sec 2.11 5.4±0.07ms ? ?/sec
> physical_plan_tpch_q4 1.00 1412.9±8.72µs
? ?/sec 2.05 2.9±0.03ms ? ?/sec
> physical_plan_tpch_q5 1.00 3.2±0.02ms
? ?/sec 1.81 5.9±0.06ms ? ?/sec
> physical_plan_tpch_q6 1.00 883.5±6.22µs
? ?/sec 1.74 1541.0±9.79µs ? ?/sec
> physical_plan_tpch_q7 1.00 4.0±0.03ms
? ?/sec 1.76 7.0±0.06ms ? ?/sec
> physical_plan_tpch_q8 1.00 5.3±0.02ms
? ?/sec 1.71 9.1±0.04ms ? ?/sec
> physical_plan_tpch_q9 1.00 3.8±0.01ms
? ?/sec 1.69 6.5±0.02ms ? ?/sec
> physical_select_aggregates_from_200 1.00 17.0±0.11ms
? ?/sec 1.04 17.7±0.13ms ? ?/sec
> physical_select_all_from_1000 1.00 23.2±0.25ms
? ?/sec 1.08 24.9±0.13ms ? ?/sec
> physical_select_one_from_700 1.00 1142.4±5.22µs
? ?/sec 1.15 1309.0±11.54µs ? ?/sec
> physical_sorted_union_order_by_10_int64 1.00 5.3±0.04ms
? ?/sec 1.81 9.7±0.11ms ? ?/sec
> physical_sorted_union_order_by_10_uint64 1.00 13.9±0.13ms
? ?/sec 1.98 27.5±0.33ms ? ?/sec
> physical_sorted_union_order_by_50_int64 1.00 136.0±0.97ms
? ?/sec 1.15 155.8±1.09ms ? ?/sec
> physical_sorted_union_order_by_50_uint64 1.00 789.8±3.51ms
? ?/sec 1.24 976.1±6.48ms ? ?/sec
> physical_theta_join_consider_sort 1.00 1835.5±10.16µs
? ?/sec 1.40 2.6±0.01ms ? ?/sec
> physical_unnest_to_join 1.00 1864.4±12.15µs
? ?/sec 1.64 3.0±0.02ms ? ?/sec
> physical_window_function_partition_by_12_on_values 1.00 933.6±5.48µs
? ?/sec 1.32 1234.8±12.09µs ? ?/sec
> physical_window_function_partition_by_30_on_values 1.00 1751.6±6.64µs
? ?/sec 1.17 2.1±0.01ms ? ?/sec
> physical_window_function_partition_by_4_on_values 1.00 603.7±5.05µs
? ?/sec 1.50 908.1±14.92µs ? ?/sec
> physical_window_function_partition_by_7_on_values 1.00 718.6±3.82µs
? ?/sec 1.43 1026.4±11.74µs ? ?/sec
> physical_window_function_partition_by_8_on_values 1.00 767.8±8.49µs
? ?/sec 1.40 1073.8±11.15µs ? ?/sec
> with_param_values_many_columns 1.00 579.1±8.13µs
? ?/sec 1.02 593.1±3.97µs ? ?/sec
> ```
Woah, is this right?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
