============================================================ Benchmark — PostgreSQL 18 • 1 000 000 rows Runs per query: 3 JIT: off Parallelism: off ============================================================ ── heap (db: bench_am table: events_heap) ───────────────────────── Q1 count(*) 39.995 ms Q2 SUM/AVG numeric+double 188.718 ms Q3 GROUP BY country (10) 230.867 ms Q4 GROUP BY event_type+p95 459.168 ms Q5 date range 1 month 22.232 ms Q6 JSONB @> GIN 128.999 ms Q7 JSONB key + GROUP BY 393.745 ms Q8 array @> GIN 68.479 ms Q9 LIKE text scan 158.020 ms Q10 heavy multi-agg 2081.005 ms ── colcompress (db: bench_am table: events_col) ───────────────────────── Q1 count(*) 5.877 ms Q2 SUM/AVG numeric+double 131.495 ms Q3 GROUP BY country (10) 159.572 ms Q4 GROUP BY event_type+p95 479.591 ms Q5 date range 1 month 24.837 ms Q6 JSONB @> GIN 207.500 ms Q7 JSONB key + GROUP BY 346.920 ms Q8 array @> GIN 140.953 ms Q9 LIKE text scan 128.217 ms Q10 heavy multi-agg 2050.967 ms ── rowcompress (db: bench_am table: events_row) ───────────────────────── Q1 count(*) 361.764 ms Q2 SUM/AVG numeric+double 406.719 ms Q3 GROUP BY country (10) 422.889 ms Q4 GROUP BY event_type+p95 720.518 ms Q5 date range 1 month 74.097 ms Q6 JSONB @> GIN 351.627 ms Q7 JSONB key + GROUP BY 591.446 ms Q8 array @> GIN 324.110 ms Q9 LIKE text scan 381.702 ms Q10 heavy multi-agg 2159.305 ms Results saved → /home/saulo/Projetos/storage_engine/dist/tests/bench/matrix_20260430/results_serial_pg18.csv Generate chart: python3 /home/saulo/Projetos/storage_engine/dist/tests/bench/chart.py /home/saulo/Projetos/storage_engine/dist/tests/bench/matrix_20260430/results_serial_pg18.csv