Postgres Pro
Downloads
Home   >   mailing lists

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

From Oliver Jowett
Subject Re: parameterized query much much slower than one with hard-coded string
Date
Msg-id CA+0W9LP70SVmTkE17SjnoDqmqizQdo7KJ7=MbvdvHSCJXU8Evw@mail.gmail.com
Whole thread Raw
In response to parameterized query much much slower than one with hard-coded string  (Timbo Chen <timbo@powerreviews.com>)
List pgsql-jdbc
Tree view 
On 10 November 2011 21:30, Timbo Chen <timbo@powerreviews.com> wrote:
> 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.

Run the EXPLAIN ANALYZE via a prepared statement that's parameterized
in the same way. You get the output back as a separate resultset IIRC

Oliver

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: parameterized query much much slower than one with hard-coded string
Next
From: Timbo Chen
Date:
Subject: Re: parameterized query much much slower than one with hard-coded string