Heroku:查看日志中的参数和 sql 活动?

本文介绍了Heroku:查看日志中的参数和 sql 活动?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

当我在服务器上查看我的 heroku 日志时(使用 heroku logs --tail --app myapp)，我看到如下内容:

When i view my heroku logs on the server (with heroku logs --tail --app myapp) i see something like this:

2011-06-21T14:09:25+00:00 app[web.1]: Started PUT "/reports/19.xml" for 77.89.149.137 at 2011-06-21 07:09:25 -0700
2011-06-21T14:09:25+00:00 heroku[router]: PUT myapp.heroku.com/reports/19.xml dyno=web.1 queue=0 wait=0ms service=7ms status=401 bytes=28
2011-06-21T14:09:26+00:00 heroku[nginx]: PUT /reports/19.xml HTTP/1.1 | 77.89.149.137 | 656 | http | 401

在我的本地日志中，我会看到如下内容:

While in my local log i'd see something like this:

Started PUT "/reports/19" for 127.0.0.1 at 2011-06-21 15:27:01 +0100
  Processing by ReportsController#update as XML
  Parameters: {"report"=>{"workflow_status"=>"3"}, "id"=>"19"}
  Person Load (0.9ms)  SELECT "people".* FROM "people" WHERE "people"."email" = '[email protected]' LIMIT 1
  Report Load (0.4ms)  SELECT "reports".* FROM "reports" WHERE "reports"."id" = 19 LIMIT 1
DEPRECATION WARNING: Object#returning has been deprecated in favor of Object#tap. (called from update_report at /home/max/work/rails_apps/flamingo_container/flamingo/vendor/plugins/resource_this/lib/resource_this.rb:135)
Creating scope :open. Overwriting existing method Task.open.
  Task Load (2.0ms)  SELECT "tasks".* FROM "tasks" WHERE "tasks"."id" = 14 LIMIT 1
Completed 200 OK in 1648ms (Views: 568.2ms | ActiveRecord: 3.2ms)

即包含更多信息，特别是参数、来自路由器的信息、生成的 sql、呈现的任何模板等.

Ie with a lot more information, particularly the params, info from the router, generated sql, any templates rendered etc etc.

有谁知道如何让我的 heroku 日志像我的开发日志一样冗长?我已经完成了以下操作:

Does anyone know how i can get my heroku log to be as verbose as my development one? I've done the following already:

1) 在相关(rails 3)环境文件中设置日志级别:

1) Set the log level in the relevant (rails 3) environment file:

config.log_level = :debug

2) 告诉 heroku 使用不同的记录器级别，如 http://devcenter.heroku.com/articles/logging 中所述

2) Told heroku to use a different logger level, as described on http://devcenter.heroku.com/articles/logging

heroku config:add LOG_LEVEL=DEBUG --app myapp #from CLI

两者都没有任何区别......任何人有什么想法吗?
谢谢，最大

Neither has made any difference...any ideas anyone?
thanks, max

推荐答案

您实际上希望在 Heroku 日志中显示 SQL/params 输出.您可以通过将下面显示的行添加到 production.rb 文件中的 config 块来实现:

You're essentially wanting to show the SQL / params output in the Heroku logs. You can do this by adding the line shown below to the config block within your production.rb file:

MyAppNameHere::Application.configure do

  # add this line
  config.logger = Logger.new(STDOUT)

end

顺便说一下，将日志级别设置为 debug 只是意味着 Rails.logger.debug 将在您使用 Heroku 时输出到日志

By the way, setting the log level to debug just means that Rails.logger.debug will output to the logs when you're on Heroku

这篇关于Heroku:查看日志中的参数和 sql 活动?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！