expected/R_2-1-8.out

   1                                                      QUERY PLAN
   2 --------------------------------------------------------------------------------------------------------------------
   3  Aggregate  (cost=xxx rows=1 width=4)
   4    CTE c1
   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)
  16                                          Sort Key: b1t2.c1
  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    CTE c2
  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    CTE c3
  34      ->  Aggregate  (cost=xxx rows=1 width=4)
  35            ->  Nested Loop  (cost=xxx rows=100 width=4)
  36                  Join Filter: (b3t1.c1 = b3t3.c1)
  37                  ->  Hash Join  (cost=xxx rows=100 width=12)
  38                        Hash Cond: (b3t1.c1 = b3t2.c1)
  39                        ->  Merge Join  (cost=xxx rows=1000 width=8)
  40                              Merge Cond: (b3t1.c1 = b3t4.c1)
  41                              ->  Index Only Scan using t1_i1 on t1 b3t1  (cost=xxx rows=1000 width=4)
  42                              ->  Index Only Scan using t4_i1 on t4 b3t4  (cost=xxx rows=1100 width=4)
  43                        ->  Hash  (cost=xxx rows=100 width=4)
  44                              ->  Seq Scan on t2 b3t2  (cost=xxx rows=100 width=4)
  45                  ->  Index Only Scan using t3_i1 on t3 b3t3  (cost=xxx rows=1 width=4)
  46                        Index Cond: (c1 = b3t4.c1)
  47    ->  Nested Loop  (cost=xxx rows=1 width=4)
  48          Join Filter: (bmt1.c1 = bmt4.c1)
  49          ->  Hash Join  (cost=xxx rows=1 width=24)
  50                Hash Cond: (bmt3.c1 = bmt1.c1)
  51                ->  Seq Scan on t3 bmt3  (cost=xxx rows=1100 width=4)
  52                ->  Hash  (cost=xxx rows=1 width=20)
  53                      ->  Merge Join  (cost=xxx rows=1 width=20)
  54                            Merge Cond: (bmt1.c1 = bmt2.c1)
  55                            ->  Sort  (cost=xxx rows=1 width=16)
  56                                  Sort Key: bmt1.c1
  57                                  ->  Nested Loop  (cost=xxx rows=1 width=16)
  58                                        ->  Hash Join  (cost=xxx rows=1 width=12)
  59                                              Hash Cond: (c2.c1 = c1.c1)
  60                                              ->  Merge Join  (cost=xxx rows=1 width=8)
  61                                                    Merge Cond: (c2.c1 = c3.c1)
  62                                                    ->  Sort  (cost=xxx rows=1 width=4)
  63                                                          Sort Key: c2.c1
  64                                                          ->  CTE Scan on c2  (cost=xxx rows=1 width=4)
  65                                                    ->  Sort  (cost=xxx rows=1 width=4)
  66                                                          Sort Key: c3.c1
  67                                                          ->  CTE Scan on c3  (cost=xxx rows=1 width=4)
  68                                              ->  Hash  (cost=xxx rows=1 width=4)
  69                                                    ->  CTE Scan on c1  (cost=xxx rows=1 width=4)
  70                                        ->  Index Only Scan using t1_i1 on t1 bmt1  (cost=xxx rows=1 width=4)
  71                                              Index Cond: (c1 = c1.c1)
  72                            ->  Sort  (cost=xxx rows=100 width=4)
  73                                  Sort Key: bmt2.c1
  74                                  ->  Seq Scan on t2 bmt2  (cost=xxx rows=100 width=4)
  75          ->  Index Only Scan using t4_i1 on t4 bmt4  (cost=xxx rows=1 width=4)
  76                Index Cond: (c1 = bmt3.c1)
  77 (74 rows)
  78
  79                                                      QUERY PLAN
  80 --------------------------------------------------------------------------------------------------------------------
  81  Aggregate  (cost=xxx rows=1 width=4)
  82    CTE c1
  83      ->  Aggregate  (cost=xxx rows=1 width=4)
  84            ->  Nested Loop  (cost=xxx rows=1 width=4)
  85                  Join Filter: (b1t2.c1 = b1t1.c1)
  86                  ->  Hash Join  (cost=xxx rows=1 width=12)
  87                        Hash Cond: (b1t4.c1 = b1t2.c1)
  88                        ->  Seq Scan on t4 b1t4  (cost=xxx rows=1100 width=4)
  89                        ->  Hash  (cost=xxx rows=1 width=8)
  90                              ->  Merge Join  (cost=xxx rows=1 width=8)
  91                                    Merge Cond: (b1t3.c1 = b1t2.c1)
  92                                    ->  Index Only Scan using t3_i1 on t3 b1t3  (cost=xxx rows=1100 width=4)
  93                                    ->  Sort  (cost=xxx rows=100 width=4)
  94                                          Sort Key: b1t2.c1
  95                                          ->  Seq Scan on t2 b1t2  (cost=xxx rows=100 width=4)
  96                  ->  Index Only Scan using t1_i1 on t1 b1t1  (cost=xxx rows=1 width=4)
  97                        Index Cond: (c1 = b1t3.c1)
  98    CTE c2
  99      ->  Aggregate  (cost=xxx rows=1 width=4)
 100            ->  Nested Loop  (cost=xxx rows=1 width=4)
 101                  ->  Hash Join  (cost=xxx rows=1 width=12)
 102                        Hash Cond: (b2t1.c1 = b2t3.c1)
 103                        ->  Seq Scan on t1 b2t1  (cost=xxx rows=1000 width=4)
 104                        ->  Hash  (cost=xxx rows=1 width=8)
 105                              ->  Merge Join  (cost=xxx rows=1 width=8)
 106                                    Merge Cond: (b2t3.c1 = b2t4.c1)
 107                                    ->  Index Only Scan using t3_i1 on t3 b2t3  (cost=xxx rows=1100 width=4)
 108                                    ->  Index Only Scan using t4_i1 on t4 b2t4  (cost=xxx rows=1100 width=4)
 109                  ->  Index Only Scan using t2_i1 on t2 b2t2  (cost=xxx rows=1 width=4)
 110                        Index Cond: (c1 = b2t1.c1)
 111    CTE c3
 112      ->  Aggregate  (cost=xxx rows=1 width=4)
 113            ->  Nested Loop  (cost=xxx rows=1 width=4)
 114                  Join Filter: (b3t1.c1 = b3t3.c1)
 115                  ->  Hash Join  (cost=xxx rows=1 width=12)
 116                        Hash Cond: (b3t1.c1 = b3t2.c1)
 117                        ->  Merge Join  (cost=xxx rows=1 width=8)
 118                              Merge Cond: (b3t1.c1 = b3t4.c1)
 119                              ->  Index Only Scan using t1_i1 on t1 b3t1  (cost=xxx rows=1000 width=4)
 120                              ->  Index Only Scan using t4_i1 on t4 b3t4  (cost=xxx rows=1100 width=4)
 121                        ->  Hash  (cost=xxx rows=100 width=4)
 122                              ->  Seq Scan on t2 b3t2  (cost=xxx rows=100 width=4)
 123                  ->  Index Only Scan using t3_i1 on t3 b3t3  (cost=xxx rows=1 width=4)
 124                        Index Cond: (c1 = b3t4.c1)
 125    ->  Nested Loop  (cost=xxx rows=1 width=4)
 126          Join Filter: (bmt1.c1 = bmt4.c1)
 127          ->  Hash Join  (cost=xxx rows=1 width=24)
 128                Hash Cond: (bmt3.c1 = bmt1.c1)
 129                ->  Seq Scan on t3 bmt3  (cost=xxx rows=1100 width=4)
 130                ->  Hash  (cost=xxx rows=1 width=20)
 131                      ->  Merge Join  (cost=xxx rows=1 width=20)
 132                            Merge Cond: (bmt1.c1 = bmt2.c1)
 133                            ->  Sort  (cost=xxx rows=1 width=16)
 134                                  Sort Key: bmt1.c1
 135                                  ->  Nested Loop  (cost=xxx rows=1 width=16)
 136                                        ->  Hash Join  (cost=xxx rows=1 width=12)
 137                                              Hash Cond: (c2.c1 = c1.c1)
 138                                              ->  Merge Join  (cost=xxx rows=1 width=8)
 139                                                    Merge Cond: (c2.c1 = c3.c1)
 140                                                    ->  Sort  (cost=xxx rows=1 width=4)
 141                                                          Sort Key: c2.c1
 142                                                          ->  CTE Scan on c2  (cost=xxx rows=1 width=4)
 143                                                    ->  Sort  (cost=xxx rows=1 width=4)
 144                                                          Sort Key: c3.c1
 145                                                          ->  CTE Scan on c3  (cost=xxx rows=1 width=4)
 146                                              ->  Hash  (cost=xxx rows=1 width=4)
 147                                                    ->  CTE Scan on c1  (cost=xxx rows=1 width=4)
 148                                        ->  Index Only Scan using t1_i1 on t1 bmt1  (cost=xxx rows=1 width=4)
 149                                              Index Cond: (c1 = c1.c1)
 150                            ->  Sort  (cost=xxx rows=100 width=4)
 151                                  Sort Key: bmt2.c1
 152                                  ->  Seq Scan on t2 bmt2  (cost=xxx rows=100 width=4)
 153          ->  Index Only Scan using t4_i1 on t4 bmt4  (cost=xxx rows=1 width=4)
 154                Index Cond: (c1 = bmt3.c1)
 155 (74 rows)
 156