Re: Howto get tranaction rate in postgres

On Tue, May 23, 2006 at 03:49:20PM +0200, Meyer Marco wrote:
> I mean the transactions over time interval. Say the current db
> transactions per minute.

See the "Monitoring Database Activity" chapter in the documentation:

http://www.postgresql.org/docs/8.1/interactive/monitoring.html

One way would be to query pg_stat_database periodically and track
how fast xact_commit and xact_rollback are changing.  With monitoring
software like MRTG you could write a script to query pg_stat_database
and let the monitor track the rate of change and draw activity graphs.

Pgfouine generates usage reports but I haven't used it so I don't
know anything about it other than what its web site says.  See
"Sample reports" at the following link:

http://pgfouine.projects.postgresql.org/

--
Michael Fuhr