QUERY PLAN -------------------------------------------------------------------------------------------------------------------- Aggregate (cost=xxx rows=1 width=4) InitPlan 1 (returns $1) -> Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=100 width=4) Join Filter: (b1t2.c1 = b1t1.c1) -> Hash Join (cost=xxx rows=100 width=12) Hash Cond: (b1t4.c1 = b1t2.c1) -> Seq Scan on t4 b1t4 (cost=xxx rows=1100 width=4) -> Hash (cost=xxx rows=100 width=8) -> Merge Join (cost=xxx rows=100 width=8) Merge Cond: (b1t3.c1 = b1t2.c1) -> Index Only Scan using t3_i1 on t3 b1t3 (cost=xxx rows=1100 width=4) -> Sort (cost=xxx rows=100 width=4) Sort Key: b1t2.c1 -> Seq Scan on t2 b1t2 (cost=xxx rows=100 width=4) -> Index Only Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1 width=4) Index Cond: (c1 = b1t3.c1) InitPlan 2 (returns $3) -> Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=100 width=4) -> Hash Join (cost=xxx rows=1000 width=12) Hash Cond: (b2t3.c1 = b2t1.c1) -> Merge Join (cost=xxx rows=1100 width=8) Merge Cond: (b2t3.c1 = b2t4.c1) -> Index Only Scan using t3_i1 on t3 b2t3 (cost=xxx rows=1100 width=4) -> Index Only Scan using t4_i1 on t4 b2t4 (cost=xxx rows=1100 width=4) -> Hash (cost=xxx rows=1000 width=4) -> Seq Scan on t1 b2t1 (cost=xxx rows=1000 width=4) -> Index Only Scan using t2_i1 on t2 b2t2 (cost=xxx rows=1 width=4) Index Cond: (c1 = b2t1.c1) -> Nested Loop (cost=xxx rows=100 width=4) Join Filter: (bmt1.c1 = bmt4.c1) -> Hash Join (cost=xxx rows=100 width=12) Hash Cond: (bmt3.c1 = bmt1.c1) -> Seq Scan on t3 bmt3 (cost=xxx rows=1100 width=4) -> Hash (cost=xxx rows=100 width=8) -> Merge Join (cost=xxx rows=100 width=8) Merge Cond: (bmt1.c1 = bmt2.c1) -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=1000 width=4) -> Sort (cost=xxx rows=100 width=4) Sort Key: bmt2.c1 -> Seq Scan on t2 bmt2 (cost=xxx rows=100 width=4) -> Index Only Scan using t4_i1 on t4 bmt4 (cost=xxx rows=1 width=4) Index Cond: (c1 = bmt3.c1) (44 rows) QUERY PLAN -------------------------------------------------------------------------------------------------------------------- Aggregate (cost=xxx rows=1 width=4) InitPlan 1 (returns $1) -> Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=1 width=4) Join Filter: (b1t2.c1 = b1t1.c1) -> Hash Join (cost=xxx rows=1 width=12) Hash Cond: (b1t4.c1 = b1t2.c1) -> Seq Scan on t4 b1t4 (cost=xxx rows=1100 width=4) -> Hash (cost=xxx rows=1 width=8) -> Merge Join (cost=xxx rows=1 width=8) Merge Cond: (b1t3.c1 = b1t2.c1) -> Index Only Scan using t3_i1 on t3 b1t3 (cost=xxx rows=1100 width=4) -> Sort (cost=xxx rows=100 width=4) Sort Key: b1t2.c1 -> Seq Scan on t2 b1t2 (cost=xxx rows=100 width=4) -> Index Only Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1 width=4) Index Cond: (c1 = b1t3.c1) InitPlan 2 (returns $3) -> Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=1 width=4) -> Hash Join (cost=xxx rows=1 width=12) Hash Cond: (b2t1.c1 = b2t3.c1) -> Seq Scan on t1 b2t1 (cost=xxx rows=1000 width=4) -> Hash (cost=xxx rows=1 width=8) -> Merge Join (cost=xxx rows=1 width=8) Merge Cond: (b2t3.c1 = b2t4.c1) -> Index Only Scan using t3_i1 on t3 b2t3 (cost=xxx rows=1100 width=4) -> Index Only Scan using t4_i1 on t4 b2t4 (cost=xxx rows=1100 width=4) -> Index Only Scan using t2_i1 on t2 b2t2 (cost=xxx rows=1 width=4) Index Cond: (c1 = b2t1.c1) -> Nested Loop (cost=xxx rows=1 width=4) Join Filter: (bmt1.c1 = bmt4.c1) -> Hash Join (cost=xxx rows=1 width=12) Hash Cond: (bmt3.c1 = bmt1.c1) -> Seq Scan on t3 bmt3 (cost=xxx rows=1100 width=4) -> Hash (cost=xxx rows=1 width=8) -> Merge Join (cost=xxx rows=1 width=8) Merge Cond: (bmt1.c1 = bmt2.c1) -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=1000 width=4) -> Sort (cost=xxx rows=100 width=4) Sort Key: bmt2.c1 -> Seq Scan on t2 bmt2 (cost=xxx rows=100 width=4) -> Index Only Scan using t4_i1 on t4 bmt4 (cost=xxx rows=1 width=4) Index Cond: (c1 = bmt3.c1) (44 rows)