2 --------------------------------------------------------------------------------------------------------------------
3 Aggregate (cost=xxx rows=1 width=4)
4 InitPlan 1 (returns $1)
5 -> Aggregate (cost=xxx rows=1 width=4)
6 -> Nested Loop (cost=xxx rows=100 width=4)
7 Join Filter: (b1t2.c1 = b1t1.c1)
8 -> Hash Join (cost=xxx rows=100 width=12)
9 Hash Cond: (b1t4.c1 = b1t2.c1)
10 -> Seq Scan on t4 b1t4 (cost=xxx rows=1100 width=4)
11 -> Hash (cost=xxx rows=100 width=8)
12 -> Merge Join (cost=xxx rows=100 width=8)
13 Merge Cond: (b1t3.c1 = b1t2.c1)
14 -> Index Only Scan using t3_i1 on t3 b1t3 (cost=xxx rows=1100 width=4)
15 -> Sort (cost=xxx rows=100 width=4)
17 -> Seq Scan on t2 b1t2 (cost=xxx rows=100 width=4)
18 -> Index Only Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1 width=4)
19 Index Cond: (c1 = b1t3.c1)
20 InitPlan 2 (returns $3)
21 -> Aggregate (cost=xxx rows=1 width=4)
22 -> Nested Loop (cost=xxx rows=100 width=4)
23 -> Hash Join (cost=xxx rows=1000 width=12)
24 Hash Cond: (b2t3.c1 = b2t1.c1)
25 -> Merge Join (cost=xxx rows=1100 width=8)
26 Merge Cond: (b2t3.c1 = b2t4.c1)
27 -> Index Only Scan using t3_i1 on t3 b2t3 (cost=xxx rows=1100 width=4)
28 -> Index Only Scan using t4_i1 on t4 b2t4 (cost=xxx rows=1100 width=4)
29 -> Hash (cost=xxx rows=1000 width=4)
30 -> Seq Scan on t1 b2t1 (cost=xxx rows=1000 width=4)
31 -> Index Only Scan using t2_i1 on t2 b2t2 (cost=xxx rows=1 width=4)
32 Index Cond: (c1 = b2t1.c1)
33 -> Nested Loop (cost=xxx rows=100 width=4)
34 Join Filter: (bmt1.c1 = bmt4.c1)
35 -> Hash Join (cost=xxx rows=100 width=12)
36 Hash Cond: (bmt3.c1 = bmt1.c1)
37 -> Seq Scan on t3 bmt3 (cost=xxx rows=1100 width=4)
38 -> Hash (cost=xxx rows=100 width=8)
39 -> Merge Join (cost=xxx rows=100 width=8)
40 Merge Cond: (bmt1.c1 = bmt2.c1)
41 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=1000 width=4)
42 -> Sort (cost=xxx rows=100 width=4)
44 -> Seq Scan on t2 bmt2 (cost=xxx rows=100 width=4)
45 -> Index Only Scan using t4_i1 on t4 bmt4 (cost=xxx rows=1 width=4)
46 Index Cond: (c1 = bmt3.c1)
50 --------------------------------------------------------------------------------------------------------------------
51 Aggregate (cost=xxx rows=1 width=4)
52 InitPlan 1 (returns $1)
53 -> Aggregate (cost=xxx rows=1 width=4)
54 -> Nested Loop (cost=xxx rows=1 width=4)
55 Join Filter: (b1t2.c1 = b1t1.c1)
56 -> Hash Join (cost=xxx rows=1 width=12)
57 Hash Cond: (b1t4.c1 = b1t2.c1)
58 -> Seq Scan on t4 b1t4 (cost=xxx rows=1100 width=4)
59 -> Hash (cost=xxx rows=100 width=8)
60 -> Merge Join (cost=xxx rows=1 width=8)
61 Merge Cond: (b1t3.c1 = b1t2.c1)
62 -> Index Only Scan using t3_i1 on t3 b1t3 (cost=xxx rows=1100 width=4)
63 -> Sort (cost=xxx rows=100 width=4)
65 -> Seq Scan on t2 b1t2 (cost=xxx rows=100 width=4)
66 -> Index Only Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1 width=4)
67 Index Cond: (c1 = b1t3.c1)
68 InitPlan 2 (returns $3)
69 -> Aggregate (cost=xxx rows=1 width=4)
70 -> Nested Loop (cost=xxx rows=1 width=4)
71 -> Hash Join (cost=xxx rows=1 width=12)
72 Hash Cond: (b2t3.c1 = b2t1.c1)
73 -> Merge Join (cost=xxx rows=1 width=8)
74 Merge Cond: (b2t3.c1 = b2t4.c1)
75 -> Index Only Scan using t3_i1 on t3 b2t3 (cost=xxx rows=1100 width=4)
76 -> Index Only Scan using t4_i1 on t4 b2t4 (cost=xxx rows=1100 width=4)
77 -> Hash (cost=xxx rows=1000 width=4)
78 -> Seq Scan on t1 b2t1 (cost=xxx rows=1000 width=4)
79 -> Index Only Scan using t2_i1 on t2 b2t2 (cost=xxx rows=1 width=4)
80 Index Cond: (c1 = b2t1.c1)
81 -> Nested Loop (cost=xxx rows=1 width=4)
82 Join Filter: (bmt1.c1 = bmt4.c1)
83 -> Hash Join (cost=xxx rows=1 width=12)
84 Hash Cond: (bmt3.c1 = bmt1.c1)
85 -> Seq Scan on t3 bmt3 (cost=xxx rows=1100 width=4)
86 -> Hash (cost=xxx rows=100 width=8)
87 -> Merge Join (cost=xxx rows=1 width=8)
88 Merge Cond: (bmt1.c1 = bmt2.c1)
89 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=1000 width=4)
90 -> Sort (cost=xxx rows=100 width=4)
92 -> Seq Scan on t2 bmt2 (cost=xxx rows=100 width=4)
93 -> Index Only Scan using t4_i1 on t4 bmt4 (cost=xxx rows=1 width=4)
94 Index Cond: (c1 = bmt3.c1)