Is it possible to store the output of EXPLAIN into a table

Поиск
Список
Период
Сортировка
От Souvik Bhattacherjee
Тема Is it possible to store the output of EXPLAIN into a table
Дата
Msg-id CAANrPSdL9YpU0hqm=YfPUQKHVXrSCVTRO-5QekEDdEmNv5UbEA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Is it possible to store the output of EXPLAIN into a table  (Bruce Momjian <bruce@momjian.us>)
Re: Is it possible to store the output of EXPLAIN into a table  (Thomas Kellerer <spam_eater@gmx.net>)
Re: Is it possible to store the output of EXPLAIN into a table  (Thomas Kellerer <spam_eater@gmx.net>)
Re: Is it possible to store the output of EXPLAIN into a table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
Hi,

I was just wondering if it is possible to store the output of EXPLAIN into a table.

create temp table mytab as (select * from (explain select * from table1 where attr = 5) t);


Unfortunately, the query above does not work.


Thanks,

-Souvik

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: cache lookup failed for function 1 on fmgr_info_cxt_security,fmgr.c:184
Следующее
От: Scot Kreienkamp
Дата:
Сообщение: RE: Streaming Replication