> 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...
Sure 'ps -U' will work, but it was reported that on Solaris, plain ps
can't show the postgres status display, while ucb/ps can. I don't need
specific columns. What I need is the postgres status parameters, and if
possible, a user restriction to ps for performance reasons.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026