From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
---|---|
To: | Brice Ruth <brice(at)webprojkt(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: monitoring running queries? |
Date: | 2001-02-08 02:37:48 |
Message-ID: | Pine.LNX.4.30.0102072135170.19032-100000@chapelperilous.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 2001-02-08 02:54:56 | Re: full text searching |
Previous Message | Tom Lane | 2001-02-08 01:04:26 | Backends hanging around (was Re: Number of open files) |