analyzing debugging sentences. - Mailing list pgsql-hackers

-- Executing query:
select 0.4 * 0.5;
DEBUG:  parse tree:
DETAIL:     {QUERY    :commandType 1    :querySource 0    :canSetTag true    :utilityStmt <>    :resultRelation 0    :into <>    :hasAggs false    :hasSubLinks false    :rtable <>    :jointree       {FROMEXPR       :fromlist <>       :quals <>      }   :rowMarks <>    :forUpdate false    :rowNoWait false    :targetList (      {TARGETENTRY       :expr          {OPEXPR          :opno 1760          :opfuncid 0          :opresulttype 1700          :opretset false          :args (            {CONST             :consttype 1700             :constlen -1             :constbyval false             :constisnull false             :constvalue 10 [ 10 0 0 0 -1 -1 1 0 -96 15 ]            }            {CONST             :consttype 1700             :constlen -1             :constbyval false             :constisnull false             :constvalue 10 [ 10 0 0 0 -1 -1 1 0 -120 19 ]            }         )         }      :resno 1       :resname ?column?       :ressortgroupref 0       :resorigtbl 0       :resorigcol 0       :resjunk false      }   )   :groupClause <>    :havingQual <>    :distinctClause <>    :sortClause <>    :limitOffset <>    :limitCount <>    :setOperations <>    :resultRelations <>   }

DEBUG:  rewritten parse tree:
DETAIL:  (   {QUERY    :commandType 1    :querySource 0    :canSetTag true    :utilityStmt <>    :resultRelation 0    :into <>    :hasAggs false    :hasSubLinks false    :rtable <>    :jointree       {FROMEXPR       :fromlist <>       :quals <>      }   :rowMarks <>    :forUpdate false    :rowNoWait false    :targetList (      {TARGETENTRY       :expr          {OPEXPR          :opno 1760          :opfuncid 0          :opresulttype 1700          :opretset false          :args (            {CONST             :consttype 1700             :constlen -1             :constbyval false             :constisnull false             :constvalue 10 [ 10 0 0 0 -1 -1 1 0 -96 15 ]            }            {CONST             :consttype 1700             :constlen -1             :constbyval false             :constisnull false             :constvalue 10 [ 10 0 0 0 -1 -1 1 0 -120 19 ]            }         )         }      :resno 1       :resname ?column?       :ressortgroupref 0       :resorigtbl 0       :resorigcol 0       :resjunk false      }   )   :groupClause <>    :havingQual <>    :distinctClause <>    :sortClause <>    :limitOffset <>    :limitCount <>    :setOperations <>    :resultRelations <>   }
)

DEBUG:  plan:
DETAIL:     {RESULT    :startup_cost 0.00    :total_cost 0.01    :plan_rows 1    :plan_width 0    :targetlist (      {TARGETENTRY       :expr          {OPEXPR          :opno 1760          :opfuncid 1726          :opresulttype 1700          :opretset false          :args (            {CONST             :consttype 1700             :constlen -1             :constbyval false             :constisnull false             :constvalue 10 [ 10 0 0 0 -1 -1 1 0 -96 15 ]            }            {CONST             :consttype 1700             :constlen -1             :constbyval false             :constisnull false             :constvalue 10 [ 10 0 0 0 -1 -1 1 0 -120 19 ]            }         )         }      :resno 1       :resname ?column?       :ressortgroupref 0       :resorigtbl 0       :resorigcol 0       :resjunk false      }   )   :qual <>    :lefttree <>    :righttree <>    :initPlan <>    :extParam (b)   :allParam (b)   :nParamExec 0    :resconstantqual <>   }