What is postmaster doing?

Поиск
Список
Период
Сортировка
От Dimi Paun
Тема What is postmaster doing?
Дата
Msg-id 1287600255.18151.58.camel@dimi.lattica.com
обсуждение исходный текст
Ответы Re: What is postmaster doing?  ("Reid Thompson" <Reid.Thompson@ateb.com>)
Re: What is postmaster doing?  (Jeff Davis <pgsql@j-davis.com>)
Re: What is postmaster doing?  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
Список pgsql-performance
Folks,

I am running into a problem with the postmaster: from time to time, it
runs for a long time. E.g., from top:

23425 postgres  20   0 22008  10m  10m R 99.9  0.5  21:45.87 postmaster

I'd like to figure out what it is doing. How can I figure out what
statement causes the problem?

is there a way I can log all SQL statements to a file, together with the
time it took to execute them?

--
Dimi Paun <dimi@lattica.com>
Lattica, Inc.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: how to get the total number of records in report
Следующее
От: "Reid Thompson"
Дата:
Сообщение: Re: What is postmaster doing?