ActiveRecord slow query log

slow_query_logger.rb

# frozen_string_literal: true

ActiveSupport::Notifications.monotonic_subscribe("sql.active_record") do |_name, start, finish, _id, payload|
  duration = (finish.to_f - start.to_f) * 1000

  # NOTE: duration is in milliseconds
  if duration >= 500
    sql = payload[:sql].to_s.tr("\n", " ").squeeze(" ")
    Rails.logger.info("Slow SQL: #{sql} (duration: #{duration.to_i}ms)")
  end
end