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 | 69 | 19.25 ms | 1.0 ms | 47.0 ms |
| Nov 10, 2026 | 64 | 18.84 ms | 1.0 ms | 43.0 ms |
| Nov 11, 2026 | 60 | 19.82 ms | 1.0 ms | 35.0 ms |
| Nov 12, 2026 | 77 | 18.64 ms | 1.0 ms | 50.0 ms |
| Nov 13, 2026 | 64 | 19.83 ms | 1.0 ms | 39.0 ms |
| Nov 14, 2026 | 77 | 18.05 ms | 1.0 ms | 44.0 ms |
| Nov 15, 2026 | 55 | 18.53 ms | 1.0 ms | 35.0 ms |
| Nov 17, 2026 | 57 | 18.6 ms | 1.0 ms | 35.0 ms |
| Nov 18, 2026 | 59 | 16.32 ms | 1.0 ms | 35.0 ms |
| Nov 19, 2026 | 65 | 17.85 ms | 1.0 ms | 35.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
SELECT DISTINCT users.*, posts.*, comments.* FROM users, posts, comments WHERE users.id = posts.user_id AND posts.id = comments.post_id AND users.created_at > ? AND posts.created_at > ? AND comments.created_at > ?
Diagnostics
Query Characteristics
- Query Type
- SELECT
- Tables
- 1
- Joins
- 0
- Complexity Score
- 7
- Has LIMIT
- No
- Has ORDER BY
- No
- Has GROUP BY
- No
- Has Subqueries
- No
Optimization Suggestions
-
Add composite index: add_index :users, ["id", "created_at"]
— Efficient multi-column filtering
add_index :users, ["id", "created_at"]
Execution Plan
7 | 0 | 210 | SCAN comments USING INDEX index_comments_on_post_id 12 | 0 | 45 | SEARCH posts USING INTEGER PRIMARY KEY (rowid=?) 17 | 0 | 45 | SEARCH users USING INTEGER PRIMARY KEY (rowid=?)
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/models/application_record.rb:12 |
34.0 | — | 495 |
app/jobs/cache_warming_job.rb:36 |
44.0 | — | 1 |
app/jobs/cache_warming_job.rb:86 |
17.0 | — | 1 |
app/mailers/user_mailer.rb:91 |
22.0 | — | 1 |
app/jobs/cache_warming_job.rb:17 |
38.0 | — | 1 |
app/jobs/image_processing_job.rb:107 |
26.0 | — | 1 |
Raw Data
{
"query": {
"id": 7239,
"normalized_sql": "SELECT DISTINCT users.*, posts.*, comments.* FROM users, posts, comments WHERE users.id = posts.user_id AND posts.id = comments.post_id AND users.created_at > ? AND posts.created_at > ? AND comments.created_at > ?",
"analyzed_at": "2026-11-22 14:02:27 UTC"
},
"performance": {
"total_executions": 500,
"p95_duration_ms": "34.0",
"avg_duration_ms": 18.222,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "SELECT",
"table_count": 1,
"join_count": 0,
"where_clause_complexity": 5,
"has_subqueries": false,
"has_limit": false,
"has_order_by": false,
"has_group_by": false,
"has_having": false,
"has_distinct": true,
"has_aggregations": false,
"estimated_complexity": 7
},
"call_locations": [
{
"location": "app/models/application_record.rb:12",
"count": 495,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:36",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:86",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:91",
"count": 1,
"p95_duration_ms": "22.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:17",
"count": 1,
"p95_duration_ms": "38.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:107",
"count": 1,
"p95_duration_ms": "26.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :users, [\"id\", \"created_at\"]",
"add_index :users, :created_at"
],
"issues": [],
"explain_plan": "7 | 0 | 210 | SCAN comments USING INDEX index_comments_on_post_id\n12 | 0 | 45 | SEARCH posts USING INTEGER PRIMARY KEY (rowid=?)\n17 | 0 | 45 | SEARCH users USING INTEGER PRIMARY KEY (rowid=?)"
}