12

Automatic EXPLAIN on slow-running SQL queries. This feature has been removed from Rails 4.

config.active_record.auto_explain_threshold_in_seconds = 0.5

We find it useful, in controlled circumstances. I came up short in searching for answers to the following questions.

  1. What was the underlying rationale for removing auto-EXPLAIN?
    (I'm sure the reasons are sound, but I can't find what they are.)

  2. Is there a way to reintroduce auto-EXPLAIN in my Rails 4 codebase?
    (Couldn't find a gem, nor any online information)

Deepak Mahakale
  • 22,834
  • 10
  • 68
  • 88
changingrainbows
  • 2,551
  • 1
  • 28
  • 35

1 Answers1

22

Here is the commit that removed auto_explain. Looks like the reasoning is that it was rarely used and slightly problematic w/ the asset pipeline. As the commit notes you can still use ActiveRecord::Relation#explain to generate explain queries, but if you want to have it automatically called you will have to implement that yourself. Looking over the removed code in this commit should help you get on the right path.

Alex.Bullard
  • 5,533
  • 2
  • 25
  • 32