patrick ~ <sidsrr@xxxxxxxxx> 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
