Re: EXPLAIN doesn't show the actual function expression for FunctionScan

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: EXPLAIN doesn't show the actual function expression for FunctionScan
Дата
Msg-id 1282664935-sup-4334@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: EXPLAIN doesn't show the actual function expression for FunctionScan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Typing Records
Следующее
От: Tom Lane
Дата:
Сообщение: Re: EXPLAIN doesn't show the actual function expression for FunctionScan