postgresql - 在 rails 3 日志中屏蔽 postgres 日志垃圾邮件

Question

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

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

这些完全淹没了我真正关心的日志消息。有什么好的方法可以让这些额外的消息静音？

Answer 1

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

gem "silent-postgres"