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 |
|---|---|---|---|---|
| Nov 12, 2026 | 61 | 18.98 ms | 1.0 ms | 46.0 ms |
| Nov 11, 2026 | 73 | 19.82 ms | 1.0 ms | 44.0 ms |
| Nov 10, 2026 | 67 | 17.73 ms | 1.0 ms | 43.0 ms |
| Nov 9, 2026 | 64 | 21.27 ms | 2.0 ms | 48.0 ms |
| Nov 8, 2026 | 23 | 15.7 ms | 1.0 ms | 50.0 ms |
Total of 15 record(s).
Page 2 of 2
Normalized Query
SELECT name FROM users
Diagnostics
Query Characteristics
- Query Type
- SELECT
- Tables
- 1
- Joins
- 0
- Complexity Score
- 2
- Has LIMIT
- No
- Has ORDER BY
- No
- Has GROUP BY
- No
- Has Subqueries
- No
Issues Detected
- SELECT query without WHERE clause may return excessive data
Optimization Suggestions
- 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 WHERE clause to filter results — Avoid full table scans and reduce data transfer
Execution Plan
2 | 0 | 216 | SCAN users
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/controllers/admin_controller.rb:67 |
33.0 | — | 500 |
Raw Data
{
"query": {
"id": 7255,
"normalized_sql": "SELECT name FROM users",
"analyzed_at": "2026-11-22 15:02:25 UTC"
},
"performance": {
"total_executions": 500,
"p95_duration_ms": "33.0",
"avg_duration_ms": 17.58,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "SELECT",
"table_count": 1,
"join_count": 0,
"where_clause_complexity": 0,
"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": 2
},
"call_locations": [
{
"location": "app/controllers/admin_controller.rb:67",
"count": 500,
"p95_duration_ms": "33.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [],
"issues": [
"SELECT query without WHERE clause may return excessive data"
],
"explain_plan": "2 | 0 | 216 | SCAN users"
}