On Sun, Apr 16, 2006 at 04:32:25PM -0400, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > EXPLAIN ANALYZE doesn't show the slow timing
> > because it requires values, not $n placeholders,
>
> To analyze the plan used for a parameterized query, try
>
> PREPARE foo(...) AS SELECT ... $n ...
>
On Sun, Apr 16, 2006 at 04:32:25PM -0400, Tom Lane wrote:
> To analyze the plan used for a parameterized query, try
>
> PREPARE foo(...) AS SELECT ... $n ...
>
> EXPLAIN ANALYZE EXECUTE foo(...)
>
> But I already know what you're going to find: the planner's estimates
> for the rang
[EMAIL PROTECTED] writes:
> EXPLAIN ANALYZE doesn't show the slow timing
> because it requires values, not $n placeholders,
To analyze the plan used for a parameterized query, try
PREPARE foo(...) AS SELECT ... $n ...
EXPLAIN ANALYZE EXECUTE foo(...)
But I already know what you'
