Re: Query is taking 5 HOURS to Complete on 8.1 version

From: Richard Huxton <dev(at)archonet(dot)com>
To: smiley2211 <smiley2211(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query is taking 5 HOURS to Complete on 8.1 version
Date: 2007-07-03 20:28:48
Message-ID: 468AB180.9090503@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stark 2007-07-04 01:13:02 Re: Filesystem Direct I/O and WAL sync option
Previous Message Richard Huxton 2007-07-03 20:27:01 Re: Query is taking 5 HOURS to Complete on 8.1 version