From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Peter Geoghegan <pg(at)heroku(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: More WITH |
Date: | 2015-08-17 17:44:14 |
Message-ID: | 55D21D6E.30202@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 08/17/2015 01:30 PM, Peter Geoghegan wrote:
> On Mon, Aug 17, 2015 at 10:22 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> Would be tricky. We don't currently have any way to wrap an EXPLAIN in
>> any larger statement, do we? Would be very useful for automated query
>> analysis, though.
> No. In the grammar, ExplainStmt expects the EXPLAIN to be at the
> top-level. Having it work any other way would require significant
> refactoring.
>
Slightly apropos, I have wrapped EXPLAIN calls inside a function, such
as one that gets back the result and then sends it off to
http://explain.depesz.com, returning the URL
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Dolgov | 2015-08-17 17:57:48 | jsonb array-style subscripting |
Previous Message | Tom Lane | 2015-08-17 17:41:06 | Re: More WITH |