Re: JDBC/Stored procedure performance issue

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: JDBC/Stored procedure performance issue
Дата
Msg-id 23231.1201630130@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: JDBC/Stored procedure performance issue  (Matthew Lunnon <mlunnon@rwa-net.co.uk>)
Список pgsql-performance
Matthew Lunnon <mlunnon@rwa-net.co.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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Matthew Lunnon
Дата:
Сообщение: Re: Performance problems inside a stored procedure.
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: analyze