About pg_stat_activity - Mailing list pgsql-performance

From Cesar Arrieta
Subject About pg_stat_activity
Date
Msg-id AANLkTi=XvdtT0mDQC1CmU=GwzhhbCKuhVvxRMzTN2_Ki@mail.gmail.com
Whole thread Raw
Responses monitoring querys Re: About pg_stat_activity
Re: About pg_stat_activity
Re: About pg_stat_activity
List 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 by date:

Previous
From: Samuel Gendler
Date:
Subject: Re: [HACKERS] Slow count(*) again...
Next
From: Jens Wilke
Date:
Subject: monitoring querys Re: About pg_stat_activity