Thread: [ pgsql-monitoring ]

[ pgsql-monitoring ]

From
Osvâneo A. Ferreira
Date:
Hi,
 
I has a dinamic application, constructed on php, connecting in db postgres 7.2.
I would like monitor the all established connection. I want know whish command is running at moment.
 
Help, please !!!
 
Osvâneo A. Ferreira
 
 

Re: [ pgsql-monitoring ]

From
Andrew Sullivan
Date:
On Tue, Nov 05, 2002 at 06:48:30PM -0200, Osv?neo A.  Ferreira wrote:
> Hi,
> 
> I has a dinamic application, constructed on php, connecting in db postgres 7.2.
> I would like monitor the all established connection. I want know whish command is running at moment.
> 
> Help, please !!!

Check out pg_monitor (go to gborg.postgresql.org).  Also, this sort
of question belongs on -general.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8                                        +1 416 646 3304
x110



Re: [ pgsql-monitoring ]

From
"Christopher Kings-Lynne"
Date:
Turn on query monitoring in the postgresql.conf and then go:
 
select * from pg_stat_activity;
 
Chris
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Osvâneo A. Ferreira
Sent: Wednesday, 6 November 2002 4:49 AM
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] [ pgsql-monitoring ]

Hi,
 
I has a dinamic application, constructed on php, connecting in db postgres 7.2.
I would like monitor the all established connection. I want know whish command is running at moment.
 
Help, please !!!
 
Osvâneo A. Ferreira