Re: [ pgsql-monitoring ]

Turn on query monitoring in the postgresql.conf and then go:

select * from pg_stat_activity;

Chris
-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Osvâneo A. Ferreira
Sent: Wednesday, 6 November 2002 4:49 AM
To: pgsql-hackers(at)postgresql(dot)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(at)ig(dot)com