How do I turn on SQL debug logging for ActiveRecord in RSpec tests?

set

config.log_level = :info 

in test environment

if others answers don't work in your case, please check the 'log level' of your test environment.

its default is 'debug', which will output the SQL generated by Rails. if it was set to "info", the SQL will be missing.

You could try setting the ActiveRecord logger to stdout in your test somewhere. If you're using rspec, maybe in the spec helper?

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

By default, all your db queries will be logged already in test mode. They'll be in log/test.log.