Re: How to tell if SQL function gets inlined? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to tell if SQL function gets inlined?
Date
Msg-id 667.1068350436@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to tell if SQL function gets inlined?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: How to tell if SQL function gets inlined?
Next
From: Tom Lane
Date:
Subject: Re: Call for port reports