Rails console is not outputting SQL Statements to my Development Log Rails console is not outputting SQL Statements to my Development Log ruby ruby

Rails console is not outputting SQL Statements to my Development Log


the rails console never writes to the log file, but you can achieve it quite easily, for example, if you execute following after starting the rails console

ActiveRecord::Base.logger = Logger.new STDOUT

rails will log all SQL statements to stdout, thus display them in your terminal.and since Logger.new accepts any stream as first argument, you could just let it write to the rails development.log:

ActiveRecord::Base.logger = Logger.new File.open('log/development.log', 'a')


I am in Rails 2.3.8, the above answer doesn't really work for me.

ActiveRecord::Base.logger = Logger.new STDOUT

The following actually works:

ActiveRecord::Base.connection.instance_variable_set :@logger, Logger.new(STDOUT)

Reference http://www.shanison.com/2012/03/05/show-sql-statements-in-rails-console/