Обсуждение: Howto get tranaction rate in postgres
Hello,
I've been asked to give the transaction rate of a deployed system. How can I mesure this in postgres. Could not find anything in the documentation. Are there any tools for this.
Thanx for your help
Marco
On Tue, May 23, 2006 at 09:18:19AM +0200, Meyer Marco wrote: > I've been asked to give the transaction rate of a deployed system. How > can I mesure this in postgres. Could not find anything in the > documentation. Are there any tools for this. What transaction rate? The current rate over some time interval? The maximum possible rate for a particular set of statements? What are you trying to measure? -- Michael Fuhr
Hi, I mean the transactions over time interval. Say the current db transactions per minute. Thanks Marco -----Original Message----- From: Michael Fuhr [mailto:mike@fuhr.org] Sent: Tuesday, May 23, 2006 3:41 PM To: Meyer Marco Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Howto get tranaction rate in postgres On Tue, May 23, 2006 at 09:18:19AM +0200, Meyer Marco wrote: > I've been asked to give the transaction rate of a deployed system. How > can I mesure this in postgres. Could not find anything in the > documentation. Are there any tools for this. What transaction rate? The current rate over some time interval? The maximum possible rate for a particular set of statements? What are you trying to measure? -- Michael Fuhr
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