P95 Query Time
33 ms
Compared to previous 7 days
Query Responses
Click marker to copy SHA
| Time Period | Executions | Avg Duration | Min Duration ▲ | Max Duration |
|---|---|---|---|---|
| Nov 14, 2026 | 20 | 19.95 ms | 4.0 ms | 40.0 ms |
| Nov 15, 2026 | 11 | 18.82 ms | 6.0 ms | 33.0 ms |
| Nov 17, 2026 | 9 | 16.11 ms | 6.0 ms | 31.0 ms |
| Nov 22, 2026 | 10 | 21.1 ms | 13.0 ms | 31.0 ms |
| Nov 8, 2026 | 7 | 30.86 ms | 22.0 ms | 48.0 ms |
Total of 15 record(s).
Page 2 of 2
Normalized Query
UPDATE posts SET view_count = view_count + ? WHERE published = ?
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:67 |
33.0 | — | 173 |
app/jobs/notification_job.rb:35 |
20.0 | — | 1 |
app/jobs/cache_warming_job.rb:79 |
32.0 | — | 1 |
app/jobs/data_export_job.rb:105 |
40.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:79 |
13.0 | — | 1 |
app/jobs/image_processing_job.rb:76 |
21.0 | — | 1 |
app/jobs/cache_warming_job.rb:97 |
16.0 | — | 1 |
app/jobs/image_processing_job.rb:38 |
33.0 | — | 1 |
app/jobs/image_processing_job.rb:44 |
9.0 | — | 1 |
app/jobs/cache_warming_job.rb:101 |
40.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:116 |
24.0 | — | 1 |
app/jobs/notification_job.rb:31 |
11.0 | — | 1 |
app/jobs/import_job.rb:60 |
44.0 | — | 1 |
app/jobs/image_processing_job.rb:12 |
41.0 | — | 1 |
app/jobs/cache_warming_job.rb:19 |
41.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:109 |
37.0 | — | 1 |
app/jobs/report_generator_job.rb:74 |
40.0 | — | 1 |
app/jobs/cache_warming_job.rb:16 |
14.0 | — | 1 |
app/jobs/data_export_job.rb:22 |
22.0 | — | 1 |
app/jobs/import_job.rb:114 |
35.0 | — | 1 |
app/jobs/notification_job.rb:80 |
18.0 | — | 1 |
app/jobs/data_export_job.rb:69 |
42.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:23 |
42.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:110 |
31.0 | — | 1 |
app/jobs/cache_warming_job.rb:31 |
2.0 | — | 1 |
app/jobs/image_processing_job.rb:83 |
10.0 | — | 1 |
app/jobs/cleanup_job.rb:49 |
31.0 | — | 1 |
app/jobs/cache_warming_job.rb:22 |
2.0 | — | 1 |
app/jobs/notification_job.rb:112 |
3.0 | — | 1 |
app/jobs/data_export_job.rb:109 |
29.0 | — | 1 |
app/mailers/user_mailer.rb:104 |
48.0 | — | 1 |
app/jobs/analytics_job.rb:21 |
27.0 | — | 1 |
app/jobs/cache_warming_job.rb:99 |
29.0 | — | 1 |
Raw Data
{
"query": {
"id": 7219,
"normalized_sql": "UPDATE posts SET view_count = view_count + ? WHERE published = ?",
"analyzed_at": "2026-11-22 13:02:24 UTC"
},
"performance": {
"total_executions": 205,
"p95_duration_ms": "35.0",
"avg_duration_ms": 18.1902,
"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:67",
"count": 173,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:35",
"count": 1,
"p95_duration_ms": "20.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:79",
"count": 1,
"p95_duration_ms": "32.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:105",
"count": 1,
"p95_duration_ms": "40.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:79",
"count": 1,
"p95_duration_ms": "13.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:76",
"count": 1,
"p95_duration_ms": "21.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:97",
"count": 1,
"p95_duration_ms": "16.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:38",
"count": 1,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:44",
"count": 1,
"p95_duration_ms": "9.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:101",
"count": 1,
"p95_duration_ms": "40.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:116",
"count": 1,
"p95_duration_ms": "24.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:31",
"count": 1,
"p95_duration_ms": "11.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:60",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:12",
"count": 1,
"p95_duration_ms": "41.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:19",
"count": 1,
"p95_duration_ms": "41.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:109",
"count": 1,
"p95_duration_ms": "37.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:74",
"count": 1,
"p95_duration_ms": "40.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:16",
"count": 1,
"p95_duration_ms": "14.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:22",
"count": 1,
"p95_duration_ms": "22.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:114",
"count": 1,
"p95_duration_ms": "35.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:80",
"count": 1,
"p95_duration_ms": "18.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:69",
"count": 1,
"p95_duration_ms": "42.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:23",
"count": 1,
"p95_duration_ms": "42.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:110",
"count": 1,
"p95_duration_ms": "31.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:31",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:83",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
},
{
"location": "app/jobs/cleanup_job.rb:49",
"count": 1,
"p95_duration_ms": "31.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:22",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:112",
"count": 1,
"p95_duration_ms": "3.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:109",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:104",
"count": 1,
"p95_duration_ms": "48.0",
"p95_row_count": null
},
{
"location": "app/jobs/analytics_job.rb:21",
"count": 1,
"p95_duration_ms": "27.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:99",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [],
"issues": []
}