Inspecting generated PlannerInfo

Поиск
Список
Период
Сортировка
От Fábio Moreira
Тема Inspecting generated PlannerInfo
Дата
Msg-id CANQddpPTpV6Z370jtzeK0stcHvVnzrzbxAjo+CSkGNh4VwFWDA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Inspecting generated PlannerInfo
Список pgsql-novice
Дерево обсуждения
Hi everyone,

I wanted to dig around the query planner (specifically, to convert sub-SELECTs in WHERE to LEFT OUTER JOINs — I’m looking into modifying pull_up_sublinks() for that).

From what I could find, PostgreSQL’s tests check for output correctness but not if the query planner is actually applying specific optimizations to the input query; is that correct? Is there any way of serializing a PlannerInfo struct to inspect whether my function is applying the transformations I expect it to?

(I understand, of course, that any optimizations should eventually be visible through EXPLAIN SELECT, but that’s less than ideal for development, as the PlannerInfo will probably also get altered by other optimizations in the way to the client.)

Thanks,

--
Fábio Dias Moreira

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