Re: How to analyze load average ? - Mailing list pgsql-general

From Kevin Grittner
Subject Re: How to analyze load average ?
Date
Msg-id 501FB7B40200002500049443@gw.wicourts.gov
Whole thread Raw
In response to Re: How to analyze load average ?  (Condor <condor@stz-bg.com>)
List 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 by date:

Previous
From: Condor
Date:
Subject: Re: How to analyze load average ?
Next
From: Ben Chobot
Date:
Subject: Re: maximum number of databases and / or schemas in a single database instance