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@xxxxxxxxxxxxxxx Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance":
http://www.2ndquadrant.com/books
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance