analyzing debugging sentences.

Поиск
Список
Период
Сортировка
От jungmin shin
Тема analyzing debugging sentences.
Дата
Msg-id cd77360b0610181111p56f28689u56ca7cd3414a1efd@mail.gmail.com
обсуждение исходный текст
Ответы Re: analyzing debugging sentences.  (Andrew Dunstan <andrew@dunslane.net>)
Re: analyzing debugging sentences.  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-hackers

Hello,
 
I set on for following items in postgresql.conf
 
debug_print_parse
debug_print_rewritten
debug_print_plan
debug_print_pretty
 
now, I can see something in PGAdmin query tool when I execute a query.
can I get some idea how I can read comprehend the output?
 
-- 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 <>   }
 
 

--
Jungmin Shin

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] query log corrupted-looking entries
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: analyzing debugging sentences.