Обсуждение: Performance counters?

Поиск
Список
Период
Сортировка

Performance counters?

От
"Cestmir Hybl"
Дата:
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?

От
Richard Huxton
Дата:
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