PLANTREE
(
   {PLANNEDSTMT 
   :commandType 1 
   :queryId 0 
   :hasReturning false 
   :hasModifyingCTE false 
   :canSetTag true 
   :transientPlan false 
   :planTree 
      {SUBQUERYSCAN 
      :startup_cost 620.67 
      :total_cost 640.30 
      :plan_rows 1570 
      :plan_width 16 
      :targetlist (
         {TARGETENTRY 
         :expr 
            {VAR 
            :varno 1 
            :varattno 1 
            :vartype 1042 
            :vartypmod 5 
            :varcollid 100 
            :varlevelsup 0 
            :varnoold 1 
            :varoattno 1 
            :location 7
            }
         :resno 1 
         :resname a 
         :ressortgroupref 0 
         :resorigtbl 16397 
         :resorigcol 2 
         :resjunk false
         }
         {TARGETENTRY 
         :expr 
            {VAR 
            :varno 1 
            :varattno 2 
            :vartype 1042 
            :vartypmod 5 
            :varcollid 100 
            :varlevelsup 0 
            :varnoold 1 
            :varoattno 2 
            :location 9
            }
         :resno 2 
         :resname b 
         :ressortgroupref 0 
         :resorigtbl 16397 
         :resorigcol 3 
         :resjunk false
         }
      )
      :qual <> 
      :lefttree <> 
      :righttree <> 
      :initPlan <> 
      :extParam (b)
      :allParam (b)
      :scanrelid 1 
      :subplan 
         {SORT 
         :startup_cost 620.67 
         :total_cost 624.60 
         :plan_rows 1570 
         :plan_width 40 
         :targetlist (
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 65001 
               :varattno 1 
               :vartype 1042 
               :vartypmod 5 
               :varcollid 100 
               :varlevelsup 0 
               :varnoold 2 
               :varoattno 1 
               :location -1
               }
            :resno 1 
            :resname a 
            :ressortgroupref 0 
            :resorigtbl 16397 
            :resorigcol 2 
            :resjunk false
            }
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 65001 
               :varattno 2 
               :vartype 1042 
               :vartypmod 5 
               :varcollid 100 
               :varlevelsup 0 
               :varnoold 2 
               :varoattno 2 
               :location -1
               }
            :resno 2 
            :resname b 
            :ressortgroupref 0 
            :resorigtbl 16397 
            :resorigcol 3 
            :resjunk false
            }
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 65001 
               :varattno 3 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 0 
               :varoattno 0 
               :location -1
               }
            :resno 3 
            :resname ts 
            :ressortgroupref 0 
            :resorigtbl 16397 
            :resorigcol 4 
            :resjunk false
            }
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 65001 
               :varattno 4 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 0 
               :varoattno 0 
               :location -1
               }
            :resno 4 
            :resname te 
            :ressortgroupref 0 
            :resorigtbl 16397 
            :resorigcol 5 
            :resjunk false
            }
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 65001 
               :varattno 5 
               :vartype 20 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 2 
               :varoattno 5 
               :location -1
               }
            :resno 5 
            :resname row_number 
            :ressortgroupref 1 
            :resorigtbl 0 
            :resorigcol 0 
            :resjunk false
            }
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 65001 
               :varattno 6 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 0 
               :varoattno 0 
               :location -1
               }
            :resno 6 
            :resname p1 
            :ressortgroupref 2 
            :resorigtbl 0 
            :resorigcol 0 
            :resjunk false
            }
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 65001 
               :varattno 7 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 0 
               :varoattno 0 
               :location -1
               }
            :resno 7 
            :resname p2 
            :ressortgroupref 3 
            :resorigtbl 0 
            :resorigcol 0 
            :resjunk false
            }
         )
         :qual <> 
         :lefttree 
            {MERGEJOIN 
            :startup_cost 262.58 
            :total_cost 537.33 
            :plan_rows 1570 
            :plan_width 40 
            :targetlist (
               {TARGETENTRY 
               :expr 
                  {VAR 
                  :varno 65001 
                  :varattno 1 
                  :vartype 1042 
                  :vartypmod 5 
                  :varcollid 100 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 1 
                  :location 24
                  }
               :resno 1 
               :resname a 
               :ressortgroupref 0 
               :resorigtbl 16397 
               :resorigcol 2 
               :resjunk false
               }
               {TARGETENTRY 
               :expr 
                  {VAR 
                  :varno 65001 
                  :varattno 2 
                  :vartype 1042 
                  :vartypmod 5 
                  :varcollid 100 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 2 
                  :location 24
                  }
               :resno 2 
               :resname b 
               :ressortgroupref 0 
               :resorigtbl 16397 
               :resorigcol 3 
               :resjunk false
               }
               {TARGETENTRY 
               :expr 
                  {CONST 
                  :consttype 23 
                  :consttypmod -1 
                  :constcollid 0 
                  :constlen 4 
                  :constbyval true 
                  :constisnull true 
                  :location -1 
                  :constvalue <>
                  }
               :resno 3 
               :resname ts 
               :ressortgroupref 0 
               :resorigtbl 16397 
               :resorigcol 4 
               :resjunk false
               }
               {TARGETENTRY 
               :expr 
                  {CONST 
                  :consttype 23 
                  :consttypmod -1 
                  :constcollid 0 
                  :constlen 4 
                  :constbyval true 
                  :constisnull true 
                  :location -1 
                  :constvalue <>
                  }
               :resno 4 
               :resname te 
               :ressortgroupref 0 
               :resorigtbl 16397 
               :resorigcol 5 
               :resjunk false
               }
               {TARGETENTRY 
               :expr 
                  {VAR 
                  :varno 65001 
                  :varattno 3 
                  :vartype 20 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 5 
                  :location 24
                  }
               :resno 5 
               :resname row_number 
               :ressortgroupref 1 
               :resorigtbl 0 
               :resorigcol 0 
               :resjunk false
               }
               {TARGETENTRY 
               :expr 
                  {MINMAX 
                  :minmaxtype 23 
                  :minmaxcollid 0 
                  :inputcollid 0 
                  :op 0 
                  :args (
                     {VAR 
                     :varno 65001 
                     :varattno 4 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 2 
                     :varoattno 3 
                     :location 38
                     }
                     {VAR 
                     :varno 65000 
                     :varattno 1 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 3 
                     :varoattno 3 
                     :location 44
                     }
                  )
                  :location 29
                  }
               :resno 6 
               :resname p1 
               :ressortgroupref 2 
               :resorigtbl 0 
               :resorigcol 0 
               :resjunk false
               }
               {TARGETENTRY 
               :expr 
                  {MINMAX 
                  :minmaxtype 23 
                  :minmaxcollid 0 
                  :inputcollid 0 
                  :op 1 
                  :args (
                     {VAR 
                     :varno 65001 
                     :varattno 5 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 2 
                     :varoattno 4 
                     :location 60
                     }
                     {VAR 
                     :varno 65000 
                     :varattno 2 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 3 
                     :varoattno 4 
                     :location 66
                     }
                  )
                  :location 54
                  }
               :resno 7 
               :resname p2 
               :ressortgroupref 3 
               :resorigtbl 0 
               :resorigcol 0 
               :resjunk false
               }
            )
            :qual <> 
            :lefttree 
               {SORT 
               :startup_cost 144.36 
               :total_cost 148.29 
               :plan_rows 1570 
               :plan_width 32 
               :targetlist (
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 65001 
                     :varattno 1 
                     :vartype 1042 
                     :vartypmod 5 
                     :varcollid 100 
                     :varlevelsup 0 
                     :varnoold 2 
                     :varoattno 1 
                     :location -1
                     }
                  :resno 1 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 65001 
                     :varattno 2 
                     :vartype 1042 
                     :vartypmod 5 
                     :varcollid 100 
                     :varlevelsup 0 
                     :varnoold 2 
                     :varoattno 2 
                     :location -1
                     }
                  :resno 2 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 65001 
                     :varattno 3 
                     :vartype 20 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 2 
                     :varoattno 5 
                     :location -1
                     }
                  :resno 3 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 65001 
                     :varattno 4 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 2 
                     :varoattno 3 
                     :location -1
                     }
                  :resno 4 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 65001 
                     :varattno 5 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 2 
                     :varoattno 4 
                     :location -1
                     }
                  :resno 5 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
               )
               :qual <> 
               :lefttree 
                  {SUBQUERYSCAN 
                  :startup_cost 0.00 
                  :total_cost 61.03 
                  :plan_rows 1570 
                  :plan_width 32 
                  :targetlist (
                     {TARGETENTRY 
                     :expr 
                        {VAR 
                        :varno 2 
                        :varattno 1 
                        :vartype 1042 
                        :vartypmod 5 
                        :varcollid 100 
                        :varlevelsup 0 
                        :varnoold 2 
                        :varoattno 1 
                        :location 24
                        }
                     :resno 1 
                     :resname <> 
                     :ressortgroupref 0 
                     :resorigtbl 0 
                     :resorigcol 0 
                     :resjunk false
                     }
                     {TARGETENTRY 
                     :expr 
                        {VAR 
                        :varno 2 
                        :varattno 2 
                        :vartype 1042 
                        :vartypmod 5 
                        :varcollid 100 
                        :varlevelsup 0 
                        :varnoold 2 
                        :varoattno 2 
                        :location 24
                        }
                     :resno 2 
                     :resname <> 
                     :ressortgroupref 0 
                     :resorigtbl 0 
                     :resorigcol 0 
                     :resjunk false
                     }
                     {TARGETENTRY 
                     :expr 
                        {VAR 
                        :varno 2 
                        :varattno 5 
                        :vartype 20 
                        :vartypmod -1 
                        :varcollid 0 
                        :varlevelsup 0 
                        :varnoold 2 
                        :varoattno 5 
                        :location 24
                        }
                     :resno 3 
                     :resname <> 
                     :ressortgroupref 0 
                     :resorigtbl 0 
                     :resorigcol 0 
                     :resjunk false
                     }
                     {TARGETENTRY 
                     :expr 
                        {VAR 
                        :varno 2 
                        :varattno 3 
                        :vartype 23 
                        :vartypmod -1 
                        :varcollid 0 
                        :varlevelsup 0 
                        :varnoold 2 
                        :varoattno 3 
                        :location 38
                        }
                     :resno 4 
                     :resname <> 
                     :ressortgroupref 0 
                     :resorigtbl 0 
                     :resorigcol 0 
                     :resjunk false
                     }
                     {TARGETENTRY 
                     :expr 
                        {VAR 
                        :varno 2 
                        :varattno 4 
                        :vartype 23 
                        :vartypmod -1 
                        :varcollid 0 
                        :varlevelsup 0 
                        :varnoold 2 
                        :varoattno 4 
                        :location 60
                        }
                     :resno 5 
                     :resname <> 
                     :ressortgroupref 0 
                     :resorigtbl 0 
                     :resorigcol 0 
                     :resjunk false
                     }
                  )
                  :qual <> 
                  :lefttree <> 
                  :righttree <> 
                  :initPlan <> 
                  :extParam (b)
                  :allParam (b)
                  :scanrelid 2 
                  :subplan 
                     {WINDOWAGG 
                     :startup_cost 0.00 
                     :total_cost 45.33 
                     :plan_rows 1570 
                     :plan_width 24 
                     :targetlist (
                        {TARGETENTRY 
                        :expr 
                           {VAR 
                           :varno 65001 
                           :varattno 1 
                           :vartype 1042 
                           :vartypmod 5 
                           :varcollid 100 
                           :varlevelsup 0 
                           :varnoold 5 
                           :varoattno 2 
                           :location 88
                           }
                        :resno 1 
                        :resname a 
                        :ressortgroupref 0 
                        :resorigtbl 16397 
                        :resorigcol 2 
                        :resjunk false
                        }
                        {TARGETENTRY 
                        :expr 
                           {VAR 
                           :varno 65001 
                           :varattno 2 
                           :vartype 1042 
                           :vartypmod 5 
                           :varcollid 100 
                           :varlevelsup 0 
                           :varnoold 5 
                           :varoattno 3 
                           :location 88
                           }
                        :resno 2 
                        :resname b 
                        :ressortgroupref 0 
                        :resorigtbl 16397 
                        :resorigcol 3 
                        :resjunk false
                        }
                        {TARGETENTRY 
                        :expr 
                           {VAR 
                           :varno 65001 
                           :varattno 3 
                           :vartype 23 
                           :vartypmod -1 
                           :varcollid 0 
                           :varlevelsup 0 
                           :varnoold 5 
                           :varoattno 4 
                           :location 88
                           }
                        :resno 3 
                        :resname ts 
                        :ressortgroupref 0 
                        :resorigtbl 16397 
                        :resorigcol 4 
                        :resjunk false
                        }
                        {TARGETENTRY 
                        :expr 
                           {VAR 
                           :varno 65001 
                           :varattno 4 
                           :vartype 23 
                           :vartypmod -1 
                           :varcollid 0 
                           :varlevelsup 0 
                           :varnoold 5 
                           :varoattno 5 
                           :location 88
                           }
                        :resno 4 
                        :resname te 
                        :ressortgroupref 0 
                        :resorigtbl 16397 
                        :resorigcol 5 
                        :resjunk false
                        }
                        {TARGETENTRY 
                        :expr 
                           {WINDOWFUNC 
                           :winfnoid 3100 
                           :wintype 20 
                           :wincollid 0 
                           :inputcollid 0 
                           :args <> 
                           :aggfilter <> 
                           :winref 1 
                           :winstar false 
                           :winagg false 
                           :location 91
                           }
                        :resno 5 
                        :resname row_number 
                        :ressortgroupref 0 
                        :resorigtbl 0 
                        :resorigcol 0 
                        :resjunk false
                        }
                     )
                     :qual <> 
                     :lefttree 
                        {SEQSCAN 
                        :startup_cost 0.00 
                        :total_cost 25.70 
                        :plan_rows 1570 
                        :plan_width 24 
                        :targetlist (
                           {TARGETENTRY 
                           :expr 
                              {VAR 
                              :varno 5 
                              :varattno 2 
                              :vartype 1042 
                              :vartypmod 5 
                              :varcollid 100 
                              :varlevelsup 0 
                              :varnoold 5 
                              :varoattno 2 
                              :location 88
                              }
                           :resno 1 
                           :resname <> 
                           :ressortgroupref 0 
                           :resorigtbl 0 
                           :resorigcol 0 
                           :resjunk false
                           }
                           {TARGETENTRY 
                           :expr 
                              {VAR 
                              :varno 5 
                              :varattno 3 
                              :vartype 1042 
                              :vartypmod 5 
                              :varcollid 100 
                              :varlevelsup 0 
                              :varnoold 5 
                              :varoattno 3 
                              :location 88
                              }
                           :resno 2 
                           :resname <> 
                           :ressortgroupref 0 
                           :resorigtbl 0 
                           :resorigcol 0 
                           :resjunk false
                           }
                           {TARGETENTRY 
                           :expr 
                              {VAR 
                              :varno 5 
                              :varattno 4 
                              :vartype 23 
                              :vartypmod -1 
                              :varcollid 0 
                              :varlevelsup 0 
                              :varnoold 5 
                              :varoattno 4 
                              :location 88
                              }
                           :resno 3 
                           :resname <> 
                           :ressortgroupref 0 
                           :resorigtbl 0 
                           :resorigcol 0 
                           :resjunk false
                           }
                           {TARGETENTRY 
                           :expr 
                              {VAR 
                              :varno 5 
                              :varattno 5 
                              :vartype 23 
                              :vartypmod -1 
                              :varcollid 0 
                              :varlevelsup 0 
                              :varnoold 5 
                              :varoattno 5 
                              :location 88
                              }
                           :resno 4 
                           :resname <> 
                           :ressortgroupref 0 
                           :resorigtbl 0 
                           :resorigcol 0 
                           :resjunk false
                           }
                        )
                        :qual <> 
                        :lefttree <> 
                        :righttree <> 
                        :initPlan <> 
                        :extParam (b)
                        :allParam (b)
                        :scanrelid 5
                        }
                     :righttree <> 
                     :initPlan <> 
                     :extParam (b)
                     :allParam (b)
                     :winref 1 
                     :partNumCols 0 
                     :partColIdx 
                     :partOperations 
                     :ordNumCols 0 
                     :ordColIdx 
                     :ordOperations 
                     :frameOptions 530 
                     :startOffset <> 
                     :endOffset <>
                     }
                  }
               :righttree <> 
               :initPlan <> 
               :extParam (b)
               :allParam (b)
               :numCols 1 
               :sortColIdx 2 
               :sortOperators 1058 
               :collations 100 
               :nullsFirst false
               }
            :righttree 
               {SORT 
               :startup_cost 118.22 
               :total_cost 122.47 
               :plan_rows 1700 
               :plan_width 16 
               :targetlist (
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 65001 
                     :varattno 1 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 3 
                     :varoattno 3 
                     :location -1
                     }
                  :resno 1 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 65001 
                     :varattno 2 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 3 
                     :varoattno 4 
                     :location -1
                     }
                  :resno 2 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 65001 
                     :varattno 3 
                     :vartype 1042 
                     :vartypmod 5 
                     :varcollid 100 
                     :varlevelsup 0 
                     :varnoold 3 
                     :varoattno 2 
                     :location -1
                     }
                  :resno 3 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
               )
               :qual <> 
               :lefttree 
                  {SEQSCAN 
                  :startup_cost 0.00 
                  :total_cost 27.00 
                  :plan_rows 1700 
                  :plan_width 16 
                  :targetlist (
                     {TARGETENTRY 
                     :expr 
                        {VAR 
                        :varno 3 
                        :varattno 3 
                        :vartype 23 
                        :vartypmod -1 
                        :varcollid 0 
                        :varlevelsup 0 
                        :varnoold 3 
                        :varoattno 3 
                        :location 44
                        }
                     :resno 1 
                     :resname <> 
                     :ressortgroupref 0 
                     :resorigtbl 0 
                     :resorigcol 0 
                     :resjunk false
                     }
                     {TARGETENTRY 
                     :expr 
                        {VAR 
                        :varno 3 
                        :varattno 4 
                        :vartype 23 
                        :vartypmod -1 
                        :varcollid 0 
                        :varlevelsup 0 
                        :varnoold 3 
                        :varoattno 4 
                        :location 66
                        }
                     :resno 2 
                     :resname <> 
                     :ressortgroupref 0 
                     :resorigtbl 0 
                     :resorigcol 0 
                     :resjunk false
                     }
                     {TARGETENTRY 
                     :expr 
                        {VAR 
                        :varno 3 
                        :varattno 2 
                        :vartype 1042 
                        :vartypmod 5 
                        :varcollid 100 
                        :varlevelsup 0 
                        :varnoold 3 
                        :varoattno 2 
                        :location 148
                        }
                     :resno 3 
                     :resname <> 
                     :ressortgroupref 0 
                     :resorigtbl 0 
                     :resorigcol 0 
                     :resjunk false
                     }
                  )
                  :qual <> 
                  :lefttree <> 
                  :righttree <> 
                  :initPlan <> 
                  :extParam (b)
                  :allParam (b)
                  :scanrelid 3
                  }
               :righttree <> 
               :initPlan <> 
               :extParam (b)
               :allParam (b)
               :numCols 1 
               :sortColIdx 3 
               :sortOperators 1058 
               :collations 100 
               :nullsFirst false
               }
            :initPlan <> 
            :extParam (b)
            :allParam (b)
            :jointype 1 
            :joinqual (
               {OPEXPR 
               :opno 97 
               :opfuncid 66 
               :opresulttype 16 
               :opretset false 
               :opcollid 0 
               :inputcollid 0 
               :args (
                  {VAR 
                  :varno 65001 
                  :varattno 4 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 3 
                  :location 156
                  }
                  {VAR 
                  :varno 65000 
                  :varattno 2 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 3 
                  :varoattno 4 
                  :location 163
                  }
               )
               :location 161
               }
               {OPEXPR 
               :opno 521 
               :opfuncid 147 
               :opresulttype 16 
               :opretset false 
               :opcollid 0 
               :inputcollid 0 
               :args (
                  {VAR 
                  :varno 65001 
                  :varattno 5 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 4 
                  :location 172
                  }
                  {VAR 
                  :varno 65000 
                  :varattno 1 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 3 
                  :varoattno 3 
                  :location 179
                  }
               )
               :location 177
               }
            )
            :mergeclauses (
               {OPEXPR 
               :opno 1054 
               :opfuncid 1048 
               :opresulttype 16 
               :opretset false 
               :opcollid 0 
               :inputcollid 100 
               :args (
                  {VAR 
                  :varno 65001 
                  :varattno 2 
                  :vartype 1042 
                  :vartypmod 5 
                  :varcollid 100 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 2 
                  :location 144
                  }
                  {VAR 
                  :varno 65000 
                  :varattno 3 
                  :vartype 1042 
                  :vartypmod 5 
                  :varcollid 100 
                  :varlevelsup 0 
                  :varnoold 3 
                  :varoattno 2 
                  :location 148
                  }
               )
               :location 147
               }
            )
            :mergeFamilies 426 
            :mergeCollations 100 
            :mergeStrategies 1 
            :mergeNullsFirst 0
            }
         :righttree <> 
         :initPlan <> 
         :extParam (b)
         :allParam (b)
         :numCols 3 
         :sortColIdx 5 6 7 
         :sortOperators 412 97 97 
         :collations 0 0 0 
         :nullsFirst false false false
         }
      }
   :rtable (
      {RTE 
      :alias 
         {ALIAS 
         :aliasname x 
         :colnames <>
         }
      :eref 
         {ALIAS 
         :aliasname x 
         :colnames ("a" "b" "ts" "te" "row_number" "p1" "p2")
         }
      :rtekind 1 
      :subquery <> 
      :security_barrier false 
      :lateral false 
      :inh false 
      :inFromCl true 
      :requiredPerms 0 
      :checkAsUser 0 
      :selectedCols (b)
      :insertedCols (b)
      :updatedCols (b)
      :securityQuals <>
      }
      {RTE 
      :alias 
         {ALIAS 
         :aliasname r 
         :colnames <>
         }
      :eref 
         {ALIAS 
         :aliasname r 
         :colnames ("a" "b" "ts" "te" "row_number")
         }
      :rtekind 1 
      :subquery <> 
      :security_barrier false 
      :lateral false 
      :inh false 
      :inFromCl true 
      :requiredPerms 2 
      :checkAsUser 0 
      :selectedCols (b)
      :insertedCols (b)
      :updatedCols (b)
      :securityQuals <>
      }
      {RTE 
      :alias <> 
      :eref 
         {ALIAS 
         :aliasname s 
         :colnames ("c" "d" "ts" "te")
         }
      :rtekind 0 
      :relid 16400 
      :relkind r 
      :tablesample <> 
      :lateral false 
      :inh false 
      :inFromCl true 
      :requiredPerms 2 
      :checkAsUser 0 
      :selectedCols (b 10 11 12)
      :insertedCols (b)
      :updatedCols (b)
      :securityQuals <>
      }
      {RTE 
      :alias <> 
      :eref 
         {ALIAS 
         :aliasname unnamed_join 
         :colnames ("a" "b" "ts" "te" "row_number" "c" "d" "ts" "te")
         }
      :rtekind 2 
      :jointype 1 
      :joinaliasvars <> 
      :lateral false 
      :inh false 
      :inFromCl true 
      :requiredPerms 0 
      :checkAsUser 0 
      :selectedCols (b)
      :insertedCols (b)
      :updatedCols (b)
      :securityQuals <>
      }
      {RTE 
      :alias <> 
      :eref 
         {ALIAS 
         :aliasname r 
         :colnames ("" "a" "b" "ts" "te")
         }
      :rtekind 0 
      :relid 16397 
      :relkind r 
      :tablesample <> 
      :lateral false 
      :inh false 
      :inFromCl true 
      :requiredPerms 2 
      :checkAsUser 0 
      :selectedCols (b 10 11 12 13)
      :insertedCols (b)
      :updatedCols (b)
      :securityQuals <>
      }
   )
   :resultRelations <> 
   :utilityStmt <> 
   :subplans <> 
   :rewindPlanIDs (b)
   :rowMarks <> 
   :relationOids (o 16400 16397)
   :invalItems <> 
   :nParamExec 0 
   :hasRowSecurity false
   }
)
