Re: Postgres process

Only active 'postgres' process you can see with description, rest will be in
'IDLE'.
Moreover, which operating system you are in..

--Raghav

On Tue, Aug 9, 2011 at 7:54 PM, iliya g <gyozov2004(at)yahoo(dot)com> 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/postgres
>
>
>
>
> Sent from Yahoo! Mail on Android
>
> ------------------------------
> * From: * Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>;
> * To: * iliya g <gyozov2004(at)yahoo(dot)com>;
> * Cc: * pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)org>;
> * Subject: * Re: [ADMIN] 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 postgres
> postgres 19294 1 0 01:13 ? 00:00:04
> /opt/PostgreSQL/9.0/bin/postgres -D data
> postgres 19295 19294 0 01:13 ? 00:00:00 postgres: logger process
> postgres 19297 19294 0 01:13 ? 00:00:00 postgres: writer process
> postgres 19298 19294 0 01:13 ? 00:00:00 postgres: wal writer
> process
> postgres 19299 19294 0 01:13 ? 00:00:01 postgres: autovacuum
> launcher process
> postgres 19301 19294 0 01:13 ? 00:00:02 postgres: stats collector
> process
> postgres 27176 19294 1 09:25 ? 00:00:01 postgres: postgres postgres
> [local] SELECT
>
> In 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'.
>
> ---
> Regards,
> Raghavendra
> EnterpriseDB Corporation
> Blog: http://raghavt.blogspot.com/
>
>
>
>> Thanks.
>>
>
>