Re: auto_explain produces invalid JSON - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: auto_explain produces invalid JSON
Date
Msg-id 4F36DD1F.8010609@dunslane.net
Whole thread Raw
In response to Re: auto_explain produces invalid JSON  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On 02/11/2012 03:22 PM, Tom Lane wrote:
> Andrew Dunstan<andrew@dunslane.net>  writes:
>> But ExplainBeginOutput says:
>>        case EXPLAIN_FORMAT_JSON:
>>             /* top-level structure is an array of plans */
>>             appendStringInfoChar(es->str, '[');
>> Now that's not true in the auto-explain case, which prints one query +
>> one plan.
> What about queries that expand to multiple plans because of rules?

Oh, hmm, good point.


>
>> Since this is an exposed API, I don't think we can just change it. We
>> probably need a new API that does the right thing for beginning and
>> ending auto_explain output. (ExplainBeginLabeledOutput?)
> I'm inclined to think that this is auto_explain's error, not that of
> the core code, ie we should be changing the output.
>
>             


It looks like it will be messy either way. ;-(

cheers

andrew





pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: auto_explain produces invalid JSON
Next
From: Andrew Dunstan
Date:
Subject: Re: auto_explain produces invalid JSON