On Thu, Sep 3, 2009 at 5:26 PM, Lee, Mija<mija@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
