Re: Performance monitor - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Performance monitor
Date
Msg-id 200103080306.WAA19806@candle.pha.pa.us
Whole thread Raw
In response to Re: Performance monitor  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: Performance monitor  (Karel Zak <zakkr@zf.jcu.cz>)
Re: Performance monitor  (Karl DeBisschop <karl@debisschop.net>)
List pgsql-hackers
> 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.


--  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: Tom Lane
Date:
Subject: Re: Proposed WAL changes
Next
From: Bruce Momjian
Date:
Subject: Re: Performance monitor