P95 Query Time
35 ms
Compared to previous 7 days
Query Responses
Click marker to copy SHA
| Time Period | Executions | Avg Duration ▲ | Min Duration | Max Duration |
|---|---|---|---|---|
| Nov 9, 2026 | 13 | 15.77 ms | 4.0 ms | 34.0 ms |
| Nov 12, 2026 | 19 | 17.89 ms | 1.0 ms | 40.0 ms |
| Nov 13, 2026 | 15 | 19.0 ms | 1.0 ms | 37.0 ms |
| Nov 16, 2026 | 12 | 19.0 ms | 4.0 ms | 35.0 ms |
| Nov 21, 2026 | 17 | 19.0 ms | 1.0 ms | 34.0 ms |
| Nov 18, 2026 | 12 | 19.42 ms | 2.0 ms | 30.0 ms |
| Nov 20, 2026 | 11 | 19.55 ms | 3.0 ms | 35.0 ms |
| Nov 8, 2026 | 8 | 19.75 ms | 9.0 ms | 33.0 ms |
| Nov 19, 2026 | 11 | 20.09 ms | 5.0 ms | 35.0 ms |
| Nov 14, 2026 | 15 | 20.4 ms | 2.0 ms | 47.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
SELECT id, name, email FROM users WHERE id = ?
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, :id
— Fast lookups for id = value queries
add_index :users, :id
Execution Plan
2 | 0 | 33 | SEARCH users USING INTEGER PRIMARY KEY (rowid=?)
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/models/user.rb:15 |
34.0 | — | 159 |
app/jobs/notification_job.rb:74 |
10.0 | — | 1 |
app/jobs/image_processing_job.rb:20 |
47.0 | — | 1 |
app/jobs/report_generator_job.rb:31 |
28.0 | — | 1 |
app/jobs/cache_warming_job.rb:101 |
23.0 | — | 1 |
app/jobs/data_export_job.rb:95 |
37.0 | — | 1 |
app/jobs/notification_job.rb:33 |
31.0 | — | 1 |
app/mailers/user_mailer.rb:45 |
22.0 | — | 1 |
app/mailers/user_mailer.rb:49 |
9.0 | — | 1 |
app/mailers/user_mailer.rb:101 |
5.0 | — | 1 |
app/jobs/cache_warming_job.rb:91 |
48.0 | — | 2 |
app/jobs/cache_warming_job.rb:51 |
26.0 | — | 1 |
app/jobs/cache_warming_job.rb:33 |
18.0 | — | 1 |
app/jobs/cache_warming_job.rb:86 |
12.0 | — | 1 |
app/jobs/cache_warming_job.rb:59 |
50.0 | — | 1 |
app/jobs/cache_warming_job.rb:27 |
35.0 | — | 1 |
app/jobs/cache_warming_job.rb:95 |
20.0 | — | 1 |
app/jobs/notification_job.rb:49 |
37.0 | — | 1 |
app/jobs/notification_job.rb:26 |
45.0 | — | 1 |
app/jobs/cache_warming_job.rb:115 |
27.0 | — | 1 |
app/jobs/cache_warming_job.rb:44 |
47.0 | — | 1 |
app/mailers/user_mailer.rb:117 |
6.0 | — | 1 |
app/jobs/cache_warming_job.rb:97 |
24.0 | — | 1 |
app/jobs/cache_warming_job.rb:69 |
4.0 | — | 1 |
app/jobs/cache_warming_job.rb:63 |
33.0 | — | 1 |
app/jobs/cache_warming_job.rb:92 |
17.0 | — | 1 |
Raw Data
{
"query": {
"id": 7199,
"normalized_sql": "SELECT id, name, email FROM users WHERE id = ?",
"analyzed_at": "2026-11-22 13:02:24 UTC"
},
"performance": {
"total_executions": 185,
"p95_duration_ms": "35.0",
"avg_duration_ms": 20.5568,
"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/user.rb:15",
"count": 159,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:91",
"count": 2,
"p95_duration_ms": "48.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:92",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:63",
"count": 1,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:69",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:97",
"count": 1,
"p95_duration_ms": "24.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:117",
"count": 1,
"p95_duration_ms": "6.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:44",
"count": 1,
"p95_duration_ms": "47.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:115",
"count": 1,
"p95_duration_ms": "27.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:26",
"count": 1,
"p95_duration_ms": "45.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:49",
"count": 1,
"p95_duration_ms": "37.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:95",
"count": 1,
"p95_duration_ms": "20.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:27",
"count": 1,
"p95_duration_ms": "35.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:59",
"count": 1,
"p95_duration_ms": "50.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:86",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:33",
"count": 1,
"p95_duration_ms": "18.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:51",
"count": 1,
"p95_duration_ms": "26.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:101",
"count": 1,
"p95_duration_ms": "5.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:49",
"count": 1,
"p95_duration_ms": "9.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:45",
"count": 1,
"p95_duration_ms": "22.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:33",
"count": 1,
"p95_duration_ms": "31.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:95",
"count": 1,
"p95_duration_ms": "37.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:101",
"count": 1,
"p95_duration_ms": "23.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:31",
"count": 1,
"p95_duration_ms": "28.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:20",
"count": 1,
"p95_duration_ms": "47.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:74",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :users, :id",
"add_index :users, [\"id\", \"name\", \"email\"], name: 'covering_idx_users_id'"
],
"issues": [],
"explain_plan": "2 | 0 | 33 | SEARCH users USING INTEGER PRIMARY KEY (rowid=?)"
}