Re: monitoring running queries? - Mailing list pgsql-general

From Dirk Lutzebaeck
Subject Re: monitoring running queries?
Date
Msg-id 14978.22261.788394.946570@ampato.core.aeccom.com
Whole thread Raw
In response to Re: monitoring running queries?  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-general
Brett W. McCoy writes:
 > On Wed, 7 Feb 2001, Brice Ruth wrote:
 >
 > > Is there any way (besides ps) to view queries that are running on the
 > > PostgreSQL server?  Something that actually output the query being run
 > > would be great.
 >
 > You can set the logging option for query to 4, I believe, and it will log
 > the full query by whatever logging facility you are using (syslog,
 > redirected stdout or whatever).  Take a look in the admin docs for
 > whatever version you are using.  There's a lot fo stuff you can log.
 >
 > If you are logging queries, you can open up the log file with tail -f and
 > monitor the log as queries are being made.

would be nice if the debug/logging level could be changed with
SIGUSR1/2 like samba.

Dirk

pgsql-general by date:

Previous
From: "Anthony E . Greene"
Date:
Subject: Re: Import Performance
Next
From: "benoit.le-dizes@voila.fr"
Date:
Subject: installation on a QUBE 2