Usage of pg_stat_database

From: Amitabh Kant <amitabhkant(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Usage of pg_stat_database
Date: 2011-10-24 14:04:20
Message-ID: CAPTAQBJOzWw+rY1gaq1Uppcx5k7O2BZ8PoiJAGyFHpDco_e4yg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message alan 2011-10-24 14:08:45 Re: delete/recreate indexes
Previous Message Venkat Balaji 2011-10-24 12:16:41 Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter