BEGIN; BEGIN EXPLAIN select 100.00 * sum(case when p_type like 'PROMO%' then l_extendedprice * (1 - l_discount) else 0 end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue from lineitem, part where l_partkey = p_partkey and l_shipdate >= date '1993-09-01' and l_shipdate < cast(date '1993-09-01' + interval '1 month' as date); QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Aggregate (cost=11854957.78..11854957.79 rows=1 width=29) -> Remote Subquery Scan on all (datanode_1_1,datanode_2_1,datanode_3_1,datanode_4_1,datanode_5_1,datanode_6_1,datanode_7_1,datanode_8_1) (cost=1149392.04..11834851.62 rows=1148923 width=29) -> Aggregate (cost=1149392.04..11834851.62 rows=1 width=29) -> Hash Join (cost=1149392.04..11834851.62 rows=1148923 width=29) Hash Cond: (lineitem.l_partkey = part.p_partkey) -> Remote Subquery Scan on all (datanode_1_1,datanode_2_1,datanode_3_1,datanode_4_1,datanode_5_1,datanode_6_1,datanode_7_1,datanode_8_1) (cost=157531.82..10544418.63 rows=7419670 width=12) Distribute results by H: l_partkey -> Bitmap Heap Scan on lineitem (cost=157431.82..10418184.24 rows=7419670 width=12) Recheck Cond: ((l_shipdate >= '1993-09-01'::date) AND (l_shipdate < '1993-10-01'::date)) -> Bitmap Index Scan on lineitem_l_shipdate_l_suppkey__idx (cost=0.00..155576.90 rows=7419670 width=0) Index Cond: ((l_shipdate >= '1993-09-01'::date) AND (l_shipdate < '1993-10-01'::date)) -> Hash (cost=605241.10..605241.10 rows=20000010 width=25) -> Seq Scan on part (cost=0.00..605241.10 rows=20000010 width=25) (13 rows) COMMIT; COMMIT