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 |
|---|---|---|---|---|
| Sep 13, 2026 | 62 | 18.19 ms | 1.0 ms | 34.0 ms |
| Sep 12, 2026 | 68 | 17.21 ms | 1.0 ms | 49.0 ms |
| Sep 11, 2026 | 60 | 18.52 ms | 1.0 ms | 39.0 ms |
| Sep 10, 2026 | 60 | 18.88 ms | 2.0 ms | 35.0 ms |
| Sep 9, 2026 | 41 | 20.54 ms | 1.0 ms | 35.0 ms |
Total of 15 record(s).
Page 2 of 2
Normalized Query
SELECT users.*, posts.*, comments.*, COUNT(DISTINCT posts.id) as post_count, COUNT(DISTINCT comments.id) as comment_count, AVG(posts.view_count) as avg_views, MAX(comments.created_at) as latest_comment FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON users.id = comments.user_id LEFT JOIN user_preferences ON users.id = user_preferences.user_id LEFT JOIN subscriptions ON users.id = subscriptions.user_id WHERE (users.active = ? OR users.premium = ?) AND (posts.published = ? OR posts.featured = ?) AND (comments.approved = ? OR comments.flagged = ?) AND users.created_at BETWEEN ? AND ? GROUP BY users.id HAVING COUNT(posts.id) > ? AND AVG(posts.view_count) > ?Diagnostics
Query Characteristics
- Query Type
- SELECT
- Tables
- 5
- Joins
- 4
- Complexity Score
- 34
- Has LIMIT
- No
- Has ORDER BY
- No
- Has GROUP BY
- Yes
- Has Subqueries
- No
Issues Detected
- Complex WHERE clause with many conditions
Optimization Suggestions
-
Add composite index: add_index :users, ["active", "premium", "published", "featured", "approved", "flagged", "created_at"]
— Efficient multi-column filtering
add_index :users, ["active", "premium", "published", "featured", "approved", "flagged", "created_at"] -
Add single_column index: add_index :comments, :user_id
— Fast JOIN execution
add_index :comments, :user_id -
Add single_column index: add_index :posts, :user_id
— Fast JOIN execution
add_index :posts, :user_id -
Add single_column index: add_index :subscriptions, :user_id
— Fast JOIN execution
add_index :subscriptions, :user_id -
Add single_column index: add_index :user_preferences, :user_id
— Fast JOIN execution
add_index :user_preferences, :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, :featured
— Fast lookups for featured = value queries
add_index :users, :featured -
Add single_column index: add_index :users, :flagged
— Fast lookups for flagged = value queries
add_index :users, :flagged -
Add single_column index: add_index :users, :premium
— Fast lookups for premium = value queries
add_index :users, :premium -
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 |
33.0 | — | 496 |
app/jobs/image_processing_job.rb:11 |
44.0 | — | 1 |
app/jobs/cache_warming_job.rb:94 |
48.0 | — | 1 |
app/jobs/notification_job.rb:54 |
42.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:107 |
34.0 | — | 1 |
Raw Data
{
"query": {
"id": 85,
"normalized_sql": "SELECT users.*, posts.*, comments.*, COUNT(DISTINCT posts.id) as post_count, COUNT(DISTINCT comments.id) as comment_count, AVG(posts.view_count) as avg_views, MAX(comments.created_at) as latest_comment FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON users.id = comments.user_id LEFT JOIN user_preferences ON users.id = user_preferences.user_id LEFT JOIN subscriptions ON users.id = subscriptions.user_id WHERE (users.active = ? OR users.premium = ?) AND (posts.published = ? OR posts.featured = ?) AND (comments.approved = ? OR comments.flagged = ?) AND users.created_at BETWEEN ? AND ? GROUP BY users.id HAVING COUNT(posts.id) > ? AND AVG(posts.view_count) > ?",
"analyzed_at": "2026-09-23 06:02:25 UTC"
},
"performance": {
"total_executions": 500,
"p95_duration_ms": "34.0",
"avg_duration_ms": 17.506,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "SELECT",
"table_count": 5,
"join_count": 4,
"where_clause_complexity": 12,
"has_subqueries": false,
"has_limit": false,
"has_order_by": false,
"has_group_by": true,
"has_having": true,
"has_distinct": true,
"has_aggregations": true,
"estimated_complexity": 34
},
"call_locations": [
{
"location": "app/controllers/analytics_controller.rb:45",
"count": 496,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:11",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:94",
"count": 1,
"p95_duration_ms": "48.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:54",
"count": 1,
"p95_duration_ms": "42.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:107",
"count": 1,
"p95_duration_ms": "34.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :users, :active",
"add_index :users, :premium",
"add_index :users, :published",
"add_index :users, :featured",
"add_index :users, :approved",
"add_index :users, :flagged",
"add_index :posts, :user_id",
"add_index :comments, :user_id",
"add_index :user_preferences, :user_id",
"add_index :subscriptions, :user_id",
"add_index :users, [\"active\", \"premium\", \"published\", \"featured\", \"approved\", \"flagged\", \"created_at\"]",
"add_index :users, :created_at"
],
"issues": [
"Complex WHERE clause with many conditions"
]
}