smiley2211 wrote:
> TOP shows CPU at 100% while executed the EXPLAIN ANALYZE...what does this
> mean?
>
> 17519 postgres 25 0 3470m 43m 39m R 100 0.3 28:50.53 postmaster

It means it's busy. Probably sorting/eliminating duplicates (see my
answer posted just before this one).

Keep an eye on "vmstat" too and see if there's much disk activity.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster