Postgres Pro
Downloads
Home   >   mailing lists

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

From Timbo Chen
Subject Re: parameterized query much much slower than one with hard-coded string
Date
Msg-id CAOerExAU5NRQH-YVkUoPPz+LniyyqYTNSFCs6KqmJMaoTRq-eg@mail.gmail.com
Whole thread Raw
In response to Re: parameterized query much much slower than one with hard-coded string  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: parameterized query much much slower than one with hard-coded string
List pgsql-jdbc
Tree view
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 by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: parameterized query much much slower than one with hard-coded string
Next
From: Dave Cramer
Date:
Subject: Re: SSL patch