Log SQL Queries Executed By ActiveRecord

When entering ActiveRecord statements in a Rails console, it can be useful to see what SQL queries are being executed under the hood.

> Book.first
  Book Load (25.6ms)  SELECT  "books".* FROM "books" ORDER BY "books"."id" ASC LIMIT $1  [["LIMIT", 1]]
=> #<Book:0x00007f824ec6ff98

Notice the line right after the statement shows the corresponding select query.

If you aren't seeing this line of SQL, then you'll need to turn on logging for ActiveRecord. For instance, your test environment may not be configured to log the SQL.

Right in your console, try running the following line:

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

Enter an ActiveRecord statement, you should now be seeing the corresponding SQL queries.

source