Retrieving sql queries from Active-record queries in Rails 3

Question

How do I trace which SQL query did my Activerecord methods generated (eg find, where).

[This](http://stackoverflow.com/a/5492207/498594) answer gives you a lot of control - you get access to the queries in the app itself. — Kelvin, Oct 12 '12 at 17:26

score 2 · Accepted Answer · answered Feb 07 '12 at 09:10

2

You can debug ActiveRecord queries from a console.

Hit rails console and enter:

ActiveRecord::Base.logger = Logger.new(STDOUT)

answered Feb 07 '12 at 09:10

shime

8,746
1
30
51

score 1 · Answer 2 · answered Feb 07 '12 at 09:12

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.

score 1 · Answer 3 · answered Feb 07 '12 at 10:11

1

You can call to_sql on relation objects (like that returned when you call where) to get the SQL for those queries.

answered Feb 07 '12 at 10:11

Ryan Bigg

106,965
23
235
261

score 0 · Answer 4 · answered Aug 21 '12 at 18:47

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!

Retrieving sql queries from Active-record queries in Rails 3

4 Answers4

Linked