Re: parameterized query much much slower than one with hard-coded string

Поиск
Список
Период
Сортировка
От Timbo Chen
Тема Re: parameterized query much much slower than one with hard-coded string
Дата
Msg-id CAOerExAU5NRQH-YVkUoPPz+LniyyqYTNSFCs6KqmJMaoTRq-eg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: parameterized query much much slower than one with hard-coded string  (Oliver Jowett <oliver@opencloud.com>)
Ответы Re: parameterized query much much slower than one with hard-coded string  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-jdbc
Дерево обсуждения
i did do an explain analyze on the query by running the query directly on the database.
just wondering if there was a way to get the execution plan for the prepared statement.

On Wed, Nov 9, 2011 at 9:57 PM, Oliver Jowett <oliver@opencloud.com> wrote:
On 10 November 2011 17:44, Timbo Chen <timbo@powerreviews.com> wrote:
> what could be the possible reason that these 2 nearly identical queries have
> such different performance?

> different execution plans?

Yes.

> how would i find out what the actual execution
> plan was?

EXPLAIN ANALYZE?

Oliver

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

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: parameterized query much much slower than one with hard-coded string
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: SSL patch