Search code examples
ruby-on-railsactiverecordruby-debug

Rails view activerecord sql statements on debug console

I am using debugger gem in my Rails 3.2 application.

How do I view the resulting SQL statement of active record method calls on the debug console?

For eg: If I run Product.all on the debug console it prints out all the products. I would also like to see the "Select * from Products" as well. Is this possible?

Edit Now that I am wiser(;p) active record also provides .to_sql method on the active record relation objects, to inspect the sql queries that they run against the underlying database.

Solution

  • Yep, you bet - just run this before your commands:

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