Re: Performance monitor - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Performance monitor
Date
Msg-id 200103081718.MAA05464@candle.pha.pa.us
Whole thread Raw
In response to Re: Performance monitor  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-hackers
> On Wed, Mar 07, 2001 at 10:06:38PM -0500, Bruce Momjian wrote:
> > > I think Bruce wants per-backend data, and this approach would seem to only
> > > get the data for the current backend. 
> > > 
> > > Also, I really don't like the proposal to write files to /tmp. If we want a
> > > perf tool, then we need to have something like 'top', which will
> > > continuously update. With 40 backends, the idea of writing 40 file to /tmp
> > > every second seems a little excessive to me.
> > 
> > My idea was to use 'ps' to gather most of the information, and just use
> > the internal stats when someone clicked on a backend and wanted more
> > information.
> 
>  Are you sure about 'ps' stuff portability? I don't known how data you
> want read from 'ps', but /proc utils are very OS specific and for example
> on Linux within a few years was libproc several time overhauled.
>  I spent several years with /proc stuff (processes manager: 
> http://home.zf.jcu.cz/~zakkr/kim).

I am not going to do a huge amount with the actual ps columns, except
allow you to sort on them.  I will do most on the ps status display we
use as the command line in ps.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Performance monitor
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: WAL does not recover gracefully from out-of-disk-sp ace