Re: postgres processes not reflected in pg_stat_activity

Поиск
Список
Период
Сортировка
От Lee, Mija
Тема Re: postgres processes not reflected in pg_stat_activity
Дата
Msg-id 5D1219ADBE9E6C4CA6F0F89C811C102F038C9864@ISIS.fhcrc.org
обсуждение исходный текст
Ответ на Re: postgres processes not reflected in pg_stat_activity  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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.marlowe@gmail.com]
Sent: Friday, September 04, 2009 11:21 AM
To: Lee, Mija
Cc: Emanuel Calvo Franco; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postgres processes not reflected in
pg_stat_activity

On Fri, Sep 4, 2009 at 12:17 PM, Lee, Mija<mija@scharp.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?

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: postgres processes not reflected in pg_stat_activity
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgres processes not reflected in pg_stat_activity