Message-ID: <4CBFA7E4.7080307@2ndquadrant.com>
Date: Wed, 20 Oct 2010 22:39:32 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Dimi Paun <dimi@lattica.com>
CC: Tom Lane <tgl@sss.pgh.pa.us>, Jeff Davis <pgsql@j-davis.com>,
	pgsql-performance@postgresql.org
Subject: Re: What is postmaster doing?
References: <1287600255.18151.58.camel@dimi.lattica.com>	
	<1287604781.28384.50.camel@jdavis-ux.asterdata.local>	
	<3615.1287606374@sss.pgh.pa.us>	
	<1287607173.18151.75.camel@dimi.lattica.com>	
	<4055.1287607529@sss.pgh.pa.us>
	<1287608150.18151.77.camel@dimi.lattica.com>
In-Reply-To: <1287608150.18151.77.camel@dimi.lattica.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Dimi Paun wrote:
> Sorry, it wasn't a ps output, it was a line from top(1).
> My to header says:
>
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                                    
> 23425 postgres  20   0 22008  10m  10m R 99.9  0.5  21:45.87 postmaster
>   

Use "top -c" instead.  On Linux that will show you what each of the 
clients is currently doing most of the time, the ones that are running 
for a long time at least.

-- 
Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support  www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance": 
http://www.2ndquadrant.com/books