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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
