Query Digest UI, a web based user interface for the pt-query-digest tool. Providing interactive reporting and graphs to help you find the best queries to optimize your ROI.

pt-query-digest analyzes query execution logs and generate a query report, filter, replay, or transform queries for MySQL, Postgresql, Memcache, and more, but only reports in text or into a database… until now!

pt-query-digest is a framework for doing things with events from a query source such as the slow query log or PROCESSLIST. By default it acts as a very sophisticated log analysis tool. You can group and sort queries in many different ways simultaneously and find the most expensive queries, or create a time line of queries in the log, for example. It can also do a “query review,” which means to save a sample of each type of query into a MySQL table so you can easily see whether you’ve reviewed and analyzed a query before. The benefit of this is that you can keep track of changes to your server’s queries and avoid repeated work. You can also save other information with the queries, such as comments, issue numbers in your ticketing system, and so on.

Press

Visualization tools for pt-query-digest tables

Screen Shots

Screen Shot #1 Screen Shot #2 Screen Shot #3

Fork me on GitHub