Rails: Show SQL Queries in Production Log

Question

How can we enabled SQL query logging in production environment?

Thanks,

Imran

I have tried different log_levels (config.log_level) with no luck. — Saim
– Saim, Commented Oct 27, 2010 at 19:29

Simone Carletti · Accepted Answer · 2010-10-27 19:32:42Z

55

In your environments/production.rb

config.log_level = :debug

Remember you need to restart the web server to apply the changes.

answered Oct 27, 2010 at 19:32

Simone Carletti

177k50 gold badges371 silver badges370 bronze badges

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

4 Comments

Saim Over a year ago

Thanks Simone. It works. I was trying with the numbers (0-4).

shingara Over a year ago

accept the answer because it's the good answer like you explain

Saim Over a year ago

Yes, I am trying but getting this message "You can accept an answer in 5 minutes" and waiting for this lag to get past :).

Ozymandias Over a year ago

This doesn't work for me. Running production via rails s -e production

bonafernando · Accepted Answer · 2019-07-11 17:59:21Z

2

If you're setting the production log level to debug, I would recommend you to set the log level with an environment variable. Log level debug is much bigger than info and it can easily grow out of control or quotas if you're using a log service. So, with an environment variable you can change it faster only restarting rails, without the need for changing the code and deploy:

config.log_level = (ENV['LOG_LEVEL'] || :debug)

This way, you optionally set the environment variable LOG_LEVEL to change it.

answered Jul 11, 2019 at 17:59

bonafernando

1,17812 silver badges14 bronze badges

1 Comment

Fumisky Wells Over a year ago

Thank you for your info!; For production, default = :info would be better ?

Collectives™ on Stack Overflow

Rails: Show SQL Queries in Production Log

2 Answers 2

4 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Related