ActiveRecord::Explainer

This gem automatically logs SQL EXPLAIN of every queries.

You can check naturally every SQL EXPLAIN from development log, without :hand: executions.

Usage

If you use Rails, it's no configuration, and you can logs SQL EXPLAIN of every queries.

Add this line to your application's Gemfile:

gem 'activerecord-explainer', group: :development

And then execute:

$ bundle

Or install it yourself as:

$ gem install activerecord-explainer

This gem subscribes sql.active_record event provided by the Active Support instrumentation API.
Subscriber handles payload, and execute EXPLAIN from ActiveRecord::Base.

Please check the implementation, if you interested in.