Re: EXPLAIN doesn't show the actual function expression for FunctionScan - Mailing list pgsql-hackers

From Robert Haas
Subject Re: EXPLAIN doesn't show the actual function expression for FunctionScan
Date
Msg-id AANLkTikmRHeTCJK7vUOdG1fYoep_H8BpFs7HMrnNSZo0@mail.gmail.com
Whole thread Raw
In response to Re: EXPLAIN doesn't show the actual function expression for FunctionScan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Aug 24, 2010 at 1:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Greg Stark <gsstark@mit.edu> writes:
>> On Tue, Aug 24, 2010 at 5:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>>  Function Scan on pg_catalog.unnest f  (cost=0.00..1.50 rows=100 width=96)
>>>   Output: (((lv)::text || op) || (rv)::text)
>>>   Function Call: unnest(ARRAY[ROW(('1.2.2'::text)::semver, '='::text, ('1.2.2'::text)::semver), ROW('1.2.23', '=',
'1.2.23')])
>
>> This may be the ultimate bike-shed but Wouldn't this be clearer the
>> other way around? I generally think input comes first and then output.
>
> The order was bothering me a bit too, but there's a generic decision
> in there that the tlist is shown before any node-type-specific items.
> Not sure that we want to move it to the bottom for all of them.

I don't think we do.  Although, it has seemed to me at times that we
might want to have "output" be controlled by its own EXPLAIN option.

EXPLAIN (VERBOSE on, OUTPUT off) ...

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Typing Records
Next
From: Robert Haas
Date:
Subject: Re: [ADMIN] Unable to drop role