I am running a productive server of postgresql 7.03, but sometimes it have a high load average value more than 10, it must be caused by a trouble query, although I have carefully checked my queries, I still can not find which query made this. I wish there is a way to monitor the query, for example, when I use 'top' find a postgres process take more than 50% CPU, I can check which query is executed in it. I have tried add query=4 in pq_options file, but nothing recorded in syslog.
pgsql-admin by date
|Next:||From: bangh||Date: 2001-02-17 17:49:22|
|Subject: Reason to not upgrade from 6.5 to 7.0 or above|
|Previous:||From: Michael Ansley||Date: 2001-02-17 16:23:04|
|Subject: RE: v7.1b4 bad performance |