From: | Brice Ruth <brice(at)webprojkt(dot)com> |
---|---|
To: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: monitoring running queries? |
Date: | 2001-02-08 14:47:24 |
Message-ID: | 3A82B17D.CA3DCE9E@webprojkt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Its not working ... I looked at the admin docs and edited the pg_options
file appropriately ... the following is what appears in /var/log/messages:
postgres[23686]: read_pg_options: verbose=2,query=4,syslog=2
But no queries ... I sent SIG_HUP to postmaster, even restarted
postmaster. The file /var/log/postgresql appears to be empty as well.
-Brice
"Brett W. McCoy" wrote:
>
> 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
--
Brice Ruth
WebProjkt, Inc.
VP, Director of Internet Technology
http://www.webprojkt.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Mitch Vincent | 2001-02-08 14:58:54 | Re: tuples too big |
Previous Message | benoit.le-dizes@voila.fr | 2001-02-08 14:46:56 | .mips.rpm |