Performance counters? - Mailing list pgsql-general

From Cestmir Hybl
Subject Performance counters?
Date
Msg-id 058501c577f6$f2654370$131fc39e@stratos
Whole thread Raw
Responses Re: Performance counters?
List pgsql-general
Hello
 
Does psql maintain some sort of global performance counters?
 
We are interested mainly in following counters (cumulative, by all psql processes):
- cpu time by all backends
- sql queries count
- fsync count
- disk reads / disk bytes read
- disk writes / disk bytes written
- transaction commit count
- client connect count
- client disconnect count
- backend start count
- backend terminate count
 
We intend to use these counters (their differences for fixed time periods) for monitoring and reporting purposes.
 
 
Thanks,
 
Cestmir Hybl

pgsql-general by date:

Previous
From: Hugo
Date:
Subject: Re: setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows
Next
From: Bjørn T Johansen
Date:
Subject: Re: Changing password for the postgres user?