Re: [PERFORM] Usage of pg_stat_database

2011-10-27 Thread Amitabh Kant
Thanks Jeff. This should help in getting a fairly approximate values. Amitabh On Fri, Oct 28, 2011 at 11:24 AM, Jeff Davis wrote: > On Mon, 2011-10-24 at 19:34 +0530, Amitabh Kant wrote: > > If I read the xact_commit field returned by "Select * from > > pg_stat_database" multiple times, and the

Re: [PERFORM] Usage of pg_stat_database

2011-10-27 Thread Jeff Davis
On Mon, 2011-10-24 at 19:34 +0530, Amitabh Kant wrote: > If I read the xact_commit field returned by "Select * from > pg_stat_database" multiple times, and then average the difference > between consecutive values, would this give an approx idea about the > transactions per second in my database?