View rails4 db log on heroku

Question

I have a heroku app running (in production environment) on cedar stack. It uses postgres db.

In my environment/productions.rb file I have commented out this line

# config.log_level = :info

And in Heroku I have this config

$> heroku config
=== xxxx Config Vars
LOG_LEVEL:                    debug
RAILS_ENV:                    production

I want to view all db query that gets executed. In development environment locally I can see logs like this:

User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."email" = '[email protected]'   AND "users"."ustatus" IN (10, 11) LIMIT 1

But on heroku logs they never appear. Anyone know how to enable db log on heroku?

Community · Accepted Answer · 2017-05-23 12:20:59Z

1

You can get the log from rails console on heroku by running below commands:

$ heroku run rails c
File.open('log/production.log', 'r').each_line { |line| puts line }

As I found here

heroku - how to see all the logs

Also here is heroku logging documentation:

https://devcenter.heroku.com/articles/logging

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Mar 8, 2014 at 21:04

Sumit Munot

3,8981 gold badge35 silver badges51 bronze badges

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

4 Comments

JVK Over a year ago

this does not work. Even in that SO, you can see one comment is written as it is not working now. That SO question's answer is old and not relevant any more. This is now not working on cedar stack.

Sumit Munot Over a year ago

usually I will look my logs by adding --tail in heroku logs command that is $> 'heroku logs --tail'

JVK Over a year ago

Sumit, if you read my question carefully, then you will find, I am asking for Db logs. That does not show up in heroku logs -t

Sumit Munot Over a year ago

@jvk, here you go..stackoverflow.com/questions/8031007/…

rails4guides.com · Accepted Answer · 2014-03-08 21:31:21Z

1

Edit: I just found out why heroku does not display query logs when they should based on your production. rb configuration. The problem is queries will not be displayed by heroku if you have a so-called hobby tier plan. You are probably using the free version, which would explain why your queries are not displayed. If you would upgrade to a standard or medium plan the heroku logs will show the performed queries.

This heroku article explicitly says no postgres logs are displayed at hobby tier level: https://devcenter.heroku.com/articles/heroku-postgres-plans#hobby-tier

edited Mar 8, 2014 at 21:31

answered Mar 8, 2014 at 20:52

rails4guides.com

1,4412 gold badges11 silver badges8 bronze badges

1 Comment

rails4guides.com Over a year ago

Did you downvote? If so, could you please elaborate.

Vitalyp · Accepted Answer · 2014-03-08 22:24:42Z

0

Do everything by yourself:

  heroku run bash

answered Mar 8, 2014 at 22:24

Vitalyp

1,0991 gold badge11 silver badges21 bronze badges

Collectives™ on Stack Overflow

View rails4 db log on heroku

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related