Re: Monitoring DB activity PosgreSQL 7.3.2

On Mon, Jul 28, 2003 at 12:36:29PM +0200, Andre Truter wrote:

> I have PostgreSQL 7.3.2 server running.
> I could normally view the sessions by doing
> 'ps auxww | grep ^postgres' like the documentation states.
>
> But, recently it is not showing me expected output anymore.
>
> THis is what I get:
> postgres  1661  0.0  0.0  9132  176 ?        S    Jul18   0:00 [postmaster]
> postgres  1848  0.0  0.0  9944    0 ?        SW   Jul27   0:00 [postmaster]

The processes with the W status are swapped out.  In some Linux versions
and maybe some other platforms, swapped out processes have the
/proc/<pid>/cmdline file truncated, so ps uses the /proc/<pid>/exe
symlink instead, which does know what executable file the process is
running ("postmaster"), but not the nice status line that Postgres sets.

Well, whether you understand or not what I just said, truth is the
mechanism for showing process status in ps is not bulletproof, and this
is one example where it fails :-(

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"A wizard is never late, Frodo Baggins, nor is he early.
He arrives precisely when he means to."  (Gandalf, en LoTR FoTR)