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 9, 2026 | 31 | 17.84 ms | 1.0 ms | 41.0 ms |
| Nov 12, 2026 | 22 | 19.91 ms | 1.0 ms | 46.0 ms |
| Nov 13, 2026 | 14 | 22.21 ms | 1.0 ms | 34.0 ms |
| Nov 18, 2026 | 20 | 16.5 ms | 1.0 ms | 34.0 ms |
| Nov 8, 2026 | 6 | 24.67 ms | 2.0 ms | 40.0 ms |
| Nov 10, 2026 | 17 | 14.94 ms | 2.0 ms | 41.0 ms |
| Nov 20, 2026 | 12 | 18.17 ms | 2.0 ms | 31.0 ms |
| Nov 19, 2026 | 8 | 18.13 ms | 3.0 ms | 31.0 ms |
| Nov 22, 2026 | 7 | 19.43 ms | 3.0 ms | 35.0 ms |
| Nov 16, 2026 | 7 | 19.86 ms | 4.0 ms | 32.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
DELETE FROM posts WHERE id = ?
Diagnostics
Query Characteristics
- Query Type
- DELETE
- 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 :posts, :id
— Fast lookups for id = value queries
add_index :posts, :id
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/models/post.rb:42 |
34.0 | — | 179 |
app/jobs/notification_job.rb:79 |
41.0 | — | 1 |
app/jobs/cache_warming_job.rb:99 |
40.0 | — | 1 |
app/jobs/image_processing_job.rb:109 |
42.0 | — | 1 |
app/jobs/image_processing_job.rb:76 |
40.0 | — | 1 |
app/jobs/cache_warming_job.rb:83 |
8.0 | — | 1 |
app/jobs/data_export_job.rb:77 |
7.0 | — | 1 |
app/mailers/user_mailer.rb:14 |
30.0 | — | 1 |
app/jobs/notification_job.rb:67 |
24.0 | — | 1 |
app/jobs/notification_job.rb:96 |
27.0 | — | 1 |
app/jobs/analytics_job.rb:23 |
46.0 | — | 1 |
app/jobs/cache_warming_job.rb:86 |
41.0 | — | 2 |
app/jobs/cleanup_job.rb:91 |
34.0 | — | 1 |
app/jobs/report_generator_job.rb:66 |
18.0 | — | 1 |
app/jobs/image_processing_job.rb:24 |
12.0 | — | 1 |
app/mailers/user_mailer.rb:105 |
21.0 | — | 1 |
app/mailers/user_mailer.rb:10 |
15.0 | — | 1 |
app/mailers/user_mailer.rb:74 |
25.0 | — | 1 |
app/jobs/cache_warming_job.rb:43 |
41.0 | — | 1 |
app/jobs/import_job.rb:24 |
11.0 | — | 1 |
app/jobs/cache_warming_job.rb:98 |
39.0 | — | 1 |
app/jobs/cache_warming_job.rb:67 |
2.0 | — | 1 |
app/jobs/cache_warming_job.rb:110 |
2.0 | — | 1 |
app/mailers/user_mailer.rb:12 |
40.0 | — | 1 |
app/jobs/cache_warming_job.rb:44 |
37.0 | — | 1 |
Raw Data
{
"query": {
"id": 7206,
"normalized_sql": "DELETE FROM posts WHERE id = ?",
"analyzed_at": "2026-11-22 13:02:24 UTC"
},
"performance": {
"total_executions": 204,
"p95_duration_ms": "35.0",
"avg_duration_ms": 18.8333,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "DELETE",
"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/post.rb:42",
"count": 179,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:86",
"count": 2,
"p95_duration_ms": "41.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:44",
"count": 1,
"p95_duration_ms": "37.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:12",
"count": 1,
"p95_duration_ms": "40.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:110",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:67",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:98",
"count": 1,
"p95_duration_ms": "39.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:24",
"count": 1,
"p95_duration_ms": "11.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:43",
"count": 1,
"p95_duration_ms": "41.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:74",
"count": 1,
"p95_duration_ms": "25.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:10",
"count": 1,
"p95_duration_ms": "15.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:105",
"count": 1,
"p95_duration_ms": "21.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:24",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:66",
"count": 1,
"p95_duration_ms": "18.0",
"p95_row_count": null
},
{
"location": "app/jobs/cleanup_job.rb:91",
"count": 1,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/analytics_job.rb:23",
"count": 1,
"p95_duration_ms": "46.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:96",
"count": 1,
"p95_duration_ms": "27.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:67",
"count": 1,
"p95_duration_ms": "24.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:14",
"count": 1,
"p95_duration_ms": "30.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:77",
"count": 1,
"p95_duration_ms": "7.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:83",
"count": 1,
"p95_duration_ms": "8.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:76",
"count": 1,
"p95_duration_ms": "40.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:109",
"count": 1,
"p95_duration_ms": "42.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:99",
"count": 1,
"p95_duration_ms": "40.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:79",
"count": 1,
"p95_duration_ms": "41.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :posts, :id"
],
"issues": []
}