2 ------------------------------------------------------------------------------------------------------------------
3 Merge Join (cost=xxx rows=10 width=4)
4 Merge Cond: (bmt1.c1 = bmt2.c1)
6 -> Merge Join (cost=xxx rows=100 width=4)
7 Merge Cond: (b1t1.c1 = b1t2.c1)
8 -> Index Only Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1000 width=4)
9 -> Sort (cost=xxx rows=100 width=12)
11 -> Nested Loop (cost=xxx rows=100 width=12)
12 -> Hash Join (cost=xxx rows=1100 width=8)
13 Hash Cond: (b1t3.c1 = b1t4.c1)
14 -> Seq Scan on t3 b1t3 (cost=xxx rows=1100 width=4)
15 -> Hash (cost=xxx rows=1100 width=4)
16 -> Seq Scan on t4 b1t4 (cost=xxx rows=1100 width=4)
17 -> Index Only Scan using t2_i1 on t2 b1t2 (cost=xxx rows=1 width=4)
18 Index Cond: (c1 = b1t3.c1)
19 InitPlan 2 (returns $3)
20 -> Merge Join (cost=xxx rows=100 width=4)
21 Merge Cond: (b2t1.c1 = b2t2.c1)
22 -> Index Only Scan using t1_i1 on t1 b2t1 (cost=xxx rows=1000 width=4)
23 -> Sort (cost=xxx rows=100 width=12)
25 -> Nested Loop (cost=xxx rows=100 width=12)
26 -> Hash Join (cost=xxx rows=1100 width=8)
27 Hash Cond: (b2t3.c1 = b2t4.c1)
28 -> Seq Scan on t3 b2t3 (cost=xxx rows=1100 width=4)
29 -> Hash (cost=xxx rows=1100 width=4)
30 -> Seq Scan on t4 b2t4 (cost=xxx rows=1100 width=4)
31 -> Index Only Scan using t2_i1 on t2 b2t2 (cost=xxx rows=1 width=4)
32 Index Cond: (c1 = b2t3.c1)
33 InitPlan 3 (returns $5)
34 -> Merge Join (cost=xxx rows=100 width=4)
35 Merge Cond: (b3t1.c1 = b3t2.c1)
36 -> Index Only Scan using t1_i1 on t1 b3t1 (cost=xxx rows=1000 width=4)
37 -> Sort (cost=xxx rows=100 width=12)
39 -> Nested Loop (cost=xxx rows=100 width=12)
40 -> Hash Join (cost=xxx rows=1100 width=8)
41 Hash Cond: (b3t3.c1 = b3t4.c1)
42 -> Seq Scan on t3 b3t3 (cost=xxx rows=1100 width=4)
43 -> Hash (cost=xxx rows=1100 width=4)
44 -> Seq Scan on t4 b3t4 (cost=xxx rows=1100 width=4)
45 -> Index Only Scan using t2_i1 on t2 b3t2 (cost=xxx rows=1 width=4)
46 Index Cond: (c1 = b3t3.c1)
47 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=999 width=4)
49 -> Sort (cost=xxx rows=100 width=16)
51 -> Nested Loop (cost=xxx rows=100 width=16)
52 -> Hash Join (cost=xxx rows=100 width=12)
53 Hash Cond: (bmt3.c1 = bmt4.c1)
54 -> Seq Scan on t3 bmt3 (cost=xxx rows=1100 width=4)
55 -> Hash (cost=xxx rows=100 width=8)
56 -> Merge Join (cost=xxx rows=100 width=8)
57 Merge Cond: (bmt4.c1 = c1.c1)
58 -> Index Only Scan using t4_i1 on t4 bmt4 (cost=xxx rows=1100 width=4)
59 -> Sort (cost=xxx rows=100 width=4)
61 -> CTE Scan on c1 (cost=xxx rows=100 width=4)
62 -> Index Only Scan using t2_i1 on t2 bmt2 (cost=xxx rows=1 width=4)
63 Index Cond: (c1 = bmt3.c1)
67 ------------------------------------------------------------------------------------------------------------------
68 Merge Join (cost=xxx rows=1 width=4)
69 Merge Cond: (bmt1.c1 = bmt2.c1)
71 -> Merge Join (cost=xxx rows=1 width=4)
72 Merge Cond: (b1t1.c1 = b1t2.c1)
73 -> Index Only Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1000 width=4)
74 -> Sort (cost=xxx rows=1 width=12)
76 -> Nested Loop (cost=xxx rows=1 width=12)
77 -> Hash Join (cost=xxx rows=1 width=8)
78 Hash Cond: (b1t3.c1 = b1t4.c1)
79 -> Seq Scan on t3 b1t3 (cost=xxx rows=1100 width=4)
80 -> Hash (cost=xxx rows=1100 width=4)
81 -> Seq Scan on t4 b1t4 (cost=xxx rows=1100 width=4)
82 -> Index Only Scan using t2_i1 on t2 b1t2 (cost=xxx rows=1 width=4)
83 Index Cond: (c1 = b1t3.c1)
84 InitPlan 2 (returns $3)
85 -> Merge Join (cost=xxx rows=1 width=4)
86 Merge Cond: (b2t1.c1 = b2t2.c1)
87 -> Index Only Scan using t1_i1 on t1 b2t1 (cost=xxx rows=1000 width=4)
88 -> Sort (cost=xxx rows=1 width=12)
90 -> Nested Loop (cost=xxx rows=1 width=12)
91 -> Hash Join (cost=xxx rows=1 width=8)
92 Hash Cond: (b2t3.c1 = b2t4.c1)
93 -> Seq Scan on t3 b2t3 (cost=xxx rows=1100 width=4)
94 -> Hash (cost=xxx rows=1100 width=4)
95 -> Seq Scan on t4 b2t4 (cost=xxx rows=1100 width=4)
96 -> Index Only Scan using t2_i1 on t2 b2t2 (cost=xxx rows=1 width=4)
97 Index Cond: (c1 = b2t3.c1)
98 InitPlan 3 (returns $5)
99 -> Merge Join (cost=xxx rows=1 width=4)
100 Merge Cond: (b3t1.c1 = b3t2.c1)
101 -> Index Only Scan using t1_i1 on t1 b3t1 (cost=xxx rows=1000 width=4)
102 -> Sort (cost=xxx rows=1 width=12)
104 -> Nested Loop (cost=xxx rows=1 width=12)
105 -> Hash Join (cost=xxx rows=1 width=8)
106 Hash Cond: (b3t3.c1 = b3t4.c1)
107 -> Seq Scan on t3 b3t3 (cost=xxx rows=1100 width=4)
108 -> Hash (cost=xxx rows=1100 width=4)
109 -> Seq Scan on t4 b3t4 (cost=xxx rows=1100 width=4)
110 -> Index Only Scan using t2_i1 on t2 b3t2 (cost=xxx rows=1 width=4)
111 Index Cond: (c1 = b3t3.c1)
112 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=999 width=4)
114 -> Sort (cost=xxx rows=1 width=16)
116 -> Nested Loop (cost=xxx rows=1 width=16)
117 -> Hash Join (cost=xxx rows=1 width=12)
118 Hash Cond: (bmt3.c1 = bmt4.c1)
119 -> Seq Scan on t3 bmt3 (cost=xxx rows=1100 width=4)
120 -> Hash (cost=xxx rows=1 width=8)
121 -> Merge Join (cost=xxx rows=1 width=8)
122 Merge Cond: (bmt4.c1 = c1.c1)
123 -> Index Only Scan using t4_i1 on t4 bmt4 (cost=xxx rows=1100 width=4)
124 -> Sort (cost=xxx rows=1 width=4)
126 -> CTE Scan on c1 (cost=xxx rows=1 width=4)
127 -> Index Only Scan using t2_i1 on t2 bmt2 (cost=xxx rows=1 width=4)
128 Index Cond: (c1 = bmt3.c1)