PLANTREE
(
   {PLANNEDSTMT 
   :commandType 1 
   :queryId 0 
   :hasReturning false 
   :hasModifyingCTE false 
   :canSetTag true 
   :transientPlan false 
   :planTree 
      {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 2 
            :varoattno 3 
            :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 2 
            :varoattno 4 
            :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 22
               }
            :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 22
               }
            :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 2 
               :varoattno 3 
               :location 22
               }
            :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 2 
               :varoattno 4 
               :location 22
               }
            :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 22
               }
            :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 3 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 3 
                  :location 36
                  }
                  {VAR 
                  :varno 65000 
                  :varattno 1 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 3 
                  :varoattno 3 
                  :location 42
                  }
               )
               :location 27
               }
            :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 4 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 4 
                  :location 58
                  }
                  {VAR 
                  :varno 65000 
                  :varattno 2 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 3 
                  :varoattno 4 
                  :location 64
                  }
               )
               :location 52
               }
            :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 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 3 
                  :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 4 
                  :location -1
                  }
               :resno 4 
               :resname <> 
               :ressortgroupref 0 
               :resorigtbl 0 
               :resorigcol 0 
               :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 <> 
               :ressortgroupref 0 
               :resorigtbl 0 
               :resorigcol 0 
               :resjunk false
               }
            )
            :qual <> 
            :lefttree 
               {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 86
                     }
                  :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 5 
                     :varoattno 3 
                     :location 86
                     }
                  :resno 2 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 65001 
                     :varattno 3 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 5 
                     :varoattno 4 
                     :location 86
                     }
                  :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 5 
                     :varoattno 5 
                     :location 86
                     }
                  :resno 4 
                  :resname <> 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {WINDOWFUNC 
                     :winfnoid 3100 
                     :wintype 20 
                     :wincollid 0 
                     :inputcollid 0 
                     :args <> 
                     :aggfilter <> 
                     :winref 1 
                     :winstar false 
                     :winagg false 
                     :location 89
                     }
                  :resno 5 
                  :resname <> 
                  :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 86
                        }
                     :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 86
                        }
                     :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 86
                        }
                     :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 86
                        }
                     :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 42
                     }
                  :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 64
                     }
                  :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 146
                     }
                  :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 3 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 2 
               :varoattno 3 
               :location 154
               }
               {VAR 
               :varno 65000 
               :varattno 2 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 3 
               :varoattno 4 
               :location 161
               }
            )
            :location 159
            }
            {OPEXPR 
            :opno 521 
            :opfuncid 147 
            :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 4 
               :location 170
               }
               {VAR 
               :varno 65000 
               :varattno 1 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 3 
               :varoattno 3 
               :location 177
               }
            )
            :location 175
            }
         )
         :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 142
               }
               {VAR 
               :varno 65000 
               :varattno 3 
               :vartype 1042 
               :vartypmod 5 
               :varcollid 100 
               :varlevelsup 0 
               :varnoold 3 
               :varoattno 2 
               :location 146
               }
            )
            :location 145
            }
         )
         :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 2 
      :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
   }
)
