Re: Planner debug views

Поиск
Список
Период
Сортировка
Искать
От
Qingqing Zhou
Тема
Re: Planner debug views
Дата
Msg-id
CAJjS0u3VEUawDDGJu0ykfdF7K-PPvsWVwxEBQ7tm7vno35va2A@mail.gmail.com
Ответ на
Re: Planner debug views (Alvaro Herrera)
Список
Дерево обсуждения
Planner debug views Qingqing Zhou <zhouqq.postgres@gmail.com>
Re: Planner debug views Tatsuo Ishii <ishii@postgresql.org>
Re: Planner debug views Qingqing Zhou <zhouqq.postgres@gmail.com>
Re: Planner debug views Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Planner debug views Qingqing Zhou <zhouqq.postgres@gmail.com>
Re: Planner debug views Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Planner debug views Tom Lane <tgl@sss.pgh.pa.us>
Re: Planner debug views Qingqing Zhou <zhouqq.postgres@gmail.com>
Re: Planner debug views Tom Lane <tgl@sss.pgh.pa.us>
Re: Planner debug views Qingqing Zhou <zhouqq.postgres@gmail.com>
Re: Planner debug views Tom Lane <tgl@sss.pgh.pa.us>
Re: Planner debug views Qingqing Zhou <zhouqq.postgres@gmail.com>
Re: Planner debug views Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Planner debug views Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Planner debug views Qingqing Zhou <zhouqq.postgres@gmail.com>
Re: Planner debug views Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Planner debug views Qingqing Zhou <zhouqq.postgres@gmail.com>
On Tue, Jul 28, 2015 at 12:08 PM, Alvaro Herrera
 wrote:
> I would have a tuplestore, and the planner code would push tuples to it.
> After the planning is done, EXPLAIN can read and return tuples from the
> store to the user.
>

Not sure if I got it: so EXPLAIN will return tuples to libpq client. But
how do we store these returned tuples (RelOptInfo, Path etc) so we can
throw queries against them later?

Something like this:
INSERT INTO my_space SELECT (EXPLAIN SELECT ...); -- won't get parsed

Regards,
Qingqing


В списке pgsql-hackers по дате отправления
От: Joe Conway
Дата:
От: David Rowley
Дата:
FAQ