P95 Query Time
36 ms
Compared to previous 7 days
Query Responses
Click marker to copy SHA
| Time Period | Executions | Avg Duration ▲ | Min Duration | Max Duration |
|---|---|---|---|---|
| Nov 11, 2026 | 15 | 19.6 ms | 1.0 ms | 42.0 ms |
| Nov 22, 2026 | 2 | 20.0 ms | 19.0 ms | 21.0 ms |
| Nov 10, 2026 | 16 | 20.75 ms | 3.0 ms | 46.0 ms |
| Nov 13, 2026 | 15 | 22.8 ms | 1.0 ms | 46.0 ms |
| Nov 8, 2026 | 5 | 23.2 ms | 2.0 ms | 49.0 ms |
Total of 15 record(s).
Page 2 of 2
Normalized Query
SELECT id, name FROM users WHERE email = ?
Diagnostics
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
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/models/application_record.rb:12 |
34.0 | — | 175 |
app/jobs/image_processing_job.rb:92 |
48.0 | — | 1 |
app/jobs/cache_warming_job.rb:69 |
14.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:67 |
23.0 | — | 1 |
app/jobs/cache_warming_job.rb:80 |
2.0 | — | 1 |
app/jobs/cache_warming_job.rb:102 |
43.0 | — | 1 |
app/jobs/report_generator_job.rb:31 |
42.0 | — | 1 |
app/jobs/data_export_job.rb:75 |
20.0 | — | 1 |
app/mailers/user_mailer.rb:11 |
46.0 | — | 1 |
app/jobs/cache_warming_job.rb:40 |
10.0 | — | 1 |
app/jobs/notification_job.rb:100 |
38.0 | — | 1 |
app/jobs/image_processing_job.rb:74 |
42.0 | — | 1 |
app/jobs/cache_warming_job.rb:108 |
25.0 | — | 1 |
app/jobs/cache_warming_job.rb:36 |
30.0 | — | 1 |
app/jobs/image_processing_job.rb:45 |
3.0 | — | 1 |
app/jobs/notification_job.rb:83 |
46.0 | — | 1 |
app/jobs/notification_job.rb:40 |
10.0 | — | 1 |
app/jobs/cache_warming_job.rb:11 |
41.0 | — | 1 |
app/jobs/notification_job.rb:110 |
44.0 | — | 1 |
app/mailers/user_mailer.rb:13 |
23.0 | — | 1 |
app/jobs/notification_job.rb:54 |
36.0 | — | 1 |
app/mailers/user_mailer.rb:28 |
49.0 | — | 1 |
Raw Data
{
"query": {
"id": 7207,
"normalized_sql": "SELECT id, name FROM users WHERE email = ?",
"analyzed_at": "2026-11-22 13:02:24 UTC"
},
"performance": {
"total_executions": 196,
"p95_duration_ms": "38.0",
"avg_duration_ms": 19.1122,
"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": 175,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:92",
"count": 1,
"p95_duration_ms": "48.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:69",
"count": 1,
"p95_duration_ms": "14.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:67",
"count": 1,
"p95_duration_ms": "23.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:80",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:102",
"count": 1,
"p95_duration_ms": "43.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:31",
"count": 1,
"p95_duration_ms": "42.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:75",
"count": 1,
"p95_duration_ms": "20.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:11",
"count": 1,
"p95_duration_ms": "46.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:40",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:100",
"count": 1,
"p95_duration_ms": "38.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:74",
"count": 1,
"p95_duration_ms": "42.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:108",
"count": 1,
"p95_duration_ms": "25.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:36",
"count": 1,
"p95_duration_ms": "30.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:45",
"count": 1,
"p95_duration_ms": "3.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:83",
"count": 1,
"p95_duration_ms": "46.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:40",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:11",
"count": 1,
"p95_duration_ms": "41.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:110",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:13",
"count": 1,
"p95_duration_ms": "23.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:54",
"count": 1,
"p95_duration_ms": "36.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:28",
"count": 1,
"p95_duration_ms": "49.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"
}