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 по дате отправления: