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

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