From: | Gilles DAROLD <gilles(at)darold(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Postgresql log analyzer |
Date: | 2001-08-23 12:35:47 |
Message-ID: | 3B84F8A3.C88BE41A@darold.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi all,
I have updated the drafts for pg log analyzer especially for EXPLAIN output.
What do you want to see as statistics result. Currently I only output the following:
- scan type
- startup cost
- total cost
- number of rows returned
- and the width
There's certainly other usefull information but I don't know. Please let me know !
Note:
This is a simple draft to show what can be done, as a general purpose it will include:
- A configuration file (to choose what should be reported, paths, etc...)
or/and command line args
- An index page with resume of all reports
- Incremental scan working on full or rotate log
For other good requests it's done...
Let me know any other requests otherwise I will publish the first release at least on
monday
if not tomorow !
http://www.samse.fr/GPL/log_report/
Regards,
Gilles Darold
Andrew McMillan wrote:
> Gilles DAROLD wrote:
> >
> > Hi all,
> >
> > Here is a first draft generated by a log analyzer for postgres I've wrote today:
> >
> > http://www.samse.fr/GPL/log_report/
> >
> > In all this html report there is what I'm able to extract minus the statistics.
> >
> > I need to know what people want to see reported to have a powerfull log analyzer,
>
> I like what you have there so far.
>
> For my own use I would like to see the ability to turn some of these off,
> and also perhaps a summary page that you would click through to the more
> detailed reports.
>
> The 'query' page is kind of complicated too. Would it be possible to put
> that into a table layout as well?
> +-------------------------------+
> |select... |
> +----+----+----+--------+-------+
> |stat|stat|stat|stat ...| |
> +----+----+----+--------+-------+
>
> sort of layout.
>
> It would be nice to see an EXPLAIN on the query page, but you would want
> this to be an option, I guess. I imagine you could do this by getting the
> EXPLAIN at log analysis time if it isn't in the logs.
>
> Cheers,
> Andrew.
> --
> _____________________________________________________________________
> Andrew McMillan, e-mail: Andrew @ catalyst . net . nz
> Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
> Me: +64(21)635-694, Fax:+64(4)499-5596, Office: +64(4)499-2267xtn709
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-23 13:07:08 | Re: problems transfering databases |
Previous Message | Albert Reiner | 2001-08-23 12:12:32 | Re: [NOVICE] protected ON DELETE CASCADE |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-23 13:17:25 | Re: Reverse Engineering |
Previous Message | Vince Vielhaber | 2001-08-23 10:18:27 | Re: Re: bugs - lets call an exterminator! |