P95 Query Time

P95 Query Time

The 95th percentile database query duration — 95% of queries complete faster than this. Weighted by execution frequency across all queries. Slow queries are often caused by missing indexes or N+1 patterns.

34 ms

19.8%

Compared to previous 7 days

Execution Rate

Query Execution Rate

Total database queries executed over the last 14 days, expressed as an average rate. Spikes may indicate N+1 queries or inefficient data access patterns.

13.93 / day

6.9%

Compared to previous 7 days

Query Responses

Query Responses

This panel shows all executions of this query, including performance metrics, duration distribution, and query execution details.

Click marker to copy SHA
Time Period ▼ Executions Avg Duration Min Duration Max Duration
Nov 12, 2026 16 21.13 ms 4.0 ms 44.0 ms
Nov 11, 2026 6 25.83 ms 6.0 ms 44.0 ms
Nov 10, 2026 25 18.56 ms 2.0 ms 40.0 ms
Nov 9, 2026 15 20.0 ms 2.0 ms 39.0 ms
Nov 8, 2026 6 19.33 ms 9.0 ms 32.0 ms
Total of 15 record(s).

Normalized Query

SELECT id, name FROM users WHERE email = ?

Diagnostics

Query Diagnostics

Automatically generated analysis for this query. Includes N+1 detection (from live request data), query characteristics, detected issues, optimization suggestions, and a database EXPLAIN plan. Click Re-analyze to regenerate.


Query Characteristics
Query Type
SELECT
Tables
1
Joins
0
Complexity Score
3
Has LIMIT
No
Has ORDER BY
No
Has GROUP BY
No
Has Subqueries
No

Optimization Suggestions
  • Add single_column index: add_index :users, :email — Fast lookups for email = value queries
    add_index :users, :email

Execution Plan
2 | 0 | 216 | SCAN users

Query Locations

Query Locations

Shows where in your codebase this query originates, based on the last 30 days of executions. P95 duration and row count highlight the worst-case performance at each call site.

Location P95 Duration (ms) P95 Row Count Count
app/models/application_record.rb:12 33.0 — 167
app/jobs/notification_job.rb:12 45.0 — 1
app/jobs/report_generator_job.rb:29 42.0 — 1
app/jobs/cache_warming_job.rb:110 30.0 — 1
app/jobs/notification_job.rb:57 6.0 — 1
app/jobs/cache_warming_job.rb:86 35.0 — 1
app/mailers/user_mailer.rb:53 20.0 — 1
app/jobs/notification_job.rb:14 32.0 — 1
app/jobs/cache_warming_job.rb:105 36.0 — 1
app/jobs/webhook_delivery_job.rb:94 36.0 — 1
app/jobs/cache_warming_job.rb:60 29.0 — 2
app/jobs/cache_warming_job.rb:69 44.0 — 1
app/jobs/import_job.rb:89 16.0 — 1
app/mailers/user_mailer.rb:28 15.0 — 1
app/jobs/cache_warming_job.rb:39 4.0 — 1
app/jobs/analytics_job.rb:66 24.0 — 1
app/jobs/image_processing_job.rb:46 44.0 — 1
app/jobs/image_processing_job.rb:80 38.0 — 1
app/jobs/cache_warming_job.rb:68 21.0 — 1
app/jobs/data_export_job.rb:107 24.0 — 1
app/jobs/image_processing_job.rb:112 40.0 — 1
app/jobs/analytics_job.rb:96 25.0 — 1
app/jobs/analytics_job.rb:70 35.0 — 1
app/jobs/notification_job.rb:34 12.0 — 1
app/jobs/data_export_job.rb:109 8.0 — 1
app/jobs/cache_warming_job.rb:97 25.0 — 1
app/jobs/notification_job.rb:60 39.0 — 1
app/jobs/cache_warming_job.rb:27 9.0 — 1

Raw Data

{
  "query": {
    "id": 7253,
    "normalized_sql": "SELECT id, name FROM users WHERE email = ?",
    "analyzed_at": "2026-11-22 15:02:25 UTC"
  },
  "performance": {
    "total_executions": 195,
    "p95_duration_ms": "35.0",
    "avg_duration_ms": 18.7538,
    "p95_row_count": null,
    "avg_row_count": null
  },
  "characteristics": {
    "query_type": "SELECT",
    "table_count": 1,
    "join_count": 0,
    "where_clause_complexity": 1,
    "has_subqueries": false,
    "has_limit": false,
    "has_order_by": false,
    "has_group_by": false,
    "has_having": false,
    "has_distinct": false,
    "has_aggregations": false,
    "estimated_complexity": 3
  },
  "call_locations": [
    {
      "location": "app/models/application_record.rb:12",
      "count": 167,
      "p95_duration_ms": "33.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:60",
      "count": 2,
      "p95_duration_ms": "29.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:27",
      "count": 1,
      "p95_duration_ms": "9.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:60",
      "count": 1,
      "p95_duration_ms": "39.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:97",
      "count": 1,
      "p95_duration_ms": "25.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/data_export_job.rb:109",
      "count": 1,
      "p95_duration_ms": "8.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:34",
      "count": 1,
      "p95_duration_ms": "12.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/analytics_job.rb:70",
      "count": 1,
      "p95_duration_ms": "35.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/analytics_job.rb:96",
      "count": 1,
      "p95_duration_ms": "25.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/image_processing_job.rb:112",
      "count": 1,
      "p95_duration_ms": "40.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/data_export_job.rb:107",
      "count": 1,
      "p95_duration_ms": "24.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:68",
      "count": 1,
      "p95_duration_ms": "21.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/image_processing_job.rb:80",
      "count": 1,
      "p95_duration_ms": "38.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/image_processing_job.rb:46",
      "count": 1,
      "p95_duration_ms": "44.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/analytics_job.rb:66",
      "count": 1,
      "p95_duration_ms": "24.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:39",
      "count": 1,
      "p95_duration_ms": "4.0",
      "p95_row_count": null
    },
    {
      "location": "app/mailers/user_mailer.rb:28",
      "count": 1,
      "p95_duration_ms": "15.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/import_job.rb:89",
      "count": 1,
      "p95_duration_ms": "16.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:69",
      "count": 1,
      "p95_duration_ms": "44.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/webhook_delivery_job.rb:94",
      "count": 1,
      "p95_duration_ms": "36.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:105",
      "count": 1,
      "p95_duration_ms": "36.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:14",
      "count": 1,
      "p95_duration_ms": "32.0",
      "p95_row_count": null
    },
    {
      "location": "app/mailers/user_mailer.rb:53",
      "count": 1,
      "p95_duration_ms": "20.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:86",
      "count": 1,
      "p95_duration_ms": "35.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:57",
      "count": 1,
      "p95_duration_ms": "6.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:110",
      "count": 1,
      "p95_duration_ms": "30.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/report_generator_job.rb:29",
      "count": 1,
      "p95_duration_ms": "42.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:12",
      "count": 1,
      "p95_duration_ms": "45.0",
      "p95_row_count": null
    }
  ],
  "n_plus_one": {
    "detected": false
  },
  "index_recommendations": [
    "add_index :users, :email",
    "add_index :users, [\"email\", \"id\", \"name\"], name: 'covering_idx_users_email'"
  ],
  "issues": [],
  "explain_plan": "2 | 0 | 216 | SCAN users"
}