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

From Alvaro Herrera
Subject Re: EXPLAIN doesn't show the actual function expression for FunctionScan
Date
Msg-id 1282664935-sup-4334@alvh.no-ip.org
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
Excerpts from Tom Lane's message of mar ago 24 11:36:50 -0400 2010:
> Andres Freund <andres@anarazel.de> writes:
> > On Tuesday 24 August 2010 16:40:30 Tom Lane wrote:
> >> So I got annoyed by $SUBJECT just now while chasing Wheeler's bug
> >> report.  Seems like this would be a good thing to print.  Should
> >> it appear always, or just with VERBOSE, or ???
> 
> > I vote for only showing it with verbose
> 
> That'd be fine with me.  The lack of prior complaints suggests that
> most of the time people don't need it.

Yeah, and if the expression is large, it could get cumbersome (consider
crosstab functions which are often called with large gobs of text).  On
the other hand, the same case makes it very useful to have the text for
further research on query behavior.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Typing Records
Next
From: Tom Lane
Date:
Subject: Re: EXPLAIN doesn't show the actual function expression for FunctionScan