Re: Server load statistics

Hallöchen!

hubert depesz lubaczewski writes:

> On Sun, Jul 25, 2010 at 12:15:06PM +0200, Torsten Bronger wrote:
>
>> I need statistics about the PG server load. At the moment, I use
>> for this
>>
>> SELECT tup_returned + tup_fetched + tup_inserted + tup_updated +
>> tup_deleted FROM pg_stat_database WHERE datname='mydb';
>>
>> However, the figures are absurdly high (> 100.000 rows per second).
>> If a "row" is one dataset (one user account, one blog entry, one
>> comment etc), I expect two or three orders of magnitude less. Is my
>> SQL statement nevertheless a good way to measure how busy the server
>> is?
>
> did you rememebr to substract *previous* value of this select?

Yes, I did. I plot curves, and they seem to be proportional to the
load. It's just the absolute values that look very strange.
Additionally, I don't know whether the above sum makes sense at all.

Tschö,
Torsten.

--
Torsten Bronger, aquisgrana, europa vetus
Jabber ID: torsten(dot)bronger(at)jabber(dot)rwth-aachen(dot)de
or http://bronger-jmp.appspot.com