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

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Query is taking 5 HOURS to Complete on 8.1 version
Дата
Msg-id 468AB180.9090503@archonet.com
обсуждение исходный текст
Ответ на Re: Query is taking 5 HOURS to Complete on 8.1 version  (smiley2211 <smiley2211@yahoo.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Query is taking 5 HOURS to Complete on 8.1 version
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Filesystem Direct I/O and WAL sync option