How to show SQL queries run in the Rails console?
activerecord, ruby-on-rails
Solution
Rails 3+
Enter this line in the console:
ActiveRecord::Base.logger = Logger.new(STDOUT)
Rails 2
Enter this line in the console:
ActiveRecord::Base.connection.instance_variable_set :@logger, Logger.new(STDOUT)
Problem
When I run queries (e.g. `MyModel.where(...)` or `record.associated_things`) in the console, how can I see the actual database queries being run so I can gain more understanding of what is happening?