Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG

Поиск
Список
Период
Сортировка
От Ankit Kumar Pandey
Тема Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
Дата
Msg-id 990013ee-5d76-b2af-1f79-9bb4fdb5eda3@gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
Список pgsql-hackers
On 25/12/22 23:54, Tom Lane wrote:
>
> These days people
> would probably also wish that the output could be machine-
> readable in some way (JSON-formatted, perhaps).

Perhaps switch to enable logs could be on (standard logging style), 
json, xml etc and print the output

as required?


>   however, because it won't show you anything about
> paths that were considered and immediately rejected by
> add_path (or never got to add_path at all, because of the
> approximate-initial-cost filters in joinpath.c).  We've
> sometimes speculated about logging every path submitted to
> add_path, but that would likely be too verbose to be very
> helpful.
>
Maybe we could add verbose option too and this could be one of the 
output. Are there any more relevant information

that you could think of which can be included here?


Also, inputs from other hackers are welcomed here.


-- 
Regards,
Ankit Kumar Pandey




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error-safe user functions