About pg_stat_activity

Поиск
Список
Период
Сортировка
От Cesar Arrieta
Тема About pg_stat_activity
Дата
Msg-id AANLkTi=XvdtT0mDQC1CmU=GwzhhbCKuhVvxRMzTN2_Ki@mail.gmail.com
обсуждение исходный текст
Ответы monitoring querys Re: About pg_stat_activity  (Jens Wilke <jens.wilke@affinitas.de>)
Re: About pg_stat_activity  (Maciek Sakrejda <msakrejda@truviso.com>)
Re: About pg_stat_activity  (Greg Smith <greg@2ndquadrant.com>)
Список pgsql-performance
Hi, im César, im developing an app that saves information included in "pg_stat_activity" view in order to monitor querys. The objective of this app is to gather information about querys that take to long to finish and overload the server. I was wandering if I could see somehwere the implementation of "pg_stat_activity" view, in order to not save the information in another table, I need to use historical information about querys.
If you could help looking about this, or if you know about an app that already do this, please let me know.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Samuel Gendler
Дата:
Сообщение: Re: [HACKERS] Slow count(*) again...
Следующее
От: Jens Wilke
Дата:
Сообщение: monitoring querys Re: About pg_stat_activity