Postgres Pro
Downloads
Home   >   mailing lists

Re: parameterized query much much slower than one with hard-coded string - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: parameterized query much much slower than one with hard-coded string
Date
Msg-id 7810.1320937823@sss.pgh.pa.us
Whole thread Raw
In response to Re: parameterized query much much slower than one with hard-coded string  (Timbo Chen <timbo@powerreviews.com>)
List pgsql-jdbc
Tree view 
Timbo Chen <timbo@powerreviews.com> 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 by date:

Previous
From: Magosányi Árpád
Date:
Subject: Re: SSL patch
Next
From: Dave Cramer
Date:
Subject: Re: SSL patch