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 21, 2026 | 15 | 14.0 ms | 1.0 ms | 34.0 ms |
| Nov 19, 2026 | 16 | 12.94 ms | 1.0 ms | 34.0 ms |
| Nov 20, 2026 | 17 | 22.41 ms | 5.0 ms | 35.0 ms |
| Nov 9, 2026 | 20 | 21.65 ms | 3.0 ms | 45.0 ms |
| Nov 13, 2026 | 21 | 16.57 ms | 1.0 ms | 47.0 ms |
Total of 15 record(s).
Page 2 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 | — | 169 |
app/jobs/data_export_job.rb:97 |
21.0 | — | 1 |
app/jobs/cache_warming_job.rb:47 |
47.0 | — | 1 |
app/jobs/import_job.rb:78 |
19.0 | — | 1 |
app/jobs/cache_warming_job.rb:94 |
7.0 | — | 1 |
app/jobs/image_processing_job.rb:57 |
11.0 | — | 1 |
app/jobs/import_job.rb:120 |
37.0 | — | 1 |
app/jobs/image_processing_job.rb:116 |
27.0 | — | 1 |
app/jobs/cache_warming_job.rb:49 |
32.0 | — | 1 |
app/jobs/notification_job.rb:39 |
42.0 | — | 1 |
app/jobs/image_processing_job.rb:115 |
39.0 | — | 1 |
app/jobs/cache_warming_job.rb:61 |
28.0 | — | 1 |
app/jobs/notification_job.rb:79 |
25.0 | — | 1 |
app/jobs/report_generator_job.rb:49 |
4.0 | — | 1 |
app/jobs/cache_warming_job.rb:100 |
45.0 | — | 1 |
app/jobs/notification_job.rb:25 |
3.0 | — | 1 |
app/jobs/data_export_job.rb:67 |
33.0 | — | 1 |
app/jobs/report_generator_job.rb:68 |
39.0 | — | 1 |
app/jobs/notification_job.rb:10 |
38.0 | — | 1 |
Raw Data
{
"query": {
"id": 7227,
"normalized_sql": "INSERT INTO posts (user_id, title, content, published, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?)",
"analyzed_at": "2026-11-22 14:02:27 UTC"
},
"performance": {
"total_executions": 187,
"p95_duration_ms": "35.0",
"avg_duration_ms": 18.6845,
"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": 169,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:97",
"count": 1,
"p95_duration_ms": "21.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:47",
"count": 1,
"p95_duration_ms": "47.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:78",
"count": 1,
"p95_duration_ms": "19.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:94",
"count": 1,
"p95_duration_ms": "7.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:57",
"count": 1,
"p95_duration_ms": "11.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:120",
"count": 1,
"p95_duration_ms": "37.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:116",
"count": 1,
"p95_duration_ms": "27.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:49",
"count": 1,
"p95_duration_ms": "32.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:39",
"count": 1,
"p95_duration_ms": "42.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:115",
"count": 1,
"p95_duration_ms": "39.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:61",
"count": 1,
"p95_duration_ms": "28.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:79",
"count": 1,
"p95_duration_ms": "25.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:49",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:100",
"count": 1,
"p95_duration_ms": "45.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:25",
"count": 1,
"p95_duration_ms": "3.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:67",
"count": 1,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:68",
"count": 1,
"p95_duration_ms": "39.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:10",
"count": 1,
"p95_duration_ms": "38.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [],
"issues": []
}