Le 05/04/2013 16:17, Merlin Moncure a écrit :
>
> Ok, "explain" (without analyze) is measuring plan time only (not
> execution time). Can you confirm that's the time we are measuring
> (and again, according to what)? Performance issues here are a
> different ball game. Please supply precise version#, there were a
> couple of plantime bugs fixed recently.
>
> merlin
Yes, I confirm time is taken by analyze alone. Executing the query is quick.
PG version is 8.4.8.
Franck