Re: How to analyze load average ?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: How to analyze load average ?
Дата
Msg-id 501FB7B40200002500049443@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: How to analyze load average ?  (Condor <condor@stz-bg.com>)
Список pgsql-general
Condor <condor@stz-bg.com> wrote:

> For that reason Im asking is there a way to detect why my load avg
> is 0.88. When I run select * from pg_stat_activity;

So, on a 32 core system if you run vmstat or iostat with a short
interval during such an episode, you should be seeing about 97% idle
time for your CPUs.  If you want to know what's sucking up the other
3%, you might want to try oprofile.

-Kevin

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

Предыдущее
От: Condor
Дата:
Сообщение: Re: How to analyze load average ?
Следующее
От: Ben Chobot
Дата:
Сообщение: Re: maximum number of databases and / or schemas in a single database instance