Re: Query is taking 5 HOURS to Complete on 8.1 version - Mailing list pgsql-performance

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