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 8, 2026 | 11 | 23.27 ms | 4.0 ms | 46.0 ms |
| Nov 20, 2026 | 10 | 21.2 ms | 5.0 ms | 34.0 ms |
| Nov 21, 2026 | 10 | 20.8 ms | 6.0 ms | 34.0 ms |
| Nov 12, 2026 | 14 | 22.43 ms | 7.0 ms | 47.0 ms |
| Nov 22, 2026 | 2 | 23.5 ms | 23.0 ms | 24.0 ms |
Total of 15 record(s).
Page 2 of 2
Normalized Query
SELECT posts.title, posts.content, users.name FROM posts JOIN users ON posts.user_id = users.id WHERE posts.published = ?
Diagnostics
Query Characteristics
- Query Type
- SELECT
- Tables
- 2
- Joins
- 1
- Complexity Score
- 8
- Has LIMIT
- No
- Has ORDER BY
- No
- Has GROUP BY
- No
- Has Subqueries
- No
Optimization Suggestions
-
Add single_column index: add_index :posts, :published
— Fast lookups for published = value queries
add_index :posts, :published -
Add single_column index: add_index :posts, :user_id
— Fast JOIN execution
add_index :posts, :user_id
Execution Plan
3 | 0 | 216 | SCAN posts 7 | 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 | — | 154 |
app/jobs/notification_job.rb:41 |
31.0 | — | 1 |
app/jobs/report_generator_job.rb:114 |
44.0 | — | 1 |
app/jobs/notification_job.rb:19 |
35.0 | — | 1 |
app/jobs/analytics_job.rb:65 |
10.0 | — | 1 |
app/jobs/cache_warming_job.rb:65 |
16.0 | — | 1 |
app/mailers/user_mailer.rb:103 |
14.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:32 |
47.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:119 |
16.0 | — | 1 |
app/jobs/report_generator_job.rb:42 |
8.0 | — | 1 |
app/jobs/notification_job.rb:13 |
10.0 | — | 1 |
app/jobs/report_generator_job.rb:25 |
41.0 | — | 1 |
app/jobs/notification_job.rb:72 |
29.0 | — | 1 |
app/jobs/cache_warming_job.rb:42 |
34.0 | — | 1 |
app/jobs/cache_warming_job.rb:74 |
5.0 | — | 1 |
app/jobs/image_processing_job.rb:92 |
30.0 | — | 1 |
app/jobs/cache_warming_job.rb:66 |
3.0 | — | 1 |
app/jobs/cache_warming_job.rb:78 |
28.0 | — | 1 |
app/jobs/cache_warming_job.rb:47 |
43.0 | — | 1 |
app/mailers/user_mailer.rb:40 |
18.0 | — | 1 |
app/jobs/notification_job.rb:97 |
4.0 | — | 1 |
app/jobs/report_generator_job.rb:87 |
19.0 | — | 1 |
app/mailers/user_mailer.rb:117 |
39.0 | — | 1 |
app/jobs/import_job.rb:26 |
29.0 | — | 1 |
app/mailers/user_mailer.rb:67 |
46.0 | — | 1 |
Raw Data
{
"query": {
"id": 7201,
"normalized_sql": "SELECT posts.title, posts.content, users.name FROM posts JOIN users ON posts.user_id = users.id WHERE posts.published = ?",
"analyzed_at": "2026-11-22 13:02:24 UTC"
},
"performance": {
"total_executions": 178,
"p95_duration_ms": "35.0",
"avg_duration_ms": 18.8315,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "SELECT",
"table_count": 2,
"join_count": 1,
"where_clause_complexity": 1,
"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": 8
},
"call_locations": [
{
"location": "app/models/application_record.rb:12",
"count": 154,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:41",
"count": 1,
"p95_duration_ms": "31.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:114",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:19",
"count": 1,
"p95_duration_ms": "35.0",
"p95_row_count": null
},
{
"location": "app/jobs/analytics_job.rb:65",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:65",
"count": 1,
"p95_duration_ms": "16.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:103",
"count": 1,
"p95_duration_ms": "14.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:32",
"count": 1,
"p95_duration_ms": "47.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:119",
"count": 1,
"p95_duration_ms": "16.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:42",
"count": 1,
"p95_duration_ms": "8.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:13",
"count": 1,
"p95_duration_ms": "10.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:25",
"count": 1,
"p95_duration_ms": "41.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:72",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:42",
"count": 1,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:74",
"count": 1,
"p95_duration_ms": "5.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:92",
"count": 1,
"p95_duration_ms": "30.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:66",
"count": 1,
"p95_duration_ms": "3.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:78",
"count": 1,
"p95_duration_ms": "28.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:47",
"count": 1,
"p95_duration_ms": "43.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:40",
"count": 1,
"p95_duration_ms": "18.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:97",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:87",
"count": 1,
"p95_duration_ms": "19.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:117",
"count": 1,
"p95_duration_ms": "39.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:26",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:67",
"count": 1,
"p95_duration_ms": "46.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :posts, :published",
"add_index :posts, :user_id",
"add_index :posts, [\"published\", \"posts.title\", \"posts.content\", \"users.name\"], name: 'covering_idx_posts_published'"
],
"issues": [],
"explain_plan": "3 | 0 | 216 | SCAN posts\n7 | 0 | 45 | SEARCH users USING INTEGER PRIMARY KEY (rowid=?)"
}