Re: How to analyze load average ?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-general(at)postgresql(dot)org>,"Condor" <condor(at)stz-bg(dot)com>
Subject: Re: How to analyze load average ?
Date: 2012-08-06 17:25:24
Message-ID: 501FB7B40200002500049443@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Condor <condor(at)stz-bg(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2012-08-06 17:26:28 Re: maximum number of databases and / or schemas in a single database instance
Previous Message Stefan Kaltenbrunner 2012-08-06 17:21:49 Mailsystem maintenance/migration announcement