Re: How to analyze load average ?

From: Condor <condor(at)stz-bg(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to analyze load average ?
Date: 2012-08-06 17:06:05
Message-ID: 2226b9556b969afd3ce63230acb0ea26@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2012-08-06 17:38, Tomas Vondra wrote:
> On 6 Srpen 2012, 16:23, Condor wrote:
>> Hello,
>>
>> can some tell me, how I can analyze from where my server bring up
>> load
>> average ?
>>
>> ...
>>
>> When I connect to server i see only 2 query with select * from
>> pg_stat_activity;
>> that is not complicated, select rid from table where id = 1;
>> Both tables have index on most frequently columns. When I check my
>> server load average is 0.88 0.94 0.87
>>
>>...
>>
>> Any one can tell me how I can find from where that load average is
>> so
>> high ?
>
> Errr, what? Why do you think the load average is high?
>
> Load average is defined as a number of processes in the run queue
> (i.e.
> using or waiting for a CPU). So the load average "0.88 0.94 0.87"
> means
> there was less than one process waiting for CPU most of the time. I
> wouldn't call that "high load average", especially not on a 32-core
> system.
>
> Tomas

I think load avg is high because before I change the servers my produce
server
was on 16 cpu, 24 gb memory and load avg on that server was 0.24.
Database is the same,
users that use the server is the same, nothing is changed. I dump the
DB from old server
and import it to new one before few days ago and because that is the
new server with more
resource I monitor his load avg and I think is too high. 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;
did not see more then 3-4 query that isn't much complicated and I
already try them with
explain to see what is the result.

I know what load average mean, I was OpenBSD user a few years, now I
use Slackware with kernel 3.5.

Hristo

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2012-08-06 17:21:49 Mailsystem maintenance/migration announcement
Previous Message Rodrigo Gonzalez 2012-08-06 16:54:05 Re: Where is diskchecker.pl ?