Re: ExplainOneQuery_hook ignored for EXPLAIN EXECUTE

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: ExplainOneQuery_hook ignored for EXPLAIN EXECUTE
Дата
Msg-id 20161113222804.o2uw7c2fish67iej@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: ExplainOneQuery_hook ignored for EXPLAIN EXECUTE  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ExplainOneQuery_hook ignored for EXPLAIN EXECUTE
Список pgsql-hackers
On 2016-11-13 17:20:05 -0500, Tom Lane wrote:
> Andres Freund <andres@anarazel.de> writes:
> > I don't quite know what the hook in $subject was originally designed
> > for, but right now it has the problem that it's not invoked for EXPLAIN
> > EXECUTE.  That's because ExplainExecuteQuery directly calls
> > ExplainOnePlan instead of ExplainOneQuery_hook.
>
> > Unfortunately that's not entirely trivial to fix, because the hook
> > accepts a Query, not a PlannedStmt.
>
> AFAIR, the purpose of that hook was to let index advisor plugins have
> control of the planning step in an EXPLAIN, so that they could do things
> like injecting hypothetical indexes.  There isn't any easy way to do
> something similar in EXPLAIN EXECUTE because the plan comes out of the
> plancache.

> Why do you care?  It's a pretty specialized hook.

Citus currently uses it to output additional information for distributed
queries. I suspect we'll instead, for now, have to intercept EXPLAIN as
a whole then :( (moving to custom plans unfortunately is still a bit off
unfortunately).

Andres



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ExplainOneQuery_hook ignored for EXPLAIN EXECUTE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ExplainOneQuery_hook ignored for EXPLAIN EXECUTE