How to monitor postmaster to find a trouble query? - Mailing list pgsql-admin

From lt
Subject How to monitor postmaster to find a trouble query?
Date
Msg-id 002601c09904$57ca2b80$1030fea9@laptop1
Whole thread Raw
Responses Re: How to monitor postmaster to find a trouble query?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,
    I am running a productive server of postgresql 7.03, but sometimes it have a high load average value more than 10,
itmust be caused by a trouble query, although I have carefully checked my queries, I still can not find which query
madethis. I wish there is a way to monitor the query, for example, when I use 'top' find a postgres process take more
than50% CPU, I can check which query is executed in it. I have tried add query=4 in pq_options file, but nothing
recordedin syslog.  


pgsql-admin by date:

Previous
From: Michael Ansley
Date:
Subject: RE: v7.1b4 bad performance
Next
From: Tom Lane
Date:
Subject: Re: How to monitor postmaster to find a trouble query?