2023-01-20 23:23:17.984 UTC [94545:756] pg_regress/join LOG:  statement: set enable_parallel_hash = on;
2023-01-20 23:23:17.985 UTC [94545:757] pg_regress/join LOG:  statement: set parallel_leader_participation = off;
2023-01-20 23:23:17.986 UTC [94545:758] pg_regress/join LOG:  statement: set min_parallel_table_scan_size = 0;
2023-01-20 23:23:17.987 UTC [94545:759] pg_regress/join LOG:  statement: set parallel_setup_cost = 0;
2023-01-20 23:23:17.988 UTC [94545:760] pg_regress/join LOG:  statement: set parallel_tuple_cost = 0;
2023-01-20 23:23:17.988 UTC [94545:761] pg_regress/join LOG:  statement: set max_parallel_workers_per_gather = 2;
2023-01-20 23:23:17.989 UTC [94545:762] pg_regress/join LOG:  statement: set enable_material = off;
2023-01-20 23:23:17.990 UTC [94545:763] pg_regress/join LOG:  statement: set enable_mergejoin = off;
2023-01-20 23:23:17.991 UTC [94545:764] pg_regress/join LOG:  statement: set work_mem = '4MB';
2023-01-20 23:23:17.992 UTC [94545:765] pg_regress/join LOG:  statement: explain (costs off)
          select count(*) from join_foo
            left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
            on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
2023-01-20 23:23:17.994 UTC [94545:766] pg_regress/join LOG:  statement: select count(*) from join_foo
          left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
          on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
2023-01-20 23:23:18.125 UTC [94545:767] pg_regress/join LOG:  statement: select final > 1 as multibatch
          from hash_join_batches(
        $$
          select count(*) from join_foo
            left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
            on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
        $$);
2023-01-26 20:05:16.751 UTC [94545:768] pg_regress/join LOG:  statement: rollback to settings;