Re: monitoring running queries?

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.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
If you think the problem is bad now, just wait until we've solved it.
        -- Arthur Kasspe