CODEWITHSUNDEEP
sqlruby-on-railsactiverecordsql-execution-plan
Patrick Klingemann
Patrick Klingemann

Reputation: 9014

disable explain in Rails 3.2

Is it possible to disable the new the explain functionality in Rails 3.2 globally via configuration? I'm using activerecord-sqlserver-adapter 3.2.1 and there appear to be some bugs with the explain (show plan) portion of the gem.

Upvotes: 14

Views: 4188

Answers (3)

Evan
Evan

Reputation: 7416

You should note that config.auto_explain_threshold_in_seconds has been completely removed in Rails 4.0 & 4.1. In 4.1 it will throw a full error.

See https://github.com/rails/rails/pull/9400/files

If you upgrade, comment that line out.

Upvotes: 1

Holger Just
Holger Just

Reputation: 55718

To cite from http://weblog.rubyonrails.org/2011/12/6/what-s-new-in-edge-rails-explain/

New applications get

config.active_record.auto_explain_threshold_in_seconds = 0.5

in config/environments/development.rb. Active Record monitors queries and if they take more than that threshold their query plan will be logged using warn.

[...]

By default the threshold is nil in the test and production environments, which means the feature is disabled.

so just set

config.active_record.auto_explain_threshold_in_seconds = nil

Upvotes: 24

igreulich
igreulich

Reputation: 138

You can disable auto-explain by setting config.active_record.auto_explain_threshold_in_seconds = nil in your config/environments/development.rb

Upvotes: 9

Related Questions