[ pgsql-monitoring ]

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

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
osvaneo@ig.com