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 18, 2026 | 58 | 17.81 ms | 1.0 ms | 35.0 ms |
| Nov 19, 2026 | 60 | 18.87 ms | 2.0 ms | 35.0 ms |
| Nov 20, 2026 | 68 | 18.54 ms | 1.0 ms | 35.0 ms |
| Nov 21, 2026 | 55 | 18.45 ms | 1.0 ms | 35.0 ms |
| Nov 22, 2026 | 29 | 18.55 ms | 1.0 ms | 35.0 ms |
Total of 15 record(s).
Page 2 of 2
Normalized Query
SELECT * FROM (SELECT users.id, users.name, users.email, COUNT(posts.id) as post_count FROM users LEFT JOIN posts ON users.id = posts.user_id WHERE users.active = ? GROUP BY users.id) as user_posts JOIN (SELECT user_id, COUNT(*) as comment_count FROM comments WHERE approved = ? GROUP BY user_id) as user_comments ON user_posts.id = user_comments.user_id WHERE user_posts.post_count > ? AND user_comments.comment_count > ?
Diagnostics
Query Characteristics
- Query Type
- SELECT
- Tables
- 3
- Joins
- 2
- Complexity Score
- 23
- Has LIMIT
- No
- Has ORDER BY
- No
- Has GROUP BY
- Yes
- Has Subqueries
- Yes
Issues Detected
- Using SELECT * may retrieve unnecessary columns
Optimization Suggestions
-
Add single_column index: add_index :posts, :user_id
— Fast JOIN execution
add_index :posts, :user_id -
Add single_column index: add_index :users, :active
— Fast lookups for active = value queries
add_index :users, :active
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/models/application_record.rb:12 |
33.0 | — | 488 |
app/jobs/notification_job.rb:29 |
35.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:30 |
47.0 | — | 1 |
app/jobs/cache_warming_job.rb:10 |
8.0 | — | 1 |
app/jobs/image_processing_job.rb:97 |
41.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:45 |
12.0 | — | 1 |
app/jobs/import_job.rb:66 |
13.0 | — | 1 |
app/jobs/import_job.rb:99 |
22.0 | — | 1 |
app/jobs/analytics_job.rb:86 |
32.0 | — | 1 |
app/jobs/cache_warming_job.rb:80 |
48.0 | — | 1 |
app/jobs/image_processing_job.rb:105 |
12.0 | — | 1 |
app/jobs/notification_job.rb:81 |
21.0 | — | 1 |
app/mailers/user_mailer.rb:43 |
45.0 | — | 1 |
Raw Data
{
"query": {
"id": 7215,
"normalized_sql": "SELECT * FROM (SELECT users.id, users.name, users.email, COUNT(posts.id) as post_count FROM users LEFT JOIN posts ON users.id = posts.user_id WHERE users.active = ? GROUP BY users.id) as user_posts JOIN (SELECT user_id, COUNT(*) as comment_count FROM comments WHERE approved = ? GROUP BY user_id) as user_comments ON user_posts.id = user_comments.user_id WHERE user_posts.post_count > ? AND user_comments.comment_count > ?",
"analyzed_at": "2026-11-22 13:02:24 UTC"
},
"performance": {
"total_executions": 500,
"p95_duration_ms": "34.0",
"avg_duration_ms": 18.232,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "SELECT",
"table_count": 3,
"join_count": 2,
"where_clause_complexity": 1,
"has_subqueries": true,
"has_limit": false,
"has_order_by": false,
"has_group_by": true,
"has_having": false,
"has_distinct": false,
"has_aggregations": true,
"estimated_complexity": 23
},
"call_locations": [
{
"location": "app/models/application_record.rb:12",
"count": 488,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:29",
"count": 1,
"p95_duration_ms": "35.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:30",
"count": 1,
"p95_duration_ms": "47.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:10",
"count": 1,
"p95_duration_ms": "8.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:97",
"count": 1,
"p95_duration_ms": "41.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:45",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:66",
"count": 1,
"p95_duration_ms": "13.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:99",
"count": 1,
"p95_duration_ms": "22.0",
"p95_row_count": null
},
{
"location": "app/jobs/analytics_job.rb:86",
"count": 1,
"p95_duration_ms": "32.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:80",
"count": 1,
"p95_duration_ms": "48.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:105",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:81",
"count": 1,
"p95_duration_ms": "21.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:43",
"count": 1,
"p95_duration_ms": "45.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :users, :active",
"add_index :posts, :user_id"
],
"issues": [
"Using SELECT * may retrieve unnecessary columns"
]
}