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

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Timbo Chen <timbo(at)powerreviews(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: parameterized query much much slower than one with hard-coded string
Date: 2011-11-10 12:35:56
Message-ID: CA+0W9LP70SVmTkE17SjnoDqmqizQdo7KJ7=MbvdvHSCJXU8Evw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 10 November 2011 21:30, Timbo Chen <timbo(at)powerreviews(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2011-11-10 13:56:34 Re: SSL patch
Previous Message Timbo Chen 2011-11-10 08:30:05 Re: parameterized query much much slower than one with hard-coded string