Message-ID: <4E4221E0.8030907@ringerc.id.au>
Date: Wed, 10 Aug 2011 14:14:56 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
To: iliya g <gyozov2004@yahoo.com>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Postgres process
References: <1312860397.93185.YahooMailNeo@web120526.mail.ne1.yahoo.com>
In-Reply-To: <1312860397.93185.YahooMailNeo@web120526.mail.ne1.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 9/08/2011 11:26 AM, iliya g wrote:
> Hi guys,
>
> 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.

On operating systems that support it, postgresql changes the process 
name to tell you what it's doing.

On other operating systems, use the pg_stat_activity view. See the manual.

If you still need more information, please read this so you provide 
enough detail to get a proper answer before following up:

   http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

... since you didn't even mention what operating system you were running 
on in your question!

--
Craig Ringer