Re: Auto-explain patch

Поиск
Список
Период
Сортировка
Искать
От
Dean Rasheed
Тема
Re: Auto-explain patch
Дата
Msg-id
BAY102-W270D92DBFAD83E0B24919FF25D0@phx.gbl
Ответ на
Re: Auto-explain patch (ITAGAKI Takahiro)
Список
Дерево обсуждения
Re: Auto-explain patch Dean Rasheed <dean_rasheed@hotmail.com>
Re: Auto-explain patch Simon Riggs <simon@2ndquadrant.com>
Re: Auto-explain patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Auto-explain patch Dean Rasheed <dean_rasheed@hotmail.com>
Re: Auto-explain patch ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Auto-explain patch Simon Riggs <simon@2ndQuadrant.com>
Re: Auto-explain patch ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Auto-explain patch "Alex Hunsaker" <badalex@gmail.com>
auto_explain contrib moudle ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: auto_explain contrib moudle Jeff Davis <pgsql@j-davis.com>
Re: auto_explain contrib moudle Jeff Davis <pgsql@j-davis.com>
Re: auto_explain contrib moudle Martin Pihlak <martin.pihlak@gmail.com>
Re: auto_explain contrib moudle Jeff Davis <pgsql@j-davis.com>
Re: auto_explain contrib moudle Martin Pihlak <martin.pihlak@gmail.com>
Re: auto_explain contrib moudle Jeff Davis <pgsql@j-davis.com>
Re: auto_explain contrib moudle Martin Pihlak <martin.pihlak@gmail.com>
Re: auto_explain contrib moudle Jeff Davis <pgsql@j-davis.com>
Re: auto_explain contrib moudle Tom Lane <tgl@sss.pgh.pa.us>
Re: auto_explain contrib moudle Jeff Davis <pgsql@j-davis.com>
Re: auto_explain contrib moudle Jeff Davis <pgsql@j-davis.com>
Re: auto_explain contrib moudle ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: auto_explain contrib moudle Jeff Davis <pgsql@j-davis.com>
Re: auto_explain contrib moudle Tom Lane <tgl@sss.pgh.pa.us>
Re: auto_explain contrib moudle ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: auto_explain contrib moudle ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: auto_explain contrib moudle Tom Lane <tgl@sss.pgh.pa.us>
Re: auto_explain contrib moudle ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: auto_explain contrib moudle Tom Lane <tgl@sss.pgh.pa.us>
Re: auto_explain contrib moudle Tom Lane <tgl@sss.pgh.pa.us>
Re: auto_explain contrib moudle Jeff Davis <pgsql@j-davis.com>
Re: auto_explain contrib moudle Tom Lane <tgl@sss.pgh.pa.us>
Re: auto_explain contrib moudle ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: auto_explain contrib moudle "Alex Hunsaker" <badalex@gmail.com>
Re: Auto-explain patch Dean Rasheed <dean_rasheed@hotmail.com>
Re: Auto-explain patch ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Auto-explain patch Dean Rasheed <dean_rasheed@hotmail.com>
Re: Auto-explain patch ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Auto-explain patch "Marko Kreen" <markokr@gmail.com>
Re: Auto-explain patch ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Auto-explain patch "Marko Kreen" <markokr@gmail.com>

> * auto_explain.tgz
> A contrib module version of auto-explain.
> An arguable part is initializing instruments in ExecutorRun_hook.
> The initialization should be done in ExecutorStart normally, but
> it is too late in the hook. Is it safe? or are there any better idea?
> README is a plain-text for now, and I'll rewrite it in sgml if needed.
>

How about adding a new hook to control instrumentation of queries in
ExecutorStart? Something like:

typedef bool (*ExecutorDoInstrument_hook_type) (QueryDesc *queryDesc, int eflags);

extern PGDLLIMPORT ExecutorDoInstrument_hook_type ExecutorDoInstrument_hook;

I think that would allow your module code to be simplified,
and it would allow other future extensions to hook in and
enable instrumentation before queries are run.

Regards, Dean.

_________________________________________________________________
Win a voice over part with Kung Fu Panda & Live Search   and   100’s of Kung Fu Panda prizes to win with Live Search
http://clk.atdmt.com/UKM/go/107571439/direct/01/
В списке pgsql-hackers по дате отправления
От: Gregory Stark
Дата:
От: Tom Lane
Дата:
FAQ