Re: Count actual transaction per minute?
| От | hubert depesz lubaczewski |
|---|---|
| Тема | Re: Count actual transaction per minute? |
| Дата | |
| Msg-id | 20100512162004.GA29780@depesz.com обсуждение исходный текст |
| Ответ на | Count actual transaction per minute? (Melvin Davidson <melvin6925@yahoo.com>) |
| Ответы |
Re: Count actual transaction per minute?
|
| Список | pgsql-general |
On Wed, May 12, 2010 at 09:12:43AM -0700, Melvin Davidson wrote: > Can anyone tell me how to measure _actual_ transactions per minute on a PostgreSQL server. I am not talking about usingpgbench, as I am not interested in determining what is possible, but rather the actual count of queries / transactionsbeing sent to the server. sure. run: select sum(xact_commit + xact_rollback) from pg_stat_database every minute, substract previous result from current, and you'll know your current tpm. Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
В списке pgsql-general по дате отправления: