QUERY PLAN                                                                                                                           
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Gather
   Workers Planned: 2
   ->  Parallel Bitmap Heap Scan on part
         Recheck Cond: (((p_size <= 5) AND (p_size >= 1) AND (p_container = ANY ('{"SM CASE","SM BOX","SM PACK","SM PKG"}'::bpchar[]))) OR ((p_container = ANY ('{"MED BAG","MED BOX","MED PKG","MED PACK"}'::bpchar[])) AND (p_size <= 10) AND (p_size >= 1)))
         ->  BitmapOr
               ->  BitmapAnd
                     ->  Bitmap Index Scan on part_p_size_idx
                           Index Cond: ((p_size <= 5) AND (p_size >= 1))
                     ->  Bitmap Index Scan on part_p_container_p_brand_p_partkey_idx
                           Index Cond: (p_container = ANY ('{"SM CASE","SM BOX","SM PACK","SM PKG"}'::bpchar[]))
               ->  BitmapAnd
                     ->  Bitmap Index Scan on part_p_container_p_brand_p_partkey_idx
                           Index Cond: (p_container = ANY ('{"MED BAG","MED BOX","MED PKG","MED PACK"}'::bpchar[]))
                     ->  Bitmap Index Scan on part_p_size_idx
                           Index Cond: ((p_size <= 10) AND (p_size >= 1))
(15 rows)