pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres process
10+ messages / 5 participants
[nested] [flat]
* Postgres process
@ 2011-08-09 03:26 iliya g <gyozov2004@yahoo.com>
0 siblings, 2 replies; 10+ messages in thread
From: iliya g @ 2011-08-09 03:26 UTC (permalink / raw)
To: pgsql-admin
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.
Thanks.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Postgres process
@ 2011-08-09 11:05 Raghavendra <raghavendra.rao@enterprisedb.com>
parent: iliya g <gyozov2004@yahoo.com>
1 sibling, 0 replies; 10+ messages in thread
From: Raghavendra @ 2011-08-09 11:05 UTC (permalink / raw)
To: iliya g <gyozov2004@yahoo.com>; +Cc: pgsql-admin
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.
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Postgres process
@ 2011-08-09 14:24 iliya g <gyozov2004@yahoo.com>
0 siblings, 2 replies; 10+ messages in thread
From: iliya g @ 2011-08-09 14:24 UTC (permalink / raw)
To: raghavendra.rao@enterprisedb.com <raghavendra.rao@enterprisedb.com>; +Cc: 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:
......./pgsql/bin/postgres
Sent from Yahoo! Mail on Android
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Postgres process
@ 2011-08-09 14:32 Raghavendra <raghavendra.rao@enterprisedb.com>
parent: iliya g <gyozov2004@yahoo.com>
1 sibling, 0 replies; 10+ messages in thread
From: Raghavendra @ 2011-08-09 14:32 UTC (permalink / raw)
To: iliya g <gyozov2004@yahoo.com>; +Cc: pgsql-admin
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@yahoo.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.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,
>
> 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.
>>
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Postgres process
@ 2011-08-09 14:48 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: iliya g <gyozov2004@yahoo.com>
1 sibling, 1 reply; 10+ messages in thread
From: Kevin Grittner @ 2011-08-09 14:48 UTC (permalink / raw)
To: raghavendra.rao@enterprisedb.com <raghavendra.rao@enterprisedb.com>; iliya g <gyozov2004@yahoo.com>; +Cc: pgsql-admin
iliya g <gyozov2004@yahoo.com> wrote:
> The problem is that when I run ps - ef l grep postgres, I only get
> postgres and not the process description.
It's hard to know what advice to give without more information.
Could you post the output of the query shown on this page?:
http://wiki.postgresql.org/wiki/Server_Configuration
-Kevin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Postgres process
@ 2011-08-09 15:02 Raghavendra <raghavendra.rao@enterprisedb.com>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 10+ messages in thread
From: Raghavendra @ 2011-08-09 15:02 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: iliya g <gyozov2004@yahoo.com>; pgsql-admin
I go with Kevin.
Still, my guess we cannot get the process description on SunOS.
--Raghav
On Tue, Aug 9, 2011 at 8:18 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov>wrote:
> iliya g <gyozov2004@yahoo.com> wrote:
>
> > The problem is that when I run ps - ef l grep postgres, I only get
> > postgres and not the process description.
>
> It's hard to know what advice to give without more information.
> Could you post the output of the query shown on this page?:
>
> http://wiki.postgresql.org/wiki/Server_Configuration
>
> -Kevin
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Postgres process
@ 2011-08-09 15:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: Raghavendra <raghavendra.rao@enterprisedb.com>
0 siblings, 1 reply; 10+ messages in thread
From: Tom Lane @ 2011-08-09 15:45 UTC (permalink / raw)
To: Raghavendra <raghavendra.rao@enterprisedb.com>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; iliya g <gyozov2004@yahoo.com>; pgsql-admin
Raghavendra <raghavendra.rao@enterprisedb.com> writes:
> Still, my guess we cannot get the process description on SunOS.
I surely hope you're not still running SunOS. If you mean Solaris,
note what the manual says at
http://www.postgresql.org/docs/9.0/static/monitoring-ps.html
Tip: Solaris requires special handling. You must use /usr/ucb/ps,
rather than /bin/ps. You also must use two w flags, not just one. In
addition, your original invocation of the postgres command must have
a shorter ps status display than that provided by each server
process. If you fail to do all three things, the ps output for each
server process will be the original postgres command line.
This advice is close to ten years old, but might well still apply to
recent Solaris releases.
regards, tom lane
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Postgres process
@ 2011-08-09 16:38 Raghavendra <raghavendra.rao@enterprisedb.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 10+ messages in thread
From: Raghavendra @ 2011-08-09 16:38 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; iliya g <gyozov2004@yahoo.com>; pgsql-admin
Ahh,,, I missed this.. :)
Thank you Tom for pointing to appropriate direction. Below command worked
/usr/ucb/ps -ww <PID>
--Raghav
On Tue, Aug 9, 2011 at 9:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Raghavendra <raghavendra.rao@enterprisedb.com> writes:
> > Still, my guess we cannot get the process description on SunOS.
>
> I surely hope you're not still running SunOS. If you mean Solaris,
> note what the manual says at
> http://www.postgresql.org/docs/9.0/static/monitoring-ps.html
>
> Tip: Solaris requires special handling. You must use /usr/ucb/ps,
> rather than /bin/ps. You also must use two w flags, not just one. In
> addition, your original invocation of the postgres command must have
> a shorter ps status display than that provided by each server
> process. If you fail to do all three things, the ps output for each
> server process will be the original postgres command line.
>
> This advice is close to ten years old, but might well still apply to
> recent Solaris releases.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Postgres process
@ 2011-08-09 16:58 iliya g <gyozov2004@yahoo.com>
0 siblings, 0 replies; 10+ messages in thread
From: iliya g @ 2011-08-09 16:58 UTC (permalink / raw)
To: raghavendra.rao@enterprisedb.com <raghavendra.rao@enterprisedb.com>; tgl@sss.pgh.pa.us <tgl@sss.pgh.pa.us>; +Cc: Kevin.Grittner@wicourts.gov <Kevin.Grittner@wicourts.gov>; pgsql-admin
Thanks, Tom. Let me look into this.
Sent from Yahoo! Mail on Android
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Postgres process
@ 2011-08-10 06:14 Craig Ringer <ringerc@ringerc.id.au>
parent: iliya g <gyozov2004@yahoo.com>
1 sibling, 0 replies; 10+ messages in thread
From: Craig Ringer @ 2011-08-10 06:14 UTC (permalink / raw)
To: iliya g <gyozov2004@yahoo.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2011-08-10 06:14 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-09 03:26 Postgres process iliya g <gyozov2004@yahoo.com>
2011-08-09 11:05 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2011-08-10 06:14 ` Craig Ringer <ringerc@ringerc.id.au>
2011-08-09 14:24 Re: Postgres process iliya g <gyozov2004@yahoo.com>
2011-08-09 14:32 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2011-08-09 14:48 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-08-09 15:02 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2011-08-09 15:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-08-09 16:38 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2011-08-09 16:58 Re: Postgres process iliya g <gyozov2004@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox