lookout-query_reviewer
Advanced tools
QueryReviewer is an advanced SQL query analyzer. It accomplishes the following goals:
I use this utility for most of my MySQL-backed Rails projects. Still the best out there in my opinion for analyzing and understanding your generated SQL queries. I forked the original query_reviewer and applied a collection of patches that have been made since the plugin was created. A list of the biggest additions below:
lib/tasks to fix deprecation warningsAs of August 2011, This has become the "official" version to use. David has deprecated the original repo and recommends that people looking for this utility use this fork instead. This fork compiles a variety of patches that were made since that time along with additional work to support compatibility with 1.9 and Rails 3. Also: If anyone else creates generally useful enhancements to this utility please start by forking this and then issue me a pull request.
Note: This plugin should work for Rails 2.X and Rails 3. If you run into issues, please file a bug report or send a pull request. I consider this new fork to be a group effort so if you want to be added as a contributor to help maintain this, please let me know!
As of right now, this plugin supports analyzing queries only for MySQL. I consider this the primary limitation of this gem. I am now using PostgreSQL for a number of my projects and the "EXPLAIN" output is totally different. Several people have started a PostgreSQL adapter for this plugin, but none that are mature enough to include here.
If anyone is interested at taking a stab at implementing PostgreSQL support for this utility, that would be hugely appreciated! I hope this plugin can come to support all the major Rails adapters over time.
All you have to do is install it into your Rails 2 or 3 project.
gem install query_reviewer
Right now if you use bundler, simply add this to your Gemfile:
# Gemfile
gem "query_reviewer", :git => "git://github.com/nesquena/query_reviewer.git"
If you are not using bundler, you might want to start using it. You can also install this as a plugin:
script/plugin install git://github.com/nesquena/query_reviewer.git
In Rails 2, the rake tasks are not loaded automatically (as a gem), you’ll need to add the following to your Rakefile:
# Rakefile
begin
require 'query_reviewer/tasks'
rescue LoadError
STDERR.puts "The query_reviewer gem could not be found!"
end
You can then run:
$ rake query_reviewer:setup
Which will create config/query_reviewer.yml in your application, see below for what these options mean.
If you don't create a config file, the gem will use the default in vendor/plugins/query_reviewer.
The configuration file allows you to set configuration parameters shared across all rails environment, as well as overriding those shared parameteres with environment-specific parameters (such as disabling analysis on production!)
enabled: whether any output or query analysis is performed. Set this false in production!inject_view: controls whether the output automatically is injected before the </body> in HTML output.profiling: when enabled, runs the MySQL SET PROFILING=1 for queries longer than the warn_duration_threshold / 2.0production_data: whether the duration of a query should be taken into accountstack_trace_lines: number of lines of call stack to include in the "short" version of the stack tracetrace_includes_vendor: whether the "short" version of the stack trace should include files in /vendortrace_includes_lib: whether the "short" version of the stack trace should include files in /libwarn_severity: the severity of problem that merits "WARNING" statuscritical_severity: the severity of problem that merits "CRITICAL" statuswarn_query_count: the number of queries in a single request that merits "WARNING" statuscritical_query_count: the number of queries in a single request that merits "CRITICAL" statuswarn_duration_threshold: how long a query must take in seconds (float) before it's considered "WARNING"critical_duration_threshold: how long a query must take in seconds (float) before it's considered "CRITICIAL"If you disable the inject_view option above, you'll need to manually put the analyzer's output into your view:
# view.html.haml
= query_review_output
and that will display the analyzer view!
Random collection of resources that might be interesting related to this utility:
Other related gems that prove useful for database optimization:
There have been other alternatives created since this was originally released. A few of the best are listed below. I for one still prefer this utility over the other options:
Know of a better alternative? Let me know!
Created by Kongregate & David Stevenson. Refactorings and compilations of all fixes since was done by Nathan Esquenazi. Also, ajvargo for helping with some fixes.
Copyright (c) 2007-2008 Kongregate & David Stevenson, released under the MIT license
FAQs
Unknown package
We found that lookout-query_reviewer demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.
Security News
The Ultralytics' PyPI Package was compromised four times in one weekend through GitHub Actions cache poisoning and failure to rotate previously compromised API tokens.
Security News
Research
Socket researchers found a malicious Maven package impersonating the legitimate ‘XZ for Java’ library, introducing a backdoor for remote code execution.