Re: postgres processes not reflected in pg_stat_activity

On Fri, Sep 4, 2009 at 10:32 AM, Lee, Mija<mija(at)scharp(dot)org> 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.