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

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: parameterized query much much slower than one with hard-coded string
Дата
Msg-id
7810.1320937823@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
parameterized query much much slower than one with hard-coded string Timbo Chen <timbo@powerreviews.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 Timbo Chen <timbo@powerreviews.com>
Re: parameterized query much much slower than one with hard-coded string Tom Lane <tgl@sss.pgh.pa.us>
Re: parameterized query much much slower than one with hard-coded string Oliver Jowett <oliver@opencloud.com>
Timbo Chen  writes:
> just wondering if there was a way to get the execution plan for the
> prepared statement.

Prepare an equivalently-parameterized statement by hand:

PREPARE foo(int,text,...) AS ...

and then do EXPLAIN [ANALYZE] EXECUTE foo(...)

			regards, tom lane
В списке pgsql-jdbc по дате отправления
От: Magosányi Árpád
Дата:
Сообщение: Re: SSL patch
От: Dave Cramer
Дата:
Сообщение: Re: SSL patch
FAQ