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 22, 2026 | 4 | 20.5 ms | 9.0 ms | 31.0 ms |
| Nov 21, 2026 | 13 | 20.46 ms | 8.0 ms | 35.0 ms |
| Nov 20, 2026 | 16 | 23.56 ms | 1.0 ms | 35.0 ms |
| Nov 19, 2026 | 12 | 13.75 ms | 1.0 ms | 27.0 ms |
| Nov 18, 2026 | 13 | 17.92 ms | 2.0 ms | 35.0 ms |
| Nov 17, 2026 | 16 | 16.0 ms | 5.0 ms | 33.0 ms |
| Nov 16, 2026 | 12 | 19.0 ms | 1.0 ms | 34.0 ms |
| Nov 15, 2026 | 15 | 18.6 ms | 2.0 ms | 35.0 ms |
| Nov 14, 2026 | 17 | 22.06 ms | 5.0 ms | 46.0 ms |
| Nov 13, 2026 | 15 | 21.73 ms | 6.0 ms | 50.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
INSERT INTO posts (user_id, title, content, published, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?)
Diagnostics
Query Characteristics
- Query Type
- INSERT
- Tables
- 0
- Joins
- 0
- Complexity Score
- 0
- 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:8 |
34.0 | — | 167 |
app/jobs/image_processing_job.rb:48 |
31.0 | — | 1 |
app/mailers/user_mailer.rb:103 |
46.0 | — | 1 |
app/jobs/report_generator_job.rb:45 |
5.0 | — | 1 |
app/jobs/notification_job.rb:65 |
12.0 | — | 1 |
app/jobs/cache_warming_job.rb:36 |
48.0 | — | 1 |
app/jobs/notification_job.rb:74 |
50.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:19 |
42.0 | — | 1 |
app/jobs/cache_warming_job.rb:101 |
23.0 | — | 1 |
app/mailers/user_mailer.rb:40 |
25.0 | — | 1 |
app/jobs/cache_warming_job.rb:104 |
18.0 | — | 1 |
app/jobs/cache_warming_job.rb:31 |
17.0 | — | 1 |
app/jobs/cache_warming_job.rb:26 |
17.0 | — | 1 |
app/jobs/cache_warming_job.rb:80 |
47.0 | — | 1 |
app/jobs/cache_warming_job.rb:113 |
38.0 | — | 1 |
app/jobs/cache_warming_job.rb:54 |
35.0 | — | 1 |
app/mailers/user_mailer.rb:15 |
34.0 | — | 1 |
app/jobs/cache_warming_job.rb:47 |
20.0 | — | 1 |
app/mailers/user_mailer.rb:71 |
30.0 | — | 1 |
app/mailers/user_mailer.rb:87 |
25.0 | — | 1 |
app/jobs/image_processing_job.rb:118 |
42.0 | — | 1 |
app/jobs/import_job.rb:69 |
29.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:80 |
3.0 | — | 1 |
app/jobs/image_processing_job.rb:27 |
36.0 | — | 1 |
app/jobs/image_processing_job.rb:76 |
8.0 | — | 1 |
app/jobs/cache_warming_job.rb:116 |
49.0 | — | 1 |
app/jobs/cache_warming_job.rb:45 |
21.0 | — | 1 |
app/jobs/cache_warming_job.rb:103 |
18.0 | — | 1 |
app/jobs/image_processing_job.rb:99 |
3.0 | — | 1 |
app/jobs/image_processing_job.rb:39 |
13.0 | — | 1 |
app/jobs/report_generator_job.rb:35 |
47.0 | — | 1 |
app/jobs/analytics_job.rb:57 |
40.0 | — | 1 |
Raw Data
{
"query": {
"id": 7250,
"normalized_sql": "INSERT INTO posts (user_id, title, content, published, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?)",
"analyzed_at": "2026-11-22 15:02:25 UTC"
},
"performance": {
"total_executions": 198,
"p95_duration_ms": "38.0",
"avg_duration_ms": 19.6818,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "INSERT",
"table_count": 0,
"join_count": 0,
"where_clause_complexity": 0,
"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": 0
},
"call_locations": [
{
"location": "app/models/post.rb:8",
"count": 167,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:48",
"count": 1,
"p95_duration_ms": "31.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:103",
"count": 1,
"p95_duration_ms": "46.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:45",
"count": 1,
"p95_duration_ms": "5.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:65",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:36",
"count": 1,
"p95_duration_ms": "48.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:74",
"count": 1,
"p95_duration_ms": "50.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:19",
"count": 1,
"p95_duration_ms": "42.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/mailers/user_mailer.rb:40",
"count": 1,
"p95_duration_ms": "25.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:104",
"count": 1,
"p95_duration_ms": "18.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:31",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:26",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:80",
"count": 1,
"p95_duration_ms": "47.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:113",
"count": 1,
"p95_duration_ms": "38.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:54",
"count": 1,
"p95_duration_ms": "35.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:15",
"count": 1,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:47",
"count": 1,
"p95_duration_ms": "20.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:71",
"count": 1,
"p95_duration_ms": "30.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:87",
"count": 1,
"p95_duration_ms": "25.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:118",
"count": 1,
"p95_duration_ms": "42.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:69",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:80",
"count": 1,
"p95_duration_ms": "3.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:27",
"count": 1,
"p95_duration_ms": "36.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:76",
"count": 1,
"p95_duration_ms": "8.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:116",
"count": 1,
"p95_duration_ms": "49.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:45",
"count": 1,
"p95_duration_ms": "21.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:103",
"count": 1,
"p95_duration_ms": "18.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:99",
"count": 1,
"p95_duration_ms": "3.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:39",
"count": 1,
"p95_duration_ms": "13.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:35",
"count": 1,
"p95_duration_ms": "47.0",
"p95_row_count": null
},
{
"location": "app/jobs/analytics_job.rb:57",
"count": 1,
"p95_duration_ms": "40.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [],
"issues": []
}