вторник, 23 июня 2009 г.

Postgresql transaction counter (transactions per second)

There are transactions counters for each database in a cluster.

If you want to find out how many transactions has your system generated at the moment, you should connect to any database as a superuser (postgres) and

select sum(xact_commit) from pg_stat_database;

Easy, but took some time to find the recipe.

2 комментария:

VanOk комментирует...

Privet, smojesh pomoch' v sozdanii addona k igre? Ochen' nujen chelovek znayshchii Python. Vot tol'ko takogo cheloveka nikak ne naiti.

Anton комментирует...

Kak s toboy svyazat'sya?