CODEWITHSUNDEEP
ruby-on-railsactiverecordruby-debug
thanikkal
thanikkal

Reputation: 3356

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.

Upvotes: 8

Views: 3964

Answers (1)

Brad Werth
Brad Werth

Reputation: 17647

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

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

Upvotes: 21

Related Questions