Re: How to tell if SQL function gets inlined?

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

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. You can
change client_min_messages to see that in your psql session. I think
the parse tree doesn't do the inlining, only the optimizer.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-11-09 04:00:36 Re: How to tell if SQL function gets inlined?
Previous Message Bruce Momjian 2003-11-09 03:16:53 Re: Bug fix for 7.4?