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
In response to
pgsql-performance by date
|Next:||From: Andrew Sullivan||Date: 2008-01-29 18:09:26|
|Subject: Re: analyze|
|Previous:||From: Matthew Lunnon||Date: 2008-01-29 17:38:13|
|Subject: Re: Performance problems inside a stored procedure.|