在Rails 3日志中沉默Postgres日志垃圾邮件 [英] Silencing postgres log spam in rails 3 logs

问题描述

在每个请求上，我的development.log都包含很多条目，如下所示:

On every request my development.log contains a lot of entries like so:

SQL (0.5ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"table1"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum

SQL (0.5ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"table2"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum

这些完全淹没了我真正关心的日志消息.是否有消除这些多余消息的好方法?

These are completely drowning out the log messages I actually care about. Is there a good way to silence these extra messages?

推荐答案

将其添加到您的Gemfile中，执行bundle install，然后重新启动服务器.

Add this to your Gemfile, do a bundle install, and restart your server.

gem "silent-postgres"

这篇关于在Rails 3日志中沉默Postgres日志垃圾邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！