QUERYTREE
(
   {QUERY 
   :commandType 5 
   :querySource 0 
   :canSetTag true 
   :utilityStmt ? 
   :resultRelation 0 
   :hasAggs false 
   :hasWindowFuncs false 
   :hasSubLinks false 
   :hasDistinctOn false 
   :hasRecursive false 
   :hasModifyingCTE false 
   :hasForUpdate false 
   :hasRowSecurity false 
   :temporalType 0 
   :temporalTs 0 
   :temporalTe 0 
   :cteList <> 
   :rtable <> 
   :jointree <> 
   :targetList <> 
   :withCheckOptions <> 
   :onConflict <> 
   :returningList <> 
   :groupClause <> 
   :groupingSets <> 
   :havingQual <> 
   :windowClause <> 
   :distinctClause <> 
   :sortClause <> 
   :limitOffset <> 
   :limitCount <> 
   :rowMarks <> 
   :setOperations <> 
   :constraintDeps <>
   }
)

WARNING:  could not dump unrecognized node type: 742


QUERYTREEx


PLANTREE
(
   {
   }
)



PLANTREE


QUERYTREE
(
   {QUERY 
   :commandType 1 
   :querySource 0 
   :canSetTag true 
   :utilityStmt <> 
   :resultRelation 0 
   :hasAggs false 
   :hasWindowFuncs false 
   :hasSubLinks false 
   :hasDistinctOn false 
   :hasRecursive false 
   :hasModifyingCTE false 
   :hasForUpdate false 
   :hasRowSecurity false 
   :temporalType 0 
   :temporalTs 0 
   :temporalTe 0 
   :cteList <> 
   :rtable (
      {RTE 
      :alias 
         {ALIAS 
         :aliasname x 
         :colnames <>
         }
      :eref 
         {ALIAS 
         :aliasname x 
         :colnames ("a" "b" "ts" "te")
         }
      :rtekind 1 
      :subquery 
         {QUERY 
         :commandType 1 
         :querySource 0 
         :canSetTag true 
         :utilityStmt <> 
         :resultRelation 0 
         :hasAggs false 
         :hasWindowFuncs false 
         :hasSubLinks false 
         :hasDistinctOn false 
         :hasRecursive false 
         :hasModifyingCTE false 
         :hasForUpdate false 
         :hasRowSecurity false 
         :temporalType 1 
         :temporalTs 3 
         :temporalTe 4 
         :cteList <> 
         :rtable (
            {RTE 
            :alias 
               {ALIAS 
               :aliasname r 
               :colnames <>
               }
            :eref 
               {ALIAS 
               :aliasname r 
               :colnames ("a" "b" "ts" "te" "*RN*")
               }
            :rtekind 1 
            :subquery 
               {QUERY 
               :commandType 1 
               :querySource 0 
               :canSetTag true 
               :utilityStmt <> 
               :resultRelation 0 
               :hasAggs false 
               :hasWindowFuncs true 
               :hasSubLinks false 
               :hasDistinctOn false 
               :hasRecursive false 
               :hasModifyingCTE false 
               :hasForUpdate false 
               :hasRowSecurity false 
               :temporalType 0 
               :temporalTs 0 
               :temporalTe 0 
               :cteList <> 
               :rtable (
                  {RTE 
                  :alias <> 
                  :eref 
                     {ALIAS 
                     :aliasname r 
                     :colnames ("" "a" "b" "ts" "te")
                     }
                  :rtekind 0 
                  :relid 16397 
                  :relkind r 
                  :tablesample <> 
                  :lateral false 
                  :inh true 
                  :inFromCl true 
                  :requiredPerms 2 
                  :checkAsUser 0 
                  :selectedCols (b 10 11 12 13)
                  :insertedCols (b)
                  :updatedCols (b)
                  :securityQuals <>
                  }
               )
               :jointree 
                  {FROMEXPR 
                  :fromlist (
                     {RANGETBLREF 
                     :rtindex 1
                     }
                  )
                  :quals <>
                  }
               :targetList (
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 1 
                     :varattno 2 
                     :vartype 1042 
                     :vartypmod 5 
                     :varcollid 100 
                     :varlevelsup 0 
                     :varnoold 1 
                     :varoattno 2 
                     :location -1
                     }
                  :resno 1 
                  :resname a 
                  :ressortgroupref 0 
                  :resorigtbl 16397 
                  :resorigcol 2 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 1 
                     :varattno 3 
                     :vartype 1042 
                     :vartypmod 5 
                     :varcollid 100 
                     :varlevelsup 0 
                     :varnoold 1 
                     :varoattno 3 
                     :location -1
                     }
                  :resno 2 
                  :resname b 
                  :ressortgroupref 0 
                  :resorigtbl 16397 
                  :resorigcol 3 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 1 
                     :varattno 4 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 1 
                     :varoattno 4 
                     :location -1
                     }
                  :resno 3 
                  :resname ts 
                  :ressortgroupref 0 
                  :resorigtbl 16397 
                  :resorigcol 4 
                  :resjunk false
                  }
                  {TARGETENTRY 
                  :expr 
                     {VAR 
                     :varno 1 
                     :varattno 5 
                     :vartype 23 
                     :vartypmod -1 
                     :varcollid 0 
                     :varlevelsup 0 
                     :varnoold 1 
                     :varoattno 5 
                     :location -1
                     }
                  :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 -1
                     }
                  :resno 5 
                  :resname *RN* 
                  :ressortgroupref 0 
                  :resorigtbl 0 
                  :resorigcol 0 
                  :resjunk false
                  }
               )
               :withCheckOptions <> 
               :onConflict <> 
               :returningList <> 
               :groupClause <> 
               :groupingSets <> 
               :havingQual <> 
               :windowClause (
                  {WINDOWCLAUSE 
                  :name <> 
                  :refname <> 
                  :partitionClause <> 
                  :orderClause <> 
                  :frameOptions 530 
                  :startOffset <> 
                  :endOffset <> 
                  :winref 1 
                  :copiedOrder false
                  }
               )
               :distinctClause <> 
               :sortClause <> 
               :limitOffset <> 
               :limitCount <> 
               :rowMarks <> 
               :setOperations <> 
               :constraintDeps <>
               }
            :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 true 
            :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" "*RN*" "c" "d" "ts" "te")
               }
            :rtekind 2 
            :jointype 1 
            :joinaliasvars (
               {VAR 
               :varno 1 
               :varattno 1 
               :vartype 1042 
               :vartypmod 5 
               :varcollid 100 
               :varlevelsup 0 
               :varnoold 1 
               :varoattno 1 
               :location -1
               }
               {VAR 
               :varno 1 
               :varattno 2 
               :vartype 1042 
               :vartypmod 5 
               :varcollid 100 
               :varlevelsup 0 
               :varnoold 1 
               :varoattno 2 
               :location -1
               }
               {VAR 
               :varno 1 
               :varattno 3 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 1 
               :varoattno 3 
               :location -1
               }
               {VAR 
               :varno 1 
               :varattno 4 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 1 
               :varoattno 4 
               :location -1
               }
               {VAR 
               :varno 1 
               :varattno 5 
               :vartype 20 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 1 
               :varoattno 5 
               :location -1
               }
               {VAR 
               :varno 2 
               :varattno 1 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 2 
               :varoattno 1 
               :location -1
               }
               {VAR 
               :varno 2 
               :varattno 2 
               :vartype 1042 
               :vartypmod 5 
               :varcollid 100 
               :varlevelsup 0 
               :varnoold 2 
               :varoattno 2 
               :location -1
               }
               {VAR 
               :varno 2 
               :varattno 3 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 2 
               :varoattno 3 
               :location -1
               }
               {VAR 
               :varno 2 
               :varattno 4 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 2 
               :varoattno 4 
               :location -1
               }
            )
            :lateral false 
            :inh false 
            :inFromCl true 
            :requiredPerms 0 
            :checkAsUser 0 
            :selectedCols (b)
            :insertedCols (b)
            :updatedCols (b)
            :securityQuals <>
            }
         )
         :jointree 
            {FROMEXPR 
            :fromlist (
               {JOINEXPR 
               :jointype 1 
               :isNatural false 
               :larg 
                  {RANGETBLREF 
                  :rtindex 1
                  }
               :rarg 
                  {RANGETBLREF 
                  :rtindex 2
                  }
               :usingClause <> 
               :quals 
                  {BOOLEXPR 
                  :boolop and 
                  :args (
                     {OPEXPR 
                     :opno 1054 
                     :opfuncid 1048 
                     :opresulttype 16 
                     :opretset false 
                     :opcollid 0 
                     :inputcollid 100 
                     :args (
                        {VAR 
                        :varno 1 
                        :varattno 2 
                        :vartype 1042 
                        :vartypmod 5 
                        :varcollid 100 
                        :varlevelsup 0 
                        :varnoold 1 
                        :varoattno 2 
                        :location 28
                        }
                        {VAR 
                        :varno 2 
                        :varattno 2 
                        :vartype 1042 
                        :vartypmod 5 
                        :varcollid 100 
                        :varlevelsup 0 
                        :varnoold 2 
                        :varoattno 2 
                        :location 32
                        }
                     )
                     :location 31
                     }
                     {OPEXPR 
                     :opno 97 
                     :opfuncid 66 
                     :opresulttype 16 
                     :opretset false 
                     :opcollid 0 
                     :inputcollid 0 
                     :args (
                        {VAR 
                        :varno 1 
                        :varattno 3 
                        :vartype 23 
                        :vartypmod -1 
                        :varcollid 0 
                        :varlevelsup 0 
                        :varnoold 1 
                        :varoattno 3 
                        :location -1
                        }
                        {VAR 
                        :varno 2 
                        :varattno 4 
                        :vartype 23 
                        :vartypmod -1 
                        :varcollid 0 
                        :varlevelsup 0 
                        :varnoold 2 
                        :varoattno 4 
                        :location -1
                        }
                     )
                     :location -1
                     }
                     {OPEXPR 
                     :opno 521 
                     :opfuncid 147 
                     :opresulttype 16 
                     :opretset false 
                     :opcollid 0 
                     :inputcollid 0 
                     :args (
                        {VAR 
                        :varno 1 
                        :varattno 4 
                        :vartype 23 
                        :vartypmod -1 
                        :varcollid 0 
                        :varlevelsup 0 
                        :varnoold 1 
                        :varoattno 4 
                        :location -1
                        }
                        {VAR 
                        :varno 2 
                        :varattno 3 
                        :vartype 23 
                        :vartypmod -1 
                        :varcollid 0 
                        :varlevelsup 0 
                        :varnoold 2 
                        :varoattno 3 
                        :location -1
                        }
                     )
                     :location -1
                     }
                  )
                  :location -1
                  }
               :alias <> 
               :rtindex 3 
               :largTs <> 
               :largTe <> 
               :rargTs <> 
               :rargTe <>
               }
            )
            :quals <>
            }
         :targetList (
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 1 
               :varattno 1 
               :vartype 1042 
               :vartypmod 5 
               :varcollid 100 
               :varlevelsup 0 
               :varnoold 1 
               :varoattno 1 
               :location -1
               }
            :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 -1
               }
            :resno 2 
            :resname b 
            :ressortgroupref 0 
            :resorigtbl 16397 
            :resorigcol 3 
            :resjunk false
            }
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 1 
               :varattno 3 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 1 
               :varoattno 3 
               :location -1
               }
            :resno 3 
            :resname ts 
            :ressortgroupref 0 
            :resorigtbl 16397 
            :resorigcol 4 
            :resjunk false
            }
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 1 
               :varattno 4 
               :vartype 23 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 1 
               :varoattno 4 
               :location -1
               }
            :resno 4 
            :resname te 
            :ressortgroupref 0 
            :resorigtbl 16397 
            :resorigcol 5 
            :resjunk false
            }
            {TARGETENTRY 
            :expr 
               {VAR 
               :varno 1 
               :varattno 5 
               :vartype 20 
               :vartypmod -1 
               :varcollid 0 
               :varlevelsup 0 
               :varnoold 1 
               :varoattno 5 
               :location -1
               }
            :resno 5 
            :resname *RN* 
            :ressortgroupref 1 
            :resorigtbl 0 
            :resorigcol 0 
            :resjunk true
            }
            {TARGETENTRY 
            :expr 
               {MINMAX 
               :minmaxtype 23 
               :minmaxcollid 0 
               :inputcollid 0 
               :op 0 
               :args (
                  {VAR 
                  :varno 1 
                  :varattno 3 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 1 
                  :varoattno 3 
                  :location -1
                  }
                  {VAR 
                  :varno 2 
                  :varattno 3 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 3 
                  :location -1
                  }
               )
               :location -1
               }
            :resno 6 
            :resname *P1* 
            :ressortgroupref 2 
            :resorigtbl 0 
            :resorigcol 0 
            :resjunk true
            }
            {TARGETENTRY 
            :expr 
               {MINMAX 
               :minmaxtype 23 
               :minmaxcollid 0 
               :inputcollid 0 
               :op 1 
               :args (
                  {VAR 
                  :varno 1 
                  :varattno 4 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 1 
                  :varoattno 4 
                  :location -1
                  }
                  {VAR 
                  :varno 2 
                  :varattno 4 
                  :vartype 23 
                  :vartypmod -1 
                  :varcollid 0 
                  :varlevelsup 0 
                  :varnoold 2 
                  :varoattno 4 
                  :location -1
                  }
               )
               :location -1
               }
            :resno 7 
            :resname *P2* 
            :ressortgroupref 3 
            :resorigtbl 0 
            :resorigcol 0 
            :resjunk true
            }
         )
         :withCheckOptions <> 
         :onConflict <> 
         :returningList <> 
         :groupClause <> 
         :groupingSets <> 
         :havingQual <> 
         :windowClause <> 
         :distinctClause <> 
         :sortClause (
            {SORTGROUPCLAUSE 
            :tleSortGroupRef 1 
            :eqop 410 
            :sortop 412 
            :nulls_first false 
            :hashable true
            }
            {SORTGROUPCLAUSE 
            :tleSortGroupRef 2 
            :eqop 96 
            :sortop 97 
            :nulls_first false 
            :hashable true
            }
            {SORTGROUPCLAUSE 
            :tleSortGroupRef 3 
            :eqop 96 
            :sortop 97 
            :nulls_first false 
            :hashable true
            }
         )
         :limitOffset <> 
         :limitCount <> 
         :rowMarks <> 
         :setOperations <> 
         :constraintDeps <>
         }
      :security_barrier false 
      :lateral false 
      :inh false 
      :inFromCl true 
      :requiredPerms 2 
      :checkAsUser 0 
      :selectedCols (b)
      :insertedCols (b)
      :updatedCols (b)
      :securityQuals <>
      }
   )
   :jointree 
      {FROMEXPR 
      :fromlist (
         {RANGETBLREF 
         :rtindex 1
         }
      )
      :quals <>
      }
   :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 7
         }
      :resno 2 
      :resname b 
      :ressortgroupref 0 
      :resorigtbl 16397 
      :resorigcol 3 
      :resjunk false
      }
      {TARGETENTRY 
      :expr 
         {VAR 
         :varno 1 
         :varattno 3 
         :vartype 23 
         :vartypmod -1 
         :varcollid 0 
         :varlevelsup 0 
         :varnoold 1 
         :varoattno 3 
         :location 7
         }
      :resno 3 
      :resname ts 
      :ressortgroupref 0 
      :resorigtbl 16397 
      :resorigcol 4 
      :resjunk false
      }
      {TARGETENTRY 
      :expr 
         {VAR 
         :varno 1 
         :varattno 4 
         :vartype 23 
         :vartypmod -1 
         :varcollid 0 
         :varlevelsup 0 
         :varnoold 1 
         :varoattno 4 
         :location 7
         }
      :resno 4 
      :resname te 
      :ressortgroupref 0 
      :resorigtbl 16397 
      :resorigcol 5 
      :resjunk false
      }
   )
   :withCheckOptions <> 
   :onConflict <> 
   :returningList <> 
   :groupClause <> 
   :groupingSets <> 
   :havingQual <> 
   :windowClause <> 
   :distinctClause <> 
   :sortClause <> 
   :limitOffset <> 
   :limitCount <> 
   :rowMarks <> 
   :setOperations <> 
   :constraintDeps <>
   }
)



QUERYTREEx
1570.000000
make_temporalAdjustment: numRows = 4710.000000; numCols = 7; datatype = 23
   {TARGETENTRY 
   :expr 
      {VAR 
      :varno 1 
      :varattno 3 
      :vartype 23 
      :vartypmod -1 
      :varcollid 0 
      :varlevelsup 0 
      :varnoold 1 
      :varoattno 3 
      :location -1
      }
   :resno 3 
   :resname ts 
   :ressortgroupref 0 
   :resorigtbl 16397 
   :resorigcol 4 
   :resjunk false
   }

WARNING:  01000: could not dump unrecognized node type: 140
LOCATION:  _outNode, outfuncs.c:3484


PLANTREE
(
   {PLANNEDSTMT 
   :commandType 1 
   :queryId 0 
   :hasReturning false 
   :hasModifyingCTE false 
   :canSetTag true 
   :transientPlan false 
   :planTree 
      {SUBQUERYSCAN 
      :startup_cost 620.67 
      :total_cost 754.12 
      :plan_rows 4710 
      :plan_width 24 
      :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 7
            }
         :resno 2 
         :resname b 
         :ressortgroupref 0 
         :resorigtbl 16397 
         :resorigcol 3 
         :resjunk false
         }
         {TARGETENTRY 
         :expr 
            {VAR 
            :varno 1 
            :varattno 3 
            :vartype 23 
            :vartypmod -1 
            :varcollid 0 
            :varlevelsup 0 
            :varnoold 1 
            :varoattno 3 
            :location 7
            }
         :resno 3 
         :resname ts 
         :ressortgroupref 0 
         :resorigtbl 16397 
         :resorigcol 4 
         :resjunk false
         }
         {TARGETENTRY 
         :expr 
            {VAR 
            :varno 1 
            :varattno 4 
            :vartype 23 
            :vartypmod -1 
            :varcollid 0 
            :varlevelsup 0 
            :varnoold 1 
            :varoattno 4 
            :location 7
            }
         :resno 4 
         :resname te 
         :ressortgroupref 0 
         :resorigtbl 16397 
         :resorigcol 5 
         :resjunk false
         }
      )
      :qual <> 
      :lefttree <> 
      :righttree <> 
      :initPlan <> 
      :extParam (b)
      :allParam (b)
      :scanrelid 1 
      :subplan 
         {
         }
      }
   :rtable (
      {RTE 
      :alias 
         {ALIAS 
         :aliasname x 
         :colnames <>
         }
      :eref 
         {ALIAS 
         :aliasname x 
         :colnames ("a" "b" "ts" "te")
         }
      :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" "*RN*")
         }
      :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" "*RN*" "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
   }
)



PLANTREE
curr=NULL
false:3
1 sweepline = 1
FIRSTCALL
Storing tuple
2 sweepline = 2
1:14989440; 2:14989442; 3:1; 4:7
5:1
6:2
7:5
Storing tuple
3 sweepline = 5
1:14990896; 2:14990898; 3:1; 4:7
5:1
6:3
7:4
Storing tuple
1:14991056; 2:14991058; 3:3; 4:9
5:2
6:3
7:4
Storing tuple
4 sweepline = 3
1:14991056; 2:14991058; 3:3; 4:9
5:2
6:3
7:4
Storing tuple
3 sweepline = 4
1:14990976; 2:14990978; 3:3; 4:9
5:2
6:3
7:5
Storing tuple
3 sweepline = 5
1:14991136; 2:14991138; 3:3; 4:9
5:2
6:7
7:9
Storing tuple
2 sweepline = 7
1:14991136; 2:14991138; 3:3; 4:9
5:2
6:7
7:9
Storing tuple
3 sweepline = 9
1:14991216; 2:14991218; 3:8; 4:10
5:3
6:8
7:10
4 sweepline = 8
Storing tuple
3 sweepline = 10
curr=NULL
