Usage of pg_stat_database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux