Re: What is postmaster doing?

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