Log analyzer

PostgreSQL »  Log analyzer
PostgreSQL »  Hints and Tips »  Log analyzer

Posted By Chris Smith Posted on 08 Mar 2006, 07:02 AM
I found a useful little tool the other day.

Practical Query Analyzer (written in ruby) will parse a postgresql or mysql log (though at last look mysql support was broken) and tell you what sort of queries are being run. This can help you work out where to concentrate on increasing speed or reducing the number of queries being run.

I use mysql a lot at work so I wrote a small perl script to give me the same output. My ruby skills are extremely basic so it seemed easier to do it in perl.

Want to post a comment? Fill in the details below.

Your Name  : 
Your Email  : 
Your Website  : 
Spam Check! Please answer this question  : 9 + 2 =