Maatkit does more than just MySQL. I’ve just committed a new version of mk-query-digest, a powerful log analysis tool, with support for Posgtres logs, in both syslog and stderr format. I’m hoping that people will give this a spin in the real world. I have lots of test cases but that’s never enough.
A brief tutorial:
# Get it
$ wget http://www.maatkit.org/trunk/mk-query-digest
# Run it
$ perl mk-query-digest --type pglog /path/to/log/file
# Learn about it (search for the string "pglog")
$ perldoc mk-query-digest
I’m going to close comments on this blog post so I don’t get bug reports in the comments. If you have feedback, please post it to the Maatkit mailing list, or the Maatkit issue tracker. Or reply to the thread I just started on the Postgres mailing list.
Related posts:
- mk-query-digest now understands HTTP You used t
- I’m a Postgres user, as it turns out Someone re
- How MySQL really executes a query WARNING: n
Related posts brought to you by Yet Another Related Posts Plugin.
PlanetMySQL Voting: Vote UP / Vote DOWN