Re: EXPLAIN BUFFERS

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>
To: Greg Smith <greg@2ndquadrant.com>
Cc: Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>, Euler Taveira de Oliveira <euler@timbira.com>, Jeff Janes <jeff.janes@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2009-12-08T10:46:04Z
Lists: pgsql-hackers
On Dec 8, 2009, at 12:05 AM, Greg Smith <greg@2ndquadrant.com> wrote:

> Robert Haas wrote:
>> I could live with the equals signs, but the use of parentheses seems
>> weird and inconsistent with normal english usage (which permits
>> parentheses as a means of making parenthetical comments).
> But it is consistent with people seeing:
>
> Seq Scan on foo (cost=0.00..155.00 rows=10000 width=4)
>
> Which seems to be what was being emulated here.  I though that was  
> pretty reasonable given this is a related feature.

It's not the same at all. The essence of a parenthetical phrase is  
that it can be omitted without turning what's left into nonsense - and  
in fact we have COSTS OFF, which does just that. Omitting only the  
parenthesized portions of the proposed output would not be sensible.

...Robert