Class: SqlOptimizerController

Inherits:
ApplicationController
  • Object
show all
Defined in:
app/controllers/sql_optimizer_controller.rb

Instance Method Summary collapse

Instance Method Details

#graph ⇒ Object 



12
13
14
15
 
# File 'app/controllers/sql_optimizer_controller.rb', line 12

def graph
  @query_logs = QueryLog.where.not(source: nil)
  render json: collect_graph.to_json
end

#index ⇒ Object 



5
6
7
8
9
10
 
# File 'app/controllers/sql_optimizer_controller.rb', line 5

def index
  @query_logs = QueryLog.where.not(source: nil)
  @popular_queries = @query_logs.group_by(&:query).sort_by { |_, val| val.size }.last(3)
  @max_query = @query_logs.order(duration: :desc).first
  @min_query = @query_logs.order(:duration).first
end