# PERF-01 Duplicate Insert Replay Report (current)

- Generated: 2026-04-17 09:26:36
- Base URL: https://mirror3.athena-db.com
- Insert path: /gateway/insert
- Metrics path: /metrics
- Client: neon_dexter_sentinel
- Workers: 25, 50, 100
- Requests per worker: 20
- Request timeout (s): 15.0
- Seed before scenario: False

## Replay Payload

```json
{
  "table_name": "global_companies_registry",
  "insert_body": {
    "registration_number": "PERF-01-DUPLICATE"
  }
}
```

## Latency and Outcome Summary

| Workers | Requests | Elapsed(s) | p50(ms) | p95(ms) | p99(ms) | Mean(ms) | Status Counts | Top Codes |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 25 | 500 | 1.31 | 52.16 | 82.52 | 246.73 | 62.88 | 500:500 | sql_execution:500 |
| 50 | 1000 | 1.16 | 51.85 | 73.86 | 101.12 | 55.81 | 500:1000 | sql_execution:1000 |
| 100 | 2000 | 1.28 | 56.84 | 82.44 | 130.34 | 60.72 | 500:2000 | sql_execution:2000 |

## DB 23505 Proxy and Queue/Fallback Event Deltas

| Workers | db_unique_violation (proxy 23505) | admission_defer_high_watermark | admission_reject_queue_full | admission_reject_enqueue_failed | db_timeout | window_wait_timeout | bulk_fallback_sql_error | deferred_insert_queued | backend_unavailable_insert |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |

## Notes

- `db_unique_violation` is a gateway metric proxy for DB `sql_state=23505` observations.
- `admission_*`, `window_wait_timeout`, `db_timeout`, and `bulk_fallback_sql_error` are queue/fallback resilience signals.
- For true before/after comparison across code versions, run this script twice with `--label before` and `--label after` and compare reports.
