Class: RailsPulse::Queries::Cards::AverageQueryTimes

Inherits:
Object
  • Object
show all
Defined in:
app/models/rails_pulse/queries/cards/average_query_times.rb

Instance Method Summary collapse

Constructor Details

#initialize(query:) ⇒ AverageQueryTimes

Returns a new instance of AverageQueryTimes.



5
6
7
 
# File 'app/models/rails_pulse/queries/cards/average_query_times.rb', line 5

def initialize(query:)
  @query = query
end

Instance Method Details

#to_metric_card ⇒ Object 



9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
 
# File 'app/models/rails_pulse/queries/cards/average_query_times.rb', line 9

def to_metric_card
  operations = if @query
    RailsPulse::Operation.where(query: @query)
  else
    RailsPulse::Operation.all
  end

  # Calculate overall average response time
  average_query_time = operations.average(:duration)&.round(0) || 0

  # Calculate trend by comparing last 7 days vs previous 7 days
  last_7_days = 7.days.ago.beginning_of_day
  previous_7_days = 14.days.ago.beginning_of_day
  current_period_avg = operations.where("occurred_at >= ?", last_7_days).average(:duration) || 0
  previous_period_avg = operations.where("occurred_at >= ? AND occurred_at < ?", previous_7_days, last_7_days).average(:duration) || 0

  percentage = previous_period_avg.zero? ?  0 : ((previous_period_avg - current_period_avg) / previous_period_avg * 100).abs.round(1)
  trend_icon = percentage < 0.1 ?  "move-right" : current_period_avg < previous_period_avg ? "trending-down" : "trending-up"
  trend_amount = previous_period_avg.zero? ? "0%" : "#{percentage}%"

  sparkline_data = operations
    .group_by_week(:occurred_at, time_zone: "UTC")
    .average(:duration)
    .each_with_object({}) do |(date, avg), hash|
      formatted_date = date.strftime("%b %-d")
      value = avg&.round(0) || 0
      hash[formatted_date] = {
        value: value
      }
    end

  {
    title: "Average Query Time",
    summary: "#{average_query_time} ms",
    line_chart_data: sparkline_data,
    trend_icon: trend_icon,
    trend_amount: trend_amount,
    trend_text: "Compared to last week"
  }
end