2 ------------------------------------------------------------------------------------------------
3 Nested Loop (cost=xxx rows=100 width=4)
4 Join Filter: (bmt1.c1 = bmt4.c1)
5 -> Merge Join (cost=xxx rows=100 width=12)
6 Merge Cond: (bmt1.c1 = bmt2.c1)
7 -> Merge Join (cost=xxx rows=1000 width=8)
8 Merge Cond: (bmt1.c1 = bmt3.c1)
9 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=1000 width=4)
10 -> Index Only Scan using t3_i1 on t3 bmt3 (cost=xxx rows=1100 width=4)
11 -> Sort (cost=xxx rows=100 width=4)
13 -> Seq Scan on t2 bmt2 (cost=xxx rows=100 width=4)
14 -> Index Only Scan using t4_i1 on t4 bmt4 (cost=xxx rows=1 width=4)
15 Index Cond: (c1 = bmt3.c1)
19 -----------------------------------------------------------------------------------------
20 Merge Join (cost=xxx rows=50 width=4)
21 Merge Cond: (bmt1.c1 = bmt2.c1)
22 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=1000 width=4)
23 -> Sort (cost=xxx rows=100 width=12)
25 -> Hash Join (cost=xxx rows=100 width=12)
26 Hash Cond: (bmt3.c1 = bmt2.c1)
27 -> Hash Join (cost=xxx rows=1100 width=8)
28 Hash Cond: (bmt3.c1 = bmt4.c1)
29 -> Seq Scan on t3 bmt3 (cost=xxx rows=1100 width=4)
30 -> Hash (cost=xxx rows=1100 width=4)
31 -> Seq Scan on t4 bmt4 (cost=xxx rows=1100 width=4)
32 -> Hash (cost=xxx rows=100 width=4)
33 -> Seq Scan on t2 bmt2 (cost=xxx rows=100 width=4)