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