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

From: Timbo Chen <timbo(at)powerreviews(dot)com>
To: Oliver Jowett <oliver(at)opencloud(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 08:30:05
Message-ID: CAOerExAU5NRQH-YVkUoPPz+LniyyqYTNSFCs6KqmJMaoTRq-eg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(at)opencloud(dot)com> wrote:

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2011-11-10 12:35:56 Re: parameterized query much much slower than one with hard-coded string
Previous Message Oliver Jowett 2011-11-10 05:57:41 Re: parameterized query much much slower than one with hard-coded string