postgres processes not reflected in pg_stat_activity

From: "Lee, Mija" <mija(at)scharp(dot)org>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: postgres processes not reflected in pg_stat_activity
Date: 2009-09-03 23:26:43
Message-ID: 5D1219ADBE9E6C4CA6F0F89C811C102F038C964F@ISIS.fhcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello:
I have a server that has many more postgres processes (postgres -D
<datadir>, owned by postgres, listed with an ps -ef) than connections in
pg_stat_activity. How can I find out what those processes are?
I have been going through the docs and found a reference to if the
autovacuum launcher should show up in pg_stat_activity, but it looks
like that was implemented in 8.3.
I'm running 8.3.5 on solaris 10.
Thanks so much for the help!
Mija

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential, proprietary, and/or privileged information protected by
law. If you are not the intended recipient, you may not use, copy, or
distribute this e-mail message or its attachments. If you believe you
have received this e-mail message in error, please contact the sender by
reply e-mail and destroy all copies of the original message.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-09-04 02:54:26 Re: postgres processes not reflected in pg_stat_activity
Previous Message Rafael Domiciano 2009-09-02 16:06:50 Re: ERROR: syntax error at or near "NEW"