Moreover, which operating system you are in..
--Raghav
On Tue, Aug 9, 2011 at 7:54 PM, iliya g <gyozov2004@xxxxxxxxx> wrote:
Thanks, Raghavendra.
The problem is that when I run ps - ef l grep postgres, I only get postgres and not the process description. I can't see what kind of process it is and if it is a logger process or writer or stats collector. I get this at he end:
......./pgsql/bin/postgresSent from Yahoo! Mail on Android
From: Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>;
To: iliya g <gyozov2004@xxxxxxxxx>;
Cc: pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx>;
Subject: Re: Postgres process
Sent: Tue, Aug 9, 2011 11:05:29 AM
Hi, I need some help discovering the processes that run on an instance. I know that there are many processes running on one instance and they are all called postges, but I was hoping you can help me find a way to uniquely identify each one of them. I want to discover what the process name is and what the does. Let me know if you have any suggestions.As you know, there are set of Mandatory process starts along with instance and others 'one-user-per-connection' basis called 'postgres' process (also called as 'Server Process' or 'User Process').eg:--bash-4.1$ ps -ef | grep postgrespostgres 19294 1 0 01:13 ? 00:00:04 /opt/PostgreSQL/9.0/bin/postgres -D datapostgres 19295 19294 0 01:13 ? 00:00:00 postgres: logger processpostgres 19297 19294 0 01:13 ? 00:00:00 postgres: writer processpostgres 19298 19294 0 01:13 ? 00:00:00 postgres: wal writer processpostgres 19299 19294 0 01:13 ? 00:00:01 postgres: autovacuum launcher processpostgres 19301 19294 0 01:13 ? 00:00:02 postgres: stats collector processpostgres 27176 19294 1 09:25 ? 00:00:01 postgres: postgres postgres [local] SELECTIn the above example, you can see both mandatory process and user-process performing 'SELECT' operation.To identify postgres process uniquely, you can get it from catalog view 'pg_stat_activity'.Thanks.
