q01 0 rule=projection_simplification,considered_count=6,applied_count=0,candidates=rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n3,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n3,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q01 0 rule=count_non_null_column_pruning,considered_count=1,applied_count=0,candidates=rule=count_non_null_column_pruning,aggregate_node_id=n4,column=__algeon_native_aggregate_arg_7,source_node_id=none,file_column_index=none,applied=false,rejected_reason=UnsupportedInputLineage
q01 0 rule=shared_subplan_materialization,considered_count=1,candidate_count=0,applied_count=0,candidates=none
q01 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n4,join_node_id=none,applied=false,rejected_reason=InputNotJoin
q02 0 rule=projection_simplification,considered_count=11,applied_count=3,candidates=rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=n5,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n9,replacement_node_id=n7,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n22,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n17,replacement_node_id=n14,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n21,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n19,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q02 0 rule=semijoin_reduction,considered_count=1,applied_count=0,candidates=rule=semijoin_reduction,candidate_node_id=n20,before_root_node_id=n20,after_root_node_id=none,crossed_join_node_ids=none,target_subtree_id=none,key_mappings=none,cost_threshold_multiplier=8,cost_gate=none,applied=false,rejected_reason=AmbiguousKeyLineage
q02 0 rule=join_build_side_selection,considered_count=7,applied_count=1,candidates=rule=join_build_side_selection,candidate_node_id=n4,before_build_side=right,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=299,right_estimated_bytes=177,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n6,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=588,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n11,before_build_side=right,after_build_side=none,left_estimated_rows=5,right_estimated_rows=3,left_estimated_bytes=223,right_estimated_bytes=125,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n12,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=none,left_estimated_bytes=none,right_estimated_bytes=none,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=none,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n15,before_build_side=right,after_build_side=none,left_estimated_rows=5,right_estimated_rows=3,left_estimated_bytes=135,right_estimated_bytes=125,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n17,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=118,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n18,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=177,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide
q02 0 rule=join_filter_reassociation,considered_count=9,applied_count=3,candidates=rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n17,crossed_join_node_id=n16,filtered_child_node_id=n13,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n4,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n15,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n18,crossed_join_node_id=n17,filtered_child_node_id=n16,filtering_node_id=n15,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n11,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n18,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n17,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n15,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape
q02 0 rule=dimension_derived_row_group_pruning,considered_count=14,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n0,target_source_node_id=n3,dimension_key_column=p_partkey,target_key_column=ps_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetLineageReusedInPlan|rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n3,target_source_node_id=n0,dimension_key_column=ps_partkey,target_key_column=p_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n6,dimension_source_node_id=n3,target_source_node_id=n5,dimension_key_column=ps_suppkey,target_key_column=s_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n6,dimension_source_node_id=n5,target_source_node_id=n3,dimension_key_column=s_suppkey,target_key_column=ps_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetLineageReusedInPlan|rule=dimension_derived_row_group_pruning,candidate_node_id=n11,dimension_source_node_id=n7,target_source_node_id=n8,dimension_key_column=n_regionkey,target_key_column=r_regionkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetLineageReusedInPlan|rule=dimension_derived_row_group_pruning,candidate_node_id=n11,dimension_source_node_id=n8,target_source_node_id=n7,dimension_key_column=r_regionkey,target_key_column=n_regionkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n12,dimension_source_node_id=n5,target_source_node_id=n7,dimension_key_column=s_nationkey,target_key_column=n_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n12,dimension_source_node_id=n7,target_source_node_id=n5,dimension_key_column=n_nationkey,target_key_column=s_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n15,dimension_source_node_id=n14,target_source_node_id=n8,dimension_key_column=n_regionkey,target_key_column=r_regionkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetLineageReusedInPlan|rule=dimension_derived_row_group_pruning,candidate_node_id=n15,dimension_source_node_id=n8,target_source_node_id=n14,dimension_key_column=r_regionkey,target_key_column=n_regionkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n17,dimension_source_node_id=n16,target_source_node_id=n14,dimension_key_column=s_nationkey,target_key_column=n_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n17,dimension_source_node_id=n14,target_source_node_id=n16,dimension_key_column=n_nationkey,target_key_column=s_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n18,dimension_source_node_id=n16,target_source_node_id=n3,dimension_key_column=s_suppkey,target_key_column=ps_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetLineageReusedInPlan|rule=dimension_derived_row_group_pruning,candidate_node_id=n18,dimension_source_node_id=n3,target_source_node_id=n16,dimension_key_column=ps_suppkey,target_key_column=s_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent
q02 0 rule=local_parquet_source_reuse,considered_count=2,applied_count=0,candidates=rule=local_parquet_source_reuse,source_node_ids=n7+n14,reuse_count=2,stable_file_ids=local:<dataset>/nation.parquet:1422:mtime=<run>,superset_read_columns=n_nationkey+n_name+n_regionkey,branch_filter_count=0,max_variant_selected_bytes=524288000,applied=false,rejected_reason=UnsupportedSourceContract|rule=local_parquet_source_reuse,source_node_ids=n5+n16,reuse_count=2,stable_file_ids=local:<dataset>/supplier.parquet:2642:mtime=<run>,superset_read_columns=s_suppkey+s_name+s_address+s_nationkey+s_phone+s_acctbal+s_comment,branch_filter_count=0,max_variant_selected_bytes=524288000,applied=false,rejected_reason=UnsupportedSourceContract
q02 0 rule=shared_subplan_materialization,considered_count=1,candidate_count=0,applied_count=0,candidates=none
q02 0 rule=dynamic_filter_route_discovery,considered_count=8,route_count=6,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n4,dynamic_filter_id=df0,producer_build_side=right,producer_input_node_id=n3,consumer_input_node_id=n2,consumer_kind=local_parquet_source,consumer_node_id=n0,consumer_source_node_id=n0,producer_key_column=ps_partkey,consumer_key_column=p_partkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=299,total_source_bytes=299,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n6,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n5,consumer_input_node_id=n4,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=n3,producer_key_column=s_suppkey,consumer_key_column=ps_suppkey,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=177,total_source_bytes=177,routed=false,rejected_reason=ConsumerSourceReusedInPlan|rule=dynamic_filter_route_discovery,candidate_node_id=n11,dynamic_filter_id=df1,producer_build_side=right,producer_input_node_id=n10,consumer_input_node_id=n7,consumer_kind=local_parquet_source,consumer_node_id=n7,consumer_source_node_id=n7,producer_key_column=r_regionkey,consumer_key_column=n_regionkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=223,total_source_bytes=223,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n12,dynamic_filter_id=df2,producer_build_side=right,producer_input_node_id=n11,consumer_input_node_id=n6,consumer_kind=local_parquet_source,consumer_node_id=n5,consumer_source_node_id=n5,producer_key_column=n_nationkey,consumer_key_column=s_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=588,total_source_bytes=588,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n15,dynamic_filter_id=df3,producer_build_side=right,producer_input_node_id=n10,consumer_input_node_id=n14,consumer_kind=local_parquet_source,consumer_node_id=n14,consumer_source_node_id=n14,producer_key_column=r_regionkey,consumer_key_column=n_regionkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=135,total_source_bytes=135,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n17,dynamic_filter_id=df4,producer_build_side=left,producer_input_node_id=n16,consumer_input_node_id=n15,consumer_kind=local_parquet_source,consumer_node_id=n14,consumer_source_node_id=n14,producer_key_column=s_nationkey,consumer_key_column=n_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=135,total_source_bytes=135,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n18,dynamic_filter_id=df5,producer_build_side=right,producer_input_node_id=n3,consumer_input_node_id=n17,consumer_kind=local_parquet_source,consumer_node_id=n16,consumer_source_node_id=n16,producer_key_column=ps_suppkey,consumer_key_column=s_suppkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=118,total_source_bytes=118,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n22,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n21,consumer_input_node_id=n13,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape
q02 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n20,join_node_id=n19,applied=false,rejected_reason=UnsupportedAggregateExpression
q03 0 rule=projection_simplification,considered_count=8,applied_count=0,candidates=rule=projection_simplification,candidate_node_id=n14,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n15,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n9,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q03 0 rule=join_build_side_selection,considered_count=4,applied_count=1,candidates=rule=join_build_side_selection,candidate_node_id=n5,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=119,right_estimated_bytes=202,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n9,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=224,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n5,before_build_side=left,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=119,right_estimated_bytes=202,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n11,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=none,left_estimated_bytes=none,right_estimated_bytes=none,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=grouped_aggregate_keyset,applied=false,rejected_reason=NoBetterBuildSide
q03 0 rule=join_filter_reassociation,considered_count=1,applied_count=0,candidates=rule=join_filter_reassociation,candidate_node_id=n5,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape
q03 0 rule=dimension_derived_row_group_pruning,considered_count=4,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n5,dimension_source_node_id=n0,target_source_node_id=n3,dimension_key_column=c_custkey,target_key_column=o_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n5,dimension_source_node_id=n3,target_source_node_id=n0,dimension_key_column=o_custkey,target_key_column=c_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n11,dimension_source_node_id=n3,target_source_node_id=none,dimension_key_column=o_orderkey,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetKeyLineageUnavailable|rule=dimension_derived_row_group_pruning,candidate_node_id=n11,dimension_source_node_id=none,target_source_node_id=none,dimension_key_column=none,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionKeyLineageUnavailable
q03 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q03 0 rule=dynamic_filter_route_discovery,considered_count=2,route_count=2,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n5,dynamic_filter_id=df0,producer_build_side=left,producer_input_node_id=n2,consumer_input_node_id=n4,consumer_kind=local_parquet_source,consumer_node_id=n3,consumer_source_node_id=n3,producer_key_column=c_custkey,consumer_key_column=o_custkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=202,total_source_bytes=202,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n11,dynamic_filter_id=df1,producer_build_side=right,producer_input_node_id=n10,consumer_input_node_id=n5,consumer_kind=local_parquet_source,consumer_node_id=n3,consumer_source_node_id=n3,producer_key_column=l_orderkey,consumer_key_column=o_orderkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=202,total_source_bytes=202,routed=true,rejected_reason=none
q03 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=1,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n11,join_node_id=n10,applied=true,rejected_reason=none
q04 0 rule=projection_simplification,considered_count=8,applied_count=0,candidates=rule=projection_simplification,candidate_node_id=n10,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n7,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n5,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n7,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n5,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q04 0 rule=semijoin_reduction,considered_count=1,applied_count=0,candidates=rule=semijoin_reduction,candidate_node_id=n6,before_root_node_id=n6,after_root_node_id=none,crossed_join_node_ids=none,target_subtree_id=n0,key_mappings=o_orderkey->o_orderkey@n0,cost_threshold_multiplier=8,cost_gate=none,applied=false,rejected_reason=UnsupportedLeftShape
q04 0 rule=count_non_null_column_pruning,considered_count=1,applied_count=0,candidates=rule=count_non_null_column_pruning,aggregate_node_id=n8,column=__algeon_native_aggregate_arg_0,source_node_id=none,file_column_index=none,applied=false,rejected_reason=UnsupportedInputLineage
q04 0 rule=shared_subplan_materialization,considered_count=1,candidate_count=0,applied_count=0,candidates=none
q04 0 rule=dynamic_filter_route_discovery,considered_count=1,route_count=0,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n6,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n5,consumer_input_node_id=n2,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape
q04 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n8,join_node_id=n7,applied=false,rejected_reason=UnsupportedAggregateExpression
q05 0 rule=projection_simplification,considered_count=11,applied_count=3,candidates=rule=projection_simplification,candidate_node_id=n21,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n18,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=n3,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n11,replacement_node_id=n9,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n15,replacement_node_id=n12,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n19,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n14,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n12,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q05 0 rule=join_build_side_selection,considered_count=10,applied_count=3,candidates=rule=join_build_side_selection,candidate_node_id=n4,before_build_side=right,after_build_side=none,left_estimated_rows=5,right_estimated_rows=3,left_estimated_bytes=223,right_estimated_bytes=125,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n10,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=118,right_estimated_bytes=165,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n12,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=236,left_advisory_rows=3,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n13,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=118,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=3,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n14,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=none,left_estimated_bytes=none,right_estimated_bytes=none,left_advisory_rows=3,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=none,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n5,before_build_side=left,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=118,right_estimated_bytes=165,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n7,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=236,left_advisory_rows=3,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n8,before_build_side=left,after_build_side=none,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=118,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=3,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n13,before_build_side=right,after_build_side=none,left_estimated_rows=5,right_estimated_rows=3,left_estimated_bytes=223,right_estimated_bytes=125,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n16,before_build_side=right,after_build_side=left,left_estimated_rows=none,right_estimated_rows=none,left_estimated_bytes=none,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=grouped_aggregate_keyset,applied=true,rejected_reason=none
q05 0 rule=join_filter_reassociation,considered_count=2,applied_count=1,candidates=rule=join_filter_reassociation,candidate_node_id=n14,crossed_join_node_id=n13,filtered_child_node_id=n12,filtering_node_id=n2,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n4,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape
q05 0 rule=dimension_derived_row_group_pruning,considered_count=8,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n5,dimension_source_node_id=n1,target_source_node_id=n2,dimension_key_column=c_custkey,target_key_column=o_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n5,dimension_source_node_id=n2,target_source_node_id=n1,dimension_key_column=o_custkey,target_key_column=c_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=n2,target_source_node_id=n6,dimension_key_column=o_orderkey,target_key_column=l_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=n6,target_source_node_id=n2,dimension_key_column=l_orderkey,target_key_column=o_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n13,dimension_source_node_id=n9,target_source_node_id=n10,dimension_key_column=n_regionkey,target_key_column=r_regionkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n13,dimension_source_node_id=n10,target_source_node_id=n9,dimension_key_column=r_regionkey,target_key_column=n_regionkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n16,dimension_source_node_id=none,target_source_node_id=none,dimension_key_column=none,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionKeyLineageUnavailable|rule=dimension_derived_row_group_pruning,candidate_node_id=n16,dimension_source_node_id=n9,target_source_node_id=none,dimension_key_column=n_nationkey,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetKeyLineageUnavailable
q05 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q05 0 rule=dynamic_filter_route_discovery,considered_count=5,route_count=4,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n5,dynamic_filter_id=df0,producer_build_side=left,producer_input_node_id=n1,consumer_input_node_id=n4,consumer_kind=local_parquet_source,consumer_node_id=n2,consumer_source_node_id=n2,producer_key_column=c_custkey,consumer_key_column=o_custkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=165,total_source_bytes=165,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n7,dynamic_filter_id=df1,producer_build_side=right,producer_input_node_id=n6,consumer_input_node_id=n5,consumer_kind=local_parquet_source,consumer_node_id=n2,consumer_source_node_id=n2,producer_key_column=l_orderkey,consumer_key_column=o_orderkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=165,total_source_bytes=165,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n8,dynamic_filter_id=none,producer_build_side=left,producer_input_node_id=n0,consumer_input_node_id=n7,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape|rule=dynamic_filter_route_discovery,candidate_node_id=n13,dynamic_filter_id=df2,producer_build_side=right,producer_input_node_id=n12,consumer_input_node_id=n9,consumer_kind=local_parquet_source,consumer_node_id=n9,consumer_source_node_id=n9,producer_key_column=r_regionkey,consumer_key_column=n_regionkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=223,total_source_bytes=223,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n16,dynamic_filter_id=df3,producer_build_side=left,producer_input_node_id=n15,consumer_input_node_id=n13,consumer_kind=local_parquet_source,consumer_node_id=n9,consumer_source_node_id=n9,producer_key_column=s_nationkey,consumer_key_column=n_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=223,total_source_bytes=223,routed=true,rejected_reason=none
q05 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=1,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n17,join_node_id=n16,applied=true,rejected_reason=none
q06 0 rule=projection_simplification,considered_count=4,applied_count=0,candidates=rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q06 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q06 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n3,join_node_id=none,applied=false,rejected_reason=InputNotJoin
q07 0 rule=projection_simplification,considered_count=6,applied_count=2,candidates=rule=projection_simplification,candidate_node_id=n18,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n15,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=n3,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=n4,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n16,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q07 0 rule=join_build_side_selection,considered_count=5,applied_count=4,candidates=rule=join_build_side_selection,candidate_node_id=n7,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=118,right_estimated_bytes=283,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n8,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=118,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=2,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n9,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=118,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=2,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n10,before_build_side=right,after_build_side=left,left_estimated_rows=5,right_estimated_rows=none,left_estimated_bytes=164,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=2,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n12,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=5,left_estimated_bytes=none,right_estimated_bytes=164,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide
q07 0 rule=join_filter_reassociation,considered_count=1,applied_count=0,candidates=rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=NoPushableResidualPredicate
q07 0 rule=dimension_derived_row_group_pruning,considered_count=8,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=n4,target_source_node_id=n5,dimension_key_column=s_suppkey,target_key_column=l_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=n5,target_source_node_id=n4,dimension_key_column=l_suppkey,target_key_column=s_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n8,dimension_source_node_id=n3,target_source_node_id=n5,dimension_key_column=o_orderkey,target_key_column=l_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n8,dimension_source_node_id=n5,target_source_node_id=n3,dimension_key_column=l_orderkey,target_key_column=o_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n9,dimension_source_node_id=n2,target_source_node_id=n3,dimension_key_column=c_custkey,target_key_column=o_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n9,dimension_source_node_id=n3,target_source_node_id=n2,dimension_key_column=o_custkey,target_key_column=c_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n10,dimension_source_node_id=n0,target_source_node_id=n4,dimension_key_column=n_nationkey,target_key_column=s_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n10,dimension_source_node_id=n4,target_source_node_id=n0,dimension_key_column=s_nationkey,target_key_column=n_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetLineageReusedInPlan
q07 0 rule=shared_subplan_materialization,considered_count=1,candidate_count=0,applied_count=0,candidates=none
q07 0 rule=dynamic_filter_route_discovery,considered_count=5,route_count=5,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n7,dynamic_filter_id=df0,producer_build_side=left,producer_input_node_id=n4,consumer_input_node_id=n6,consumer_kind=local_parquet_source,consumer_node_id=n5,consumer_source_node_id=n5,producer_key_column=s_suppkey,consumer_key_column=l_suppkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=283,total_source_bytes=283,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n8,dynamic_filter_id=df1,producer_build_side=left,producer_input_node_id=n3,consumer_input_node_id=n7,consumer_kind=local_parquet_source,consumer_node_id=n5,consumer_source_node_id=n5,producer_key_column=o_orderkey,consumer_key_column=l_orderkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=283,total_source_bytes=283,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n9,dynamic_filter_id=df2,producer_build_side=left,producer_input_node_id=n2,consumer_input_node_id=n8,consumer_kind=local_parquet_source,consumer_node_id=n3,consumer_source_node_id=n3,producer_key_column=c_custkey,consumer_key_column=o_custkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=118,total_source_bytes=118,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n10,dynamic_filter_id=df3,producer_build_side=left,producer_input_node_id=n1,consumer_input_node_id=n9,consumer_kind=local_parquet_source,consumer_node_id=n4,consumer_source_node_id=n4,producer_key_column=n_nationkey,consumer_key_column=s_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=118,total_source_bytes=118,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n12,dynamic_filter_id=df4,producer_build_side=right,producer_input_node_id=n11,consumer_input_node_id=n10,consumer_kind=local_parquet_source,consumer_node_id=n2,consumer_source_node_id=n2,producer_key_column=n_nationkey,consumer_key_column=c_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=118,total_source_bytes=118,routed=true,rejected_reason=none
q07 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n14,join_node_id=n13,applied=false,rejected_reason=JoinResidualUnsupported
q08 0 rule=projection_simplification,considered_count=14,applied_count=3,candidates=rule=projection_simplification,candidate_node_id=n26,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n24,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n23,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=n9,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=n11,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n21,replacement_node_id=n18,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n24,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n22,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n21,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n18,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n12,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q08 0 rule=join_build_side_selection,considered_count=7,applied_count=3,candidates=rule=join_build_side_selection,candidate_node_id=n5,before_build_side=right,after_build_side=none,left_estimated_rows=5,right_estimated_rows=3,left_estimated_bytes=135,right_estimated_bytes=125,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n6,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=118,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n9,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=165,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n14,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=163,right_estimated_bytes=295,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n16,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=118,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n17,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=none,left_estimated_bytes=none,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=1,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=none,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n20,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=5,left_estimated_bytes=none,right_estimated_bytes=164,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide
q08 0 rule=join_filter_reassociation,considered_count=13,applied_count=3,candidates=rule=join_filter_reassociation,candidate_node_id=n10,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n17,crossed_join_node_id=n16,filtered_child_node_id=n15,filtering_node_id=n2,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n4,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n17,crossed_join_node_id=n16,filtered_child_node_id=n5,filtering_node_id=n4,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n6,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n4,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n13,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n17,crossed_join_node_id=n16,filtered_child_node_id=n8,filtering_node_id=n6,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n9,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n6,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n5,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n14,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape
q08 0 rule=dimension_derived_row_group_pruning,considered_count=14,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n5,dimension_source_node_id=n1,target_source_node_id=n2,dimension_key_column=n_regionkey,target_key_column=r_regionkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n5,dimension_source_node_id=n2,target_source_node_id=n1,dimension_key_column=r_regionkey,target_key_column=n_regionkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n6,dimension_source_node_id=n0,target_source_node_id=n1,dimension_key_column=c_nationkey,target_key_column=n_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n6,dimension_source_node_id=n1,target_source_node_id=n0,dimension_key_column=n_nationkey,target_key_column=c_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n9,dimension_source_node_id=n7,target_source_node_id=n0,dimension_key_column=o_custkey,target_key_column=c_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n9,dimension_source_node_id=n0,target_source_node_id=n7,dimension_key_column=c_custkey,target_key_column=o_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n14,dimension_source_node_id=n10,target_source_node_id=n13,dimension_key_column=p_partkey,target_key_column=l_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n14,dimension_source_node_id=n13,target_source_node_id=n10,dimension_key_column=l_partkey,target_key_column=p_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n16,dimension_source_node_id=n13,target_source_node_id=n15,dimension_key_column=l_suppkey,target_key_column=s_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n16,dimension_source_node_id=n15,target_source_node_id=n13,dimension_key_column=s_suppkey,target_key_column=l_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n17,dimension_source_node_id=n7,target_source_node_id=n13,dimension_key_column=o_orderkey,target_key_column=l_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n17,dimension_source_node_id=n13,target_source_node_id=n7,dimension_key_column=l_orderkey,target_key_column=o_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n20,dimension_source_node_id=n15,target_source_node_id=n19,dimension_key_column=s_nationkey,target_key_column=n_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n20,dimension_source_node_id=n19,target_source_node_id=n15,dimension_key_column=n_nationkey,target_key_column=s_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent
q08 0 rule=local_parquet_source_reuse,considered_count=1,applied_count=0,candidates=rule=local_parquet_source_reuse,source_node_ids=n1+n19,reuse_count=2,stable_file_ids=local:<dataset>/nation.parquet:1422:mtime=<run>,superset_read_columns=n_nationkey+n_name+n_regionkey,branch_filter_count=0,max_variant_selected_bytes=524288000,applied=false,rejected_reason=UnsupportedSourceContract
q08 0 rule=shared_subplan_materialization,considered_count=1,candidate_count=0,applied_count=0,candidates=none
q08 0 rule=dynamic_filter_route_discovery,considered_count=7,route_count=7,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n5,dynamic_filter_id=df0,producer_build_side=right,producer_input_node_id=n4,consumer_input_node_id=n1,consumer_kind=local_parquet_source,consumer_node_id=n1,consumer_source_node_id=n1,producer_key_column=r_regionkey,consumer_key_column=n_regionkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=135,total_source_bytes=135,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n6,dynamic_filter_id=df1,producer_build_side=left,producer_input_node_id=n0,consumer_input_node_id=n5,consumer_kind=local_parquet_source,consumer_node_id=n1,consumer_source_node_id=n1,producer_key_column=c_nationkey,consumer_key_column=n_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=135,total_source_bytes=135,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n9,dynamic_filter_id=df2,producer_build_side=left,producer_input_node_id=n8,consumer_input_node_id=n6,consumer_kind=local_parquet_source,consumer_node_id=n0,consumer_source_node_id=n0,producer_key_column=o_custkey,consumer_key_column=c_custkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=118,total_source_bytes=118,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n14,dynamic_filter_id=df3,producer_build_side=left,producer_input_node_id=n12,consumer_input_node_id=n13,consumer_kind=local_parquet_source,consumer_node_id=n13,consumer_source_node_id=n13,producer_key_column=p_partkey,consumer_key_column=l_partkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=295,total_source_bytes=295,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n16,dynamic_filter_id=df4,producer_build_side=right,producer_input_node_id=n15,consumer_input_node_id=n14,consumer_kind=local_parquet_source,consumer_node_id=n13,consumer_source_node_id=n13,producer_key_column=s_suppkey,consumer_key_column=l_suppkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=295,total_source_bytes=295,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n17,dynamic_filter_id=df5,producer_build_side=right,producer_input_node_id=n16,consumer_input_node_id=n9,consumer_kind=local_parquet_source,consumer_node_id=n7,consumer_source_node_id=n7,producer_key_column=l_orderkey,consumer_key_column=o_orderkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=165,total_source_bytes=165,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n20,dynamic_filter_id=df6,producer_build_side=right,producer_input_node_id=n19,consumer_input_node_id=n18,consumer_kind=local_parquet_source,consumer_node_id=n15,consumer_source_node_id=n15,producer_key_column=n_nationkey,consumer_key_column=s_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=118,total_source_bytes=118,routed=true,rejected_reason=none
q08 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n23,join_node_id=n22,applied=false,rejected_reason=UnsupportedGroupExpression
q09 0 rule=projection_simplification,considered_count=10,applied_count=4,candidates=rule=projection_simplification,candidate_node_id=n20,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n17,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n1,replacement_node_id=n0,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n3,replacement_node_id=n1,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=n5,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n15,replacement_node_id=n11,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n16,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q09 0 rule=join_build_side_selection,considered_count=5,applied_count=3,candidates=rule=join_build_side_selection,candidate_node_id=n6,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=146,right_estimated_bytes=354,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n8,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=177,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n9,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=118,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=1,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n10,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=106,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=1,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n12,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=5,left_estimated_bytes=none,right_estimated_bytes=164,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide
q09 0 rule=join_filter_reassociation,considered_count=1,applied_count=0,candidates=rule=join_filter_reassociation,candidate_node_id=n6,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape
q09 0 rule=dimension_derived_row_group_pruning,considered_count=8,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n6,dimension_source_node_id=n2,target_source_node_id=n5,dimension_key_column=p_partkey,target_key_column=l_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n6,dimension_source_node_id=n5,target_source_node_id=n2,dimension_key_column=l_partkey,target_key_column=p_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n9,dimension_source_node_id=n1,target_source_node_id=n5,dimension_key_column=s_suppkey,target_key_column=l_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n9,dimension_source_node_id=n5,target_source_node_id=n1,dimension_key_column=l_suppkey,target_key_column=s_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n10,dimension_source_node_id=n0,target_source_node_id=n5,dimension_key_column=o_orderkey,target_key_column=l_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n10,dimension_source_node_id=n5,target_source_node_id=n0,dimension_key_column=l_orderkey,target_key_column=o_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n12,dimension_source_node_id=n1,target_source_node_id=n11,dimension_key_column=s_nationkey,target_key_column=n_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n12,dimension_source_node_id=n11,target_source_node_id=n1,dimension_key_column=n_nationkey,target_key_column=s_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent
q09 0 rule=shared_subplan_materialization,considered_count=1,candidate_count=0,applied_count=0,candidates=none
q09 0 rule=dynamic_filter_route_discovery,considered_count=5,route_count=4,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n6,dynamic_filter_id=df0,producer_build_side=left,producer_input_node_id=n4,consumer_input_node_id=n5,consumer_kind=local_parquet_source,consumer_node_id=n5,consumer_source_node_id=n5,producer_key_column=p_partkey,consumer_key_column=l_partkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=354,total_source_bytes=354,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n8,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n7,consumer_input_node_id=n6,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape|rule=dynamic_filter_route_discovery,candidate_node_id=n9,dynamic_filter_id=df1,producer_build_side=left,producer_input_node_id=n1,consumer_input_node_id=n8,consumer_kind=local_parquet_source,consumer_node_id=n5,consumer_source_node_id=n5,producer_key_column=s_suppkey,consumer_key_column=l_suppkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=354,total_source_bytes=354,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n10,dynamic_filter_id=df2,producer_build_side=left,producer_input_node_id=n0,consumer_input_node_id=n9,consumer_kind=local_parquet_source,consumer_node_id=n5,consumer_source_node_id=n5,producer_key_column=o_orderkey,consumer_key_column=l_orderkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=354,total_source_bytes=354,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n12,dynamic_filter_id=df3,producer_build_side=right,producer_input_node_id=n11,consumer_input_node_id=n10,consumer_kind=local_parquet_source,consumer_node_id=n1,consumer_source_node_id=n1,producer_key_column=n_nationkey,consumer_key_column=s_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=118,total_source_bytes=118,routed=true,rejected_reason=none
q09 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n14,join_node_id=n13,applied=false,rejected_reason=UnsupportedGroupExpression
q10 0 rule=projection_simplification,considered_count=10,applied_count=2,candidates=rule=projection_simplification,candidate_node_id=n17,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=n3,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n11,replacement_node_id=n9,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n16,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n7,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q10 0 rule=join_build_side_selection,considered_count=6,applied_count=1,candidates=rule=join_build_side_selection,candidate_node_id=n4,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=165,right_estimated_bytes=542,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n8,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=227,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n10,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=5,left_estimated_bytes=none,right_estimated_bytes=164,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n4,before_build_side=left,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=165,right_estimated_bytes=542,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n8,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=227,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n12,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=5,left_estimated_bytes=none,right_estimated_bytes=164,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide
q10 0 rule=dimension_derived_row_group_pruning,considered_count=6,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n0,target_source_node_id=n3,dimension_key_column=o_custkey,target_key_column=c_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n3,target_source_node_id=n0,dimension_key_column=c_custkey,target_key_column=o_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n8,dimension_source_node_id=n0,target_source_node_id=n5,dimension_key_column=o_orderkey,target_key_column=l_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n8,dimension_source_node_id=n5,target_source_node_id=n0,dimension_key_column=l_orderkey,target_key_column=o_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n12,dimension_source_node_id=none,target_source_node_id=none,dimension_key_column=none,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionKeyLineageUnavailable|rule=dimension_derived_row_group_pruning,candidate_node_id=n12,dimension_source_node_id=n9,target_source_node_id=none,dimension_key_column=n_nationkey,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetKeyLineageUnavailable
q10 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q10 0 rule=dynamic_filter_route_discovery,considered_count=3,route_count=3,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n4,dynamic_filter_id=df0,producer_build_side=left,producer_input_node_id=n2,consumer_input_node_id=n3,consumer_kind=local_parquet_source,consumer_node_id=n3,consumer_source_node_id=n3,producer_key_column=o_custkey,consumer_key_column=c_custkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=542,total_source_bytes=542,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n8,dynamic_filter_id=df1,producer_build_side=right,producer_input_node_id=n7,consumer_input_node_id=n4,consumer_kind=local_parquet_source,consumer_node_id=n0,consumer_source_node_id=n0,producer_key_column=l_orderkey,consumer_key_column=o_orderkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=165,total_source_bytes=165,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n12,dynamic_filter_id=df2,producer_build_side=right,producer_input_node_id=n9,consumer_input_node_id=n11,consumer_kind=local_parquet_source,consumer_node_id=n3,consumer_source_node_id=n3,producer_key_column=n_nationkey,consumer_key_column=c_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=542,total_source_bytes=542,routed=true,rejected_reason=none
q10 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=1,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n12,join_node_id=n11,applied=true,rejected_reason=none
q11 0 rule=projection_simplification,considered_count=14,applied_count=3,candidates=rule=projection_simplification,candidate_node_id=n20,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n18,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n16,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=n3,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=n4,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n11,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n9,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=n10,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n14,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n3,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n12,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q11 0 rule=join_build_side_selection,considered_count=6,applied_count=2,candidates=rule=join_build_side_selection,candidate_node_id=n4,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=5,left_estimated_bytes=118,right_estimated_bytes=164,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n6,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=224,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n11,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=5,left_estimated_bytes=118,right_estimated_bytes=164,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n13,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=165,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n4,before_build_side=left,after_build_side=none,left_estimated_rows=3,right_estimated_rows=5,left_estimated_bytes=118,right_estimated_bytes=164,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n8,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=none,left_estimated_bytes=none,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=grouped_aggregate_keyset,applied=false,rejected_reason=NoBetterBuildSide
q11 0 rule=join_filter_reassociation,considered_count=8,applied_count=2,candidates=rule=join_filter_reassociation,candidate_node_id=n16,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=NoPushableResidualPredicate|rule=join_filter_reassociation,candidate_node_id=n6,crossed_join_node_id=n5,filtered_child_node_id=n3,filtering_node_id=n2,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n11,filtered_child_node_id=n3,filtering_node_id=n2,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n18,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=NoPushableResidualPredicate|rule=join_filter_reassociation,candidate_node_id=n6,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n4,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n13,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape|rule=join_filter_reassociation,candidate_node_id=n11,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape
q11 0 rule=dimension_derived_row_group_pruning,considered_count=4,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n0,target_source_node_id=n1,dimension_key_column=s_nationkey,target_key_column=n_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n1,target_source_node_id=n0,dimension_key_column=n_nationkey,target_key_column=s_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n8,dimension_source_node_id=n0,target_source_node_id=none,dimension_key_column=s_suppkey,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetKeyLineageUnavailable|rule=dimension_derived_row_group_pruning,candidate_node_id=n8,dimension_source_node_id=none,target_source_node_id=none,dimension_key_column=none,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionKeyLineageUnavailable
q11 0 rule=shared_subplan_materialization,considered_count=3,candidate_count=1,applied_count=1,candidates=rule=shared_subplan_materialization,family_key=shared-grouped-scalar-v1-fnv64-<run>,aggregate_node_ids=n9+n16,reuse_count=2,group_exprs=ps_partkey,aggregate_exprs=fn=sum;distinct=false;arg=__algeon_native_aggregate_arg_0;filter=none;alias=sum(partsupp.ps_supplycost * partsupp.ps_availqty),filtered_aggregate_count=0,filtered_aggregate_memory_shape=not_applicable,filtered_aggregate_estimation_input_rows=none,filtered_aggregate_estimated_materialization_bytes=none,filtered_aggregate_memory_budget_bytes=none,filtered_aggregate_memory_threshold_bytes=none,filtered_aggregate_memory_threshold_policy=not_applicable,source_fingerprints=join(type=inner,keys=input0.s_suppkey=input1.ps_suppkey,residual=none,nulls=NullsDoNotMatch,left=join(type=inner,keys=input0.s_nationkey=input1.n_nationkey,residual=none,nulls=NullsDoNotMatch,left=local_parquet(files=stable_id=local:<dataset>/supplier.parquet:2642:mtime=<run>;location=<dataset>/supplier.parquet;resolved_contract=original_location=fnv64:<run>:len:<run>;reader_location=fnv64:<run>:len:<run>;storage_domain=none;content_identity=none;storage_profile_id=none;read_strategy=local_kvikio;credential_mode=none;cache_status=disabled;lakehouse_cache_read_mode=disabled;lakehouse_cache_root=none;lakehouse_cache_path=none;lakehouse_cache_max_bytes=none;lakehouse_cache_fill_mode=disabled;;row_groups=all;partition_values=[];predicate=none;scan_limit=none;max_rows=none;zero_column_count=false),right=filter(local_parquet(files=stable_id=local:<dataset>/nation.parquet:1422:mtime=<run>;location=<dataset>/nation.parquet;resolved_contract=original_location=fnv64:<run>:len:<run>;reader_location=fnv64:<run>:len:<run>;storage_domain=none;content_identity=none;storage_profile_id=none;read_strategy=local_kvikio;credential_mode=none;cache_status=disabled;lakehouse_cache_read_mode=disabled;lakehouse_cache_root=none;lakehouse_cache_path=none;lakehouse_cache_max_bytes=none;lakehouse_cache_fill_mode=disabled;;row_groups=all;partition_values=[];predicate=none;scan_limit=none;max_rows=none;zero_column_count=false);predicate=(n_name = "GERMANY"))),right=local_parquet(files=stable_id=local:<dataset>/partsupp.parquet:1773:mtime=<run>;location=<dataset>/partsupp.parquet;resolved_contract=original_location=fnv64:<run>:len:<run>;reader_location=fnv64:<run>:len:<run>;storage_domain=none;content_identity=none;storage_profile_id=none;read_strategy=local_kvikio;credential_mode=none;cache_status=disabled;lakehouse_cache_read_mode=disabled;lakehouse_cache_root=none;lakehouse_cache_path=none;lakehouse_cache_max_bytes=none;lakehouse_cache_fill_mode=disabled;;row_groups=all;partition_values=[];predicate=none;scan_limit=none;max_rows=none;zero_column_count=false)),exact_source_variant_count=2,repeated_selected_source_bytes=953,duplicate_selected_source_bytes=447,applied=true,rejected_reason=none
q11 0 rule=dynamic_filter_route_discovery,considered_count=3,route_count=2,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n4,dynamic_filter_id=df0,producer_build_side=left,producer_input_node_id=n0,consumer_input_node_id=n3,consumer_kind=local_parquet_source,consumer_node_id=n1,consumer_source_node_id=n1,producer_key_column=s_nationkey,consumer_key_column=n_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=164,total_source_bytes=164,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n8,dynamic_filter_id=df1,producer_build_side=right,producer_input_node_id=n7,consumer_input_node_id=n4,consumer_kind=local_parquet_source,consumer_node_id=n0,consumer_source_node_id=n0,producer_key_column=ps_suppkey,consumer_key_column=s_suppkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=118,total_source_bytes=118,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n13,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n12,consumer_input_node_id=n10,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape
q11 0 rule=aggregate_join_pushdown,considered_count=2,applied_count=1,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n9,join_node_id=n8,applied=true,rejected_reason=none|rule=aggregate_join_pushdown,aggregate_node_id=n11,join_node_id=none,applied=false,rejected_reason=InputNotJoin
q12 0 rule=projection_simplification,considered_count=6,applied_count=0,candidates=rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n5,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n9,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q12 0 rule=join_build_side_selection,considered_count=2,applied_count=1,candidates=rule=join_build_side_selection,candidate_node_id=n4,before_build_side=right,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=259,right_estimated_bytes=125,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n6,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=259,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none
q12 0 rule=dimension_derived_row_group_pruning,considered_count=2,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n6,dimension_source_node_id=n0,target_source_node_id=none,dimension_key_column=l_orderkey,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetKeyLineageUnavailable|rule=dimension_derived_row_group_pruning,candidate_node_id=n6,dimension_source_node_id=none,target_source_node_id=none,dimension_key_column=none,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionKeyLineageUnavailable
q12 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q12 0 rule=dynamic_filter_route_discovery,considered_count=1,route_count=1,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n6,dynamic_filter_id=df0,producer_build_side=left,producer_input_node_id=n2,consumer_input_node_id=n5,consumer_kind=local_parquet_source,consumer_node_id=n3,consumer_source_node_id=n3,producer_key_column=l_orderkey,consumer_key_column=o_orderkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=125,total_source_bytes=125,routed=true,rejected_reason=none
q12 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=1,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n6,join_node_id=n5,applied=true,rejected_reason=none
q13 0 rule=projection_simplification,considered_count=9,applied_count=1,candidates=rule=projection_simplification,candidate_node_id=n11,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n7,replacement_node_id=n6,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n12,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n9,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n3,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q13 0 rule=count_non_null_column_pruning,considered_count=2,applied_count=1,candidates=rule=count_non_null_column_pruning,aggregate_node_id=n10,column=__algeon_native_aggregate_arg_0,source_node_id=none,file_column_index=none,applied=false,rejected_reason=UnsupportedInputLineage|rule=count_non_null_column_pruning,aggregate_node_id=n4,column=o_orderkey,source_node_id=n1,file_column_index=0,applied=true,rejected_reason=none
q13 0 rule=shared_subplan_materialization,considered_count=3,candidate_count=0,applied_count=0,candidates=none
q13 0 rule=dynamic_filter_route_discovery,considered_count=1,route_count=0,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n5,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n4,consumer_input_node_id=n0,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape
q13 0 rule=aggregate_join_pushdown,considered_count=2,applied_count=1,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n5,join_node_id=n4,applied=true,rejected_reason=none|rule=aggregate_join_pushdown,aggregate_node_id=n8,join_node_id=none,applied=false,rejected_reason=InputNotJoin
q14 0 rule=projection_simplification,considered_count=8,applied_count=0,candidates=rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n5,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n5,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q14 0 rule=join_build_side_selection,considered_count=1,applied_count=0,candidates=rule=join_build_side_selection,candidate_node_id=n4,before_build_side=right,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=224,right_estimated_bytes=163,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide
q14 0 rule=dimension_derived_row_group_pruning,considered_count=2,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n0,target_source_node_id=n3,dimension_key_column=l_partkey,target_key_column=p_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n3,target_source_node_id=n0,dimension_key_column=p_partkey,target_key_column=l_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent
q14 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q14 0 rule=dynamic_filter_route_discovery,considered_count=1,route_count=1,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n4,dynamic_filter_id=df0,producer_build_side=right,producer_input_node_id=n3,consumer_input_node_id=n2,consumer_kind=local_parquet_source,consumer_node_id=n0,consumer_source_node_id=n0,producer_key_column=p_partkey,consumer_key_column=l_partkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=224,total_source_bytes=224,routed=true,rejected_reason=none
q14 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n7,join_node_id=n6,applied=false,rejected_reason=UnsupportedSidePattern
q15 0 rule=projection_simplification,considered_count=8,applied_count=3,candidates=rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=n5,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n9,replacement_node_id=n7,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=n9,applied=true,rejected_reason=none
q15 0 rule=join_build_side_selection,considered_count=2,applied_count=0,candidates=rule=join_build_side_selection,candidate_node_id=n7,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=1,left_estimated_bytes=none,right_estimated_bytes=none,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n9,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=357,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide
q15 0 rule=join_filter_reassociation,considered_count=2,applied_count=1,candidates=rule=join_filter_reassociation,candidate_node_id=n9,crossed_join_node_id=n6,filtered_child_node_id=n4,filtering_node_id=n8,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n7,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape
q15 0 rule=dimension_derived_row_group_pruning,considered_count=4,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=none,target_source_node_id=none,dimension_key_column=none,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionKeyLineageUnavailable|rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=none,target_source_node_id=none,dimension_key_column=none,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionKeyLineageUnavailable|rule=dimension_derived_row_group_pruning,candidate_node_id=n9,dimension_source_node_id=none,target_source_node_id=none,dimension_key_column=none,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionKeyLineageUnavailable|rule=dimension_derived_row_group_pruning,candidate_node_id=n9,dimension_source_node_id=n8,target_source_node_id=none,dimension_key_column=s_suppkey,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetKeyLineageUnavailable
q15 0 rule=shared_subplan_materialization,considered_count=1,candidate_count=0,applied_count=0,candidates=none
q15 0 rule=dynamic_filter_route_discovery,considered_count=2,route_count=0,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n7,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n6,consumer_input_node_id=n4,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=max(revenue.total_revenue),consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=ProducerKeyLineageUnavailable|rule=dynamic_filter_route_discovery,candidate_node_id=n9,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n8,consumer_input_node_id=n7,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=n0,producer_key_column=s_suppkey,consumer_key_column=l_suppkey,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=224,total_source_bytes=224,routed=false,rejected_reason=ConsumerSourceReusedInPlan
q15 0 rule=aggregate_join_pushdown,considered_count=2,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n3,join_node_id=none,applied=false,rejected_reason=InputNotJoin|rule=aggregate_join_pushdown,aggregate_node_id=n5,join_node_id=none,applied=false,rejected_reason=InputNotJoin
q16 0 rule=projection_simplification,considered_count=4,applied_count=0,candidates=rule=projection_simplification,candidate_node_id=n11,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n11,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q16 0 rule=join_build_side_selection,considered_count=1,applied_count=0,candidates=rule=join_build_side_selection,candidate_node_id=n3,before_build_side=right,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=281,right_estimated_bytes=118,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide
q16 0 rule=dimension_derived_row_group_pruning,considered_count=2,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n3,dimension_source_node_id=n0,target_source_node_id=n2,dimension_key_column=p_partkey,target_key_column=ps_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n3,dimension_source_node_id=n2,target_source_node_id=n0,dimension_key_column=ps_partkey,target_key_column=p_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent
q16 0 rule=count_non_null_column_pruning,considered_count=1,applied_count=0,candidates=rule=count_non_null_column_pruning,aggregate_node_id=n9,column=alias1,source_node_id=none,file_column_index=none,applied=false,rejected_reason=UnsupportedInputLineage
q16 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q16 0 rule=dynamic_filter_route_discovery,considered_count=2,route_count=1,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n3,dynamic_filter_id=df0,producer_build_side=right,producer_input_node_id=n2,consumer_input_node_id=n1,consumer_kind=local_parquet_source,consumer_node_id=n0,consumer_source_node_id=n0,producer_key_column=ps_partkey,consumer_key_column=p_partkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=281,total_source_bytes=281,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n7,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n6,consumer_input_node_id=n3,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape
q16 0 rule=aggregate_join_pushdown,considered_count=2,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n8,join_node_id=n7,applied=false,rejected_reason=UnsupportedJoinType|rule=aggregate_join_pushdown,aggregate_node_id=n9,join_node_id=none,applied=false,rejected_reason=InputNotJoin
q17 0 rule=projection_simplification,considered_count=9,applied_count=1,candidates=rule=projection_simplification,candidate_node_id=n12,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n9,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=n3,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n11,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n5,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q17 0 rule=semijoin_reduction,considered_count=1,applied_count=0,candidates=rule=semijoin_reduction,candidate_node_id=n9,before_root_node_id=n9,after_root_node_id=none,crossed_join_node_ids=none,target_subtree_id=none,key_mappings=none,cost_threshold_multiplier=8,cost_gate=none,applied=false,rejected_reason=UnsupportedLeftShape
q17 0 rule=join_build_side_selection,considered_count=2,applied_count=0,candidates=rule=join_build_side_selection,candidate_node_id=n4,before_build_side=right,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=198,right_estimated_bytes=177,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n9,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=none,left_estimated_bytes=none,right_estimated_bytes=none,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=grouped_aggregate_keyset,applied=false,rejected_reason=NoBetterBuildSide
q17 0 rule=dimension_derived_row_group_pruning,considered_count=2,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n0,target_source_node_id=n3,dimension_key_column=p_partkey,target_key_column=l_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n3,target_source_node_id=n0,dimension_key_column=l_partkey,target_key_column=p_partkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent
q17 0 rule=local_parquet_source_reuse,considered_count=1,applied_count=0,candidates=rule=local_parquet_source_reuse,source_node_ids=n3+n6,reuse_count=2,stable_file_ids=local:<dataset>/lineitem.parquet:5023:mtime=<run>,superset_read_columns=l_partkey+l_quantity+l_extendedprice,branch_filter_count=0,max_variant_selected_bytes=524288000,applied=false,rejected_reason=UnsupportedSourceContract
q17 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q17 0 rule=dynamic_filter_route_discovery,considered_count=2,route_count=1,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n4,dynamic_filter_id=df0,producer_build_side=right,producer_input_node_id=n3,consumer_input_node_id=n2,consumer_kind=local_parquet_source,consumer_node_id=n0,consumer_source_node_id=n0,producer_key_column=l_partkey,consumer_key_column=p_partkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=198,total_source_bytes=198,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n9,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n8,consumer_input_node_id=n5,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape
q17 0 rule=aggregate_join_pushdown,considered_count=2,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n7,join_node_id=none,applied=false,rejected_reason=InputNotJoin|rule=aggregate_join_pushdown,aggregate_node_id=n10,join_node_id=n9,applied=false,rejected_reason=JoinResidualUnsupported
q18 0 rule=projection_simplification,considered_count=5,applied_count=1,candidates=rule=projection_simplification,candidate_node_id=n14,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=n1,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n3,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n5,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q18 0 rule=semijoin_reduction,considered_count=1,applied_count=1,candidates=rule=semijoin_reduction,candidate_node_id=n9,before_root_node_id=n9,after_root_node_id=n9,crossed_join_node_ids=n4+n2,target_subtree_id=n1,key_mappings=o_orderkey->o_orderkey@n1,cost_threshold_multiplier=8,cost_gate=signal=aggregate_keyset_shape,threshold_multiplier=8,accepted=true,applied=true,rejected_reason=none
q18 0 rule=join_build_side_selection,considered_count=4,applied_count=1,candidates=rule=join_build_side_selection,candidate_node_id=n7,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=162,right_estimated_bytes=224,left_advisory_rows=none,right_advisory_rows=1,left_advisory_bytes=none,right_advisory_bytes=87,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n9,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=118,left_advisory_rows=3,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n7,before_build_side=left,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=162,right_estimated_bytes=224,left_advisory_rows=none,right_advisory_rows=1,left_advisory_bytes=none,right_advisory_bytes=87,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n10,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=none,left_estimated_bytes=none,right_estimated_bytes=none,left_advisory_rows=3,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=grouped_aggregate_keyset,applied=false,rejected_reason=NoBetterBuildSide
q18 0 rule=dimension_derived_row_group_pruning,considered_count=4,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=n0,target_source_node_id=n1,dimension_key_column=c_custkey,target_key_column=o_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=n1,target_source_node_id=n0,dimension_key_column=o_custkey,target_key_column=c_custkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n10,dimension_source_node_id=n1,target_source_node_id=none,dimension_key_column=o_orderkey,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetKeyLineageUnavailable|rule=dimension_derived_row_group_pruning,candidate_node_id=n10,dimension_source_node_id=none,target_source_node_id=none,dimension_key_column=none,target_key_column=none,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionKeyLineageUnavailable
q18 0 rule=local_parquet_source_reuse,considered_count=1,applied_count=1,candidates=rule=local_parquet_source_reuse,source_node_ids=n2+n8,reuse_count=2,stable_file_ids=local:<dataset>/lineitem.parquet:5023:mtime=<run>,superset_read_columns=l_orderkey+l_quantity,branch_filter_count=0,max_variant_selected_bytes=524288000,applied=true,rejected_reason=none
q18 0 rule=shared_subplan_materialization,considered_count=3,candidate_count=0,applied_count=0,candidates=none
q18 0 rule=dynamic_filter_route_discovery,considered_count=3,route_count=2,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n6,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n5,consumer_input_node_id=n1,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape|rule=dynamic_filter_route_discovery,candidate_node_id=n7,dynamic_filter_id=df0,producer_build_side=left,producer_input_node_id=n0,consumer_input_node_id=n6,consumer_kind=local_parquet_source,consumer_node_id=n1,consumer_source_node_id=n1,producer_key_column=c_custkey,consumer_key_column=o_custkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=224,total_source_bytes=224,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n9,dynamic_filter_id=df1,producer_build_side=right,producer_input_node_id=n8,consumer_input_node_id=n7,consumer_kind=local_parquet_source,consumer_node_id=n1,consumer_source_node_id=n1,producer_key_column=l_orderkey,consumer_key_column=o_orderkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=224,total_source_bytes=224,routed=true,rejected_reason=none
q18 0 rule=aggregate_join_pushdown,considered_count=2,applied_count=1,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n3,join_node_id=none,applied=false,rejected_reason=InputNotJoin|rule=aggregate_join_pushdown,aggregate_node_id=n10,join_node_id=n9,applied=true,rejected_reason=none
q19 0 rule=projection_simplification,considered_count=6,applied_count=0,candidates=rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n3,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q19 0 rule=join_build_side_selection,considered_count=1,applied_count=0,candidates=rule=join_build_side_selection,candidate_node_id=n7,before_build_side=right,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=379,right_estimated_bytes=245,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide
q19 0 rule=join_filter_reassociation,considered_count=2,applied_count=1,candidates=rule=join_filter_reassociation,candidate_node_id=n5,crossed_join_node_id=none,filtered_child_node_id=n0,filtering_node_id=n1,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n7,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=NoPushableResidualPredicate
q19 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q19 0 rule=dynamic_filter_route_discovery,considered_count=1,route_count=1,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n7,dynamic_filter_id=df0,producer_build_side=right,producer_input_node_id=n6,consumer_input_node_id=n3,consumer_kind=local_parquet_source,consumer_node_id=n0,consumer_source_node_id=n0,producer_key_column=p_partkey,consumer_key_column=l_partkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=379,total_source_bytes=379,routed=true,rejected_reason=none
q19 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n9,join_node_id=n8,applied=false,rejected_reason=JoinResidualUnsupported
q20 0 rule=projection_simplification,considered_count=8,applied_count=2,candidates=rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=n3,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=n5,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n15,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n8,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q20 0 rule=semijoin_reduction,considered_count=3,applied_count=0,candidates=rule=semijoin_reduction,candidate_node_id=n15,before_root_node_id=n15,after_root_node_id=none,crossed_join_node_ids=n4,target_subtree_id=n3,key_mappings=s_suppkey->s_suppkey@n3,cost_threshold_multiplier=8,cost_gate=signal=byte_estimate:semi_right_bytes=165:target_bytes=324,threshold_multiplier=8,accepted=false,applied=false,rejected_reason=CostGateRejected|rule=semijoin_reduction,candidate_node_id=n14,before_root_node_id=n14,after_root_node_id=none,crossed_join_node_ids=none,target_subtree_id=none,key_mappings=none,cost_threshold_multiplier=8,cost_gate=none,applied=false,rejected_reason=UnsupportedLeftShape|rule=semijoin_reduction,candidate_node_id=n9,before_root_node_id=n9,after_root_node_id=none,crossed_join_node_ids=none,target_subtree_id=n5,key_mappings=ps_partkey->ps_partkey@n5,cost_threshold_multiplier=8,cost_gate=none,applied=false,rejected_reason=UnsupportedLeftShape
q20 0 rule=join_build_side_selection,considered_count=2,applied_count=2,candidates=rule=join_build_side_selection,candidate_node_id=n4,before_build_side=right,after_build_side=left,left_estimated_rows=5,right_estimated_rows=3,left_estimated_bytes=164,right_estimated_bytes=324,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=true,rejected_reason=none|rule=join_build_side_selection,candidate_node_id=n14,before_build_side=right,after_build_side=left,left_estimated_rows=3,right_estimated_rows=none,left_estimated_bytes=165,right_estimated_bytes=none,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=20,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_other_side,applied=true,rejected_reason=none
q20 0 rule=join_filter_reassociation,considered_count=1,applied_count=0,candidates=rule=join_filter_reassociation,candidate_node_id=n4,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=UnsupportedPreservedInputShape
q20 0 rule=dimension_derived_row_group_pruning,considered_count=2,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n0,target_source_node_id=n3,dimension_key_column=n_nationkey,target_key_column=s_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n4,dimension_source_node_id=n3,target_source_node_id=n0,dimension_key_column=s_nationkey,target_key_column=n_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent
q20 0 rule=shared_subplan_materialization,considered_count=1,candidate_count=0,applied_count=0,candidates=none
q20 0 rule=dynamic_filter_route_discovery,considered_count=4,route_count=1,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n4,dynamic_filter_id=df0,producer_build_side=left,producer_input_node_id=n2,consumer_input_node_id=n3,consumer_kind=local_parquet_source,consumer_node_id=n3,consumer_source_node_id=n3,producer_key_column=n_nationkey,consumer_key_column=s_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=324,total_source_bytes=324,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n9,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n8,consumer_input_node_id=n5,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape|rule=dynamic_filter_route_discovery,candidate_node_id=n14,dynamic_filter_id=none,producer_build_side=left,producer_input_node_id=n9,consumer_input_node_id=n13,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape|rule=dynamic_filter_route_discovery,candidate_node_id=n15,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n14,consumer_input_node_id=n4,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape
q20 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n12,join_node_id=none,applied=false,rejected_reason=InputNotJoin
q21 0 rule=projection_simplification,considered_count=12,applied_count=1,candidates=rule=projection_simplification,candidate_node_id=n21,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n17,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n5,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n7,replacement_node_id=n3,applied=true,rejected_reason=none|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n12,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n21,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n17,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n6,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n2,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n11,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q21 0 rule=semijoin_reduction,considered_count=1,applied_count=0,candidates=rule=semijoin_reduction,candidate_node_id=n14,before_root_node_id=n14,after_root_node_id=none,crossed_join_node_ids=none,target_subtree_id=none,key_mappings=none,cost_threshold_multiplier=8,cost_gate=none,applied=false,rejected_reason=UnsupportedLeftShape
q21 0 rule=join_build_side_selection,considered_count=5,applied_count=0,candidates=rule=join_build_side_selection,candidate_node_id=n7,before_build_side=right,after_build_side=none,left_estimated_rows=3,right_estimated_rows=3,left_estimated_bytes=221,right_estimated_bytes=212,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=conservative_bytes,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n8,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=5,left_estimated_bytes=none,right_estimated_bytes=164,left_advisory_rows=3,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n12,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=103,left_advisory_rows=none,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n15,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=118,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=none,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide|rule=join_build_side_selection,candidate_node_id=n16,before_build_side=right,after_build_side=none,left_estimated_rows=none,right_estimated_rows=3,left_estimated_bytes=none,right_estimated_bytes=212,left_advisory_rows=1,right_advisory_rows=none,left_advisory_bytes=151,right_advisory_bytes=none,small_build_side_bytes=67108864,small_build_side_rows=1000000,selection_basis=small_current_side,applied=false,rejected_reason=NoBetterBuildSide
q21 0 rule=join_filter_reassociation,considered_count=21,applied_count=21,candidates=rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none|rule=join_filter_reassociation,candidate_node_id=n12,crossed_join_node_id=n8,filtered_child_node_id=n7,filtering_node_id=n11,applied=true,rejected_reason=none
q21 0 rule=dimension_derived_row_group_pruning,considered_count=6,applied_count=0,candidates=rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=n3,target_source_node_id=n4,dimension_key_column=s_suppkey,target_key_column=l_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetLineageReusedInPlan|rule=dimension_derived_row_group_pruning,candidate_node_id=n7,dimension_source_node_id=n4,target_source_node_id=n3,dimension_key_column=l_suppkey,target_key_column=s_suppkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n8,dimension_source_node_id=n3,target_source_node_id=n0,dimension_key_column=s_nationkey,target_key_column=n_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n8,dimension_source_node_id=n0,target_source_node_id=n3,dimension_key_column=n_nationkey,target_key_column=s_nationkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n12,dimension_source_node_id=n4,target_source_node_id=n9,dimension_key_column=l_orderkey,target_key_column=o_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=DimensionPredicateAbsent|rule=dimension_derived_row_group_pruning,candidate_node_id=n12,dimension_source_node_id=n9,target_source_node_id=n4,dimension_key_column=o_orderkey,target_key_column=l_orderkey,derived_min_key=none,derived_max_key=none,selected_row_groups_before=none,selected_row_groups_after=none,max_dimension_rows=1000000,applied=false,rejected_reason=TargetLineageReusedInPlan
q21 0 rule=local_parquet_source_reuse,considered_count=1,applied_count=0,candidates=rule=local_parquet_source_reuse,source_node_ids=n4+n14,reuse_count=2,stable_file_ids=local:<dataset>/lineitem.parquet:5023:mtime=<run>,superset_read_columns=l_orderkey+l_suppkey+l_commitdate+l_receiptdate,branch_filter_count=0,max_variant_selected_bytes=524288000,applied=false,rejected_reason=UnsupportedSourceContract
q21 0 rule=count_non_null_column_pruning,considered_count=1,applied_count=0,candidates=rule=count_non_null_column_pruning,aggregate_node_id=n18,column=__algeon_native_aggregate_arg_0,source_node_id=none,file_column_index=none,applied=false,rejected_reason=UnsupportedInputLineage
q21 0 rule=shared_subplan_materialization,considered_count=1,candidate_count=0,applied_count=0,candidates=none
q21 0 rule=dynamic_filter_route_discovery,considered_count=5,route_count=2,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n7,dynamic_filter_id=df0,producer_build_side=right,producer_input_node_id=n6,consumer_input_node_id=n3,consumer_kind=local_parquet_source,consumer_node_id=n3,consumer_source_node_id=n3,producer_key_column=l_suppkey,consumer_key_column=s_suppkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=221,total_source_bytes=221,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n8,dynamic_filter_id=df1,producer_build_side=right,producer_input_node_id=n2,consumer_input_node_id=n7,consumer_kind=local_parquet_source,consumer_node_id=n3,consumer_source_node_id=n3,producer_key_column=n_nationkey,consumer_key_column=s_nationkey,filter_kinds=range+small_in_list+hash_set_contains,consumer_lowering=reader_predicate,consumer_reduction_stage=source_reader,selected_source_bytes=221,total_source_bytes=221,routed=true,rejected_reason=none|rule=dynamic_filter_route_discovery,candidate_node_id=n12,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n11,consumer_input_node_id=n8,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=n4,producer_key_column=o_orderkey,consumer_key_column=l_orderkey,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=212,total_source_bytes=212,routed=false,rejected_reason=ConsumerSourceReusedInPlan|rule=dynamic_filter_route_discovery,candidate_node_id=n15,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n14,consumer_input_node_id=n13,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape|rule=dynamic_filter_route_discovery,candidate_node_id=n16,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n6,consumer_input_node_id=n15,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape
q21 0 rule=aggregate_join_pushdown,considered_count=1,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n18,join_node_id=n17,applied=false,rejected_reason=JoinResidualUnsupported
q22 0 rule=projection_simplification,considered_count=8,applied_count=0,candidates=rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n9,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n13,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n10,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n9,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch|rule=projection_simplification,candidate_node_id=n4,replacement_node_id=none,applied=false,rejected_reason=SchemaMismatch
q22 0 rule=join_filter_reassociation,considered_count=1,applied_count=0,candidates=rule=join_filter_reassociation,candidate_node_id=n8,crossed_join_node_id=none,filtered_child_node_id=none,filtering_node_id=none,applied=false,rejected_reason=NoPushableResidualPredicate
q22 0 rule=local_parquet_source_reuse,considered_count=1,applied_count=0,candidates=rule=local_parquet_source_reuse,source_node_ids=n0+n5,reuse_count=2,stable_file_ids=local:<dataset>/customer.parquet:2827:mtime=<run>,superset_read_columns=c_custkey+c_phone+c_acctbal,branch_filter_count=0,max_variant_selected_bytes=524288000,applied=false,rejected_reason=UnsupportedSourceContract
q22 0 rule=count_non_null_column_pruning,considered_count=1,applied_count=0,candidates=rule=count_non_null_column_pruning,aggregate_node_id=n11,column=__algeon_native_aggregate_arg_0,source_node_id=none,file_column_index=none,applied=false,rejected_reason=UnsupportedInputLineage
q22 0 rule=shared_subplan_materialization,considered_count=2,candidate_count=0,applied_count=0,candidates=none
q22 0 rule=dynamic_filter_route_discovery,considered_count=2,route_count=0,candidates=rule=dynamic_filter_route_discovery,candidate_node_id=n3,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n2,consumer_input_node_id=n1,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape|rule=dynamic_filter_route_discovery,candidate_node_id=n8,dynamic_filter_id=none,producer_build_side=right,producer_input_node_id=n7,consumer_input_node_id=n4,consumer_kind=none,consumer_node_id=none,consumer_source_node_id=none,producer_key_column=none,consumer_key_column=none,filter_kinds=none,consumer_lowering=none,consumer_reduction_stage=none,selected_source_bytes=none,total_source_bytes=none,routed=false,rejected_reason=UnsupportedJoinShape
q22 0 rule=aggregate_join_pushdown,considered_count=2,applied_count=0,candidates=rule=aggregate_join_pushdown,aggregate_node_id=n7,join_node_id=none,applied=false,rejected_reason=InputNotJoin|rule=aggregate_join_pushdown,aggregate_node_id=n11,join_node_id=n10,applied=false,rejected_reason=JoinResidualUnsupported