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 |
|---|---|---|---|---|
| Sep 23, 2026 | 6 | 18.17 ms | 3.0 ms | 32.0 ms |
| Sep 22, 2026 | 51 | 17.51 ms | 1.0 ms | 35.0 ms |
| Sep 21, 2026 | 46 | 17.91 ms | 2.0 ms | 33.0 ms |
| Sep 20, 2026 | 69 | 18.59 ms | 1.0 ms | 35.0 ms |
| Sep 19, 2026 | 45 | 16.16 ms | 1.0 ms | 35.0 ms |
| Sep 18, 2026 | 55 | 20.15 ms | 1.0 ms | 35.0 ms |
| Sep 17, 2026 | 60 | 20.45 ms | 1.0 ms | 35.0 ms |
| Sep 16, 2026 | 49 | 18.71 ms | 1.0 ms | 34.0 ms |
| Sep 15, 2026 | 69 | 18.81 ms | 1.0 ms | 38.0 ms |
| Sep 14, 2026 | 62 | 18.55 ms | 2.0 ms | 44.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
SELECT users.* FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON posts.id = comments.post_id WHERE users.active = ? AND posts.published = ? AND comments.approved = ? OR users.created_at > ? AND posts.created_at > ? AND comments.created_at > ?Diagnostics
Query Characteristics
- Query Type
- SELECT
- Tables
- 3
- Joins
- 2
- Complexity Score
- 18
- Has LIMIT
- No
- Has ORDER BY
- No
- Has GROUP BY
- No
- Has Subqueries
- No
Optimization Suggestions
- Use includes() or preload() to load associated records — Eliminate N+1 queries and reduce database load
- Use includes() to eager load associations — Eliminate N+1 queries and reduce database load
- Use joins() when you only need to filter, not access associated data — Eliminate N+1 queries and reduce database load
- Use preload() when you don't need to query on associations — Eliminate N+1 queries and reduce database load
-
Add composite index: add_index :users, ["active", "published", "approved", "created_at"]
— Efficient multi-column filtering
add_index :users, ["active", "published", "approved", "created_at"] -
Add single_column index: add_index :comments, :post_id
— Fast JOIN execution
add_index :comments, :post_id -
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 -
Add single_column index: add_index :users, :approved
— Fast lookups for approved = value queries
add_index :users, :approved -
Add single_column index: add_index :users, :published
— Fast lookups for published = value queries
add_index :users, :published
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/controllers/analytics_controller.rb:45 |
34.0 | — | 488 |
app/jobs/cache_warming_job.rb:96 |
36.0 | — | 1 |
app/jobs/image_processing_job.rb:102 |
12.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:93 |
33.0 | — | 1 |
app/jobs/cache_warming_job.rb:119 |
38.0 | — | 1 |
app/jobs/notification_job.rb:103 |
23.0 | — | 1 |
app/mailers/user_mailer.rb:70 |
32.0 | — | 1 |
app/mailers/user_mailer.rb:61 |
23.0 | — | 1 |
app/jobs/cache_warming_job.rb:86 |
36.0 | — | 1 |
app/jobs/data_export_job.rb:105 |
37.0 | — | 1 |
app/jobs/cache_warming_job.rb:30 |
44.0 | — | 1 |
app/jobs/cache_warming_job.rb:87 |
2.0 | — | 1 |
app/jobs/image_processing_job.rb:96 |
44.0 | — | 1 |
Raw Data
{
"query": {
"id": 37,
"normalized_sql": "SELECT users.* FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON posts.id = comments.post_id WHERE users.active = ? AND posts.published = ? AND comments.approved = ? OR users.created_at > ? AND posts.created_at > ? AND comments.created_at > ?",
"analyzed_at": "2026-09-23 04:02:22 UTC"
},
"performance": {
"total_executions": 500,
"p95_duration_ms": "34.0",
"avg_duration_ms": 18.684,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "SELECT",
"table_count": 3,
"join_count": 2,
"where_clause_complexity": 6,
"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": 18
},
"call_locations": [
{
"location": "app/controllers/analytics_controller.rb:45",
"count": 488,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:96",
"count": 1,
"p95_duration_ms": "36.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:102",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:93",
"count": 1,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:119",
"count": 1,
"p95_duration_ms": "38.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:103",
"count": 1,
"p95_duration_ms": "23.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:70",
"count": 1,
"p95_duration_ms": "32.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:61",
"count": 1,
"p95_duration_ms": "23.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:86",
"count": 1,
"p95_duration_ms": "36.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:105",
"count": 1,
"p95_duration_ms": "37.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:30",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:87",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:96",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :users, :active",
"add_index :users, :published",
"add_index :users, :approved",
"add_index :posts, :user_id",
"add_index :comments, :post_id",
"add_index :users, [\"active\", \"published\", \"approved\", \"created_at\"]",
"add_index :users, :created_at"
],
"issues": []
}