Re: auto_explain produces invalid JSON
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-02-13T16:15:10Z
Lists: pgsql-hackers
[ sorry for ignoring this over the weekend --- I wasn't feeling very well ] Andrew Dunstan <andrew@dunslane.net> writes: > On 02/11/2012 03:22 PM, Tom Lane wrote: >> 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. > Well, maybe this is more to your taste, although it strikes me as more > than something of a kludge. At least it's short :-) I see you've already committed this, but I agree that it's quite a kluge. After looking a bit more at the existing explain code, it seems like the critical issue is that explain.c has ExplainOpenGroup/ExplainCloseGroup calls around the ExplainPrintPlan call (see ExplainOnePlan), while auto_explain does not. I did not like your originally proposed patch because it seemed to introduce yet another formatting concept into code that has already got a few too many. But couldn't we fix this by exporting ExplainOpenGroup/ExplainCloseGroup and then calling those from auto_explain? regards, tom lane