Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris

From: Mathijs Brands <mathijs(at)ilse(dot)nl>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Larry Rosenman <ler(at)lerctr(dot)org>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, PostgreSQL-ports <pgsql-ports(at)postgresql(dot)org>, PostgreSQL-Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris
Date: 2001-03-28 22:34:53
Message-ID: 20010329003452.C26435@ilse.nl (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackerspgsql-ports
On Thu, Mar 29, 2001 at 12:30:06AM +0200, Mathijs Brands allegedly wrote:
> 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

Damn! Small correction:

ps -U mathijs -o user,pid,pcpu,pmem,vsz=SZ -o rss,tty,s,stime=START -o time,comm

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

In response to

pgsql-ports by date

Next:From: Tom LaneDate: 2001-03-28 22:38:18
Subject: Re: Cygwin PostgreSQL Regression Test Problems (Revisited)
Previous:From: Jason TishlerDate: 2001-03-28 22:34:49
Subject: Re: Cygwin PostgreSQL Regression Test Problems (Revisited)

pgsql-hackers by date

Next:From: Mathijs BrandsDate: 2001-03-28 22:51:26
Subject: Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris
Previous:From: Bruce MomjianDate: 2001-03-28 22:33:05
Subject: Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris

pgsql-admin by date

Next:From: Mathijs BrandsDate: 2001-03-28 22:51:26
Subject: Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris
Previous:From: Bruce MomjianDate: 2001-03-28 22:33:05
Subject: Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group