Re: Postgresql log analyzer

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