How do I trace which SQL query did my Activerecord methods generated (eg find, where).
1
-
This answer gives you a lot of control - you get access to the queries in the app itself.Kelvin– Kelvin2012-10-12 17:26:22 +00:00Commented Oct 12, 2012 at 17:26
Add a comment
|
4 Answers
You can debug ActiveRecord queries from a console.
Hit rails console and enter:
ActiveRecord::Base.logger = Logger.new(STDOUT)
Comments
I assume you're using Rails 3.0.x, you can do that by configuring your active record. Put this in config/environments/development.rb
# Log ActiveRecord
ActiveRecord::Base.logger = Logger.new(STDOUT) if defined?
Rails::Console
Now, every query is explained in console.
Comments
You can call to_sql on relation objects (like that returned when you call where) to get the SQL for those queries.
Comments
If you want to do it permanently (always show queries in console) just add those files:
~/.rvmrc
railsrc_path = File.expand_path('~/.railsrc')
if ( ENV['RAILS_ENV'] || defined? Rails ) && File.exist?( railsrc_path )
begin
load railsrc_path
rescue Exception
warn "Could not load: #{ railsrc_path }" # because of $!.message
end
end
~/.railsrc
require 'active_record'
ActiveRecord::Base.logger = Logger.new(STDOUT)
ActiveRecord::Base.clear_active_connections!
