plan-simple.txt
text/plain
Filename: plan-simple.txt
Type: text/plain
Part: 1
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)