# PERF-01 Duplicate Insert Replay Report (after)

- Generated: 2026-04-17T05:57:10.740011500+00:00
- 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.00
- Seed before each scenario: true

## Replay Payload

```json
{
  "insert_body": {
    "registration_number": "PERF-01-DUP-001"
  },
  "table_name": "cz_companies"
}
```

## Latency and Outcome Summary

| Workers | Requests | Elapsed(s) | p50(ms) | p95(ms) | p99(ms) | Mean(ms) | Min(ms) | Max(ms) | Status Counts | Top Codes |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 25 | 500 | 0.61 | 19.00 | 61.82 | 170.71 | 24.01 | 16.27 | 246.15 | 409:500 | unique_violation:500 |
| 50 | 1000 | 0.44 | 19.08 | 38.22 | 50.01 | 20.86 | 15.97 | 58.84 | 409:1000 | unique_violation:1000 |
| 100 | 2000 | 8.47 | 19.08 | 59.26 | 185.54 | 30.61 | 15.94 | 8018.36 | 409:2000 | unique_violation: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 | 8 | 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 observed DB sql_state=23505 conflict paths.
- admission_*, db_timeout, window_wait_timeout, and bulk_fallback_sql_error capture queue/fallback resilience behavior.
- For strict before/after comparison, run this example twice with --label before and --label after.
