Re: machine-readable explain output v2

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: machine-readable explain output v2
Date: 2009-07-19 02:29:42
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-hackers

Hi Robert, Hi all,

Applies cleanly, code changes look sensible, no behaviour changes.

Applies after trivial conflicts (updated version attached). Once more the code
changes look sensible to me, except maybe that I don't like the codeflow at
some parts. That's partially related due to having to generate xml/json output
by hand...

One part where I find the code flow ugly is 'did_boilerplate' in
report_triggers/its callsites.
I can see why it is done that way, but its not exactly obvious to read when
you want to find out how the format looks.

Another, minor, issue is that the patch changes the FORMAT TEXT/default output
if VERBOSE is specified (schema is added). I don't see that as a real problem
because the format for VERBOSE is new anyway, but I thought I would mention

XML Format:
As discussed previously I would like the format to look a bit different - but
everyone wants it to look different anyway, so I think its ok as one of
multiple possible lowest common determinators... With the big advantage of
already being implemented.

I think it would be nice in the future to add some sort of
'category={planner,timing,..}' attribute, but I think that should be
discussed/implemented separately.

I think it would be nice to add some more documentation about the xml format
for application writers, but I think this should be a separate patch anyway.

I did not yet look at the contrib/autoexplain portions. Will do that on Monday
or so.


Attachment Content-Type Size
explain_format-v2_updated.patch text/x-patch 63.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-07-19 02:30:33 Re: Using results from INSERT ... RETURNING
Previous Message Andres Freund 2009-07-19 01:15:49 Re: explain refactoring v4 - RR Review