Class: SQLRecorder

Inherits:
Object
  • Object
show all
Includes:
Singleton
Defined in:
lib/performance_promise/sql_recorder.rb

Instance Method Summary collapse

Instance Method Details

#clean_trace(trace) ⇒ Object 



35
36
37
38
39
 
# File 'lib/performance_promise/sql_recorder.rb', line 35

def clean_trace(trace)
  Rails.backtrace_cleaner.remove_silencers!
  Rails.backtrace_cleaner.add_silencer { |line| not line =~ /^(app)\// }
  Rails.backtrace_cleaner.clean(trace)
end

#flush ⇒ Object 



8
9
10
11
12
 
# File 'lib/performance_promise/sql_recorder.rb', line 8

def flush
  captured_queries = @db_queries
  @db_queries = []
  return captured_queries
end

#invalid_payload?(payload) ⇒ Boolean

Returns:

  • (Boolean) 


27
28
29
30
31
32
33
 
# File 'lib/performance_promise/sql_recorder.rb', line 27

def invalid_payload?(payload)
  ignore_query_names = [
    'SCHEMA',
    'SQLR-EXPLAIN',
  ]
  payload[:name] && ignore_query_names.any? { |name| payload[:name].in?(name) }
end

#record(payload, duration) ⇒ Object 



14
15
16
17
18
19
20
21
22
23
24
25
 
# File 'lib/performance_promise/sql_recorder.rb', line 14

def record(payload, duration)
  return if invalid_payload?(payload)
  sql = payload[:sql]
  cleaned_trace = clean_trace(caller)
  explained = ActiveRecord::Base.connection.execute("EXPLAIN QUERY PLAN #{sql}", 'SQLR-EXPLAIN')
  @db_queries << {
    :sql => sql,
    :duration => duration,
    :trace => cleaned_trace,
    :explained => explained,
  }
end