Re: More WITH - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: More WITH
Date
Msg-id 55D21D6E.30202@dunslane.net
Whole thread Raw
In response to Re: More WITH  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers

On 08/17/2015 01:30 PM, Peter Geoghegan wrote:
> On Mon, Aug 17, 2015 at 10:22 AM, Josh Berkus <josh@agliodbs.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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: More WITH
Next
From: Dmitry Dolgov
Date:
Subject: jsonb array-style subscripting