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 17, 2026 | 13 | 21.08 ms | 7.0 ms | 35.0 ms |
| Nov 10, 2026 | 15 | 23.27 ms | 5.0 ms | 42.0 ms |
| Nov 8, 2026 | 6 | 17.33 ms | 4.0 ms | 44.0 ms |
| Nov 9, 2026 | 10 | 19.5 ms | 4.0 ms | 45.0 ms |
| Nov 16, 2026 | 15 | 20.87 ms | 4.0 ms | 34.0 ms |
| Nov 13, 2026 | 19 | 16.26 ms | 3.0 ms | 35.0 ms |
| Nov 21, 2026 | 8 | 15.63 ms | 3.0 ms | 29.0 ms |
| Nov 22, 2026 | 10 | 14.4 ms | 3.0 ms | 35.0 ms |
| Nov 11, 2026 | 16 | 21.63 ms | 2.0 ms | 47.0 ms |
| Nov 12, 2026 | 21 | 20.24 ms | 2.0 ms | 48.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
SELECT COUNT(*) FROM comments WHERE post_id = ?
Diagnostics
Query Characteristics
- Query Type
- SELECT
- Tables
- 1
- Joins
- 0
- Complexity Score
- 3
- Has LIMIT
- No
- Has ORDER BY
- No
- Has GROUP BY
- No
- Has Subqueries
- No
Optimization Suggestions
-
Add single_column index: add_index :comments, :post_id
— Fast lookups for post_id = value queries
add_index :comments, :post_id
Execution Plan
3 | 0 | 53 | SEARCH comments USING COVERING INDEX index_comments_on_post_id (post_id=?)
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/models/post.rb:18 |
34.0 | — | 166 |
app/jobs/notification_job.rb:61 |
44.0 | — | 1 |
app/jobs/notification_job.rb:19 |
17.0 | — | 1 |
app/jobs/cache_warming_job.rb:120 |
3.0 | — | 1 |
app/jobs/analytics_job.rb:89 |
48.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:115 |
39.0 | — | 1 |
app/jobs/image_processing_job.rb:10 |
26.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:79 |
25.0 | — | 1 |
app/jobs/notification_job.rb:51 |
21.0 | — | 1 |
app/jobs/report_generator_job.rb:120 |
16.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:68 |
38.0 | — | 1 |
app/jobs/cache_warming_job.rb:72 |
33.0 | — | 1 |
app/jobs/report_generator_job.rb:91 |
47.0 | — | 1 |
app/jobs/cache_warming_job.rb:47 |
8.0 | — | 1 |
app/jobs/notification_job.rb:32 |
29.0 | — | 1 |
app/jobs/image_processing_job.rb:81 |
37.0 | — | 1 |
app/jobs/notification_job.rb:108 |
5.0 | — | 1 |
app/jobs/image_processing_job.rb:74 |
42.0 | — | 1 |
app/jobs/cache_warming_job.rb:70 |
23.0 | — | 1 |
app/jobs/cache_warming_job.rb:25 |
17.0 | — | 1 |
app/jobs/notification_job.rb:109 |
45.0 | — | 1 |
app/jobs/cache_warming_job.rb:14 |
4.0 | — | 1 |
app/mailers/user_mailer.rb:39 |
44.0 | — | 2 |
Raw Data
{
"query": {
"id": 7202,
"normalized_sql": "SELECT COUNT(*) FROM comments WHERE post_id = ?",
"analyzed_at": "2026-11-22 13:02:24 UTC"
},
"performance": {
"total_executions": 189,
"p95_duration_ms": "35.0",
"avg_duration_ms": 18.5238,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "SELECT",
"table_count": 1,
"join_count": 0,
"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": true,
"estimated_complexity": 3
},
"call_locations": [
{
"location": "app/models/post.rb:18",
"count": 166,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:39",
"count": 2,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:61",
"count": 1,
"p95_duration_ms": "44.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:14",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:109",
"count": 1,
"p95_duration_ms": "45.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:25",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:70",
"count": 1,
"p95_duration_ms": "23.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:74",
"count": 1,
"p95_duration_ms": "42.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:108",
"count": 1,
"p95_duration_ms": "5.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:81",
"count": 1,
"p95_duration_ms": "37.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:32",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:47",
"count": 1,
"p95_duration_ms": "8.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:91",
"count": 1,
"p95_duration_ms": "47.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:72",
"count": 1,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:68",
"count": 1,
"p95_duration_ms": "38.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:120",
"count": 1,
"p95_duration_ms": "16.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:51",
"count": 1,
"p95_duration_ms": "21.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:79",
"count": 1,
"p95_duration_ms": "25.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:10",
"count": 1,
"p95_duration_ms": "26.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:115",
"count": 1,
"p95_duration_ms": "39.0",
"p95_row_count": null
},
{
"location": "app/jobs/analytics_job.rb:89",
"count": 1,
"p95_duration_ms": "48.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:120",
"count": 1,
"p95_duration_ms": "3.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:19",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :comments, :post_id"
],
"issues": [],
"explain_plan": "3 | 0 | 53 | SEARCH comments USING COVERING INDEX index_comments_on_post_id (post_id=?)"
}