[ADMIN] How to monitor postmaster to find a trouble query?

Hi, 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,

Re: [ADMIN] How to monitor postmaster to find a trouble query?

"lt" [EMAIL PROTECTED] writes: I have tried add query=4 in pq_options file, but nothing recorded in syslog. Are you starting the postmaster with -S ? That suppresses its log... regards, tom lane