Re: postgres processes not reflected in pg_stat_activity

On Thu, Sep 3, 2009 at 5:26 PM, Lee, Mija<mija(at)scharp(dot)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