Log all SQL statements in RoR 3 app. config/initializers/sql_logger.rb

sql_logger.rb

# config/initializers/sql_logger.rb
connection = ActiveRecord::Base.connection
class << connection
  alias :original_exec :execute
  def execute(sql, *name)
    # try to log sql command but ignore any errors that occur in this block
    # we log before executing, in case the execution raises an error
    begin
        rails_env = ENV['RAILS_ENV'] || 'development'
        file = File.open(Rails.root.to_s + "/log/sql_#{rails_env}.log",'a'){|f| f.puts Time.now.to_s+": "+sql} if (%w(staging development).include? rails_env)
    rescue Exception => e
      ;
    end
    # execute original statement
    original_exec(sql, *name)
  end
end