$ chlift migrate bench --runs 5 --out bench-raw.json query (demo dataset, median of runs) postgres clickhouse FINAL clickhouse daily active users, last 30 days 5388ms 266ms 107ms (20x / 50x) events per kind per week, 6 months 21950ms 1600ms 710ms (14x / 31x) top 10 accounts by events, last 7 days 5740ms 159ms 57ms (36x / 101x) p95 latency per endpoint, last 30 days 23994ms 147ms 78ms (163x / 308x) raw samples (every run, same invocation): bench-raw.json $ python3 bench_table.py bench-raw.json runs per query: 5, taken 2026-10-03T16:51:12Z query postgres ch FINAL ch speed-up FINAL / after cutover daily active users, last 30 days 5388ms 266ms 107ms 20x / 50x events per kind per week, 6 months 21950ms 1600ms 710ms 14x / 31x top 10 accounts by events, last 7 days 5740ms 159ms 57ms 36x / 101x p95 latency per endpoint, last 30 days 23994ms 147ms 78ms 163x / 308x