PostgreSQL Performance Audit
Database performance benchmarks with trend analysis and competitive context.
Competitive comparisons based on publicly available documentation as of June 2026. All SveltyCMS metrics self-measured via bun test tests/benchmarks/.
Console-only by default. Use BENCHMARK_RECORD=1 to write results to this report.
BENCHMARK_RECORD=1 bun test tests/benchmarks/auth-performance.test.tsThe full matrix runner (bun run scripts/benchmark-matrix/index.ts --sql) always records.
π Latest Performance Audit
π Fix Overlays
Phase notes and remediation entries appear here after matrix or surgical runs.
Partial update β dimension rollups and issues reflect only tests invoked in this run.
β PASS (partial invocation) Β· 1/42 tests Β· 41 skipped Β· postgresql Β· standalone run
Dimension health
| Dimension | Tests | Status | Worst Ξ | Issues |
|---|---|---|---|---|
| Core | 14 | π’ | +41% | 0 |
| API | 0 | βͺ | β | 0 |
| Scale | 0 | βͺ | β | 0 |
| Resilience | 0 | βͺ | β | 0 |
Issues (action required)
β All clear β no regressions or budget violations detected.
Executive latency matrix
| Scenario | Latency | Trend | Budget | Result |
|---|---|---|---|---|
| Database Performance | 2.323ms | π΄ slower: 2.24ms β 2.32ms (+4%) (2 runs) | < 5ms | π’ |
| Database Performance | 0.886ms | βͺ stable at 0.854ms (Β±0.002ms) (2 runs) | < 5ms | π’ |
| Database Performance | 0.952ms | βͺ stable at 0.946ms (Β±0.044ms) (2 runs) | < 5ms | π’ |
| Database Performance | 1.008ms | βͺ established at 1.01ms (1 run) | < 5ms | π’ |
| Database Performance | 0.996ms | βͺ established at 0.996ms (1 run) | < 5ms | π’ |
| Database Performance | 0.904ms | βͺ established at 0.904ms (1 run) | < 5ms | π’ |
| Database Performance | 2.233ms | βͺ established at 2.23ms (1 run) | < 5ms | π’ |
| Database Performance | 2.293ms | βͺ stable at 2.19ms (Β±0.075ms) (2 runs) | < 5ms | π’ |
| Database Performance | 2.094ms | βͺ stable at 2.07ms (Β±0.046ms) (2 runs) | < 5ms | π’ |
| Database Performance | 2.197ms | βͺ stable at 1.56ms (Β±1.19ms) (2 runs) | < 5ms | π’ |
| Database Performance | 0.745ms | βͺ established at 0.745ms (1 run) | < 5ms | π’ |
| Database Performance | 0.024ms | βͺ established at 0.024ms (1 run) | < 5ms | π’ |
| Database Performance | 2.070ms | βͺ stable at 2.08ms (Β±0.030ms) (2 runs) | < 5ms | π’ |
| Database Performance | 7.256ms | βͺ stable at 7.33ms (Β±0.082ms) (2 runs) | < 5ms | π’ |
Historical pulse
Scope: Sparklines only β full run tables:
tests/benchmarks/results/history.sqlite
| Metric | Trend | Sparkline | Latest |
|---|---|---|---|
| database performance (BULK INSERT (100)) (warm) | π’ | βββ |
7.256ms |
π Latency trend chart (last 10 runs)
xychart-beta
title "postgresql REST p95 (last 10 runs)"
x-axis ["R1", "R2", "R3", "R4", "R5", "R6", "R7", "R8", "R9", "R10"]
y-axis "Latency (ms)"
line "p95" : [0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000]
π Regression severity matrix (quadrant)
quadrantChart
title "Regression severity (impact vs delta)"
x-axis Low latency impact --> High latency impact
y-axis Low delta --> High delta
quadrant-1 Monitor
quadrant-2 Investigate soon
quadrant-3 Acceptable variance
quadrant-4 Critical β fix first
Database Performance: [0.95, 0.95]
Current Run Summary (2026-08-04)
Scope: Only tests that ran in THIS invocation.
β οΈ Executive PASS/FAIL reflects the last full matrix run.
Run ID: c41de3d0-0bec-4620-90a2-6f22a9aaedca Β· Tests invoked: 1 Β· Metrics: 14 Β· DB: postgresql
| Test | Metric | Avg (ms) | p95 (ms) | RPS | Trend | Detail |
|---|---|---|---|---|---|---|
| Database Performance | FIND MANY (limit 50) | 0.952 | 1.123 | 923 | π’ | βͺ stable at 0.946ms (Β±0.044ms) (2 runs) |
| Database Performance | FIND PAGE (50 hasMore) | 1.008 | 1.168 | 885 | π’ | βͺ established at 1.01ms (1 run) |
| Database Performance | FIND PAGE keyset | 0.996 | 1.146 | 893 | π’ | βͺ established at 0.996ms (1 run) |
| Database Performance | FIND MANY offset 50 | 0.904 | 1.061 | 976 | π’ | βͺ established at 0.904ms (1 run) |
| Database Performance | LIST+COUNT (legacy) | 2.233 | 2.709 | 420 | π’ | βͺ established at 2.23ms (1 run) |
| Database Performance | UPDATE | 2.293 | 2.827 | 390 | π’ | βͺ stable at 2.19ms (Β±0.075ms) (2 runs) |
| Database Performance | NATIVE UPSERT | 2.094 | 2.500 | 421 | π’ | βͺ stable at 2.07ms (Β±0.046ms) (2 runs) |
| Database Performance | COUNT | 2.197 | 2.655 | 405 | π’ | βͺ stable at 1.56ms (Β±1.19ms) (2 runs) |
| Database Performance | COUNT ESTIMATE | 0.745 | 0.867 | 1181 | π’ | βͺ established at 0.745ms (1 run) |
| Database Performance | COUNT CACHED | 0.024 | 0.026 | 40749 | π’ | βͺ established at 0.024ms (1 run) |
| Database Performance | DELETE | 2.070 | 2.495 | 477 | π’ | βͺ stable at 2.08ms (Β±0.030ms) (2 runs) |
| Database Performance | BULK INSERT (100) | 7.256 | 9.221 | 137 | π’ | βͺ stable at 7.33ms (Β±0.082ms) (2 runs) |
| Database Performance | INSERT | 2.323 | 3.075 | 382 | βͺ | π΄ slower: 2.24ms β 2.32ms (+4%) (2 runs) |
| Database Performance | FIND ONE | 0.886 | 1.055 | 982 | βͺ | βͺ stable at 0.854ms (Β±0.002ms) (2 runs) |
Historical Trends (2026-08-04)
Scope: Sparklines only β full run tables live in
history.sqlite(link below). Runs = sparkline bar count.
Detail: tests/benchmarks/results/history.sqlite Β· SELECT test_id, phase, avg_ms, p95_ms, rps, timestamp FROM runs WHERE db_type='postgresql' AND redis=0 ORDER BY timestamp DESC
Series: 1 Β· DB: postgresql
| Metric | Trend | Sparkline (last 7) | Latest |
|---|---|---|---|
| DATABASE PERFORMANCE (warm) | π’ | βββββββ |
2.293ms |
π¬ Full benchmark ledger (41 modules)
Expand dimension groups, then any row, for ASCII truth tables. Executive summary above shows pass/fail and issues only.
Core Β· 18 tests
π·οΈ API LAYER LATENCY Β· π’ 2.951ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β API LAYER LATENCY β
β File: tests/benchmarks/api-latency.test.ts β
β Ran: 2026-07-21 16:15:15 β
β API Latency Benchmark (Production Optimized) β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β HTTP: findById @ 8c β 2.951 ms β p95: 4.658 ms β RPS: 322 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ PHASED COLD START Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β Measures the time to READY state (serving traffic) vs WARMED state (background tasks).
π·οΈ SRE TRUTH AUDIT Β· βͺ β³ pending Β· β‘οΈ pending Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β SRE TRUTH AUDIT β
β File: tests/benchmarks/truth-latency.test.ts β
β Ran: 2026-07-21 16:15:02 β
β Validates performance claims by comparing SDK, Middleware, and Real HTTP Stack β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Logic Baseline β 0.000 ms β p95: 0.001 ms β RPS: 2,345,583 β
β Local SDK (Full) β 0.005 ms β p95: 0.009 ms β RPS: 192,468 β
β HTTP End-to-End β 0.793 ms β p95: 1.684 ms β RPS: 1,261 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Incremental Content Reload Β· π’ 0.329ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β INCREMENTAL CONTENT RELOAD AUDIT β
β File: tests/benchmarks/content-incremental-reload.test.ts β
β Ran: 2026-07-21 16:20:19 β
β Measures surgical single-file fullReload vs full reconciliation path β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Incremental fullReload (1 file) β 0.329 ms β p95: 0.473 ms β RPS: 3,041 β
β Full Reconciliation Reload β 0.622 ms β p95: 0.847 ms β RPS: 1,608 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Middleware & Hooks Performance Β· π’ 0.874ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β MIDDLEWARE & HOOKS AUDIT β
β File: tests/benchmarks/hooks-performance.test.ts β
β Ran: 2026-07-21 16:17:49 β
βMeasures the cost of the full middleware chain including Turbo, Security, Auth, and Audit via HTTP E2E.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Static Asset (No Middleware) β 0.874 ms β p95: 1.402 ms β RPS: 1,122 β
β Turbo Pipeline (Light) β 0.693 ms β p95: 1.110 ms β RPS: 1,322 β
β Full Security + Auth Pipeline β 1.866 ms β p95: 2.880 ms β RPS: 505 β
β REST with API Caching β 1.749 ms β p95: 2.593 ms β RPS: 569 β
β Mutation + Audit Logging β 15.514 ms β p95: 18.698 ms β RPS: 53 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ State Machine Transitions Β· π’ 267.882ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β STATE MACHINE INTEGRITY β
β File: tests/benchmarks/state-machine-transition.test.ts β
β Ran: 2026-07-21 16:20:37 β
βSimulates rapid system re-initializations and verifies valid self-healing state transitions under stress.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β State Transition (READY -> IDLE -> READY) β 267.882 ms β p95: 320.365 ms β RPS: 4 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ database performance Β· π’ 7.256ms Β· β‘οΈ βͺ stable at 7.33ms (Β±0.082ms) (2 runs) (2026-08-04 12:02:11) Β· source
``` βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β SVELTYCMS β DATABASE ADAPTER PERFORMANCE (POSTGRESQL) β β File: tests/benchmarks/database-performance.test.ts β β Ran: 2026-08-04 12:02:11 β β Measures raw CRUD performance, indexing efficiency, and connection pool resilience β β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£ β INSERT β 2.323 ms β p95: 3.075 ms β RPS: 382 β β FIND ONE β 0.886 ms β p95: 1.055 ms β RPS: 982 β β FIND MANY (limit 50) β 0.952 ms β p95: 1.123 ms β RPS: 923 β β FIND PAGE (50 hasMore) β 1.008 ms β p95: 1.168 ms β RPS: 885 β β FIND PAGE keyset β 0.996 ms β p95: 1.146 ms β RPS: 893 β β FIND MANY offset 50 β 0.904 ms β p95: 1.061 ms β RPS: 976 β β LIST+COUNT (legacy) β 2.233 ms β p95: 2.709 ms β RPS: 420 β β UPDATE β 2.293 ms β p95: 2.827 ms β RPS: 390 β β NATIVE UPSERT β 2.094 ms β p95: 2.500 ms β RPS: 421 β β COUNT β 2.197 ms β p95: 2.655 ms β RPS: 405 β β COUNT ESTIMATE β 0.745 ms β p95: 0.867 ms β RPS: 1,181 β β COUNT CACHED β 0.024 ms β p95: 0.026 ms β RPS: 40,749 β β DELETE β 2.070 ms β p95: 2.495 ms β RPS: 477 β β BULK INSERT (100) β 7.256 ms β p95: 9.221 ms β RPS: 137 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ ```π·οΈ ACID Transaction Overhead Β· π’ 4.430ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β ACID INTEGRITY AUDIT β
β File: tests/benchmarks/transaction-acid.test.ts β
β Ran: 2026-07-21 16:19:57 β
β Measures transaction commit latencies and rollback overhead across database adapters β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β TX Commit β 4.430 ms β p95: 8.374 ms β RPS: 218 β
β TX Rollback Integrity β 5.034 ms β p95: 7.937 ms β RPS: 199 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Cache Β· π’ 0.001ms Β· β‘οΈ recorded (awaiting trend) Β· source
``` βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β SVELTYCMS β CACHE SERVICE TELEMETRY β β File: tests/benchmarks/cache-service.test.ts β β Ran: 2026-07-21 16:20:07 β β Measures L1 cache hit latency and pattern invalidation overhead at scale β β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£ β Cache L1 Hit β 0.001 ms β p95: 0.001 ms β RPS: 1,609,390 β β Pattern Invalidation (1k items @ 200k noise) β 6.897 ms β p95: 7.547 ms β RPS: 145 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ ```π·οΈ Cache Hit/Miss Ratio & Efficiency Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β Measures Redis cache hit/miss ratio, cold vs warm read speedup, and invalidation performance.
π·οΈ unknown Β· π’ 0.003ms Β· β‘οΈ recorded (awaiting trend) Β· source
``` βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β SVELTYCMS β CACHE EVICTION BOUNDARY HARDENING β β File: unknown β β Ran: 2026-07-21 16:20:06 β β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£ β Cache Flooding & Eviction β 0.003 ms β p95: 0.005 ms β RPS: 338,691 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ ```π·οΈ Middleware Β· π’ 12.207ms Β· β‘οΈ βͺ established at 12.21ms (1 run) (2026-07-10 08:07:22) Β· source
> β³ Pendingπ·οΈ System Β· π’ 0.729ms Β· β‘οΈ βͺ established at 0.729ms (1 run) (2026-07-10 08:08:10) Β· source
> β³ Pendingπ·οΈ Metadata Β· π’ 0.957ms Β· β‘οΈ βͺ established at 0.957ms (1 run) (2026-07-10 08:08:10) Β· source
> β³ Pendingπ·οΈ CRUD Β· π’ 1.353ms Β· β‘οΈ βͺ established at 1.35ms (1 run) (2026-07-10 08:08:10) Β· source
> β³ Pendingπ·οΈ Logic Β· π’ β³ pending Β· β‘οΈ βͺ established at 0ms (1 run) (2026-07-10 08:03:03) Β· source
> β³ Pendingπ·οΈ SDK Β· π’ 0.681ms Β· β‘οΈ recorded (awaiting trend) Β· source
``` βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β SVELTYCMS β SDK OVERHEAD TELEMETRY β β File: tests/benchmarks/local-api-performance.test.ts β β Ran: 2026-07-21 16:17:24 β β Measures LocalCMS SDK overhead vs direct adapter calls to verify zero-tax dispatching β β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£ β Direct Adapter Call β 0.681 ms β p95: 1.513 ms β RPS: 1,468 β β LocalCMS SDK Call β 0.673 ms β p95: 1.726 ms β RPS: 1,486 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ ```π·οΈ HTTP Β· π’ 0.575ms Β· β‘οΈ βͺ established at 0.575ms (1 run) (2026-07-10 08:03:03) Β· source
> β³ PendingAPI Β· 8 tests
π·οΈ Temporal Integrity Audit Β· π’ 17.794ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β TEMPORAL INTEGRITY β
β File: tests/benchmarks/temporal-integrity.test.ts β
β Ran: 2026-07-21 16:17:56 β
βValidates deterministic UTC normalization of ISO date strings across timezone offsets for consistent persistence.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Timezone Ingestion β 17.794 ms β p95: 17.794 ms β RPS: 56 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Relational & Nested Queries Β· π’ 4.487ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β RELATIONAL RESOLVER AUDIT β
β File: tests/benchmarks/relational-performance.test.ts β
β Ran: 2026-07-21 16:17:05 β
βMeasures GraphQL resolver performance for shallow and deep relational queries including joins and nested population.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Shallow Relational Query β 4.487 ms β p95: 6.549 ms β RPS: 207 β
β Deep Relational Query β 3.775 ms β p95: 5.829 ms β RPS: 250 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Auth & RBAC Performance Β· π’ 0.551ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β AUTHENTICATION TELEMETRY β
β File: tests/benchmarks/auth-performance.test.ts β
β Ran: 2026-07-21 16:15:18 β
β Authentication & RBAC Pipeline Benchmark (Production Optimized) β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Auth Validation @ 1c β 0.551 ms β p95: 0.641 ms β RPS: 1,654 β
β HTTP Auth Pipeline @ 8c β 2.446 ms β p95: 3.870 ms β RPS: 395 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ REST API Performance Β· π’ 0.675ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β ENTERPRISE REST API AUDIT β
β File: tests/benchmarks/rest-api-performance.test.ts β
β Ran: 2026-07-21 16:15:13 β
βMeasures latency, throughput, and correctness of core REST endpoints: health check, schema, CRUD list, and search.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Health Check β 0.675 ms β p95: 1.214 ms β RPS: 1,481 β
β Collection Schema β 1.856 ms β p95: 2.980 ms β RPS: 539 β
β Collection Find (List) β 1.766 ms β p95: 2.727 ms β RPS: 566 β
β Collection Search β 1.546 ms β p95: 2.347 ms β RPS: 647 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ GraphQL API Performance Β· π’ 1.275ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β GRAPHQL PERFORMANCE AUDIT β
β File: tests/benchmarks/graphql-api-performance.test.ts β
β Ran: 2026-07-21 16:16:28 β
β Measures GraphQL resolver performance and throughput across varied query scenarios. β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β GQL: System Health β 1.275 ms β p95: 2.194 ms β RPS: 784 β
β GQL: Collection List β 5.273 ms β p95: 8.660 ms β RPS: 190 β
β GQL: Concurrent Load β 4.158 ms β p95: 6.774 ms β RPS: 241 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Enterprise SEO Suite Audit Β· π’ 1.172ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β ENTERPRISE SEO AUDIT β
β File: tests/benchmarks/seo-performance.test.ts β
β Ran: 2026-07-21 16:17:09 β
βMeasures redirect lookup latency, dynamic sitemap.xml generation, robots.txt serving, and 404 logging performance.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Redirect Lookup (301) β 1.172 ms β p95: 1.880 ms β RPS: 854 β
β Dynamic Sitemap XML β 0.885 ms β p95: 1.438 ms β RPS: 1,130 β
β Robots.txt Generation β 1.424 ms β p95: 2.362 ms β RPS: 702 β
β Missing Path (404 Log) β 5.818 ms β p95: 8.663 ms β RPS: 172 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ REAL-TIME BROADCAST AUDIT Β· π’ 0.180ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β YJS COLLABORATION SYNC AUDIT β
β File: tests/benchmarks/websocket-broadcast.test.ts β
β Ran: 2026-07-21 16:21:54 β
β Measures end-to-end Yjs update propagation latency and connection handshake timing. β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Yjs CRDT Update Sync β 0.180 ms β p95: 0.311 ms β RPS: 5,561 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ WebSocket & Realtime Latency Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β Benchmarks WebSocket connection/broadcast latency.
Scale Β· 18 tests
π·οΈ Negative Cache Performance Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β Benchmarks 404-miss response times and cache lookup speedup.
π·οΈ Revision & History Growth Β· π’ 1.362ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β REVISION STRESS AUDIT β
β File: tests/benchmarks/revision-stress.test.ts β
β Ran: 2026-07-21 16:18:25 β
βMeasures read and history list latency degradation under heavy revision history growth (100 revisions per entry).β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Latest Read (High Revision Count) β 1.362 ms β p95: 2.074 ms β RPS: 734 β
β History List Retrieval β 1.168 ms β p95: 2.031 ms β RPS: 857 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Memory Stability & GC Behavior Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β Long-running soak test to identify memory leaks and GC pressure.
π·οΈ Multi-Tenant Performance & Isolation Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β Stress-tests cross-tenant isolation and security boundary latency.
π·οΈ Realistic Mixed Workload Β· π’ 2.881ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β MIXED WORKLOAD AUDIT β
β File: tests/benchmarks/mixed-workload.test.ts β
β Ran: 2026-07-21 16:17:13 β
βSimulates real-world traffic with a weighted mix of reads, searches, GraphQL queries, and metadata requests.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Mixed Workload β 2.881 ms β p95: 4.843 ms β RPS: 337 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ GraphQL Load Stress Β· π’ 5.199ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β GRAPHQL CAPACITY DISCOVERY β
β File: tests/benchmarks/graphql-stress.test.ts β
β Ran: 2026-07-21 16:16:38 β
β Discovers the server's maximum sustainable GraphQL throughput by ramping concurrency β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β GQL: 5c Warmup β 5.199 ms β p95: 7.919 ms β RPS: 190 β
β GQL: 10c Light β 8.434 ms β p95: 12.089 ms β RPS: 118 β
β GQL: 20c Moderate β 14.096 ms β p95: 19.866 ms β RPS: 71 β
β GQL: 40c Heavy β 26.608 ms β p95: 37.087 ms β RPS: 38 β
β GQL: 60c Stress β 41.163 ms β p95: 61.533 ms β RPS: 24 β
β GQL: 80c Extreme β 55.184 ms β p95: 79.745 ms β RPS: 18 β
β GQL: 100c Max β 41.135 ms β p95: 77.826 ms β RPS: 24 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Bulk Migration & Scale Β· π’ 52.603ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β MIGRATION & SCALE AUDIT β
β File: tests/benchmarks/migration-scale.test.ts β
β Ran: 2026-07-21 16:21:31 β
βMeasures bulk ingestion throughput for 10,000 entries and post-migration random lookup performance.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Bulk Migration (10k) β 52.603 ms β p95: 119.602 ms β RPS: 19 β
β Post-Migration Read β 3.845 ms β p95: 6.382 ms β RPS: 260 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Million-Row Index Pressure Β· π’ 5.346ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β INDEX PRESSURE AUDIT β
β File: tests/benchmarks/index-pressure.test.ts β
β Ran: 2026-07-21 16:18:18 β
β Measures read performance with sorting and filtering on a large entry collection. β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Sorted List (25k rows) β 5.346 ms β p95: 9.435 ms β RPS: 187 β
β Filtered Query (25k rows) β 3.462 ms β p95: 5.547 ms β RPS: 289 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Content Scale Stress Β· π’ 1.294ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β CONTENT SCALE STRESS AUDIT β
β File: tests/benchmarks/content-scale-stress.test.ts β
β Ran: 2026-07-21 16:20:20 β
βMeasures file-scanning and content discovery performance at extreme scale (1,000+ collections)β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Cold Stress Scan (1k) β 1.294 ms β p95: 2.397 ms β RPS: 773 β
β Warm Stress Scan (1k) β 0.423 ms β p95: 0.523 ms β RPS: 2,366 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Media Upload Stress & Throughput Β· π’ 1.517ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β MEDIA UPLOAD STRESS AUDIT β
β File: tests/benchmarks/media-upload-stress.test.ts β
β Ran: 2026-07-21 16:21:16 β
βMeasures throughput for large file uploads, concurrent transfers, and streaming efficiency.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Single Upload (0.1MB) β 1.517 ms β p95: 1.836 ms β RPS: 659 β
β Small Upload (20KB) β 4.437 ms β p95: 7.201 ms β RPS: 225 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Full Client Journey Simulation Β· π’ 26.028ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β WORLD LIFE DATA β
β File: tests/benchmarks/client-journey.test.ts β
β Ran: 2026-07-21 16:18:01 β
βMeasures cumulative latency of a realistic editorial user workflow: Auth β List β View β Edit β Save.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Full Journey @ 4c β 26.028 ms β p95: 35.165 ms β RPS: 38 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Concurrency & Race Condition Β· βͺ β³ pending Β· β‘οΈ pending Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β THROUGHPUT SCALING (POSTGRESQL) β
β File: tests/benchmarks/concurrency-throughput.test.ts β
β Ran: 2026-07-21 16:21:44 β
β 100 writes across 10, 100, 1000 docs. Same work, different parallelism. β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β 10 docs Γ 10 β 0.000 ms β p95: 0.000 ms β RPS: 825 β
β 100 docs Γ 1 β 0.000 ms β p95: 0.000 ms β RPS: 933 β
β 1000 docs Γ 1 β 0.000 ms β p95: 0.000 ms β RPS: 954 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Multi-Doc Concurrency Throughput Β· π’ 1.586ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β LOCAL SDK BENCHMARK (POSTGRESQL) β
β File: tests/benchmarks/local-api-throughput.test.ts β
β Ran: 2026-07-21 16:18:29 β
β Measures write throughput, read throughput, and SDK overhead in one pass. β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Writes (1000) β 1.586 ms β p95: 0.000 ms β RPS: 630 β
β Reads (1000) β 0.226 ms β p95: 0.000 ms β RPS: 4,426 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Max Throughput β No Throttle Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β 1000 concurrent writes across 100 docs β no semaphore.
π·οΈ Local SDK Throughput Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β 1000 direct adapter calls β no HTTP, no middleware.
π·οΈ Failure Propagation & Fast-Fail Audit Β· βͺ β³ pending Β· β‘οΈ pending Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β AI INFRASTRUCTURE AUDIT β
β File: tests/benchmarks/ai-performance.test.ts β
β Ran: 2026-07-21 16:17:39 β
β Measures the latency tax of internal CMS logic for AI enrichment and layout generation. β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β AI Text Enrichment β 0.000 ms β p95: 0.001 ms β RPS: 1,506,024 β
β AI Layout Spec Generation β 0.000 ms β p95: 0.000 ms β RPS: 2,297,090 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Chaos & Infrastructure Resilience Β· π’ 170.556ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β CHAOS RESILIENCE AUDIT β
β File: tests/benchmarks/chaos-resilience.test.ts β
β Ran: 2026-07-21 16:16:17 β
βSimulates infrastructure brownouts and measures system stability and graceful degradation under stress.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Chaos Resilience (Brownout) β 170.556 ms β p95: 686.820 ms β RPS: 6 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ Production Day Simulation Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β Full production day with mixed workload, 100% reliability.
Resilience Β· 5 tests
π·οΈ Circuit Breaker Failover Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β Measures system graceful degradation when external services fail.
π·οΈ Throttling & Backoff Stress Β· π’ 2.568ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β THROTTLING AUDIT β
β File: tests/benchmarks/throttling-backoff-stress.test.ts β
β Ran: 2026-07-21 16:20:21 β
βSimulates high-velocity traffic from a single client IP to verify rate-limiting enforcement and backoff consistency.β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Throttling Enforcement β 2.568 ms β p95: 5.015 ms β RPS: 389 β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ·οΈ GDPR Compliance Speed Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β Measures performance of deep-deletion across all linked tables.
π·οΈ Data Residency & Sovereignty Β· β³ pending Β· β‘οΈ baseline Β· source
β³ Pending β PII blocking and data sovereignty enforcement with cross-region failover.
π·οΈ Database Failover & Reconnection Β· π’ 0.247ms Β· β‘οΈ recorded (awaiting trend) Β· source
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β SVELTYCMS β DATABASE FAILOVER AUDIT β
β File: tests/benchmarks/database-failover.test.ts β
β Ran: 2026-07-21 16:20:14 β
β Simulates database connection loss mid-request and measures circuit breaker activation, β
β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ£
β Baseline Health Check β 0.247 ms β p95: 0.342 ms β RPS: 4,054 β
β Degraded Dependency β 0.595 ms β p95: 0.951 ms β RPS: 1,680 β
β Post-Recovery Health β 2.168 ms β p95: 3.147 ms β RPS: 461 β
β Reconnect Time β 0.424 ms β p95: 0.424 ms β RPS: 0 β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ³ Host environment populates after matrix run.
Was this page helpful?