patrick ~ <[EMAIL PROTECTED]> writes:
> PREPARE pkk_00 ( integer ) <the def of pkk_offer_has_pending_purc( integer )
This is what you want to do, but not quite like that. The PREPARE
determines the plan and so VACUUMing and re-EXECUTing is going to show
the same plan. What we need to look at is
- standing start
PREPARE pkk_00 ...
EXPLAIN ANALYZE EXECUTE pkk_00 ...
VACUUM ANALYZE;
PREPARE pkk_01 ...
EXPLAIN ANALYZE EXECUTE pkk_01 ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
