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 22, 2026 | 37 | 15.84 ms | 1.0 ms | 35.0 ms |
| Nov 21, 2026 | 57 | 18.46 ms | 2.0 ms | 35.0 ms |
| Nov 20, 2026 | 62 | 18.5 ms | 1.0 ms | 35.0 ms |
| Nov 19, 2026 | 60 | 20.63 ms | 1.0 ms | 35.0 ms |
| Nov 18, 2026 | 67 | 17.22 ms | 1.0 ms | 35.0 ms |
| Nov 17, 2026 | 40 | 18.38 ms | 1.0 ms | 35.0 ms |
| Nov 16, 2026 | 51 | 19.27 ms | 1.0 ms | 35.0 ms |
| Nov 15, 2026 | 67 | 17.42 ms | 2.0 ms | 35.0 ms |
| Nov 14, 2026 | 59 | 18.25 ms | 1.0 ms | 49.0 ms |
| Nov 13, 2026 | 57 | 21.39 ms | 2.0 ms | 35.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
SELECT * FROM posts WHERE user_id = ? ORDER BY created_at DESC LIMIT ?
Diagnostics
Query Characteristics
- Query Type
- SELECT
- Tables
- 1
- Joins
- 0
- Complexity Score
- 3
- Has LIMIT
- Yes
- Has ORDER BY
- Yes
- Has GROUP BY
- No
- Has Subqueries
- No
Issues Detected
- Using SELECT * may retrieve unnecessary columns
Optimization Suggestions
-
Add composite index: add_index :posts, ["user_id", "created_at"]
— Single index for filtering and sorting
add_index :posts, ["user_id", "created_at"] -
Add single_column index: add_index :posts, :user_id
— Fast lookups for user_id = value queries
add_index :posts, :user_id
Execution Plan
7 | 0 | 61 | SEARCH posts USING INDEX index_posts_on_user_id (user_id=?) 29 | 0 | 0 | USE TEMP B-TREE FOR ORDER BY
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/models/user.rb:23 |
34.0 | — | 495 |
app/jobs/notification_job.rb:61 |
37.0 | — | 1 |
app/jobs/report_generator_job.rb:108 |
33.0 | — | 1 |
app/jobs/notification_job.rb:70 |
44.0 | — | 1 |
app/jobs/notification_job.rb:59 |
6.0 | — | 1 |
app/jobs/cache_warming_job.rb:38 |
49.0 | — | 1 |
Raw Data
{
"query": {
"id": 7246,
"normalized_sql": "SELECT * FROM posts WHERE user_id = ? ORDER BY created_at DESC LIMIT ?",
"analyzed_at": "2026-11-22 15:02:25 UTC"
},
"performance": {
"total_executions": 500,
"p95_duration_ms": "34.0",
"avg_duration_ms": 18.278,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "SELECT",
"table_count": 1,
"join_count": 0,
"where_clause_complexity": 1,
"has_subqueries": false,
"has_limit": true,
"has_order_by": true,
"has_group_by": false,
"has_having": false,
"has_distinct": false,
"has_aggregations": false,
"estimated_complexity": 3
},
"call_locations": [
{
"location": "app/models/user.rb:23",
"count": 495,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:61",
"count": 1,
"p95_duration_ms": "37.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:108",
"count": 1,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:70",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:59",
"count": 1,
"p95_duration_ms": "6.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:38",
"count": 1,
"p95_duration_ms": "49.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :posts, :user_id",
"add_index :posts, [\"user_id\", \"created_at\"]",
"add_index :posts, :created_at"
],
"issues": [
"Using SELECT * may retrieve unnecessary columns"
],
"explain_plan": "7 | 0 | 61 | SEARCH posts USING INDEX index_posts_on_user_id (user_id=?)\n29 | 0 | 0 | USE TEMP B-TREE FOR ORDER BY"
}