On May 12, 2010, at 9:12 AM, Melvin Davidson wrote:
| Can anyone tell me how to measure _actual_ transactions per minute on a PostgreSQL server. I am not talking about using pgbench, as I am not interested in determining what is possible, but rather the actual count of queries / transactions being sent to the server. |
We log query durations, and then use net-snmp to count the amount of query durations we see per second. Now, granted, that's queries, not transactions, and it's not particularly elegant..... but it's pretty effective and is surprisingly more efficient than I assumed it would be before we tried it.