# PERF-01 Duplicate Insert Replay Report (after)

- Generated: 2026-04-17T05:59:18.803119700+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: 250
- 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 | 6250 | 5.47 | 19.91 | 28.74 | 50.00 | 21.20 | 16.25 | 90.56 | 409:6250 | unique_violation:6250 |
| 50 | 12500 | 5.13 | 18.72 | 24.77 | 53.07 | 19.93 | 15.50 | 105.08 | 409:12500 | unique_violation:12500 |
| 100 | 25000 | 13.23 | 19.47 | 24.84 | 50.43 | 20.79 | 15.42 | 8020.10 | 409:25000 | unique_violation:25000 |

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