Re: postgres processes not reflected in pg_stat_activity

From: "Lee, Mija" <mija(at)scharp(dot)org>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Emanuel Calvo Franco" <postgres(dot)arg(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres processes not reflected in pg_stat_activity
Date: 2009-09-04 18:24:25
Message-ID: 5D1219ADBE9E6C4CA6F0F89C811C102F038C9864@ISIS.fhcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

343 ? S 372:35 /services/8.3.5/bin/postgres -D
/services/pgdata2
350 ? S 262:39 /services/8.3.5/bin/postgres -D
/services/pgdata2
5074 ? S 710:07 /services/8.3.5/bin/postgres -D
/services/pgdata2
6939 ? S 1:35 /services/8.3.5/bin/postgres -D
/services/pgdata2
8347 ? S 357:26 /services/8.3.5/bin/postgres -D
/services/pgdata2
8677 ? S 897:01 /services/8.3.5/bin/postgres -D
/services/pgdata2
8678 ? S 695:14 /services/8.3.5/bin/postgres -D
/services/pgdata2
16593 ? O 736:45 /services/8.3.5/bin/postgres -D
/services/pgdata2
22678 ? S 5:23 /services/8.3.5/bin/postgres -D
/services/pgdata2
22686 ? S 3:09 /services/8.3.5/bin/postgres -D
/services/pgdata2
22688 ? S 105:04 /services/8.3.5/bin/postgres -D
/services/pgdata2
22690 ? S 106:16 /services/8.3.5/bin/postgres -D
/services/pgdata2
22691 ? S 1146:00 /services/8.3.5/bin/postgres -D
/services/pgdata2
24793 ? S 2050:48 /services/8.3.5/bin/postgres -D
/services/pgdata2

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Friday, September 04, 2009 11:21 AM
To: Lee, Mija
Cc: Emanuel Calvo Franco; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] postgres processes not reflected in
pg_stat_activity

On Fri, Sep 4, 2009 at 12:17 PM, Lee, Mija<mija(at)scharp(dot)org> wrote:
> I got it once I pointed to the ucb ps per Alvaro's suggestion. Thanks!
Here's what I see with a ps auwx :

So what does ps ax|grep postgres say?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-09-04 18:31:32 Re: postgres processes not reflected in pg_stat_activity
Previous Message Scott Marlowe 2009-09-04 18:21:00 Re: postgres processes not reflected in pg_stat_activity