Re: machine-readable explain output - Mailing list pgsql-hackers

From Robert Haas
Subject Re: machine-readable explain output
Date
Msg-id 603c8f070906121045t32c10021l7421396f294f516b@mail.gmail.com
Whole thread Raw
In response to Re: machine-readable explain output  (Josh Berkus <josh@agliodbs.com>)
Responses Re: machine-readable explain output
List pgsql-hackers
On Fri, Jun 12, 2009 at 11:47 AM, Josh Berkus<josh@agliodbs.com> wrote:
> On 6/11/09 10:15 PM, Robert Haas wrote:
>>
>> Here we go, XML and JSON output.
>>
>> You will need to apply explain_refactor-v4.patch and
>> explain_options-v2.patch first, then apply the two patches attached to
>> this message.
>
> Wow, cool.  Can this work with auto_explain?  That's where I see
> machine-readable being most useful.

The patch does touch contrib/auto_explain, but just enough to make it
keep working the same way it does now.  I don't think it would be too
hard to improve on that, though; I might work on it if I get bored,
but I'm hoping someone else will be motivated enough to do that part.
:-)

How would you go about extracting the XML/JSON bits from the rest of
what is in the log file?  (apologies if this is a question I should
already know the answer to)

...Robert


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with listen_addresses = '*' on 8.4beta2 on AIX
Next
From: Josh Berkus
Date:
Subject: Re: machine-readable explain output