Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris - Mailing list pgsql-admin

From Mathijs Brands
Subject Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris
Date
Msg-id 20010329003006.A26435@ilse.nl
Whole thread Raw
In response to Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris
List pgsql-admin
On Wed, Mar 28, 2001 at 04:56:15PM -0500, Bruce Momjian allegedly wrote:
> [ Charset ISO-8859-1 unsupported, converting... ]
> > whats wrong with /usr/ucb/ps auxw | grep $PGUSER
> >
> > to get only the processes for PG?
>
> I can do that if there is no other option, but on my BSDI machine,
> restricting ps to a specific user is much faster than a ps on the whole
> system.  Seeing that 'ps' is run by default every 5 seconds, this could
> be a performance issue.
>
> If I have to use 'grep' I will, but I was hoping for a real user
> restriction.

How about the following:

ilsefe2:~$ /usr/ucb/ps -aux|head -1
USER       PID %CPU %MEM   SZ  RSS TT       S    START  TIME COMMAND
Broken Pipe
ilsefe2:~$ /usr/ucb/ps -aux|grep mathijs
mathijs   7255  0.1  0.2 2432 1816 pts/0    S 00:12:41  0:00 -bash
mathijs   7775  0.1  0.1  960  728 pts/0    S 00:24:29  0:00 grep mathijs
mathijs   7344  0.0  0.1 1064  912 pts/0    T 00:14:56  0:00 man ps
mathijs   7359  0.0  0.1 1040  808 pts/0    T 00:14:57  0:00 sh -c more -s /tmp
mathijs   7360  0.0  0.1 1184  968 pts/0    T 00:14:57  0:00 more -s /tmp/mp3Ha
ilsefe2:~$ ps -U mathijs -o user,pid,pcpu,pmem,vsz,rss,tty,s,stime=START -o time,comm
    USER   PID %CPU %MEM  VSZ  RSS TT      S    START        TIME COMMAND
 mathijs  7359  0.0  0.1 1040  808 pts/0   T 00:14:57        0:00 sh
 mathijs  7255  0.1  0.2 2432 1816 pts/0   S 00:12:41        0:00 -bash
    root  7816  0.1  0.1 1080  840 pts/0   O 00:28:13        0:00 ps
 mathijs  7344  0.0  0.1 1064  912 pts/0   T 00:14:56        0:00 man
 mathijs  7360  0.0  0.1 1184  968 pts/0   T 00:14:57        0:00 more


It doesn't use any extra extra programs, nor the somewhat deprecated /usr/ucb/ps
command. The only problem I see may be the alignment of some fields. The ps
command itself is listed because the user mathijs was running it...

Regards,

Mathijs
--
It's not that perl programmers are idiots, it's that the language
rewards idiotic behavior in a way that no other language or tool has
ever done.
                                                    Erik Naggum

pgsql-admin by date:

Previous
From: Marcin Kowalski
Date:
Subject: Re: Urgent!Can't start postmaster after rebooting
Next
From: "dhninh"
Date:
Subject: