date: 2026-11-05T21:00:40.534470+00:00 commit: 57744c532c58d3e2bd248b4368ecba0a42402ed8
COMPOSE_PROJECT_NAME=mtusi2026lab3-track5-20261105 LB_HTTP_PORT=18083 LB_STATS_PORT=23083 NO_PROXY=localhost,127.0.0.1,::1
$ make track1-compare track1-control
git archive "5c8f605cd3bd40245109348463d3e7111379b2d3" | docker build -q -t mtusi-messenger:5c8f605cd3bd40245109348463d3e7111379b2d3 -
sha256:3cd2f31af1b025c67f7d28931936c6f80774bd15dfea7e469e35b79cd0454388
docker compose build -q api
python3 scripts/scaling.py --out evidence/track1-sqlalchemy/compare --configs 8x1 --api-memory 512 --rates 2400,3600,5400 \
		--variant before:API_IMAGE=mtusi-messenger:5c8f605cd3bd40245109348463d3e7111379b2d3 --variant after
{"raw_dir": "before-8x1_rate2400_rep1_attempt1", "variant": "before", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 2400, "repeat": 1, "started": "2026-11-05T21:01:04Z", "db_mb": 2135.9, "messages": 4496029, "k6_exit": 0, "saturated": false, "requests": 72000, "rps": 2400.0, "ok_rps": 2400.0, "failed_ratio": 0, "dropped_iterations": 0, "p50_ms": 3.39, "p95_ms": 10.28, "p99_ms": 57.74, "p95_post_ms": 9.8, "p95_get_ms": 12.38, "cpu_api": 585.07, "cpu_postgres": 99.26, "cpu_lb": 24.35, "cpu_valkey": 6.17, "cpu_k6": 43.34, "mem_api_mb": 168.5, "mem_postgres_mb": 307.5, "mem_k6_mb": 193.4, "pg_backends_max": 64, "pg_active_avg": 1.77, "pg_active_max": 10, "pg_idle_avg": 58.27, "pg_idle_tx_avg": 3.96, "pg_lock_avg": 0.38, "pg_lock_max": 10, "pg_lwlock_avg": 0.27, "pg_io_avg": 0.54, "lb_scur_max": 147, "lb_qcur_max": 0, "lb_qtime_max_ms": 0, "lb_rtime_avg_ms": 5.93, "cpu_vm": 793.3, "cpu_other": 35.1, "gap_s": 4.2, "wall_s": 41.8, "disturbed": false}
{"raw_dir": "before-8x1_rate3600_rep1_attempt1", "variant": "before", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 3600, "repeat": 1, "started": "2026-11-05T21:01:51Z", "db_mb": 2172.8, "messages": 4572923, "k6_exit": 0, "saturated": true, "requests": 106860, "rps": 3562.0, "ok_rps": 3562.0, "failed_ratio": 0, "dropped_iterations": 1138, "p50_ms": 107.38, "p95_ms": 238.0, "p99_ms": 283.23, "p95_post_ms": 228.27, "p95_get_ms": 270.96, "cpu_api": 792.56, "cpu_postgres": 166.88, "cpu_lb": 40.61, "cpu_valkey": 10.58, "cpu_k6": 70.98, "mem_api_mb": 174.9, "mem_postgres_mb": 367.9, "mem_k6_mb": 458.4, "pg_backends_max": 64, "pg_active_avg": 32.08, "pg_active_max": 49, "pg_idle_avg": 15.04, "pg_idle_tx_avg": 16.88, "pg_lock_avg": 27.4, "pg_lock_max": 47, "pg_lwlock_avg": 2.16, "pg_io_avg": 0.52, "lb_scur_max": 862, "lb_qcur_max": 606, "lb_qtime_max_ms": 163, "lb_rtime_avg_ms": 56.52, "cpu_vm": 1112.1, "cpu_other": 30.5, "gap_s": 4.3, "wall_s": 41.6, "disturbed": false}
{"raw_dir": "before-8x1_rate5400_rep1_attempt1", "variant": "before", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 1, "started": "2026-11-05T21:02:38Z", "db_mb": 2227.1, "messages": 4686896, "k6_exit": 0, "saturated": true, "requests": 95087, "rps": 3169.57, "ok_rps": 3169.57, "failed_ratio": 0, "dropped_iterations": 66914, "p50_ms": 275.92, "p95_ms": 538.35, "p99_ms": 617.85, "p95_post_ms": 524.3, "p95_get_ms": 577.48, "cpu_api": 696.23, "cpu_postgres": 148.72, "cpu_lb": 33.42, "cpu_valkey": 9.01, "cpu_k6": 60.22, "mem_api_mb": 174.7, "mem_postgres_mb": 421.8, "mem_k6_mb": 649.6, "pg_backends_max": 64, "pg_active_avg": 36.08, "pg_active_max": 60, "pg_idle_avg": 11.96, "pg_idle_tx_avg": 15.96, "pg_lock_avg": 30.77, "pg_lock_max": 50, "pg_lwlock_avg": 3.5, "pg_io_avg": 0.65, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 403, "lb_rtime_avg_ms": 85.07, "cpu_vm": 1009.8, "cpu_other": 62.2, "gap_s": 4.4, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "after-8x1_rate2400_rep1_attempt1", "variant": "after", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 2400, "repeat": 1, "started": "2026-11-05T21:03:37Z", "db_mb": 2277.8, "messages": 4794359, "k6_exit": 0, "saturated": false, "requests": 72001, "rps": 2400.03, "ok_rps": 2400.03, "failed_ratio": 0, "dropped_iterations": 0, "p50_ms": 2.3, "p95_ms": 5.14, "p99_ms": 18.54, "p95_post_ms": 4.3, "p95_get_ms": 6.44, "cpu_api": 421.31, "cpu_postgres": 96.15, "cpu_lb": 24.11, "cpu_valkey": 5.89, "cpu_k6": 43.16, "mem_api_mb": 168.6, "mem_postgres_mb": 463.8, "mem_k6_mb": 199.1, "pg_backends_max": 64, "pg_active_avg": 3.26, "pg_active_max": 44, "pg_idle_avg": 58.11, "pg_idle_tx_avg": 2.63, "pg_lock_avg": 1.7, "pg_lock_max": 42, "pg_lwlock_avg": 0.63, "pg_io_avg": 0.37, "lb_scur_max": 29, "lb_qcur_max": 0, "lb_qtime_max_ms": 0, "lb_rtime_avg_ms": 2.69, "cpu_vm": 620.0, "cpu_other": 29.4, "gap_s": 4.4, "wall_s": 41.8, "disturbed": false}
{"raw_dir": "after-8x1_rate3600_rep1_attempt1", "variant": "after", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 3600, "repeat": 1, "started": "2026-11-05T21:04:24Z", "db_mb": 2314.5, "messages": 4870857, "k6_exit": 0, "saturated": false, "requests": 107005, "rps": 3566.83, "ok_rps": 3566.83, "failed_ratio": 0, "dropped_iterations": 996, "p50_ms": 10.19, "p95_ms": 210.49, "p99_ms": 265.8, "p95_post_ms": 200.81, "p95_get_ms": 232.08, "cpu_api": 610.85, "cpu_postgres": 161.31, "cpu_lb": 37.48, "cpu_valkey": 9.29, "cpu_k6": 67.99, "mem_api_mb": 170.2, "mem_postgres_mb": 521.1, "mem_k6_mb": 402.3, "pg_backends_max": 64, "pg_active_avg": 25.81, "pg_active_max": 56, "pg_idle_avg": 28.19, "pg_idle_tx_avg": 10, "pg_lock_avg": 22.35, "pg_lock_max": 48, "pg_lwlock_avg": 2, "pg_io_avg": 0.62, "lb_scur_max": 754, "lb_qcur_max": 498, "lb_qtime_max_ms": 141, "lb_rtime_avg_ms": 36.1, "cpu_vm": 931.7, "cpu_other": 44.8, "gap_s": 4.5, "wall_s": 41.9, "disturbed": false}
{"raw_dir": "after-8x1_rate5400_rep1_attempt1", "variant": "after", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 1, "started": "2026-11-05T21:05:11Z", "db_mb": 2369.6, "messages": 4986570, "k6_exit": 0, "saturated": true, "requests": 117719, "rps": 3923.97, "ok_rps": 3923.97, "failed_ratio": 0, "dropped_iterations": 44289, "p50_ms": 245.08, "p95_ms": 317.43, "p99_ms": 414.46, "p95_post_ms": 309.77, "p95_get_ms": 332.7, "cpu_api": 611.26, "cpu_postgres": 174.76, "cpu_lb": 37.62, "cpu_valkey": 9.21, "cpu_k6": 66.0, "mem_api_mb": 172.9, "mem_postgres_mb": 553.3, "mem_k6_mb": 655.2, "pg_backends_max": 64, "pg_active_avg": 45.63, "pg_active_max": 58, "pg_idle_avg": 5.56, "pg_idle_tx_avg": 12.81, "pg_lock_avg": 41.56, "pg_lock_max": 50, "pg_lwlock_avg": 2.89, "pg_io_avg": 0.48, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 229, "lb_rtime_avg_ms": 65.1, "cpu_vm": 960.1, "cpu_other": 61.2, "gap_s": 4.7, "wall_s": 42.1, "disturbed": false}
{"raw_dir": "before-8x1_rate2400_rep2_attempt1", "variant": "before", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 2400, "repeat": 2, "started": "2026-11-05T21:06:10Z", "db_mb": 2429.8, "messages": 5113330, "k6_exit": 0, "saturated": false, "requests": 72001, "rps": 2400.03, "ok_rps": 2400.03, "failed_ratio": 0, "dropped_iterations": 0, "p50_ms": 3.39, "p95_ms": 14.28, "p99_ms": 63.16, "p95_post_ms": 14.83, "p95_get_ms": 12.51, "cpu_api": 573.24, "cpu_postgres": 101.03, "cpu_lb": 24.63, "cpu_valkey": 6.18, "cpu_k6": 43.34, "mem_api_mb": 169.0, "mem_postgres_mb": 544.1, "mem_k6_mb": 189.3, "pg_backends_max": 64, "pg_active_avg": 5.73, "pg_active_max": 48, "pg_idle_avg": 53.92, "pg_idle_tx_avg": 4.35, "pg_lock_avg": 4, "pg_lock_max": 48, "pg_lwlock_avg": 0.69, "pg_io_avg": 0.54, "lb_scur_max": 86, "lb_qcur_max": 0, "lb_qtime_max_ms": 0, "lb_rtime_avg_ms": 6.43, "cpu_vm": 789.8, "cpu_other": 41.4, "gap_s": 4.9, "wall_s": 41.8, "disturbed": false}
unknown shorthand flag: 'T' in -T

