Re: [HACKERS] Postgresql log analyzer

Поиск
Список
Период
Сортировка
Искать

Re: [HACKERS] Postgresql log analyzer

От:
Gilles DAROLD <gilles@darold.net>
Дата:
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 can spend this week do do that...

Peter, sorry for my poor english that what I mean is that if you don't activated
the
log_timestamp option we have no idea when the postmaster have been started
(or at least doing a ls -la on /tmp/.s.PGSQL.5432). Other things was just
question
and you answer them, thanks.

Regards


Re: [HACKERS] Postgresql log analyzer

От:
Andrew McMillan <andrew@catalyst.net.nz>
Дата:
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

Re: Postgresql log analyzer

От:
Gilles DAROLD <gilles@darold.net>
Дата:
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



FAQ