Display SQL queries in log with Rails 4

Question

I'm using Rails 4.0.4 with Ruby 2.1 and Thin 1.6.2 on Ubuntu 14.04 through my terminal "Terminator" and my shell "Fish Shell".

When I'm launching my Rails server in development mode I don't have the SQL queries in my logs only the JS and HTML files are loaded.

I'm searching for something like that:

User Load (3.0ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 3 ORDER BY "users"."id" ASC LIMIT 1
(2.0ms)  SELECT COUNT(*) FROM "users" WHERE (driver_register_state_cd = -2)

By default, you will not see it when booting rails in production mode. Try to start it in development mode. — canoe
– canoe, Commented May 1, 2014 at 2:58

jimagic · Accepted Answer · 2014-05-01 15:30:44Z

43

the rails console never writes to the log file, but you can achieve it quite easily, for example, if you execute following after starting the rails console

ActiveRecord::Base.logger = Logger.new STDOUT

rails will log all SQL statements to stdout, thus display them in your terminal. and since Logger.new accepts any stream as first argument, you could just let it write to the rails development.log:

ActiveRecord::Base.logger = Logger.new File.open('log/development.log', 'a')

edited May 1, 2014 at 15:30

answered Apr 30, 2014 at 22:52

jimagic

4,0752 gold badges33 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user1479978 Over a year ago

I forgot to mention that I'm already in development mode... Could a gem make the queries disapear in the logs? Because I didn't touch the environment config files...

jimagic Over a year ago

where do u want rails to show SQL query? in your local desktop or server? if yes, then which server?

jimagic Over a year ago

I have updated the answer, please follow it. Please mark is checked if that solve your problem

jimagic Over a year ago

Thanks, I have upvoted your question. If possible, can you please upvote my answer by clicking on up arrow button. thanks

JonatasTeixeira Over a year ago

Its not solve my problem.. Even doing what you told the sql querie still are not showed..

|

ilgam · Accepted Answer · 2015-10-03 12:01:13Z

8

Set config.log_level in config/environments/development.rb to :debug and restart your local server, console:

 config.log_level = :debug

answered Oct 3, 2015 at 12:01

ilgam

4,4901 gold badge39 silver badges28 bronze badges

1 Comment

Tibor Nagy Over a year ago

The default log level is :debug in development mode. So this entry doesn't change anything,

cweston · Accepted Answer · 2016-02-18 17:34:15Z

8

I got what I wanted by creating an initializer file:

# initializers/sql_logging.rb
ActiveRecord::Base.logger = ActiveSupport::Logger.new(STDOUT)

This also seems to keep the logging from having the ugly timestamps prepended.

edited Feb 18, 2016 at 17:34

cweston

11.8k21 gold badges86 silver badges109 bronze badges

answered Aug 19, 2015 at 17:36

jwilsco

4083 silver badges8 bronze badges

Collectives™ on Stack Overflow

Display SQL queries in log with Rails 4

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related