Planner question

Поиск
Список
Период
Сортировка
От Tom Raney
Тема Planner question
Дата
Msg-id 48A2228E.3030901@cecs.pdx.edu
обсуждение исходный текст
Ответы Re: Planner question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I've been working on a client application (based on the Red Hat Visual 
Explain tool) to display all plans the planner considers graphically and 
it does that.  But, the trace functionality in the planner is always on 
(and thus, taking up cycles and resources) whether or not it is 
requested by the user. 

My question is:  How would I let the planner know when a planner session 
has been invoked by the "explain" command?  If I can slip a flag into 
PlannerInfo or PlannerGlobal, that would be perfect.  But, I'm a bit 
stuck on how to get explain context to that point.  I don't want to 
modify the planner() entry function parameter list, unless absolutely 
necessary. 

I currently compile with DEBUG_OPTIMIZER - and that is one option - to 
conditionally compile this functionality, but it would be great if this 
could run on a lean production system.

-Tom Raney





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

Предыдущее
От: Decibel!
Дата:
Сообщение: Re: temporary statistics option at initdb time
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: Uncopied parameters on CREATE TABLE LIKE