P95 Query Time
35 ms
Compared to previous 7 days
Query Responses
Click marker to copy SHA
| Time Period | Executions | Avg Duration | Min Duration | Max Duration ▲ |
|---|---|---|---|---|
| Nov 13, 2026 | 11 | 16.09 ms | 2.0 ms | 31.0 ms |
| Nov 18, 2026 | 12 | 16.42 ms | 1.0 ms | 31.0 ms |
| Nov 22, 2026 | 6 | 20.0 ms | 2.0 ms | 31.0 ms |
| Nov 17, 2026 | 10 | 18.0 ms | 7.0 ms | 33.0 ms |
| Nov 15, 2026 | 14 | 20.64 ms | 6.0 ms | 34.0 ms |
| Nov 20, 2026 | 7 | 20.43 ms | 3.0 ms | 34.0 ms |
| Nov 21, 2026 | 12 | 17.67 ms | 3.0 ms | 34.0 ms |
| Nov 9, 2026 | 22 | 19.09 ms | 1.0 ms | 35.0 ms |
| Nov 16, 2026 | 10 | 13.9 ms | 1.0 ms | 35.0 ms |
| Nov 19, 2026 | 9 | 26.33 ms | 15.0 ms | 35.0 ms |
Total of 15 record(s).
Page 1 of 2
Normalized Query
SELECT posts.* FROM posts WHERE title LIKE ? OR content LIKE ?
Diagnostics
Query Characteristics
- Query Type
- SELECT
- Tables
- 1
- Joins
- 0
- Complexity Score
- 4
- Has LIMIT
- No
- Has ORDER BY
- No
- Has GROUP BY
- No
- Has Subqueries
- No
Optimization Suggestions
-
Add composite index: add_index :posts, ["title", "content"]
— Efficient multi-column filtering
add_index :posts, ["title", "content"]
Execution Plan
2 | 0 | 216 | SCAN posts
Query Locations
| Location | P95 Duration (ms) | P95 Row Count | Count |
|---|---|---|---|
app/controllers/search_controller.rb:12 |
34.0 | — | 158 |
app/jobs/cache_warming_job.rb:33 |
20.0 | — | 1 |
app/jobs/cache_warming_job.rb:43 |
46.0 | — | 1 |
app/mailers/user_mailer.rb:26 |
46.0 | — | 1 |
app/jobs/cache_warming_job.rb:46 |
27.0 | — | 1 |
app/jobs/import_job.rb:43 |
4.0 | — | 1 |
app/jobs/import_job.rb:47 |
39.0 | — | 1 |
app/jobs/cache_warming_job.rb:39 |
2.0 | — | 1 |
app/jobs/data_export_job.rb:100 |
20.0 | — | 1 |
app/jobs/cache_warming_job.rb:99 |
29.0 | — | 1 |
app/jobs/report_generator_job.rb:36 |
31.0 | — | 2 |
app/mailers/user_mailer.rb:38 |
12.0 | — | 1 |
app/jobs/webhook_delivery_job.rb:110 |
49.0 | — | 1 |
app/jobs/cache_warming_job.rb:108 |
14.0 | — | 1 |
app/jobs/cache_warming_job.rb:85 |
24.0 | — | 1 |
app/jobs/cache_warming_job.rb:11 |
20.0 | — | 1 |
app/jobs/cache_warming_job.rb:23 |
17.0 | — | 1 |
app/jobs/image_processing_job.rb:117 |
16.0 | — | 1 |
app/mailers/user_mailer.rb:61 |
43.0 | — | 1 |
app/jobs/cache_warming_job.rb:54 |
46.0 | — | 1 |
app/mailers/user_mailer.rb:50 |
6.0 | — | 1 |
app/jobs/cache_warming_job.rb:40 |
2.0 | — | 1 |
app/jobs/image_processing_job.rb:87 |
27.0 | — | 1 |
app/jobs/cache_warming_job.rb:55 |
33.0 | — | 1 |
app/mailers/user_mailer.rb:72 |
12.0 | — | 1 |
app/jobs/cache_warming_job.rb:42 |
24.0 | — | 1 |
app/jobs/data_export_job.rb:70 |
4.0 | — | 1 |
app/jobs/cache_warming_job.rb:112 |
12.0 | — | 1 |
app/jobs/notification_job.rb:111 |
36.0 | — | 1 |
app/jobs/notification_job.rb:104 |
6.0 | — | 1 |
app/mailers/user_mailer.rb:14 |
29.0 | — | 1 |
Raw Data
{
"query": {
"id": 7233,
"normalized_sql": "SELECT posts.* FROM posts WHERE title LIKE ? OR content LIKE ?",
"analyzed_at": "2026-11-22 14:02:27 UTC"
},
"performance": {
"total_executions": 189,
"p95_duration_ms": "35.0",
"avg_duration_ms": 19.7884,
"p95_row_count": null,
"avg_row_count": null
},
"characteristics": {
"query_type": "SELECT",
"table_count": 1,
"join_count": 0,
"where_clause_complexity": 2,
"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": 4
},
"call_locations": [
{
"location": "app/controllers/search_controller.rb:12",
"count": 158,
"p95_duration_ms": "34.0",
"p95_row_count": null
},
{
"location": "app/jobs/report_generator_job.rb:36",
"count": 2,
"p95_duration_ms": "31.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:23",
"count": 1,
"p95_duration_ms": "17.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:117",
"count": 1,
"p95_duration_ms": "16.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:61",
"count": 1,
"p95_duration_ms": "43.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:54",
"count": 1,
"p95_duration_ms": "46.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:50",
"count": 1,
"p95_duration_ms": "6.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:40",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/image_processing_job.rb:87",
"count": 1,
"p95_duration_ms": "27.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:55",
"count": 1,
"p95_duration_ms": "33.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:72",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:42",
"count": 1,
"p95_duration_ms": "24.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:70",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:112",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:111",
"count": 1,
"p95_duration_ms": "36.0",
"p95_row_count": null
},
{
"location": "app/jobs/notification_job.rb:104",
"count": 1,
"p95_duration_ms": "6.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:14",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:11",
"count": 1,
"p95_duration_ms": "20.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:85",
"count": 1,
"p95_duration_ms": "24.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:108",
"count": 1,
"p95_duration_ms": "14.0",
"p95_row_count": null
},
{
"location": "app/jobs/webhook_delivery_job.rb:110",
"count": 1,
"p95_duration_ms": "49.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:38",
"count": 1,
"p95_duration_ms": "12.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:99",
"count": 1,
"p95_duration_ms": "29.0",
"p95_row_count": null
},
{
"location": "app/jobs/data_export_job.rb:100",
"count": 1,
"p95_duration_ms": "20.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:39",
"count": 1,
"p95_duration_ms": "2.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:47",
"count": 1,
"p95_duration_ms": "39.0",
"p95_row_count": null
},
{
"location": "app/jobs/import_job.rb:43",
"count": 1,
"p95_duration_ms": "4.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:46",
"count": 1,
"p95_duration_ms": "27.0",
"p95_row_count": null
},
{
"location": "app/mailers/user_mailer.rb:26",
"count": 1,
"p95_duration_ms": "46.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:43",
"count": 1,
"p95_duration_ms": "46.0",
"p95_row_count": null
},
{
"location": "app/jobs/cache_warming_job.rb:33",
"count": 1,
"p95_duration_ms": "20.0",
"p95_row_count": null
}
],
"n_plus_one": {
"detected": false
},
"index_recommendations": [
"add_index :posts, [\"title\", \"content\"]"
],
"issues": [],
"explain_plan": "2 | 0 | 216 | SCAN posts"
}