On Fri, Sep 4, 2009 at 10:32 AM, Lee, Mija<mija@xxxxxxxxxx> wrote: > Hi - > Thanks for the response. > I'm on solaris so the ps ax doesn't work for me. I think the equivalent > is ps -ef which shows: > postgres 6939 22678 0 15:49:49 ? 1:33 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 22678 16072 0 Aug 06 ? 5:22 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 5074 22678 0 Aug 12 ? 710:08 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 8677 22678 0 Aug 13 ? 894:39 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 8347 22678 0 Aug 25 ? 357:27 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 343 22678 0 Aug 13 ? 368:30 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 8678 22678 0 Aug 13 ? 695:15 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 24793 22678 0 Aug 12 ? 2048:13 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 22690 22678 0 Aug 06 ? 106:15 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 22686 22678 0 Aug 06 ? 3:09 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 22691 22678 0 Aug 06 ? 1145:42 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 350 22678 0 Aug 13 ? 262:39 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 16593 22678 0 Aug 12 ? 731:57 > /services/8.3.5/bin/postgres -D /services/pgdata2 > postgres 22688 22678 0 Aug 06 ? 104:59 > /services/8.3.5/bin/postgres -D /services/pgdata2 > > If I'm wrong about the ps commands, please correct me. > When I cross reference this against pg_stat_activity, 5 of them don't > show up, and a top shows the same processes using 0% cpu but almost a > gig of memory. Are these internal postgres processes that don't make a > connection? Got me, I've never been real handy on Solaris. There's likely a command that'll show something closer to what I posted. Note that in the list I posted there are several processes that are NOT pg backends, but are helper processes (stats collector etc) and it's normal to have a handful of these processes on a pg server. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
