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.

35 ms

16.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.

11.93 / day

29.6%

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
Sep 23, 2026 1 9.0 ms 9.0 ms 9.0 ms
Sep 22, 2026 10 26.5 ms 13.0 ms 34.0 ms
Sep 21, 2026 6 15.33 ms 2.0 ms 33.0 ms
Sep 20, 2026 13 19.15 ms 4.0 ms 32.0 ms
Sep 19, 2026 5 23.2 ms 12.0 ms 32.0 ms
Sep 18, 2026 13 19.0 ms 4.0 ms 34.0 ms
Sep 17, 2026 12 16.17 ms 1.0 ms 31.0 ms
Sep 16, 2026 9 16.0 ms 5.0 ms 33.0 ms
Sep 15, 2026 21 19.95 ms 1.0 ms 42.0 ms
Sep 14, 2026 16 22.19 ms 4.0 ms 45.0 ms
Total of 15 record(s).
Page 1 of 2

Normalized Query 

DELETE FROM posts WHERE id = ?

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
DELETE
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 :posts, :id — Fast lookups for id = value queries
    add_index :posts, :id

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/post.rb:42 34.0 — 139
app/jobs/cache_warming_job.rb:111 41.0 — 1
app/jobs/image_processing_job.rb:66 42.0 — 1
app/jobs/notification_job.rb:108 23.0 — 1
app/jobs/notification_job.rb:46 25.0 — 1
app/jobs/notification_job.rb:98 4.0 — 1
app/jobs/notification_job.rb:81 45.0 — 1
app/jobs/notification_job.rb:68 25.0 — 1
app/jobs/notification_job.rb:85 28.0 — 1
app/jobs/notification_job.rb:100 24.0 — 1
app/jobs/cache_warming_job.rb:71 50.0 — 1
app/jobs/data_export_job.rb:78 26.0 — 1
app/jobs/cache_warming_job.rb:110 37.0 — 1
app/jobs/webhook_delivery_job.rb:52 43.0 — 1
app/jobs/webhook_delivery_job.rb:101 45.0 — 1
app/jobs/cache_warming_job.rb:64 4.0 — 1
app/jobs/notification_job.rb:65 9.0 — 1
app/jobs/notification_job.rb:87 38.0 — 1
app/mailers/user_mailer.rb:62 10.0 — 1
app/jobs/data_export_job.rb:120 22.0 — 1
app/jobs/import_job.rb:91 7.0 — 1
app/jobs/image_processing_job.rb:65 43.0 — 1
app/jobs/cache_warming_job.rb:87 39.0 — 1
app/mailers/user_mailer.rb:63 3.0 — 1
app/jobs/cache_warming_job.rb:38 12.0 — 1
app/jobs/import_job.rb:80 10.0 — 1
app/jobs/notification_job.rb:90 20.0 — 1
app/jobs/cache_warming_job.rb:11 4.0 — 1
app/jobs/notification_job.rb:88 26.0 — 1

Raw Data 

{
  "query": {
    "id": 100,
    "normalized_sql": "DELETE FROM posts WHERE id = ?",
    "analyzed_at": "2026-09-23 07:02:22 UTC"
  },
  "performance": {
    "total_executions": 167,
    "p95_duration_ms": "38.0",
    "avg_duration_ms": 19.7425,
    "p95_row_count": null,
    "avg_row_count": null
  },
  "characteristics": {
    "query_type": "DELETE",
    "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": false,
    "estimated_complexity": 3
  },
  "call_locations": [
    {
      "location": "app/models/post.rb:42",
      "count": 139,
      "p95_duration_ms": "34.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:111",
      "count": 1,
      "p95_duration_ms": "41.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/image_processing_job.rb:66",
      "count": 1,
      "p95_duration_ms": "42.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:108",
      "count": 1,
      "p95_duration_ms": "23.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:46",
      "count": 1,
      "p95_duration_ms": "25.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:98",
      "count": 1,
      "p95_duration_ms": "4.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:81",
      "count": 1,
      "p95_duration_ms": "45.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:68",
      "count": 1,
      "p95_duration_ms": "25.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:85",
      "count": 1,
      "p95_duration_ms": "28.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:100",
      "count": 1,
      "p95_duration_ms": "24.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:71",
      "count": 1,
      "p95_duration_ms": "50.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/data_export_job.rb:78",
      "count": 1,
      "p95_duration_ms": "26.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:110",
      "count": 1,
      "p95_duration_ms": "37.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/webhook_delivery_job.rb:52",
      "count": 1,
      "p95_duration_ms": "43.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/webhook_delivery_job.rb:101",
      "count": 1,
      "p95_duration_ms": "45.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:64",
      "count": 1,
      "p95_duration_ms": "4.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:65",
      "count": 1,
      "p95_duration_ms": "9.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:87",
      "count": 1,
      "p95_duration_ms": "38.0",
      "p95_row_count": null
    },
    {
      "location": "app/mailers/user_mailer.rb:62",
      "count": 1,
      "p95_duration_ms": "10.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/data_export_job.rb:120",
      "count": 1,
      "p95_duration_ms": "22.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/import_job.rb:91",
      "count": 1,
      "p95_duration_ms": "7.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/image_processing_job.rb:65",
      "count": 1,
      "p95_duration_ms": "43.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:87",
      "count": 1,
      "p95_duration_ms": "39.0",
      "p95_row_count": null
    },
    {
      "location": "app/mailers/user_mailer.rb:63",
      "count": 1,
      "p95_duration_ms": "3.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:38",
      "count": 1,
      "p95_duration_ms": "12.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/import_job.rb:80",
      "count": 1,
      "p95_duration_ms": "10.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:90",
      "count": 1,
      "p95_duration_ms": "20.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/cache_warming_job.rb:11",
      "count": 1,
      "p95_duration_ms": "4.0",
      "p95_row_count": null
    },
    {
      "location": "app/jobs/notification_job.rb:88",
      "count": 1,
      "p95_duration_ms": "26.0",
      "p95_row_count": null
    }
  ],
  "n_plus_one": {
    "detected": false
  },
  "index_recommendations": [
    "add_index :posts, :id"
  ],
  "issues": []
}