What is postmaster doing? - Mailing list pgsql-performance

From Dimi Paun
Subject What is postmaster doing?
Date
Msg-id 1287600255.18151.58.camel@dimi.lattica.com
Whole thread Raw
Responses Re: What is postmaster doing?
Re: What is postmaster doing?
Re: What is postmaster doing?
List 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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: how to get the total number of records in report
Next
From: "Reid Thompson"
Date:
Subject: Re: What is postmaster doing?