P95 Query Time

P95 Query Time

The 95th percentile database query duration — 95% of queries complete faster than this. Weighted by execution frequency across all queries. Slow queries are often caused by missing indexes or N+1 patterns.

34 ms

11.3%

Compared to previous 7 days

Execution Rate

Query Execution Rate

Total database queries executed over the last 14 days, expressed as an average rate. Spikes may indicate N+1 queries or inefficient data access patterns.

12.71 / day

23.8%

Compared to previous 7 days

Query Responses

Query Responses

This panel shows all executions of this query, including performance metrics, duration distribution, and query execution details.

Click marker to copy SHA
Time Period ▲ Executions Avg Duration Min Duration Max Duration
Nov 18, 2026 15 18.8 ms 1.0 ms 35.0 ms
Nov 19, 2026 7 19.0 ms 3.0 ms 33.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 22, 2026 2 23.5 ms 23.0 ms 24.0 ms
Total of 15 record(s).

Normalized Query

SELECT posts.title, posts.content, users.name FROM posts JOIN users ON posts.user_id = users.id WHERE posts.published = ?

Diagnostics

Query Diagnostics

Automatically generated analysis for this query. Includes N+1 detection (from live request data), query characteristics, detected issues, optimization suggestions, and a database EXPLAIN plan. Click Re-analyze to regenerate.


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

Query Locations

Shows where in your codebase this query originates, based on the last 30 days of executions. P95 duration and row count highlight the worst-case performance at each call site.

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=?)"
}