Re: Analyzer for postgresql.log

A quick comparison. Sorry about my /partial/ point of view. Gilles
DAROLD is on BCC: so that he can also give his opinion.

His is very nice, but the main point in mine is completely different. I
focus on TIMING the different types of queries, to be able to add times
up and know which ones are more important to optimize.

I think his parsing of requests is far better than mine, however. I just
did not do any better because I did not need any better ;-)

He is generating nice graphs. I just output some bare numbers.

He minds when queries are executed. I do not mind about that at all.

Mine is completely focused to later optimization. His is focusing reporting.

He is targetting some public. I wrote it for me. (Yes, I am probably
more egoist ;-)

Note that I am not saying that mine is better. It is simply different.

Gilles: You will be able to find the AWK script on PostgreSQL archives.
If you wish me to send it to you directly, please e-mail me.

Gilles (again): If you want to respond to the whole PostgreSQL-general
list, you may need to subscribe. And sorry for abruptly including you on
this mailing list thread. Your address is now on BCC, so that you can
keep it protected from others it if you wish.

Gilles (once again): If you feel that the script I wrote fits into your
pack, it is under GPL. Just include it ;-)

Justin: Thank you for showing other possibilities. For web log analysis,
Gilles' software is definitely the choice.

Have a nice day!

Antonio Fiol

Justin Clift wrote:

>Hi,
>
>You might also like to check out "PostgreSQL Log Analyzer v1.1" by
>Gilles Darold :
>
>http://www.samse.fr/GPL/pg_analyzer/sample/
>
>:)
>
>Regards and best wishes,
>
>Justin Clift
>
>
>Tielman J de Villiers wrote:
>
>>Thank you,
>>
>>I will be using this in a cronjob to act kind of as the "analog" web log
>>analyser for my postgres logs ...
>>
>>Just one question -- the "list of times" (eg 13,15) wheat do they refer to
>>(mine all shows a "0")
>>
>>Regards
>>
>>Tielman J de Villiers
>>BondNet Pty Ltd
>>
>>-----Original Message-----
>>From: Antonio Fiol Bonnín [mailto:fiol(at)w3ping(dot)com]
>>Sent: Monday, December 10, 2001 2:37 PM
>>To: PostgreSQL General Mailing list
>>Subject: [GENERAL] Analyzer for postgresql.log
>>
>>Attached is a little AWK script that you may find of some use.
>>
>>It takes as standard input a file with the format of the Postgresql log
>>(level 2, for PostgreSQL 7.0.3 tested).
>>
>>On standard output, you get a list of times and a mangled form of every
>>executed request.
>>
>>Something like
>>
>>13;select * from my_table where field=''
>>15;select * from other_table where id= and test>
>>
>>All number are removed from requests. Also removed are the contents
>>between single quotes.
>>
>>This allows me to sort by request and then either count them or add up
>>the times. That way I know what I need to optimize.
>>
>>The script is far from perfect. It just works for me ;-)
>>
>>Antonio Fiol
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>