ActiveRecord::SqlAnalyzer.configure do |c|
  c.add_analyzer do |a|
    a.name 'users'
    a.tables %w(users permissions)
  end
  
  c.log_sample_proc Proc.new { |name| rand(1..100) <= 25 }
end

  ActiveRecord::SqlAnalyzer.configure do |c|
    # Define a custom backtrace filter. In this case, only filter out lines containing `/nokogiri/`
    c.backtrace_filter_proc Proc.new { |lines|
      lines.reject { |line| line =~ /\/nokogiri\// }
    }
  
    # Add a new analyzer, can add as many as you need
    c.add_analyzer(
      # Used for the prefix of the log files, as well as passed to `log_sample_proc`
      name: 'users'
      # SQL table names to log
      tables: %w(users permissions)
      # Logger to use (Can be changed to use your own custom one)
      logger: ActiveRecord::SqlAnalyzer::RedactedLogger
    )
    
    # Directory to log to, by default this is `Rails.root.join('log')`
    c.logger_root_path '/tmp/'
    
    # Sets a new sampler, logs only 25% of queries tagged with `users` and 50% tagged with `payments`
    c.log_sample_proc Proc.new { |name|
      val = rand(1..100)
      
      if name == 'users'
        val <= 25
      elsif name == 'payments'
        val <= 50
      end
    }
    
    # Beyond the simple find/replace, any kind of dynamic redaction you need.
    # We use this with another gem that redacts common patterns like phone numbers or emails.
    c.complex_sql_redactor_proc Proc.new { |sql|
      sql.gsub!(/(.+)@(.+)\.(.+)/, "")
    }
    
    # Adds a new redactor that strips out all numbers
    c.add_sql_redactors [
      [/[0-9]+/, ""] 
    ]
    
    # Adds a redactor for backtraces to improve aggregation.
    # In this case, strips out line numbers in case your code changes day to day.
    c.add_backtrace_redactors [
      [/:([0-9]+):in/, ":in"]
    ]
    
    # Any backtraces matching the regexes will switch to an ambiguous tracer
    # where we log more details. Can be handy if you have code sites that
    # inherits from other files or middlewares that are showing up in the caller.
    c.add_ambiguous_tracers [
      %r{\Aapp/middleware/query_string_sanitizer\.rb:\d+:in `call'\z}
    ]
    
    # How many additional lines to log when calls are ambiguous
    c.ambiguous_backtrace_lines 5
  end