> For the complete documentation index, see [llms.txt](https://ploegert.gitbook.io/til/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ploegert.gitbook.io/til/programmy/rails/log-sql-queries-executed-by-activerecord.md).

# 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.

```ruby
> 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:

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

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

[source](https://stackoverflow.com/a/2936016/535590)