patrick ~ <sidsrr(at)yahoo(dot)com> 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