Chris Hoover написа: > Is there an easy way to get a count on the number of transactions postgres > is processing a min/hour/day/etc.? If so, can it be broken down by the > individual databases in the cluster? > > Thanks, > > Chris >
You could monitor the "xact_commit" column from the "pg_stat_database" system view. More info here - http://www.postgresql.org/docs/8.1/static/monitoring-stats.html#MONITORING-STATS-VIEWS -- Milen A. Radev ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
