Re: How to tell if SQL function gets inlined?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to tell if SQL function gets inlined?
Дата
Msg-id 667.1068350436@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to tell if SQL function gets inlined?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Joe Conway wrote:
>> Is there any way, short of using a debugger with a strategically placed 
>> breakpoint, to tell if a SQL function has been inlined?

> I think you will only see it with debug_print_plan enabled.

If the function is in the WHERE clause then you can see it in EXPLAIN
output.  Functions in the SELECT list you can't see without wading
through EXPLAIN VERBOSE (or equivalently debug_print_plan).
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: How to tell if SQL function gets inlined?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Call for port reports