What is postmaster doing?

From: Dimi Paun <dimi(at)lattica(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: What is postmaster doing?
Date: 2010-10-20 18:44:15
Message-ID: 1287600255.18151.58.camel@dimi.lattica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)lattica(dot)com>
Lattica, Inc.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Reid Thompson 2010-10-20 19:24:08 Re: What is postmaster doing?
Previous Message Merlin Moncure 2010-10-19 23:56:27 Re: how to get the total number of records in report