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 9, 2026 | 16 | 24.0 ms | 3.0 ms | 50.0 ms |
| Nov 10, 2026 | 18 | 19.22 ms | 2.0 ms | 49.0 ms |
| Nov 14, 2026 | 17 | 21.94 ms | 2.0 ms | 45.0 ms |
| Nov 12, 2026 | 18 | 19.83 ms | 1.0 ms | 44.0 ms |
| Nov 8, 2026 | 9 | 14.67 ms | 2.0 ms | 43.0 ms |
| Nov 13, 2026 | 17 | 21.82 ms | 1.0 ms | 40.0 ms |
| Nov 18, 2026 | 13 | 16.15 ms | 4.0 ms | 35.0 ms |
| Nov 19, 2026 | 10 | 23.7 ms | 5.0 ms | 35.0 ms |
| Nov 22, 2026 | 9 | 21.56 ms | 2.0 ms | 35.0 ms |
| Nov 11, 2026 | 14 | 19.93 ms | 10.0 ms | 34.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
DELETE FROM comments WHERE created_at < ?
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
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/jobs/cleanup_job.rb:23 |
33.0 | — | 169 |
app/jobs/webhook_delivery_job.rb:107 |
26.0 | — | 1 |
app/jobs/cache_warming_job.rb:92 |
29.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:58 |
31.0 | — | 1 |
app/jobs/analytics_job.rb:71 |
45.0 | — | 1 |
app/jobs/image_processing_job.rb:117 |
40.0 | — | 1 |
app/jobs/image_processing_job.rb:84 |
17.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:99 |
40.0 | — | 2 |
app/jobs/cache_warming_job.rb:71 |
26.0 | — | 1 |
app/mailers/user_mailer.rb:87 |
29.0 | — | 1 |
app/jobs/cache_warming_job.rb:61 |
31.0 | — | 2 |
app/jobs/cache_warming_job.rb:41 |
2.0 | — | 1 |
app/jobs/notification_job.rb:97 |
20.0 | — | 1 |
app/jobs/cache_warming_job.rb:17 |
44.0 | — | 2 |
app/jobs/analytics_job.rb:67 |
9.0 | — | 1 |
app/jobs/image_processing_job.rb:71 |
36.0 | — | 1 |
app/jobs/cleanup_job.rb:42 |
37.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:94 |
12.0 | — | 1 |
app/jobs/cache_warming_job.rb:114 |
49.0 | — | 1 |
app/jobs/notification_job.rb:18 |
4.0 | — | 1 |
app/jobs/data_export_job.rb:98 |
50.0 | — | 1 |
app/jobs/analytics_job.rb:47 |
10.0 | — | 1 |
app/jobs/notification_job.rb:29 |
26.0 | — | 1 |
app/jobs/notification_job.rb:106 |
6.0 | — | 1 |
app/jobs/report_generator_job.rb:27 |
47.0 | — | 1 |
app/jobs/cache_warming_job.rb:94 |
10.0 | — | 1 |
app/jobs/data_export_job.rb:68 |
2.0 | — | 1 |
app/jobs/cache_warming_job.rb:28 |
43.0 | — | 1 |
Raw Data
{
"query": {
"id": 7243,
"normalized_sql": "DELETE FROM comments WHERE created_at < ?",
"analyzed_at": "2026-11-22 14:02:27 UTC"
},
"performance": {
"total_executions": 199,
"p95_duration_ms": "37.0",
"avg_duration_ms": 19.3869,
"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/jobs/cleanup_job.rb:23",
"count": 169,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:99",
"count": 2,
"p95_duration_ms": "40.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:61",
"count": 2,
"p95_duration_ms": "31.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:17",
"count": 2,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:28",
"count": 1,
"p95_duration_ms": "43.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:68",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:94",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:27",
"count": 1,
"p95_duration_ms": "47.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:106",
"count": 1,
"p95_duration_ms": "6.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:29",
"count": 1,
"p95_duration_ms": "26.0",
"p95_row_count": null
},
{
"location": "app/jobs/analytics_job.rb:47",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:98",
"count": 1,
"p95_duration_ms": "50.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:18",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:114",
"count": 1,
"p95_duration_ms": "49.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:94",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/cleanup_job.rb:42",
"count": 1,
"p95_duration_ms": "37.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/analytics_job.rb:67",
"count": 1,
"p95_duration_ms": "9.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:97",
"count": 1,
"p95_duration_ms": "20.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:41",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:87",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:71",
"count": 1,
"p95_duration_ms": "26.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:84",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:117",
"count": 1,
"p95_duration_ms": "40.0",
"p95_row_count": null
},
{
"location": "app/jobs/analytics_job.rb:71",
"count": 1,
"p95_duration_ms": "45.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:58",
"count": 1,
"p95_duration_ms": "31.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:92",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:107",
"count": 1,
"p95_duration_ms": "26.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :comments, :created_at"
],
"issues": []
}