Thanks, works fine! -Souvik
On Mon, Apr 22, 2019 at 12:02 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > Souvik Bhattacherjee <kivu...@gmail.com> writes: > > I was just wondering if it is possible to store the output of EXPLAIN > into > > a table. > > EXPLAIN won't do that directly, but you could make a plpgsql function > along the lines of > > for t in execute explain ... > return next t; > > (too lazy to check the exact details here, but I believe you can find > related examples in our regression tests) and then store the function's > result into a table. > > regards, tom lane >
