Class: SqlOptimizerController
- Inherits:
-
ApplicationController
- Object
- ApplicationController
- SqlOptimizerController
- Defined in:
- app/controllers/sql_optimizer/sql_optimizer_controller.rb
Instance Method Summary collapse
-
#graph ⇒ Object
GET /graph.
-
#index ⇒ Object
GET /sql_optimizer.
Instance Method Details
#graph ⇒ Object
GET /graph
14 15 16 17 |
# File 'app/controllers/sql_optimizer/sql_optimizer_controller.rb', line 14 def graph @query_logs = QueryLog.where.not(source: nil) render json: collect_graph.to_json end |
#index ⇒ Object
GET /sql_optimizer
6 7 8 9 10 11 |
# File 'app/controllers/sql_optimizer/sql_optimizer_controller.rb', line 6 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 |