About pg_stat_activity

From: Cesar Arrieta <cesar(dot)cba(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: About pg_stat_activity
Date: 2011-02-02 15:21:47
Message-ID: AANLkTi=XvdtT0mDQC1CmU=GwzhhbCKuhVvxRMzTN2_Ki@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2011-02-02 16:03:37 Re: [PERFORM] Slow count(*) again...
Previous Message Noah Misch 2011-02-02 05:20:04 Re: Exhaustive list of what takes what locks