Usage of pg_stat_database - Mailing list pgsql-performance

From Amitabh Kant
Subject Usage of pg_stat_database
Date
Msg-id CAPTAQBJOzWw+rY1gaq1Uppcx5k7O2BZ8PoiJAGyFHpDco_e4yg@mail.gmail.com
Whole thread Raw
Responses Re: Usage of pg_stat_database
List pgsql-performance
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? 

Does this figure include the number of select statements being executed in the db? 


With regards

Amitabh

pgsql-performance by date:

Previous
From: Stephen Frost
Date:
Subject: Re: hstore query: Any better idea than adding more memory?
Next
From: Amitabh Kant
Date:
Subject: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server