| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Mike <ipso(at)snappymail(dot)ca>, Andres Freund <andres(at)anarazel(dot)de>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: machine-readable explain output v4 |
| Date: | 2009-08-12 14:26:41 |
| Message-ID: | 603c8f070908120726r3b9fe62bg6b01214f02a263f4@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Aug 12, 2009 at 10:01 AM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>> Another design issue is this: The root node of an XML document is
>> ideally a distinguished element that can't occur within itself.
>> auto-explain doesn't seem to be doing this.
>
> Huh? I get (for "explain 2+2")
>
> <explain xmlns="http://www.postgresql.org/2009/explain">
> <Query>
> <Plan>
> <Node-Type>Result</Node-Type>
> <Startup-Cost>0.00</Startup-Cost>
> <Total-Cost>0.01</Total-Cost>
> <Plan-Rows>1</Plan-Rows>
> <Plan-Width>0</Plan-Width>
> </Plan>
> </Query>
> </explain>
He's talking about *auto* explain.
...Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre Frédéric Caillaud | 2009-08-12 14:47:31 | Re: COPY speedup |
| Previous Message | Cédric Villemain | 2009-08-12 14:07:04 | expanding our usage of POSIX_FADVISE |