Re: JDBC/Stored procedure performance issue

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Matthew Lunnon <mlunnon(at)rwa-net(dot)co(dot)uk> writes:
> Is there any way to work out what plan the query is using in side the 
> function?  I think I have a similar problem with a query taking much 
> longer from inside a function than it does as a select statement.

Standard approach is to PREPARE a statement that has parameters in the
same places where the function uses variables/parameters, and then use
EXPLAIN [ANALYZE] EXECUTE to test it.

			regards, tom lane