Usage:  docker [OPTIONS] COMMAND [ARG...]

Run 'docker --help' for more information
{"raw_dir": "before-8x1_rate3600_rep2_attempt1", "variant": "before", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 3600, "repeat": 2, "started": "2026-11-05T21:06:57Z", "db_mb": 2462.6, "messages": 5170129, "k6_exit": 0, "saturated": true, "requests": 106806, "rps": 3560.2, "ok_rps": 3560.2, "failed_ratio": 0, "dropped_iterations": 1197, "p50_ms": 92.87, "p95_ms": 223.99, "p99_ms": 289.24, "p95_post_ms": 208.67, "p95_get_ms": 250.66, "cpu_api": 774.41, "cpu_postgres": 159.55, "cpu_lb": 37.95, "cpu_valkey": 9.54, "cpu_k6": 68.04, "mem_api_mb": 174.3, "mem_postgres_mb": 559.2, "mem_k6_mb": 475.9, "pg_backends_max": 64, "pg_active_avg": 31.5, "pg_active_max": 54, "pg_idle_avg": 17.58, "pg_idle_tx_avg": 14.92, "pg_lock_avg": 26.46, "pg_lock_max": 53, "pg_lwlock_avg": 2.65, "pg_io_avg": 0.73, "lb_scur_max": 777, "lb_qcur_max": 521, "lb_qtime_max_ms": 148, "lb_rtime_avg_ms": 49, "cpu_vm": 1087.7, "cpu_other": 38.2, "gap_s": 4.0, "wall_s": 41.6, "disturbed": false}
{"raw_dir": "before-8x1_rate5400_rep2_attempt1", "variant": "before", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 2, "started": "2026-11-05T21:07:45Z", "db_mb": 2516.1, "messages": 5284358, "k6_exit": 0, "saturated": true, "requests": 108875, "rps": 3629.17, "ok_rps": 3629.17, "failed_ratio": 0, "dropped_iterations": 53126, "p50_ms": 260.28, "p95_ms": 362.79, "p99_ms": 480.28, "p95_post_ms": 351.64, "p95_get_ms": 394.84, "cpu_api": 778.55, "cpu_postgres": 167.7, "cpu_lb": 39.26, "cpu_valkey": 10.2, "cpu_k6": 75.15, "mem_api_mb": 175.0, "mem_postgres_mb": 583.5, "mem_k6_mb": 648.5, "pg_backends_max": 64, "pg_active_avg": 34.73, "pg_active_max": 56, "pg_idle_avg": 13.19, "pg_idle_tx_avg": 16.04, "pg_lock_avg": 29.35, "pg_lock_max": 45, "pg_lwlock_avg": 2.65, "pg_io_avg": 0.65, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 265, "lb_rtime_avg_ms": 70.34, "cpu_vm": 1097.6, "cpu_other": 26.7, "gap_s": 4.2, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "after-8x1_rate2400_rep2_attempt1", "variant": "after", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 2400, "repeat": 2, "started": "2026-11-05T21:08:43Z", "db_mb": 2571.8, "messages": 5402264, "k6_exit": 0, "saturated": false, "requests": 72000, "rps": 2400.0, "ok_rps": 2400.0, "failed_ratio": 0, "dropped_iterations": 0, "p50_ms": 2.19, "p95_ms": 4.43, "p99_ms": 11.11, "p95_post_ms": 3.51, "p95_get_ms": 5.4, "cpu_api": 402.9, "cpu_postgres": 94.19, "cpu_lb": 23.53, "cpu_valkey": 5.66, "cpu_k6": 41.23, "mem_api_mb": 170.3, "mem_postgres_mb": 575.2, "mem_k6_mb": 193.8, "pg_backends_max": 64, "pg_active_avg": 1.44, "pg_active_max": 5, "pg_idle_avg": 59.89, "pg_idle_tx_avg": 2.67, "pg_lock_avg": 0, "pg_lock_max": 0, "pg_lwlock_avg": 0.33, "pg_io_avg": 0.37, "lb_scur_max": 11, "lb_qcur_max": 0, "lb_qtime_max_ms": 0, "lb_rtime_avg_ms": 2.45, "cpu_vm": 597.4, "cpu_other": 29.9, "gap_s": 4.7, "wall_s": 41.8, "disturbed": false}
{"raw_dir": "after-8x1_rate3600_rep2_attempt1", "variant": "after", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 3600, "repeat": 2, "started": "2026-11-05T21:09:30Z", "db_mb": 2608.7, "messages": 5479013, "k6_exit": 0, "saturated": false, "requests": 107622, "rps": 3587.4, "ok_rps": 3587.4, "failed_ratio": 0, "dropped_iterations": 379, "p50_ms": 3.51, "p95_ms": 76.11, "p99_ms": 147.83, "p95_post_ms": 69.31, "p95_get_ms": 100.41, "cpu_api": 593.03, "cpu_postgres": 145.91, "cpu_lb": 34.92, "cpu_valkey": 8.53, "cpu_k6": 59.82, "mem_api_mb": 172.3, "mem_postgres_mb": 590.8, "mem_k6_mb": 311.9, "pg_backends_max": 64, "pg_active_avg": 10.77, "pg_active_max": 59, "pg_idle_avg": 44.81, "pg_idle_tx_avg": 8.42, "pg_lock_avg": 7.35, "pg_lock_max": 50, "pg_lwlock_avg": 1.5, "pg_io_avg": 0.42, "lb_scur_max": 419, "lb_qcur_max": 163, "lb_qtime_max_ms": 54, "lb_rtime_avg_ms": 9.66, "cpu_vm": 869.0, "cpu_other": 26.8, "gap_s": 4.0, "wall_s": 41.7, "disturbed": false}
{"raw_dir": "after-8x1_rate5400_rep2_attempt1", "variant": "after", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 2, "started": "2026-11-05T21:10:17Z", "db_mb": 2664.0, "messages": 5612789, "k6_exit": 0, "saturated": true, "requests": 118369, "rps": 3945.63, "ok_rps": 3945.63, "failed_ratio": 0, "dropped_iterations": 43632, "p50_ms": 243.15, "p95_ms": 318.15, "p99_ms": 415.68, "p95_post_ms": 312.57, "p95_get_ms": 334.47, "cpu_api": 614.42, "cpu_postgres": 175.77, "cpu_lb": 39.18, "cpu_valkey": 9.14, "cpu_k6": 73.57, "mem_api_mb": 173.8, "mem_postgres_mb": 580.3, "mem_k6_mb": 650.3, "pg_backends_max": 64, "pg_active_avg": 47.96, "pg_active_max": 58, "pg_idle_avg": 4.88, "pg_idle_tx_avg": 11.15, "pg_lock_avg": 41.81, "pg_lock_max": 46, "pg_lwlock_avg": 3.96, "pg_io_avg": 0.62, "lb_scur_max": 999, "lb_qcur_max": 743, "lb_qtime_max_ms": 199, "lb_rtime_avg_ms": 64.45, "cpu_vm": 963.5, "cpu_other": 51.4, "gap_s": 4.0, "wall_s": 42.0, "disturbed": false}
{"compose_up_failed": 1, "log": "evidence/track1-sqlalchemy/compare/compose-up-failed.log"}
{"raw_dir": "before-8x1_rate2400_rep3_attempt1", "variant": "before", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 2400, "repeat": 3, "started": "2026-11-05T21:11:46Z", "db_mb": 2724.7, "messages": 5740748, "k6_exit": 0, "saturated": false, "requests": 72001, "rps": 2400.03, "ok_rps": 2400.03, "failed_ratio": 0, "dropped_iterations": 0, "p50_ms": 3.22, "p95_ms": 14.38, "p99_ms": 64.88, "p95_post_ms": 13.92, "p95_get_ms": 16.46, "cpu_api": 565.58, "cpu_postgres": 99.82, "cpu_lb": 24.31, "cpu_valkey": 6.12, "cpu_k6": 42.76, "mem_api_mb": 161.8, "mem_postgres_mb": 545.0, "mem_k6_mb": 189.6, "pg_backends_max": 64, "pg_active_avg": 3.15, "pg_active_max": 29, "pg_idle_avg": 56.92, "pg_idle_tx_avg": 3.92, "pg_lock_avg": 1.19, "pg_lock_max": 26, "pg_lwlock_avg": 0.77, "pg_io_avg": 0.54, "lb_scur_max": 61, "lb_qcur_max": 0, "lb_qtime_max_ms": 0, "lb_rtime_avg_ms": 3.97, "cpu_vm": 763.4, "cpu_other": 24.8, "gap_s": 4.6, "wall_s": 41.8, "disturbed": false}
{"raw_dir": "before-8x1_rate3600_rep3_attempt1", "variant": "before", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 3600, "repeat": 3, "started": "2026-11-05T21:12:33Z", "db_mb": 2761.8, "messages": 5817237, "k6_exit": 0, "saturated": false, "requests": 107457, "rps": 3581.9, "ok_rps": 3581.9, "failed_ratio": 0, "dropped_iterations": 544, "p50_ms": 11.24, "p95_ms": 155.14, "p99_ms": 198.69, "p95_post_ms": 145.45, "p95_get_ms": 184.17, "cpu_api": 773.75, "cpu_postgres": 153.28, "cpu_lb": 36.41, "cpu_valkey": 9.37, "cpu_k6": 67.81, "mem_api_mb": 167.5, "mem_postgres_mb": 553.6, "mem_k6_mb": 353.1, "pg_backends_max": 64, "pg_active_avg": 19.46, "pg_active_max": 54, "pg_idle_avg": 29.46, "pg_idle_tx_avg": 15.08, "pg_lock_avg": 15.58, "pg_lock_max": 42, "pg_lwlock_avg": 1.62, "pg_io_avg": 0.54, "lb_scur_max": 568, "lb_qcur_max": 312, "lb_qtime_max_ms": 76, "lb_rtime_avg_ms": 29.48, "cpu_vm": 1086.3, "cpu_other": 45.7, "gap_s": 4.0, "wall_s": 41.8, "disturbed": false}
{"raw_dir": "before-8x1_rate5400_rep3_attempt1", "variant": "before", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 3, "started": "2026-11-05T21:13:21Z", "db_mb": 2815.8, "messages": 5931405, "k6_exit": 0, "saturated": true, "requests": 109964, "rps": 3665.47, "ok_rps": 3665.47, "failed_ratio": 0, "dropped_iterations": 52034, "p50_ms": 258.12, "p95_ms": 373.74, "p99_ms": 467.07, "p95_post_ms": 364.8, "p95_get_ms": 407.84, "cpu_api": 775.03, "cpu_postgres": 168.6, "cpu_lb": 37.1, "cpu_valkey": 9.98, "cpu_k6": 75.11, "mem_api_mb": 179.8, "mem_postgres_mb": 569.0, "mem_k6_mb": 646.3, "pg_backends_max": 64, "pg_active_avg": 32.69, "pg_active_max": 50, "pg_idle_avg": 14.15, "pg_idle_tx_avg": 17.15, "pg_lock_avg": 28.23, "pg_lock_max": 39, "pg_lwlock_avg": 1.69, "pg_io_avg": 0.54, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 337, "lb_rtime_avg_ms": 70.52, "cpu_vm": 1113.7, "cpu_other": 47.9, "gap_s": 4.1, "wall_s": 41.8, "disturbed": false}
{"compose_up_failed": 1, "log": "evidence/track1-sqlalchemy/compare/compose-up-failed.log"}
{"raw_dir": "after-8x1_rate2400_rep3_attempt1", "variant": "after", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 2400, "repeat": 3, "started": "2026-11-05T21:14:49Z", "db_mb": 2872.5, "messages": 6051065, "k6_exit": 0, "saturated": false, "requests": 72001, "rps": 2400.03, "ok_rps": 2400.03, "failed_ratio": 0, "dropped_iterations": 0, "p50_ms": 2.2, "p95_ms": 4.63, "p99_ms": 14.2, "p95_post_ms": 3.82, "p95_get_ms": 5.88, "cpu_api": 405.23, "cpu_postgres": 93.42, "cpu_lb": 23.31, "cpu_valkey": 5.74, "cpu_k6": 40.75, "mem_api_mb": 161.7, "mem_postgres_mb": 550.6, "mem_k6_mb": 191.4, "pg_backends_max": 64, "pg_active_avg": 1.56, "pg_active_max": 7, "pg_idle_avg": 59.67, "pg_idle_tx_avg": 2.78, "pg_lock_avg": 0.07, "pg_lock_max": 2, "pg_lwlock_avg": 0.44, "pg_io_avg": 0.37, "lb_scur_max": 24, "lb_qcur_max": 0, "lb_qtime_max_ms": 0, "lb_rtime_avg_ms": 3.03, "cpu_vm": 595.6, "cpu_other": 27.1, "gap_s": 4.8, "wall_s": 41.8, "disturbed": false}
{"raw_dir": "after-8x1_rate3600_rep3_attempt1", "variant": "after", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 3600, "repeat": 3, "started": "2026-11-05T21:15:37Z", "db_mb": 2909.5, "messages": 6127615, "k6_exit": 0, "saturated": false, "requests": 107628, "rps": 3587.6, "ok_rps": 3587.6, "failed_ratio": 0, "dropped_iterations": 373, "p50_ms": 3.75, "p95_ms": 101.01, "p99_ms": 156.31, "p95_post_ms": 94.76, "p95_get_ms": 123.67, "cpu_api": 592.11, "cpu_postgres": 149.97, "cpu_lb": 35.49, "cpu_valkey": 8.53, "cpu_k6": 62.06, "mem_api_mb": 171.7, "mem_postgres_mb": 540.8, "mem_k6_mb": 312.3, "pg_backends_max": 65, "pg_active_avg": 13.38, "pg_active_max": 50, "pg_idle_avg": 42.69, "pg_idle_tx_avg": 7.96, "pg_lock_avg": 10.23, "pg_lock_max": 46, "pg_lwlock_avg": 1.23, "pg_io_avg": 0.5, "lb_scur_max": 369, "lb_qcur_max": 113, "lb_qtime_max_ms": 40, "lb_rtime_avg_ms": 16.14, "cpu_vm": 879.3, "cpu_other": 31.1, "gap_s": 4.1, "wall_s": 41.8, "disturbed": false}
{"raw_dir": "after-8x1_rate5400_rep3_attempt1", "variant": "after", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 3, "started": "2026-11-05T21:16:24Z", "db_mb": 2964.4, "messages": 6244547, "k6_exit": 0, "saturated": true, "requests": 119113, "rps": 3970.43, "ok_rps": 3970.43, "failed_ratio": 0, "dropped_iterations": 42885, "p50_ms": 241.94, "p95_ms": 310.83, "p99_ms": 427.63, "p95_post_ms": 303.77, "p95_get_ms": 325.73, "cpu_api": 616.64, "cpu_postgres": 177.3, "cpu_lb": 38.53, "cpu_valkey": 9.15, "cpu_k6": 58.57, "mem_api_mb": 179.1, "mem_postgres_mb": 559.8, "mem_k6_mb": 653.1, "pg_backends_max": 64, "pg_active_avg": 45.15, "pg_active_max": 64, "pg_idle_avg": 7.31, "pg_idle_tx_avg": 11.54, "pg_lock_avg": 40.04, "pg_lock_max": 54, "pg_lwlock_avg": 3.19, "pg_io_avg": 0.5, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 369, "lb_rtime_avg_ms": 65.55, "cpu_vm": 971.2, "cpu_other": 71.0, "gap_s": 4.4, "wall_s": 42.1, "disturbed": false}
python3 scripts/scaling.py --env API_IMAGE=mtusi-messenger:5c8f605cd3bd40245109348463d3e7111379b2d3 --out evidence/track1-sqlalchemy/control-pool --configs 8x1 --api-memory 512 --rates 5400 \
		--variant pool4:DB_POOL_MAX_SIZE=4 --variant pool8 --variant pool16:DB_POOL_MAX_SIZE=16 \
		--variant maxconn16:API_SERVER_MAXCONN=16 --variant maxconn64:API_SERVER_MAXCONN=64
{"raw_dir": "pool4-8x1_rate5400_rep1_attempt1", "variant": "pool4", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 4, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 1, "started": "2026-11-05T21:17:32Z", "db_mb": 3025.2, "messages": 6373034, "k6_exit": 0, "saturated": true, "requests": 112428, "rps": 3747.6, "ok_rps": 3747.6, "failed_ratio": 0, "dropped_iterations": 49571, "p50_ms": 249.38, "p95_ms": 354.25, "p99_ms": 416.91, "p95_post_ms": 334.28, "p95_get_ms": 399.13, "cpu_api": 785.18, "cpu_postgres": 148.5, "cpu_lb": 39.41, "cpu_valkey": 9.98, "cpu_k6": 66.63, "mem_api_mb": 175.2, "mem_postgres_mb": 220.4, "mem_k6_mb": 649.3, "pg_backends_max": 32, "pg_active_avg": 8.69, "pg_active_max": 30, "pg_idle_avg": 9.42, "pg_idle_tx_avg": 13.88, "pg_lock_avg": 5.85, "pg_lock_max": 20, "pg_lwlock_avg": 1.31, "pg_io_avg": 0.42, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 282, "lb_rtime_avg_ms": 69.59, "cpu_vm": 1112.1, "cpu_other": 62.4, "gap_s": 4.2, "wall_s": 42.1, "disturbed": false}
{"raw_dir": "pool8-8x1_rate5400_rep1_attempt1", "variant": "pool8", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 1, "started": "2026-11-05T21:18:31Z", "db_mb": 3081.2, "messages": 6463303, "k6_exit": 0, "saturated": true, "requests": 113028, "rps": 3767.6, "ok_rps": 3767.6, "failed_ratio": 0, "dropped_iterations": 48973, "p50_ms": 252.05, "p95_ms": 347.57, "p99_ms": 416.0, "p95_post_ms": 335.51, "p95_get_ms": 381.72, "cpu_api": 791.78, "cpu_postgres": 166.35, "cpu_lb": 38.2, "cpu_valkey": 10.57, "cpu_k6": 74.23, "mem_api_mb": 175.1, "mem_postgres_mb": 414.1, "mem_k6_mb": 648.5, "pg_backends_max": 64, "pg_active_avg": 32.38, "pg_active_max": 46, "pg_idle_avg": 13.92, "pg_idle_tx_avg": 17.69, "pg_lock_avg": 27.96, "pg_lock_max": 46, "pg_lwlock_avg": 2.54, "pg_io_avg": 0.42, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 271, "lb_rtime_avg_ms": 68.1, "cpu_vm": 1127.4, "cpu_other": 46.3, "gap_s": 4.2, "wall_s": 42.2, "disturbed": false}
{"raw_dir": "pool16-8x1_rate5400_rep1_attempt1", "variant": "pool16", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 16, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 1, "started": "2026-11-05T21:19:28Z", "db_mb": 3132.2, "messages": 6583859, "k6_exit": 0, "saturated": true, "requests": 98010, "rps": 3267.0, "ok_rps": 3266.63, "failed_ratio": 0.00011, "dropped_iterations": 63986, "p50_ms": 279.68, "p95_ms": 423.43, "p99_ms": 815.01, "p95_post_ms": 454.13, "p95_get_ms": 375.74, "cpu_api": 708.07, "cpu_postgres": 173.09, "cpu_lb": 33.03, "cpu_valkey": 8.32, "cpu_k6": 61.6, "mem_api_mb": 175.6, "mem_postgres_mb": 722.6, "mem_k6_mb": 649.6, "pg_backends_max": 128, "pg_active_avg": 101.77, "pg_active_max": 112, "pg_idle_avg": 9.54, "pg_idle_tx_avg": 16.69, "pg_lock_avg": 83.19, "pg_lock_max": 110, "pg_lwlock_avg": 15.38, "pg_io_avg": 0.23, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 275, "lb_rtime_avg_ms": 78.61, "cpu_vm": 1045.7, "cpu_other": 61.6, "gap_s": 4.7, "wall_s": 42.4, "disturbed": false}
{"raw_dir": "maxconn16-8x1_rate5400_rep1_attempt1", "variant": "maxconn16", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 16, "api_cpuset": "7-14", "rate": 5400, "repeat": 1, "started": "2026-11-05T21:20:27Z", "db_mb": 3186.2, "messages": 6688438, "k6_exit": 0, "saturated": true, "requests": 115190, "rps": 3839.67, "ok_rps": 3839.67, "failed_ratio": 0, "dropped_iterations": 46808, "p50_ms": 249.95, "p95_ms": 329.99, "p99_ms": 394.9, "p95_post_ms": 329.25, "p95_get_ms": 333.94, "cpu_api": 785.76, "cpu_postgres": 168.06, "cpu_lb": 38.72, "cpu_valkey": 10.16, "cpu_k6": 60.84, "mem_api_mb": 171.3, "mem_postgres_mb": 528.4, "mem_k6_mb": 643.6, "pg_backends_max": 64, "pg_active_avg": 35.77, "pg_active_max": 46, "pg_idle_avg": 11.19, "pg_idle_tx_avg": 17.04, "pg_lock_avg": 30.62, "pg_lock_max": 41, "pg_lwlock_avg": 2.73, "pg_io_avg": 0.46, "lb_scur_max": 1000, "lb_qcur_max": 872, "lb_qtime_max_ms": 298, "lb_rtime_avg_ms": 32.52, "cpu_vm": 1132.5, "cpu_other": 69.0, "gap_s": 4.0, "wall_s": 42.1, "disturbed": false}
{"raw_dir": "maxconn64-8x1_rate5400_rep1_attempt1", "variant": "maxconn64", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 64, "api_cpuset": "7-14", "rate": 5400, "repeat": 1, "started": "2026-11-05T21:21:23Z", "db_mb": 3242.4, "messages": 6841785, "k6_exit": 0, "saturated": true, "requests": 109720, "rps": 3657.33, "ok_rps": 3657.33, "failed_ratio": 0, "dropped_iterations": 52281, "p50_ms": 247.31, "p95_ms": 405.58, "p99_ms": 496.18, "p95_post_ms": 358.99, "p95_get_ms": 482.23, "cpu_api": 783.49, "cpu_postgres": 166.34, "cpu_lb": 37.41, "cpu_valkey": 10.31, "cpu_k6": 70.2, "mem_api_mb": 183.7, "mem_postgres_mb": 563.3, "mem_k6_mb": 645.2, "pg_backends_max": 64, "pg_active_avg": 33.85, "pg_active_max": 44, "pg_idle_avg": 12.54, "pg_idle_tx_avg": 17.62, "pg_lock_avg": 28.12, "pg_lock_max": 36, "pg_lwlock_avg": 2.88, "pg_io_avg": 0.46, "lb_scur_max": 1000, "lb_qcur_max": 488, "lb_qtime_max_ms": 184, "lb_rtime_avg_ms": 140.55, "cpu_vm": 1120.1, "cpu_other": 52.3, "gap_s": 4.0, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "pool4-8x1_rate5400_rep2_attempt1", "variant": "pool4", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 4, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 2, "started": "2026-11-05T21:22:22Z", "db_mb": 3299.2, "messages": 6959316, "k6_exit": 0, "saturated": true, "requests": 112874, "rps": 3762.47, "ok_rps": 3762.47, "failed_ratio": 0, "dropped_iterations": 49126, "p50_ms": 248.68, "p95_ms": 351.94, "p99_ms": 420.62, "p95_post_ms": 329.97, "p95_get_ms": 398.4, "cpu_api": 796.54, "cpu_postgres": 149.56, "cpu_lb": 38.55, "cpu_valkey": 10.16, "cpu_k6": 73.74, "mem_api_mb": 174.9, "mem_postgres_mb": 426.8, "mem_k6_mb": 636.5, "pg_backends_max": 32, "pg_active_avg": 7.15, "pg_active_max": 13, "pg_idle_avg": 11.81, "pg_idle_tx_avg": 13.04, "pg_lock_avg": 3.96, "pg_lock_max": 10, "pg_lwlock_avg": 1.42, "pg_io_avg": 0.77, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 280, "lb_rtime_avg_ms": 67.28, "cpu_vm": 1115.8, "cpu_other": 47.2, "gap_s": 4.5, "wall_s": 42.2, "disturbed": false}
{"raw_dir": "pool8-8x1_rate5400_rep2_attempt1", "variant": "pool8", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 2, "started": "2026-11-05T21:23:21Z", "db_mb": 3356.0, "messages": 7079953, "k6_exit": 0, "saturated": true, "requests": 112968, "rps": 3765.6, "ok_rps": 3765.6, "failed_ratio": 0, "dropped_iterations": 49033, "p50_ms": 252.12, "p95_ms": 348.45, "p99_ms": 432.14, "p95_post_ms": 333.56, "p95_get_ms": 384.39, "cpu_api": 794.24, "cpu_postgres": 166.95, "cpu_lb": 38.54, "cpu_valkey": 10.43, "cpu_k6": 67.77, "mem_api_mb": 176.0, "mem_postgres_mb": 582.2, "mem_k6_mb": 647.5, "pg_backends_max": 64, "pg_active_avg": 31.68, "pg_active_max": 47, "pg_idle_avg": 13.04, "pg_idle_tx_avg": 19.28, "pg_lock_avg": 27.04, "pg_lock_max": 38, "pg_lwlock_avg": 2.28, "pg_io_avg": 0.48, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 278, "lb_rtime_avg_ms": 67.21, "cpu_vm": 1132.0, "cpu_other": 54.1, "gap_s": 4.4, "wall_s": 42.3, "disturbed": false}
{"raw_dir": "pool16-8x1_rate5400_rep2_attempt1", "variant": "pool16", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 16, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 2, "started": "2026-11-05T21:24:19Z", "db_mb": 3413.1, "messages": 7200208, "k6_exit": 0, "saturated": true, "requests": 97557, "rps": 3251.9, "ok_rps": 3251.6, "failed_ratio": 9e-05, "dropped_iterations": 64444, "p50_ms": 280.58, "p95_ms": 429.03, "p99_ms": 828.34, "p95_post_ms": 459.76, "p95_get_ms": 379.9, "cpu_api": 697.96, "cpu_postgres": 176.3, "cpu_lb": 33.0, "cpu_valkey": 8.53, "cpu_k6": 63.69, "mem_api_mb": 175.0, "mem_postgres_mb": 840.6, "mem_k6_mb": 651.4, "pg_backends_max": 128, "pg_active_avg": 100.65, "pg_active_max": 112, "pg_idle_avg": 10.58, "pg_idle_tx_avg": 16.77, "pg_lock_avg": 80.62, "pg_lock_max": 102, "pg_lwlock_avg": 17.85, "pg_io_avg": 0.5, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 289, "lb_rtime_avg_ms": 79.34, "cpu_vm": 1043.0, "cpu_other": 63.5, "gap_s": 4.0, "wall_s": 42.2, "disturbed": false}
{"raw_dir": "maxconn16-8x1_rate5400_rep2_attempt1", "variant": "maxconn16", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 16, "api_cpuset": "7-14", "rate": 5400, "repeat": 2, "started": "2026-11-05T21:25:18Z", "db_mb": 3466.1, "messages": 7303747, "k6_exit": 0, "saturated": true, "requests": 116524, "rps": 3884.13, "ok_rps": 3884.13, "failed_ratio": 0, "dropped_iterations": 45477, "p50_ms": 248.15, "p95_ms": 319.33, "p99_ms": 402.84, "p95_post_ms": 318.51, "p95_get_ms": 321.7, "cpu_api": 787.91, "cpu_postgres": 171.58, "cpu_lb": 39.32, "cpu_valkey": 10.73, "cpu_k6": 72.5, "mem_api_mb": 170.0, "mem_postgres_mb": 594.3, "mem_k6_mb": 641.1, "pg_backends_max": 64, "pg_active_avg": 33.15, "pg_active_max": 46, "pg_idle_avg": 12.74, "pg_idle_tx_avg": 18.11, "pg_lock_avg": 28.19, "pg_lock_max": 40, "pg_lwlock_avg": 2.78, "pg_io_avg": 0.59, "lb_scur_max": 1000, "lb_qcur_max": 872, "lb_qtime_max_ms": 292, "lb_rtime_avg_ms": 32.83, "cpu_vm": 1141.2, "cpu_other": 59.2, "gap_s": 4.7, "wall_s": 42.1, "disturbed": false}
{"raw_dir": "maxconn64-8x1_rate5400_rep2_attempt1", "variant": "maxconn64", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 64, "api_cpuset": "7-14", "rate": 5400, "repeat": 2, "started": "2026-11-05T21:26:14Z", "db_mb": 3524.7, "messages": 7427799, "k6_exit": 0, "saturated": true, "requests": 110131, "rps": 3671.03, "ok_rps": 3671.03, "failed_ratio": 0, "dropped_iterations": 51870, "p50_ms": 245.86, "p95_ms": 405.26, "p99_ms": 493.23, "p95_post_ms": 359.02, "p95_get_ms": 478.49, "cpu_api": 792.49, "cpu_postgres": 166.46, "cpu_lb": 39.49, "cpu_valkey": 10.3, "cpu_k6": 70.5, "mem_api_mb": 188.9, "mem_postgres_mb": 596.7, "mem_k6_mb": 655.3, "pg_backends_max": 64, "pg_active_avg": 30.41, "pg_active_max": 43, "pg_idle_avg": 14.59, "pg_idle_tx_avg": 19, "pg_lock_avg": 25.85, "pg_lock_max": 42, "pg_lwlock_avg": 3, "pg_io_avg": 0.44, "lb_scur_max": 1000, "lb_qcur_max": 488, "lb_qtime_max_ms": 177, "lb_rtime_avg_ms": 138.93, "cpu_vm": 1125.4, "cpu_other": 46.2, "gap_s": 4.5, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "pool4-8x1_rate5400_rep3_attempt1", "variant": "pool4", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 4, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 3, "started": "2026-11-05T21:27:13Z", "db_mb": 3581.2, "messages": 7543873, "k6_exit": 0, "saturated": true, "requests": 112668, "rps": 3755.6, "ok_rps": 3755.6, "failed_ratio": 0, "dropped_iterations": 49335, "p50_ms": 250.04, "p95_ms": 348.29, "p99_ms": 419.84, "p95_post_ms": 326.22, "p95_get_ms": 388.53, "cpu_api": 796.62, "cpu_postgres": 145.48, "cpu_lb": 39.08, "cpu_valkey": 10.03, "cpu_k6": 73.81, "mem_api_mb": 174.9, "mem_postgres_mb": 465.8, "mem_k6_mb": 660.1, "pg_backends_max": 32, "pg_active_avg": 8.35, "pg_active_max": 16, "pg_idle_avg": 10.27, "pg_idle_tx_avg": 13.38, "pg_lock_avg": 5.12, "pg_lock_max": 13, "pg_lwlock_avg": 1.35, "pg_io_avg": 0.69, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 293, "lb_rtime_avg_ms": 67.38, "cpu_vm": 1117.1, "cpu_other": 52.1, "gap_s": 4.2, "wall_s": 42.1, "disturbed": false}
{"raw_dir": "pool8-8x1_rate5400_rep3_attempt1", "variant": "pool8", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 3, "started": "2026-11-05T21:28:11Z", "db_mb": 3637.9, "messages": 7664271, "k6_exit": 0, "saturated": true, "requests": 113367, "rps": 3778.9, "ok_rps": 3778.9, "failed_ratio": 0, "dropped_iterations": 48633, "p50_ms": 251.65, "p95_ms": 348.72, "p99_ms": 422.87, "p95_post_ms": 338.19, "p95_get_ms": 379.66, "cpu_api": 794.75, "cpu_postgres": 170.12, "cpu_lb": 39.29, "cpu_valkey": 10.25, "cpu_k6": 79.0, "mem_api_mb": 174.0, "mem_postgres_mb": 616.5, "mem_k6_mb": 647.2, "pg_backends_max": 64, "pg_active_avg": 33.65, "pg_active_max": 52, "pg_idle_avg": 12.88, "pg_idle_tx_avg": 17.46, "pg_lock_avg": 29.04, "pg_lock_max": 50, "pg_lwlock_avg": 2.92, "pg_io_avg": 0.58, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 276, "lb_rtime_avg_ms": 69.03, "cpu_vm": 1131.2, "cpu_other": 37.8, "gap_s": 4.5, "wall_s": 42.2, "disturbed": false}
{"raw_dir": "pool16-8x1_rate5400_rep3_attempt1", "variant": "pool16", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 16, "maxconn": 32, "api_cpuset": "7-14", "rate": 5400, "repeat": 3, "started": "2026-11-05T21:29:09Z", "db_mb": 3694.5, "messages": 7783534, "k6_exit": 0, "saturated": true, "requests": 93726, "rps": 3124.2, "ok_rps": 3123.7, "failed_ratio": 0.00016, "dropped_iterations": 68279, "p50_ms": 290.05, "p95_ms": 439.26, "p99_ms": 938.42, "p95_post_ms": 482.63, "p95_get_ms": 389.61, "cpu_api": 681.13, "cpu_postgres": 180.49, "cpu_lb": 31.91, "cpu_valkey": 7.86, "cpu_k6": 66.48, "mem_api_mb": 175.5, "mem_postgres_mb": 869.9, "mem_k6_mb": 648.0, "pg_backends_max": 128, "pg_active_avg": 107.54, "pg_active_max": 118, "pg_idle_avg": 7.46, "pg_idle_tx_avg": 12.96, "pg_lock_avg": 88.96, "pg_lock_max": 118, "pg_lwlock_avg": 16.23, "pg_io_avg": 0.54, "lb_scur_max": 1003, "lb_qcur_max": 747, "lb_qtime_max_ms": 302, "lb_rtime_avg_ms": 84, "cpu_vm": 1017.3, "cpu_other": 49.4, "gap_s": 4.0, "wall_s": 42.2, "disturbed": false}
{"raw_dir": "maxconn16-8x1_rate5400_rep3_attempt1", "variant": "maxconn16", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 16, "api_cpuset": "7-14", "rate": 5400, "repeat": 3, "started": "2026-11-05T21:30:08Z", "db_mb": 3744.2, "messages": 7883772, "k6_exit": 0, "saturated": true, "requests": 109733, "rps": 3657.77, "ok_rps": 3657.77, "failed_ratio": 0, "dropped_iterations": 52268, "p50_ms": 260.02, "p95_ms": 365.15, "p99_ms": 443.56, "p95_post_ms": 363.93, "p95_get_ms": 370.46, "cpu_api": 768.85, "cpu_postgres": 168.45, "cpu_lb": 39.58, "cpu_valkey": 10.52, "cpu_k6": 69.09, "mem_api_mb": 169.8, "mem_postgres_mb": 600.7, "mem_k6_mb": 642.2, "pg_backends_max": 64, "pg_active_avg": 35.81, "pg_active_max": 50, "pg_idle_avg": 11.42, "pg_idle_tx_avg": 16.77, "pg_lock_avg": 30.65, "pg_lock_max": 41, "pg_lwlock_avg": 3, "pg_io_avg": 0.62, "lb_scur_max": 1000, "lb_qcur_max": 872, "lb_qtime_max_ms": 332, "lb_rtime_avg_ms": 34.83, "cpu_vm": 1121.6, "cpu_other": 65.1, "gap_s": 4.0, "wall_s": 42.1, "disturbed": false}
{"raw_dir": "maxconn64-8x1_rate5400_rep3_attempt1", "variant": "maxconn64", "config": "8x1", "replicas": 8, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 64, "api_cpuset": "7-14", "rate": 5400, "repeat": 3, "started": "2026-11-05T21:31:04Z", "db_mb": 3799.5, "messages": 8000880, "k6_exit": 0, "saturated": true, "requests": 104536, "rps": 3484.53, "ok_rps": 3484.53, "failed_ratio": 0, "dropped_iterations": 57465, "p50_ms": 259.6, "p95_ms": 424.99, "p99_ms": 520.11, "p95_post_ms": 379.74, "p95_get_ms": 507.05, "cpu_api": 786.8, "cpu_postgres": 166.45, "cpu_lb": 37.2, "cpu_valkey": 10.31, "cpu_k6": 68.9, "mem_api_mb": 189.5, "mem_postgres_mb": 588.6, "mem_k6_mb": 651.0, "pg_backends_max": 64, "pg_active_avg": 34.85, "pg_active_max": 53, "pg_idle_avg": 10.54, "pg_idle_tx_avg": 18.62, "pg_lock_avg": 30.81, "pg_lock_max": 52, "pg_lwlock_avg": 2, "pg_io_avg": 0.5, "lb_scur_max": 1000, "lb_qcur_max": 488, "lb_qtime_max_ms": 179, "lb_rtime_avg_ms": 146.41, "cpu_vm": 1103.0, "cpu_other": 33.3, "gap_s": 4.0, "wall_s": 42.0, "disturbed": false}
python3 scripts/scaling.py --env API_IMAGE=mtusi-messenger:5c8f605cd3bd40245109348463d3e7111379b2d3 --out evidence/track1-sqlalchemy/control-cpus --configs 4x1,8x0.5 --api-memory-total 2048 --rates 3040,4560 \
		--variant pinned
{"raw_dir": "pinned-4x1_rate3040_rep1_attempt1", "variant": "pinned", "config": "4x1", "replicas": 4, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 3040, "repeat": 1, "started": "2026-11-05T21:32:12Z", "db_mb": 3849.5, "messages": 8113337, "k6_exit": 0, "saturated": true, "requests": 70414, "rps": 2347.13, "ok_rps": 2347.13, "failed_ratio": 0, "dropped_iterations": 20789, "p50_ms": 408.58, "p95_ms": 536.63, "p99_ms": 587.46, "p95_post_ms": 529.43, "p95_get_ms": 566.31, "cpu_api": 408.11, "cpu_postgres": 82.21, "cpu_lb": 21.05, "cpu_valkey": 4.85, "cpu_k6": 34.67, "mem_api_mb": 175.1, "mem_postgres_mb": 195.3, "mem_k6_mb": 638.9, "pg_backends_max": 32, "pg_active_avg": 3.15, "pg_active_max": 10, "pg_idle_avg": 10.88, "pg_idle_tx_avg": 17.96, "pg_lock_avg": 1.81, "pg_lock_max": 8, "pg_lwlock_avg": 0.35, "pg_io_avg": 0.31, "lb_scur_max": 1000, "lb_qcur_max": 872, "lb_qtime_max_ms": 463, "lb_rtime_avg_ms": 54.63, "cpu_vm": 585.4, "cpu_other": 34.5, "gap_s": 4.5, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "pinned-4x1_rate3040_rep2_attempt1", "variant": "pinned", "config": "4x1", "replicas": 4, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 3040, "repeat": 2, "started": "2026-11-05T21:32:59Z", "db_mb": 3884.9, "messages": 8148358, "k6_exit": 0, "saturated": true, "requests": 69907, "rps": 2330.23, "ok_rps": 2330.23, "failed_ratio": 0, "dropped_iterations": 21293, "p50_ms": 411.63, "p95_ms": 546.94, "p99_ms": 592.32, "p95_post_ms": 540.71, "p95_get_ms": 571.23, "cpu_api": 408.3, "cpu_postgres": 83.35, "cpu_lb": 21.46, "cpu_valkey": 4.66, "cpu_k6": 36.14, "mem_api_mb": 173.4, "mem_postgres_mb": 236.0, "mem_k6_mb": 640.6, "pg_backends_max": 32, "pg_active_avg": 1.89, "pg_active_max": 11, "pg_idle_avg": 11.7, "pg_idle_tx_avg": 18.41, "pg_lock_avg": 0.93, "pg_lock_max": 3, "pg_lwlock_avg": 0.22, "pg_io_avg": 0.15, "lb_scur_max": 1000, "lb_qcur_max": 872, "lb_qtime_max_ms": 468, "lb_rtime_avg_ms": 54.9, "cpu_vm": 582.1, "cpu_other": 28.2, "gap_s": 4.9, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "pinned-4x1_rate3040_rep3_attempt1", "variant": "pinned", "config": "4x1", "replicas": 4, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 3040, "repeat": 3, "started": "2026-11-05T21:33:47Z", "db_mb": 3916.5, "messages": 8223600, "k6_exit": 0, "saturated": true, "requests": 69920, "rps": 2330.67, "ok_rps": 2330.67, "failed_ratio": 0, "dropped_iterations": 21281, "p50_ms": 413.72, "p95_ms": 521.01, "p99_ms": 586.31, "p95_post_ms": 509.54, "p95_get_ms": 552.39, "cpu_api": 403.98, "cpu_postgres": 82.55, "cpu_lb": 20.84, "cpu_valkey": 4.71, "cpu_k6": 35.24, "mem_api_mb": 173.1, "mem_postgres_mb": 276.0, "mem_k6_mb": 637.7, "pg_backends_max": 32, "pg_active_avg": 1.89, "pg_active_max": 5, "pg_idle_avg": 12.56, "pg_idle_tx_avg": 17.56, "pg_lock_avg": 1.22, "pg_lock_max": 3, "pg_lwlock_avg": 0.15, "pg_io_avg": 0.33, "lb_scur_max": 1000, "lb_qcur_max": 872, "lb_qtime_max_ms": 472, "lb_rtime_avg_ms": 55.03, "cpu_vm": 579.1, "cpu_other": 31.8, "gap_s": 4.3, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "pinned-4x1_rate4560_rep1_attempt1", "variant": "pinned", "config": "4x1", "replicas": 4, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 4560, "repeat": 1, "started": "2026-11-05T21:34:34Z", "db_mb": 3952.2, "messages": 8299140, "k6_exit": 0, "saturated": true, "requests": 68573, "rps": 2285.77, "ok_rps": 2285.77, "failed_ratio": 0, "dropped_iterations": 68226, "p50_ms": 426.17, "p95_ms": 524.15, "p99_ms": 567.64, "p95_post_ms": 515.68, "p95_get_ms": 552.31, "cpu_api": 405.83, "cpu_postgres": 85.14, "cpu_lb": 20.27, "cpu_valkey": 4.76, "cpu_k6": 36.73, "mem_api_mb": 173.9, "mem_postgres_mb": 317.0, "mem_k6_mb": 635.3, "pg_backends_max": 32, "pg_active_avg": 2.56, "pg_active_max": 6, "pg_idle_avg": 11.37, "pg_idle_tx_avg": 18.07, "pg_lock_avg": 1.04, "pg_lock_max": 4, "pg_lwlock_avg": 0.26, "pg_io_avg": 0.41, "lb_scur_max": 1000, "lb_qcur_max": 872, "lb_qtime_max_ms": 444, "lb_rtime_avg_ms": 56.66, "cpu_vm": 584.7, "cpu_other": 32.0, "gap_s": 4.8, "wall_s": 41.9, "disturbed": false}
{"raw_dir": "pinned-4x1_rate4560_rep2_attempt1", "variant": "pinned", "config": "4x1", "replicas": 4, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 4560, "repeat": 2, "started": "2026-11-05T21:35:22Z", "db_mb": 3987.4, "messages": 8373308, "k6_exit": 0, "saturated": true, "requests": 67954, "rps": 2265.13, "ok_rps": 2265.13, "failed_ratio": 0, "dropped_iterations": 68845, "p50_ms": 429.25, "p95_ms": 529.38, "p99_ms": 589.37, "p95_post_ms": 520.7, "p95_get_ms": 564.14, "cpu_api": 406.67, "cpu_postgres": 84.48, "cpu_lb": 20.61, "cpu_valkey": 4.57, "cpu_k6": 39.43, "mem_api_mb": 175.4, "mem_postgres_mb": 358.7, "mem_k6_mb": 644.9, "pg_backends_max": 32, "pg_active_avg": 2.33, "pg_active_max": 9, "pg_idle_avg": 13.22, "pg_idle_tx_avg": 16.44, "pg_lock_avg": 1.44, "pg_lock_max": 6, "pg_lwlock_avg": 0.15, "pg_io_avg": 0.22, "lb_scur_max": 1000, "lb_qcur_max": 872, "lb_qtime_max_ms": 442, "lb_rtime_avg_ms": 56.14, "cpu_vm": 584.2, "cpu_other": 28.4, "gap_s": 4.1, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "pinned-4x1_rate4560_rep3_attempt1", "variant": "pinned", "config": "4x1", "replicas": 4, "cpus": 1.0, "memory_mb": 512, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 4560, "repeat": 3, "started": "2026-11-05T21:36:09Z", "db_mb": 4022.0, "messages": 8485464, "k6_exit": 0, "saturated": true, "requests": 67318, "rps": 2243.93, "ok_rps": 2243.93, "failed_ratio": 0, "dropped_iterations": 69484, "p50_ms": 432.21, "p95_ms": 537.02, "p99_ms": 604.17, "p95_post_ms": 527.91, "p95_get_ms": 567.85, "cpu_api": 403.5, "cpu_postgres": 80.65, "cpu_lb": 20.14, "cpu_valkey": 4.65, "cpu_k6": 34.06, "mem_api_mb": 175.6, "mem_postgres_mb": 387.2, "mem_k6_mb": 636.7, "pg_backends_max": 32, "pg_active_avg": 2.73, "pg_active_max": 9, "pg_idle_avg": 10.85, "pg_idle_tx_avg": 18.42, "pg_lock_avg": 1.12, "pg_lock_max": 3, "pg_lwlock_avg": 0.31, "pg_io_avg": 0.38, "lb_scur_max": 1000, "lb_qcur_max": 872, "lb_qtime_max_ms": 482, "lb_rtime_avg_ms": 56.76, "cpu_vm": 575.6, "cpu_other": 32.6, "gap_s": 4.6, "wall_s": 42.1, "disturbed": false}
{"raw_dir": "pinned-8x0.5_rate3040_rep1_attempt1", "variant": "pinned", "config": "8x0.5", "replicas": 8, "cpus": 0.5, "memory_mb": 256, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 3040, "repeat": 1, "started": "2026-11-05T21:37:09Z", "db_mb": 4056.5, "messages": 8558356, "k6_exit": 0, "saturated": true, "requests": 56527, "rps": 1884.23, "ok_rps": 1884.23, "failed_ratio": 0, "dropped_iterations": 34674, "p50_ms": 496.43, "p95_ms": 742.23, "p99_ms": 850.53, "p95_post_ms": 724.98, "p95_get_ms": 804.12, "cpu_api": 398.45, "cpu_postgres": 83.54, "cpu_lb": 19.14, "cpu_valkey": 4.42, "cpu_k6": 41.16, "mem_api_mb": 172.9, "mem_postgres_mb": 538.3, "mem_k6_mb": 637.6, "pg_backends_max": 64, "pg_active_avg": 27.35, "pg_active_max": 46, "pg_idle_avg": 15.04, "pg_idle_tx_avg": 21.62, "pg_lock_avg": 26.12, "pg_lock_max": 42, "pg_lwlock_avg": 0.19, "pg_io_avg": 0.35, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 581, "lb_rtime_avg_ms": 135.93, "cpu_vm": 572.3, "cpu_other": 25.6, "gap_s": 5.0, "wall_s": 42.7, "disturbed": false}
{"raw_dir": "pinned-8x0.5_rate3040_rep2_attempt1", "variant": "pinned", "config": "8x0.5", "replicas": 8, "cpus": 0.5, "memory_mb": 256, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 3040, "repeat": 2, "started": "2026-11-05T21:37:56Z", "db_mb": 4085.9, "messages": 8619943, "k6_exit": 0, "saturated": true, "requests": 59625, "rps": 1987.5, "ok_rps": 1987.5, "failed_ratio": 0, "dropped_iterations": 31575, "p50_ms": 468.15, "p95_ms": 724.23, "p99_ms": 846.8, "p95_post_ms": 709.97, "p95_get_ms": 785.68, "cpu_api": 399.71, "cpu_postgres": 86.78, "cpu_lb": 19.68, "cpu_valkey": 4.27, "cpu_k6": 30.25, "mem_api_mb": 164.0, "mem_postgres_mb": 538.4, "mem_k6_mb": 635.6, "pg_backends_max": 64, "pg_active_avg": 27.89, "pg_active_max": 46, "pg_idle_avg": 15.41, "pg_idle_tx_avg": 20.7, "pg_lock_avg": 26.41, "pg_lock_max": 46, "pg_lwlock_avg": 0.63, "pg_io_avg": 0.19, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 541, "lb_rtime_avg_ms": 129.93, "cpu_vm": 573.9, "cpu_other": 33.2, "gap_s": 4.7, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "pinned-8x0.5_rate3040_rep3_attempt1", "variant": "pinned", "config": "8x0.5", "replicas": 8, "cpus": 0.5, "memory_mb": 256, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 3040, "repeat": 3, "started": "2026-11-05T21:38:44Z", "db_mb": 4116.5, "messages": 8684280, "k6_exit": 0, "saturated": true, "requests": 59439, "rps": 1981.3, "ok_rps": 1981.3, "failed_ratio": 0, "dropped_iterations": 31762, "p50_ms": 473.29, "p95_ms": 712.81, "p99_ms": 816.1, "p95_post_ms": 699.94, "p95_get_ms": 773.63, "cpu_api": 398.38, "cpu_postgres": 85.18, "cpu_lb": 18.12, "cpu_valkey": 4.27, "cpu_k6": 41.17, "mem_api_mb": 163.0, "mem_postgres_mb": 545.8, "mem_k6_mb": 631.8, "pg_backends_max": 64, "pg_active_avg": 30.58, "pg_active_max": 56, "pg_idle_avg": 13.23, "pg_idle_tx_avg": 20.19, "pg_lock_avg": 28.77, "pg_lock_max": 56, "pg_lwlock_avg": 0.31, "pg_io_avg": 0.38, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 523, "lb_rtime_avg_ms": 129.48, "cpu_vm": 573.7, "cpu_other": 26.6, "gap_s": 4.2, "wall_s": 42.0, "disturbed": false}
{"raw_dir": "pinned-8x0.5_rate4560_rep1_attempt1", "variant": "pinned", "config": "8x0.5", "replicas": 8, "cpus": 0.5, "memory_mb": 256, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 4560, "repeat": 1, "started": "2026-11-05T21:39:31Z", "db_mb": 4147.1, "messages": 8748157, "k6_exit": 0, "saturated": true, "requests": 59406, "rps": 1980.2, "ok_rps": 1980.2, "failed_ratio": 0, "dropped_iterations": 77399, "p50_ms": 474.97, "p95_ms": 727.99, "p99_ms": 834.16, "p95_post_ms": 712.9, "p95_get_ms": 790.32, "cpu_api": 396.77, "cpu_postgres": 81.26, "cpu_lb": 18.46, "cpu_valkey": 4.1, "cpu_k6": 34.72, "mem_api_mb": 175.6, "mem_postgres_mb": 548.5, "mem_k6_mb": 629.5, "pg_backends_max": 65, "pg_active_avg": 27.85, "pg_active_max": 47, "pg_idle_avg": 13, "pg_idle_tx_avg": 22.96, "pg_lock_avg": 26.3, "pg_lock_max": 47, "pg_lwlock_avg": 0.67, "pg_io_avg": 0.33, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 521, "lb_rtime_avg_ms": 129.45, "cpu_vm": 582.7, "cpu_other": 47.4, "gap_s": 4.6, "wall_s": 42.3, "disturbed": false}
{"raw_dir": "pinned-8x0.5_rate4560_rep2_attempt1", "variant": "pinned", "config": "8x0.5", "replicas": 8, "cpus": 0.5, "memory_mb": 256, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 4560, "repeat": 2, "started": "2026-11-05T21:40:19Z", "db_mb": 4177.6, "messages": 8812043, "k6_exit": 0, "saturated": true, "requests": 58784, "rps": 1959.47, "ok_rps": 1959.47, "failed_ratio": 0, "dropped_iterations": 78017, "p50_ms": 480.65, "p95_ms": 726.89, "p99_ms": 835.31, "p95_post_ms": 714.69, "p95_get_ms": 788.06, "cpu_api": 399.1, "cpu_postgres": 84.92, "cpu_lb": 19.29, "cpu_valkey": 4.22, "cpu_k6": 42.08, "mem_api_mb": 174.1, "mem_postgres_mb": 550.2, "mem_k6_mb": 632.9, "pg_backends_max": 64, "pg_active_avg": 30.96, "pg_active_max": 49, "pg_idle_avg": 12.54, "pg_idle_tx_avg": 20.5, "pg_lock_avg": 28.58, "pg_lock_max": 47, "pg_lwlock_avg": 0.92, "pg_io_avg": 0.42, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 523, "lb_rtime_avg_ms": 133.03, "cpu_vm": 576.5, "cpu_other": 26.9, "gap_s": 4.4, "wall_s": 42.1, "disturbed": false}
{"raw_dir": "pinned-8x0.5_rate4560_rep3_attempt1", "variant": "pinned", "config": "8x0.5", "replicas": 8, "cpus": 0.5, "memory_mb": 256, "workers": 1, "pool": 8, "maxconn": 32, "api_cpuset": "7-10", "rate": 4560, "repeat": 3, "started": "2026-11-05T21:41:07Z", "db_mb": 4207.7, "messages": 8875161, "k6_exit": 0, "saturated": true, "requests": 57410, "rps": 1913.67, "ok_rps": 1913.67, "failed_ratio": 0, "dropped_iterations": 79391, "p50_ms": 490.46, "p95_ms": 739.47, "p99_ms": 849.06, "p95_post_ms": 723.97, "p95_get_ms": 802.27, "cpu_api": 401.42, "cpu_postgres": 85.64, "cpu_lb": 19.21, "cpu_valkey": 4.32, "cpu_k6": 30.29, "mem_api_mb": 173.8, "mem_postgres_mb": 542.9, "mem_k6_mb": 634.4, "pg_backends_max": 64, "pg_active_avg": 25.96, "pg_active_max": 50, "pg_idle_avg": 16.44, "pg_idle_tx_avg": 21.59, "pg_lock_avg": 24.7, "pg_lock_max": 50, "pg_lwlock_avg": 0.33, "pg_io_avg": 0.26, "lb_scur_max": 1000, "lb_qcur_max": 744, "lb_qtime_max_ms": 537, "lb_rtime_avg_ms": 135.45, "cpu_vm": 575.1, "cpu_other": 34.2, "gap_s": 4.2, "wall_s": 42.2, "disturbed": false}

exit: 0
