Cesar Arrieta wrote:
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 hope you're already setting log_min_duration_
>I was wandering if I could see somehwere the implementation of
>"pg_stat_activity" view
>From psql
\d+ pg_stat_activity
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
www.truviso.com
--
Sent via pgsql-performance mailing list (pgsql-
On Wednesday 02 February 2011 16:21:47 Cesar Arrieta wrote:
Hi,
> If you could help looking about this, or if you know about an app that
> already do this, please let me know.
have a look for http://pgfouine.projects.postgresql.org/
and http://pgfoundry.org/projects/pgstatspack/
HTH,
Jens
--
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
