# PERF-01 Duplicate Insert Replay Report (after)

- Generated: 2026-04-17T05:58:37.359160800+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: 50
- 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 | 1250 | 1.15 | 20.14 | 26.17 | 48.16 | 21.22 | 16.26 | 53.70 | 409:1250 | unique_violation:1250 |
| 50 | 2500 | 1.11 | 19.61 | 27.89 | 62.97 | 21.42 | 16.44 | 72.93 | 409:2500 | unique_violation:2500 |
| 100 | 5000 | 1.05 | 18.98 | 24.11 | 47.61 | 19.86 | 15.39 | 68.03 | 409:5000 | unique_violation:5000 |

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