Toshimaru's Blog

Show SQL queries in rails console

When you set log_level :info (mostly on production server), the SQL outputs are disabled in rails console.

# Rails Configuration
Rails.application.configure do
  config.log_level = :info
# $ rails c
> Model.count
=> 12345
# No Query is shown

If you want to see SQL generated by Model.count, What you need is setting log level manually.

The available log levels are: :debug, :info, :warn, :error, :fatal, and :unknown, corresponding to the log level numbers from 0 up to 5, respectively. To change the default log level

config.log_level = :warn # In any environment > initializer, or
Rails.logger.level = 0 # at any time

via. Log Levels - Debugging Rails Applications — Ruby on Rails Guides

# $ rails c
> Rails.logger.level = 0
=> :debug

> Model.count
   (1.8ms)  SELECT COUNT(*) FROM `models`
=> 12345

Now, you can check the queries in rails console.

Load more