Re: How to tell if SQL function gets inlined?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Joe Conway <mail(at)joeconway(dot)com>, "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: How to tell if SQL function gets inlined?
Date: 2003-11-09 04:00:36
Message-ID: 667.1068350436@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-11-09 04:02:37 Re: Call for port reports
Previous Message Bruce Momjian 2003-11-09 03:36:03 Re: How to tell if SQL function gets inlined?