P95 Query Time
34 ms
Compared to previous 7 days
Query Responses
Click marker to copy SHA
| Time Period ▼ | Executions | Avg Duration | Min Duration | Max Duration |
|---|---|---|---|---|
| Nov 22, 2026 | 7 | 17.14 ms | 1.0 ms | 32.0 ms |
| Nov 21, 2026 | 19 | 17.42 ms | 1.0 ms | 35.0 ms |
| Nov 20, 2026 | 14 | 20.14 ms | 1.0 ms | 35.0 ms |
| Nov 19, 2026 | 6 | 23.33 ms | 2.0 ms | 33.0 ms |
| Nov 18, 2026 | 16 | 21.75 ms | 7.0 ms | 34.0 ms |
| Nov 17, 2026 | 12 | 18.92 ms | 1.0 ms | 32.0 ms |
| Nov 16, 2026 | 5 | 12.8 ms | 2.0 ms | 34.0 ms |
| Nov 15, 2026 | 12 | 20.33 ms | 7.0 ms | 35.0 ms |
| Nov 14, 2026 | 12 | 18.92 ms | 3.0 ms | 43.0 ms |
| Nov 13, 2026 | 15 | 19.2 ms | 2.0 ms | 36.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
UPDATE posts SET title = ?, content = ?, updated_at = ? WHERE id = ?
Diagnostics
Query Characteristics
- Query Type
- UPDATE
- Tables
- 0
- Joins
- 0
- Complexity Score
- 1
- Has LIMIT
- No
- Has ORDER BY
- No
- Has GROUP BY
- No
- Has Subqueries
- No
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/models/post.rb:35 |
34.0 | — | 164 |
app/jobs/cache_warming_job.rb:36 |
17.0 | — | 2 |
app/jobs/image_processing_job.rb:51 |
43.0 | — | 1 |
app/jobs/cache_warming_job.rb:80 |
4.0 | — | 1 |
app/mailers/user_mailer.rb:82 |
27.0 | — | 1 |
app/jobs/cache_warming_job.rb:119 |
36.0 | — | 1 |
app/jobs/cache_warming_job.rb:100 |
27.0 | — | 1 |
app/jobs/notification_job.rb:21 |
50.0 | — | 1 |
app/jobs/cache_warming_job.rb:49 |
44.0 | — | 1 |
app/jobs/image_processing_job.rb:71 |
36.0 | — | 1 |
app/jobs/notification_job.rb:60 |
39.0 | — | 1 |
app/jobs/notification_job.rb:26 |
4.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:26 |
4.0 | — | 1 |
app/jobs/notification_job.rb:15 |
19.0 | — | 1 |
app/jobs/notification_job.rb:53 |
31.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:55 |
13.0 | — | 1 |
app/jobs/data_export_job.rb:36 |
17.0 | — | 1 |
app/jobs/notification_job.rb:24 |
8.0 | — | 1 |
app/jobs/data_export_job.rb:71 |
2.0 | — | 1 |
app/jobs/analytics_job.rb:112 |
32.0 | — | 1 |
app/jobs/image_processing_job.rb:95 |
17.0 | — | 1 |
app/jobs/cache_warming_job.rb:88 |
10.0 | — | 1 |
app/jobs/data_export_job.rb:56 |
10.0 | — | 1 |
app/mailers/user_mailer.rb:109 |
18.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:43 |
18.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:60 |
32.0 | — | 1 |
app/jobs/image_processing_job.rb:82 |
12.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:77 |
15.0 | — | 1 |
app/mailers/user_mailer.rb:115 |
32.0 | — | 1 |
Raw Data
{
"query": {
"id": 7205,
"normalized_sql": "UPDATE posts SET title = ?, content = ?, updated_at = ? WHERE id = ?",
"analyzed_at": "2026-11-22 13:02:24 UTC"
},
"performance": {
"total_executions": 193,
"p95_duration_ms": "35.0",
"avg_duration_ms": 19.8135,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "UPDATE",
"table_count": 0,
"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": 1
},
"call_locations": [
{
"location": "app/models/post.rb:35",
"count": 164,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:36",
"count": 2,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:51",
"count": 1,
"p95_duration_ms": "43.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:80",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:82",
"count": 1,
"p95_duration_ms": "27.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:119",
"count": 1,
"p95_duration_ms": "36.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:100",
"count": 1,
"p95_duration_ms": "27.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:21",
"count": 1,
"p95_duration_ms": "50.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:49",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:71",
"count": 1,
"p95_duration_ms": "36.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/notification_job.rb:26",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:26",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:15",
"count": 1,
"p95_duration_ms": "19.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:53",
"count": 1,
"p95_duration_ms": "31.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:55",
"count": 1,
"p95_duration_ms": "13.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:36",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:24",
"count": 1,
"p95_duration_ms": "8.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:71",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/analytics_job.rb:112",
"count": 1,
"p95_duration_ms": "32.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:95",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:88",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:56",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:109",
"count": 1,
"p95_duration_ms": "18.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:43",
"count": 1,
"p95_duration_ms": "18.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:60",
"count": 1,
"p95_duration_ms": "32.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:82",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:77",
"count": 1,
"p95_duration_ms": "15.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:115",
"count": 1,
"p95_duration_ms": "32.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [],
"issues": []
}