Re: postgres processes not reflected in pg_stat_activity

On Thu, Sep 3, 2009 at 5:26 PM, Lee, Mija<mija@scharp.org> wrote:
> 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

What does:
$ ps ax|grep postgres
say?

I get something like this at idle:

  312 pts/0    S+     0:00 /usr/lib/postgresql/8.3/bin/psql
  313 ?        Ss     0:00 postgres: smarlowe smarlowe [local] idle
 2784 ?        S      0:01 /usr/lib/postgresql/8.3/bin/postgres -D
/var/lib/postgresql/8.3/main -c
config_file=/etc/postgresql/8.3/main/postgresql.conf
 2787 ?        Ss     0:03 postgres: writer process
 2788 ?        Ss     0:02 postgres: wal writer process
 2789 ?        Ss     0:00 postgres: autovacuum launcher process
 2790 ?        Ss     0:00 postgres: stats collector process
32621 pts/1    S+     0:00 grep postgres