Postgres Pro
Downloads
Home   >   mailing lists

Is it possible to store the output of EXPLAIN into a table - Mailing list pgsql-general

From Souvik Bhattacherjee
Subject Is it possible to store the output of EXPLAIN into a table
Date
Msg-id CAANrPSdL9YpU0hqm=YfPUQKHVXrSCVTRO-5QekEDdEmNv5UbEA@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: cache lookup failed for function 1 on fmgr_info_cxt_security,fmgr.c:184
Next
From: Scot Kreienkamp
Date:
Subject: RE: Streaming Replication