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	April 22, 2019 18:27:18
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 Re: Is it possible to store the output of EXPLAIN into a table Re: Is it possible to store the output of EXPLAIN into a table Re: Is it possible to store the output of EXPLAIN into a table
List	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

From: Adrian Klaver
Date: 22 April 2019, 17:05:15
Subject: Re: cache lookup failed for function 1 on fmgr_info_cxt_security,fmgr.c:184

From: Scot Kreienkamp
Date: 22 April 2019, 18:30:01
Subject: RE: Streaming Replication