Railsでarproxy + fluent-loggerを使ってSQLのログを記録してみた

Gemfile

# add
gem "arproxy"
gem "fluent-logger"

query_tracer.rb

# config/initializers/query_tracer.rb

class QueryTracer < Arproxy::Base
  def execute(sql, name=nil)
    result = nil
    ms = Benchmark.ms{ result = super(sql, name) }
    Fluent::Logger::FluentLogger.open(nil, :host=>'192.168.1.1', :port=>24224)
    Fluent::Logger.post("rails.sql", {name: name, time: ms.to_f, sql: sql})
    result
  end
end

Arproxy.configure do |config|
  config.adapter = ActiveRecord::ConnectionAdapters::PostgreSQLAdapter
  config.use QueryTracer
end
Arproxy.enable!