(
   {QUERY 
   :commandType 1 
   :querySource 0 
   :canSetTag true 
   :utilityStmt <> 
   :resultRelation 0 
   :hasAggs true 
   :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 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 <>
      }
   )
   :jointree 
      {FROMEXPR 
      :fromlist (
         {RANGETBLREF 
         :rtindex 1
         }
      )
      :quals <>
      }
   :targetList (
      {TARGETENTRY 
      :expr 
         {AGGREF 
         :aggfnoid 2803 
         :aggtype 20 
         :aggcollid 0 
         :inputcollid 0 
         :aggdirectargs <> 
         :args <> 
         :aggorder <> 
         :aggdistinct <> 
         :aggfilter <> 
         :aggstar true 
         :aggvariadic false 
         :aggkind n 
         :agglevelsup 0 
         :location 7
         }
      :resno 1 
      :resname count 
      :ressortgroupref 0 
      :resorigtbl 0 
      :resorigcol 0 
      :resjunk false
      }
   )
   :withCheckOptions <> 
   :onConflict <> 
   :returningList <> 
   :groupClause <> 
   :groupingSets <> 
   :havingQual <> 
   :windowClause <> 
   :distinctClause <> 
   :sortClause <> 
   :limitOffset <> 
   :limitCount <> 
   :rowMarks <> 
   :setOperations <> 
   :constraintDeps <>
   }
)

