How to monitor postmaster to find a trouble query?

Поиск
Список
Период
Сортировка
Искать

How to monitor postmaster to find a trouble query?

От:
"lt" <ltshadow@basecity.com>
Дата:
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, 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. 

Re: How to monitor postmaster to find a trouble query?

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"lt"  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
FAQ