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