在Rails 3日志中消除PostgreSQL日志垃圾信息

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

这些完全淹没了我实际关心的日志消息。 有没有好的方法来消除这些额外的消息？

- jonnii

Answer 1

将以下内容添加到您的Gemfile中，执行bundle install，然后重新启动服务器。

gem "silent-postgres"

- Dylan Markow