Class: SqlOptimizer::SqlOptimizerController

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

Instance Method Summary collapse

Instance Method Details

#graph ⇒ Object

GET /graph



16
17
18
19
 
# File 'app/controllers/sql_optimizer/sql_optimizer_controller.rb', line 16

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

#index ⇒ Object

GET /sql_optimizer



8
9
10
11
12
13
 
# File 'app/controllers/sql_optimizer/sql_optimizer_controller.rb', line 8

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