2 -----------------------------------------------------------------------------------------------
3 Aggregate (cost=xxx rows=1 width=4)
4 -> Nested Loop (cost=xxx rows=1 width=4)
5 Join Filter: (t1.c1 = t4.c1)
6 -> Nested Loop (cost=xxx rows=1 width=12)
7 Join Filter: (t1.c1 = t3.c1)
8 -> Merge Join (cost=xxx rows=1 width=8)
9 Merge Cond: (t1.c1 = t2.c1)
10 -> Nested Loop (cost=xxx rows=6 width=4)
11 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=4)
12 Filter: (ctid = '(1,1)'::tid)
13 -> Seq Scan on r3 (cost=xxx rows=6 width=0)
15 -> Sort (cost=xxx rows=1 width=4)
17 -> Seq Scan on t2 (cost=xxx rows=1 width=4)
18 Filter: (ctid = '(1,1)'::tid)
19 -> Tid Scan on t3 (cost=xxx rows=1 width=4)
20 TID Cond: (ctid = '(1,1)'::tid)
21 -> Tid Scan on t4 (cost=xxx rows=1 width=4)
22 TID Cond: (ctid = '(1,1)'::tid)
24 Aggregate (cost=xxx rows=1 width=4)
25 -> Nested Loop (cost=xxx rows=1 width=4)
26 Join Filter: (t1.c1 = t4.c1)
27 -> Nested Loop (cost=xxx rows=1 width=12)
28 Join Filter: (t1.c1 = t3.c1)
29 -> Merge Join (cost=xxx rows=1 width=8)
30 Merge Cond: (t1.c1 = t2.c1)
31 -> Nested Loop (cost=xxx rows=6 width=4)
32 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=4)
33 Filter: (ctid = '(1,1)'::tid)
34 -> Seq Scan on r3 (cost=xxx rows=6 width=0)
36 -> Sort (cost=xxx rows=1 width=4)
38 -> Seq Scan on t2 (cost=xxx rows=1 width=4)
39 Filter: (ctid = '(1,1)'::tid)
40 -> Tid Scan on t3 (cost=xxx rows=1 width=4)
41 TID Cond: (ctid = '(1,1)'::tid)
42 -> Tid Scan on t4 (cost=xxx rows=1 width=4)
43 TID Cond: (ctid = '(1,1)'::tid)
45 Aggregate (cost=xxx rows=1 width=4)
46 -> Nested Loop (cost=xxx rows=1 width=4)
47 Join Filter: (t1.c1 = t4.c1)
48 -> Nested Loop (cost=xxx rows=1 width=12)
49 Join Filter: (t1.c1 = t3.c1)
50 -> Merge Join (cost=xxx rows=1 width=8)
51 Merge Cond: (t1.c1 = t2.c1)
52 -> Nested Loop (cost=xxx rows=6 width=4)
53 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=4)
54 Filter: (ctid = '(1,1)'::tid)
55 -> Seq Scan on r3 (cost=xxx rows=6 width=0)
57 -> Sort (cost=xxx rows=1 width=4)
59 -> Seq Scan on t2 (cost=xxx rows=1 width=4)
60 Filter: (ctid = '(1,1)'::tid)
61 -> Tid Scan on t3 (cost=xxx rows=1 width=4)
62 TID Cond: (ctid = '(1,1)'::tid)
63 -> Tid Scan on t4 (cost=xxx rows=1 width=4)
64 TID Cond: (ctid = '(1,1)'::tid)
68 ---------------------------------------------------------------------------------
69 Aggregate (cost=xxx rows=1 width=4)
70 -> Nested Loop (cost=xxx rows=2 width=4)
71 Join Filter: (t1.c1 = t4.c1)
72 -> Tid Scan on t4 (cost=xxx rows=1 width=4)
73 TID Cond: (ctid = '(1,1)'::tid)
74 -> Nested Loop (cost=xxx rows=2 width=12)
75 Join Filter: (t1.c1 = t3.c1)
76 -> Tid Scan on t3 (cost=xxx rows=1 width=4)
77 TID Cond: (ctid = '(1,1)'::tid)
78 -> Nested Loop (cost=xxx rows=2 width=8)
79 Join Filter: (t1.c1 = t2.c1)
80 -> Seq Scan on t2 (cost=xxx rows=1 width=4)
81 Filter: (ctid = '(1,1)'::tid)
82 -> Nested Loop (cost=xxx rows=2 width=4)
83 -> Tid Scan on t1 (cost=xxx rows=1 width=4)
84 TID Cond: (ctid = '(1,1)'::tid)
85 -> Seq Scan on r3 (cost=xxx rows=6 width=0)
88 Aggregate (cost=xxx rows=1 width=4)
89 -> Nested Loop (cost=xxx rows=2 width=4)
90 Join Filter: (t1.c1 = t4.c1)
91 -> Tid Scan on t4 (cost=xxx rows=1 width=4)
92 TID Cond: (ctid = '(1,1)'::tid)
93 -> Nested Loop (cost=xxx rows=2 width=12)
94 Join Filter: (t1.c1 = t3.c1)
95 -> Tid Scan on t3 (cost=xxx rows=1 width=4)
96 TID Cond: (ctid = '(1,1)'::tid)
97 -> Nested Loop (cost=xxx rows=2 width=8)
98 Join Filter: (t1.c1 = t2.c1)
99 -> Seq Scan on t2 (cost=xxx rows=1 width=4)
100 Filter: (ctid = '(1,1)'::tid)
101 -> Nested Loop (cost=xxx rows=2 width=4)
102 -> Tid Scan on t1 (cost=xxx rows=1 width=4)
103 TID Cond: (ctid = '(1,1)'::tid)
104 -> Seq Scan on r3 (cost=xxx rows=6 width=0)
107 Aggregate (cost=xxx rows=1 width=4)
108 -> Nested Loop (cost=xxx rows=2 width=4)
109 Join Filter: (t1.c1 = t4.c1)
110 -> Tid Scan on t4 (cost=xxx rows=1 width=4)
111 TID Cond: (ctid = '(1,1)'::tid)
112 -> Nested Loop (cost=xxx rows=2 width=12)
113 Join Filter: (t1.c1 = t3.c1)
114 -> Tid Scan on t3 (cost=xxx rows=1 width=4)
115 TID Cond: (ctid = '(1,1)'::tid)
116 -> Nested Loop (cost=xxx rows=2 width=8)
117 Join Filter: (t1.c1 = t2.c1)
118 -> Seq Scan on t2 (cost=xxx rows=1 width=4)
119 Filter: (ctid = '(1,1)'::tid)
120 -> Nested Loop (cost=xxx rows=2 width=4)
121 -> Tid Scan on t1 (cost=xxx rows=1 width=4)
122 TID Cond: (ctid = '(1,1)'::tid)
123 -> Seq Scan on r3 (cost=xxx rows=6 width=0)
128 ----------------------------------------------------------------------------------------------------
129 Aggregate (cost=xxx rows=1 width=4)
130 -> Nested Loop (cost=xxx rows=1 width=4)
131 Join Filter: (b1t1.c1 = b1t4.c1)
132 -> Nested Loop (cost=xxx rows=1 width=12)
133 Join Filter: (b1t1.c1 = b1t3.c1)
134 -> Merge Join (cost=xxx rows=1 width=8)
135 Merge Cond: (b1t1.c1 = b1t2.c1)
136 -> Nested Loop (cost=xxx rows=6 width=4)
137 -> Index Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1 width=4)
138 Filter: (ctid = '(1,1)'::tid)
139 -> Seq Scan on r3_ (cost=xxx rows=6 width=0)
141 -> Sort (cost=xxx rows=1 width=4)
143 -> Seq Scan on t2 b1t2 (cost=xxx rows=1 width=4)
144 Filter: (ctid = '(1,1)'::tid)
145 -> Tid Scan on t3 b1t3 (cost=xxx rows=1 width=4)
146 TID Cond: (ctid = '(1,1)'::tid)
147 -> Tid Scan on t4 b1t4 (cost=xxx rows=1 width=4)
148 TID Cond: (ctid = '(1,1)'::tid)
150 Aggregate (cost=xxx rows=1 width=4)
151 -> Nested Loop (cost=xxx rows=1 width=4)
152 Join Filter: (b2t1.c1 = b2t4.c1)
153 -> Nested Loop (cost=xxx rows=1 width=12)
154 Join Filter: (b2t1.c1 = b2t3.c1)
155 -> Merge Join (cost=xxx rows=1 width=8)
156 Merge Cond: (b2t1.c1 = b2t2.c1)
157 -> Nested Loop (cost=xxx rows=6 width=4)
158 -> Index Scan using t1_i1 on t1 b2t1 (cost=xxx rows=1 width=4)
159 Filter: (ctid = '(1,1)'::tid)
160 -> Seq Scan on r3_ (cost=xxx rows=6 width=0)
162 -> Sort (cost=xxx rows=1 width=4)
164 -> Seq Scan on t2 b2t2 (cost=xxx rows=1 width=4)
165 Filter: (ctid = '(1,1)'::tid)
166 -> Tid Scan on t3 b2t3 (cost=xxx rows=1 width=4)
167 TID Cond: (ctid = '(1,1)'::tid)
168 -> Tid Scan on t4 b2t4 (cost=xxx rows=1 width=4)
169 TID Cond: (ctid = '(1,1)'::tid)
171 Aggregate (cost=xxx rows=1 width=4)
172 -> Nested Loop (cost=xxx rows=1 width=4)
173 Join Filter: (b3t1.c1 = b3t4.c1)
174 -> Nested Loop (cost=xxx rows=1 width=12)
175 Join Filter: (b3t1.c1 = b3t3.c1)
176 -> Merge Join (cost=xxx rows=1 width=8)
177 Merge Cond: (b3t1.c1 = b3t2.c1)
178 -> Nested Loop (cost=xxx rows=6 width=4)
179 -> Index Scan using t1_i1 on t1 b3t1 (cost=xxx rows=1 width=4)
180 Filter: (ctid = '(1,1)'::tid)
181 -> Seq Scan on r3_ (cost=xxx rows=6 width=0)
183 -> Sort (cost=xxx rows=1 width=4)
185 -> Seq Scan on t2 b3t2 (cost=xxx rows=1 width=4)
186 Filter: (ctid = '(1,1)'::tid)
187 -> Tid Scan on t3 b3t3 (cost=xxx rows=1 width=4)
188 TID Cond: (ctid = '(1,1)'::tid)
189 -> Tid Scan on t4 b3t4 (cost=xxx rows=1 width=4)
190 TID Cond: (ctid = '(1,1)'::tid)
194 -------------------------------------------------------------------------------------
195 Aggregate (cost=xxx rows=1 width=4)
196 -> Nested Loop (cost=xxx rows=2 width=4)
197 Join Filter: (b1t1.c1 = b1t4.c1)
198 -> Tid Scan on t4 b1t4 (cost=xxx rows=1 width=4)
199 TID Cond: (ctid = '(1,1)'::tid)
200 -> Nested Loop (cost=xxx rows=2 width=12)
201 Join Filter: (b1t1.c1 = b1t3.c1)
202 -> Tid Scan on t3 b1t3 (cost=xxx rows=1 width=4)
203 TID Cond: (ctid = '(1,1)'::tid)
204 -> Nested Loop (cost=xxx rows=2 width=8)
205 Join Filter: (b1t1.c1 = b1t2.c1)
206 -> Seq Scan on t2 b1t2 (cost=xxx rows=1 width=4)
207 Filter: (ctid = '(1,1)'::tid)
208 -> Nested Loop (cost=xxx rows=2 width=4)
209 -> Tid Scan on t1 b1t1 (cost=xxx rows=1 width=4)
210 TID Cond: (ctid = '(1,1)'::tid)
211 -> Seq Scan on r3_ (cost=xxx rows=6 width=0)
214 Aggregate (cost=xxx rows=1 width=4)
215 -> Nested Loop (cost=xxx rows=2 width=4)
216 Join Filter: (b2t1.c1 = b2t4.c1)
217 -> Tid Scan on t4 b2t4 (cost=xxx rows=1 width=4)
218 TID Cond: (ctid = '(1,1)'::tid)
219 -> Nested Loop (cost=xxx rows=2 width=12)
220 Join Filter: (b2t1.c1 = b2t3.c1)
221 -> Tid Scan on t3 b2t3 (cost=xxx rows=1 width=4)
222 TID Cond: (ctid = '(1,1)'::tid)
223 -> Nested Loop (cost=xxx rows=2 width=8)
224 Join Filter: (b2t1.c1 = b2t2.c1)
225 -> Seq Scan on t2 b2t2 (cost=xxx rows=1 width=4)
226 Filter: (ctid = '(1,1)'::tid)
227 -> Nested Loop (cost=xxx rows=2 width=4)
228 -> Tid Scan on t1 b2t1 (cost=xxx rows=1 width=4)
229 TID Cond: (ctid = '(1,1)'::tid)
230 -> Seq Scan on r3_ (cost=xxx rows=6 width=0)
233 Aggregate (cost=xxx rows=1 width=4)
234 -> Nested Loop (cost=xxx rows=2 width=4)
235 Join Filter: (b3t1.c1 = b3t4.c1)
236 -> Tid Scan on t4 b3t4 (cost=xxx rows=1 width=4)
237 TID Cond: (ctid = '(1,1)'::tid)
238 -> Nested Loop (cost=xxx rows=2 width=12)
239 Join Filter: (b3t1.c1 = b3t3.c1)
240 -> Tid Scan on t3 b3t3 (cost=xxx rows=1 width=4)
241 TID Cond: (ctid = '(1,1)'::tid)
242 -> Nested Loop (cost=xxx rows=2 width=8)
243 Join Filter: (b3t1.c1 = b3t2.c1)
244 -> Seq Scan on t2 b3t2 (cost=xxx rows=1 width=4)
245 Filter: (ctid = '(1,1)'::tid)
246 -> Nested Loop (cost=xxx rows=2 width=4)
247 -> Tid Scan on t1 b3t1 (cost=xxx rows=1 width=4)
248 TID Cond: (ctid = '(1,1)'::tid)
249 -> Seq Scan on r3_ (cost=xxx rows=6 width=0)