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.