Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: How to tell if SQL function gets inlined?
Date
Msg-id 200311090336.hA93a3814274@candle.pha.pa.us
Whole thread Raw
In response to How to tell if SQL function gets inlined?  (Joe Conway <mail@joeconway.com>)
Responses Re: How to tell if SQL function gets inlined?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073

pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: How to tell if SQL function gets inlined?
Next
From: Tom Lane
Date:
Subject: Re: How to tell if SQL function gets inlined?