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