Postgres Pro
Downloads
Home   >   mailing lists

Thread: Performance counters?

Performance counters?

From
"Cestmir Hybl"
Date:
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

Re: Performance counters?

From
Richard Huxton
Date:
Cestmir Hybl wrote:
> Hello
>
> Does psql maintain some sort of global performance counters?

Chapter 23. Monitoring Database Activity

You will want to combine the built-in stats with ps/logfile reading to
get all the figures you want.
--
   Richard Huxton
   Archonet Ltd