Re: Postgres process
| От | iliya g |
|---|---|
| Тема | Re: Postgres process |
| Дата | |
| Msg-id | 1312899853.23309.androidMobile@web120528.mail.ne1.yahoo.com обсуждение исходный текст |
| Ответ на | Postgres process (iliya g <gyozov2004@yahoo.com>) |
| Ответы |
Re: Postgres process
Re: Postgres process |
| Список | pgsql-admin |
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: Sent from Yahoo! Mail on Android |
From: Raghavendra <raghavendra.rao@enterprisedb.com>;
To: iliya g <gyozov2004@yahoo.com>;
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>;
Subject: Re: [ADMIN] Postgres process
Sent: Tue, Aug 9, 2011 11:05:29 AM
Hi,
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'.
|
В списке pgsql-admin по дате отправления: