Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E772AB5DBFC for ; Tue, 9 Aug 2011 11:24:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 29116-03 for ; Tue, 9 Aug 2011 14:24:16 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm23-vm4.bullet.mail.ne1.yahoo.com (nm23-vm4.bullet.mail.ne1.yahoo.com [98.138.91.183]) by mail.postgresql.org (Postfix) with SMTP id 959ADB5DBFA for ; Tue, 9 Aug 2011 11:24:14 -0300 (ADT) Received: from [98.138.90.51] by nm23.bullet.mail.ne1.yahoo.com with NNFMP; 09 Aug 2011 14:24:14 -0000 Received: from [98.138.89.167] by tm4.bullet.mail.ne1.yahoo.com with NNFMP; 09 Aug 2011 14:24:13 -0000 Received: from [127.0.0.1] by omp1023.mail.ne1.yahoo.com with NNFMP; 09 Aug 2011 14:24:13 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 977574.81049.bm@omp1023.mail.ne1.yahoo.com Received: (qmail 23743 invoked by uid 60001); 9 Aug 2011 14:24:13 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1312899853; bh=7d+s/mdJLeEUa81OwHA7txbBg84d4VLOa3aY/7N7gjA=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=Q+v7/lRzAc1yPShDHG9kVWX9N9ogjlscK/ZtxWqlK4QBURk7ga1eqGSuRJ4W5dW9uqyT+C5p9HIAnTqHx6D+0zh2x3wiODTu0szhppe1WGhOBkzTEheXiBVj68roRjWp/psvMq3xvmfN5vcSmm7qLxu0GSGA0azubWOfcDkY+9s= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=W4B4RyEWRKVmnYNdhxcWyySf19ZSPgXSiBdcByRpFbV1djGh0qhmqCLpZU+aBKrlx1bGZm25dZ/FKYYC0SD14RUtBO7NwvQ+DfO4tfReDrOVCkCBD/Xu0o5bE3+1O6Y5B8bKiRtsbyenwGA4HgfDWYvpxZHIhtE2XFumgHlnIVM=; X-YMail-OSG: WJgUlrsVM1ldB_EdXHUmC5Lz3Do8ydaDKP4NBxAoHSll1v5 B_i1roOvwA15dm0705BvpF0rEnsUpwrYUdbSZ44U3Ray71J7SFuoJkNHDr.i ERVdlnaCzvZcTuy2mC_MvjPBtvnlnWzn1G1O9K885602CKkfo6wPEcLw.SUP WXQJGwerXT4oDqD1wlWzcwhSLhqTWsQxYsUkm9ThKN7gsu5RdnnMvs4Dbdwj o4QPflTYnfCrsb_1SofHWmM29In_x0zlg4sRtDRTcyU_wxtjFifZS_0QT4NQ cLFSh3eLk40_OBfbPC_rWA4nXHWqF9A3iZbBkeJ5wViqvqeIYH8cyYyzEs1w JTHwF6EVcfjlYbsEw.SPviSj3.3qb8qFYXRmBhHRqX5VRaFToeamxfAWKSbg 3jwZWUW5sGbb.7EZNXM1v8myuXhfjbLdx7KXhItxzlFH3XVsqYiUjgVtKdbe EIxb0ngaE.2r0oBj8kGhIxOU1z.L8rNpK5D_8WVlTwBOthOzULsc9yxYEgxq uqjcGuaTw Received: from [32.138.66.70] by web120528.mail.ne1.yahoo.com via HTTP; Tue, 09 Aug 2011 07:24:13 PDT X-Mailer: YahooMailWebService/0.8.112.307740 Message-ID: <1312899853.23309.androidMobile@web120528.mail.ne1.yahoo.com> Date: Tue, 9 Aug 2011 07:24:13 -0700 (PDT) From: iliya g Subject: Re: Postgres process To: "raghavendra.rao@enterprisedb.com" Cc: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-428857371-1755748125-1312899853=:23309" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.629 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001, HTML_FONT_FACE_BAD=0.981, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.812 X-Spam-Level: X-Archive-Number: 201108/37 X-Sequence-Number: 38024 ---428857371-1755748125-1312899853=:23309 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Thanks, Raghavendra.=0A=0AThe problem is that when I run ps - ef l grep pos= tgres, I only get postgres and not the process description. I can't see wha= t kind of process it is and if it is a logger process or writer or stats co= llector. I get this at he end:=0A......./pgsql/bin/postgres=0A=0A=0A=0A=0AS= ent from Yahoo! Mail on Android=0A=0A ---428857371-1755748125-1312899853=:23309 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

Thanks, Raghavendra.

=0A

The problem i= s 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:
=0A..= ...../pgsql/bin/postgres




=0A

Sent from Yahoo! Mail= on Android

=0A
=0A =
=0A
=0A
=0A = =0A =
=0A =0A = From:=0A = =0A Raghavendra <rag= havendra.rao@enterprisedb.com>;
=0A = =0A To:=0A =0A = iliya g <gyozov2004@yahoo.com>; =
=0A = =0A Cc:=0A =0A pgsql= -admin@postgresql.org <pgsql-admin@postgresql.org>; =
=0A = =0A Subject:=0A =0A = Re: [ADMIN] Postgres process =
=0A =0A = Sent:=0A = =0A Tue, Aug 9, 2011 11:05:29 AM =
=0A =0A =
=0A =0A = =0A =0A = =0A =0A = =0A
Hi,

=0A=0A
I need some help discovering the processes that ru= n on an instance. I know that there are many processes running on one insta= nce 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 discove= r what the process name is and what the does. Let me know if you have any s= uggestions.
=0A=0A

As you know, there are set of Mandatory process starts along with = instance and others =A0'one-user-per-connection' basis called '= postgres' process (also called as 'Server Process' or 'User= Process').
=0A=0A

eg:-= =A0
-bash-4.1$ ps -ef | grep postgres
=0A=0A
postgres 19294 =A0 =A0 1 =A00 01:13 ? =A0 =A0 =A0 =A000:00:04= /opt/PostgreSQL/9.0/bin/postgres -D data
postgres 19295 19294 = =A00 01:13 ? =A0 =A0 =A0 =A000:00:00 postgres: logger process
=0A=0Apostgres 19297 19294 =A00 01:13 ? =A0 =A0 =A0 =A000:00:00 postgres: writ= er process
postgres 19298 19294 =A00 01:13 ? =A0 =A0 =A0 =A000:00= :00 postgres: wal writer process
postgres 19299 19294 =A00 01:13 = ? =A0 =A0 =A0 =A000:00:01 postgres: autovacuum launcher process
=0A=0A=
postgres 19301 19294 =A00 01:13 ? =A0 =A0 =A0 =A000:00:02 postgres: st= ats collector process
postgres 27176 19294 =A01 09:25 ? =A0 =A0 = =A0 =A000:00:01 postgres: postgres postgres [local] SELECT
=0A=0A
In the above example, you can see bot= h mandatory process and user-process performing 'SELECT' operation.=
To identify postgres process uniquely, you can get it from catal= og view 'pg_stat_activity'.
=0A=0A

---
Regards,
=
Raghavendra
EnterpriseDB Corporation
=0A=0A

=A0
= =0A=0A
Thanks.

= =0A
=0A =
=0A
=0A
=0A ---428857371-1755748125-1312899853=:23309--