   {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 35
                     }
                     {VAR 
                     :varno 2 
                     :varattno 2 
                     :vartype 1042 
                     :vartypmod 5 
                     :varcollid 100 
                     :varlevelsup 0 
                     :varnoold 2 
                     :varoattno 2 
                     :location 39
                     }
                  )
                  :location 38
                  }
                  {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 0 
   :checkAsUser 0 
   :selectedCols (b)
   :insertedCols (b)
   :updatedCols (b)
   :securityQuals <>
   }
