Rails view activerecord sql statements on debug console

Question

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.

Brad Werth · Accepted Answer · 2012-09-10 06:18:33Z

21

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

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

answered Sep 10, 2012 at 6:18

Brad Werth

17.7k10 gold badges66 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

thanikkal Over a year ago

Thanks. That really helps. Btw, do you know anything that would save me some key strokes and set stuff like these up automatically or by a shorter named method call?

Brad Werth Over a year ago

Not sure, you could try to stick it into your /config/environments/development.rb.

Collectives™ on Stack Overflow

Rails view activerecord sql statements on debug console

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related