|
|
This rails plugin not only runs "EXPLAIN" before each of your select queries in development, but provides a small DIV in the rendered output of each page with the summary of query warnings that it analyzed.
It provides the following features:
- View all EXPLAIN output for all SELECT queries to generate a page (everything that query_analyzer plugin does)
- View SHOW PROFILE ALL output for queries that take significant time
- Rate a page's SQL usage into one of three categories: OK, WARNING, CRITICAL
- Display the number of SELECT, INSERT, UPDATE, and DELETE queries on each page
- Attach meaningful warnings to individual queries
- Provide smart ruby stack traces for each query
- Display interactive summary on page in development modes
Developed by Kongregate and David Stevenson, with additional support from Kevin Hall.
To install: svn export http://query-reviewer.googlecode.com/svn/trunk/ vendor/plugins/query_reviewer
Want to see what it looks like?
http://flouri.sh/2008/4/10/mysql-query-reviewer-now-with-ajax-and-profiling