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-12-01' and l_shipdate < cast(date '1993-12-01' + interval '1 month' as date); QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Aggregate (cost=11995449.81..11995449.82 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=1155569.01..11974554.51 rows=1194017 width=29) -> Aggregate (cost=1155569.01..11974554.51 rows=1 width=29) -> Hash Join (cost=1155569.01..11974554.51 rows=1194017 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=163708.78..10677768.81 rows=7710886 width=12) Distribute results by H: l_partkey -> Bitmap Heap Scan on lineitem (cost=163608.78..10546583.75 rows=7710886 width=12) Recheck Cond: ((l_shipdate >= '1993-12-01'::date) AND (l_shipdate < '1994-01-01'::date)) -> Bitmap Index Scan on lineitem_l_shipdate_l_suppkey__idx (cost=0.00..161681.06 rows=7710886 width=0) Index Cond: ((l_shipdate >= '1993-12-01'::date) AND (l_shipdate < '1994-01-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