Server load statistics
| От | Torsten Bronger |
|---|---|
| Тема | Server load statistics |
| Дата | |
| Msg-id | 87vd83zx3p.fsf@physik.rwth-aachen.de обсуждение |
| Ответы |
Re: Server load statistics
Re: Server load statistics Re: Server load statistics |
| Список | pgsql-general |
Hallöchen!
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?
Tschö,
Torsten.
--
Torsten Bronger, aquisgrana, europa vetus
Jabber ID: torsten.bronger@jabber.rwth-aachen.de
or http://bronger-jmp.appspot.com
В списке pgsql-general по дате отправления: