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.bronger@xxxxxxxxxxxxxxxxxxxxx
or http://bronger-jmp.appspot.com
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
