Hi,
just caught another InitPlan below Gather with the recent patches in
(master as of 4cc6a3f). Recipe below.
regards,
andreas
set max_parallel_workers_per_gather = 2;
set min_parallel_relation_size = 0;
set parallel_setup_cost = 0;
set parallel_tuple_cost = 0;
explain select 1 from public.quad_point_tbl as ref_0, lateral (select ref_0.p as c3, sample_0.d as c5
from public.nv_child_2010 as sample_0 left join public.mvtest_tvv as ref_1 on ('x'< (select
contypefrom pg_catalog.pg_constraint limit 1)) limit 82) as subq_0;
-- QUERY PLAN
-- --------------------------------------------------------------------------------------------------------
-- Gather (cost=0.19..13727.52 rows=902246 width=4)
-- Workers Planned: 2
-- -> Nested Loop (cost=0.19..13727.52 rows=902246 width=4)
-- -> Parallel Seq Scan on quad_point_tbl ref_0 (cost=0.00..105.85 rows=4585 width=16)
-- -> Limit (cost=0.19..1.33 rows=82 width=20)
-- InitPlan 1 (returns $0)
-- -> Limit (cost=0.00..0.19 rows=1 width=1)
-- -> Gather (cost=0.00..10.22 rows=54 width=1)
-- Workers Planned: 2
-- -> Parallel Seq Scan on pg_constraint (cost=0.00..10.22 rows=22 width=1)
-- -> Seq Scan on nv_child_2010 sample_0 (cost=0.00..35.50 rows=2550 width=20)