pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Greg Smith <greg@2ndquadrant.com>
To: Dimi Paun <dimi@lattica.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jeff Davis <pgsql@j-davis.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: What is postmaster doing?
Date: Wed, 20 Oct 2010 22:39:32 -0400
Message-ID: <4CBFA7E4.7080307@2ndquadrant.com> (raw)
In-Reply-To: <1287608150.18151.77.camel@dimi.lattica.com>
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>

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

view thread (13+ messages)

Message-ID: <4CBFA7E4.7080307@2ndquadrant.com>
Permalink:  ../4CBFA7E4.7080307@2ndquadrant.com/
Also on:    postgresql.org/message-id/4CBFA7E4.7080307@2ndquadrant.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, dimi@lattica.com, tgl@sss.pgh.pa.us, pgsql@j-davis.com
  Subject: Re: What is postmaster doing?
  In-Reply-To: <4CBFA7E4.7080307@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox