date_utc:        2026-09-27T01:08:40Z
host:            ip-172-31-7-176.us-east-2.compute.internal
instance_type:   r6id.metal
kernel:          6.18.48-109.150.amzn2023.x86_64
cpu_model:       Intel(R) Xeon(R) Platinum 8375C CPU @ 2.90GHz
cpus:            128
sockets/numa:    2 2 
mem_total_gib:   1007.7
hugepages:       HugePages_Total:=452730 HugePages_Free:=445145 Hugepagesize:=2048 
thp:             always madvise [never]
governor:        performance
numa_balancing:  0
overcommit:      0
storage:
  NAME           SIZE TYPE  MODEL                            MOUNTPOINT
  nvme4n1        200G disk  Amazon Elastic Block Store       
  ├─nvme4n1p1    200G part                                   /
  ├─nvme4n1p127    1M part                                   
  └─nvme4n1p128   10M part                                   /boot/efi
  nvme3n1        1.7T disk  Amazon EC2 NVMe Instance Storage 
  └─md0          6.9T raid0                                  /nvme
  nvme0n1        1.7T disk  Amazon EC2 NVMe Instance Storage 
  └─md0          6.9T raid0                                  /nvme
  nvme2n1        1.7T disk  Amazon EC2 NVMe Instance Storage 
  └─md0          6.9T raid0                                  /nvme
  nvme1n1        1.7T disk  Amazon EC2 NVMe Instance Storage 
  └─md0          6.9T raid0                                  /nvme
mdstat:
  Personalities : [raid0] 
  md0 : active raid0 nvme1n1[3] nvme2n1[2] nvme0n1[1] nvme3n1[0]
        7421345792 blocks super 1.2 256k chunks
        
  unused devices: <none>
data_fs:         /dev/md0       xfs   7.0T   53G  6.9T   1% /nvme
mentat_git:      815164a1+
rustc:           rustc 1.90.0 (1159e78c4 2025-09-14)
python:          Python 3.11.16
duckdb:          1.5.5
sqlite(host py): 3.40.0
postgres:        postgres (PostgreSQL) 16.15
pg_configure:     '--prefix=/nvme/pg16' '--with-icu' 'CFLAGS=-O2 -g'

postgresql.conf (non-default settings):
  DateStyle = ISO, MDY
  TimeZone = UTC
  application_name = psql
  autovacuum_max_workers = 8
  autovacuum_vacuum_cost_limit = 4000
  checkpoint_completion_target = 0.9
  checkpoint_timeout = 1800s
  client_min_messages = warning
  default_text_search_config = pg_catalog.english
  dynamic_shared_memory_type = posix
  effective_cache_size = 942637MB
  effective_io_concurrency = 256
  huge_pages = on
  lc_messages = C
  lc_monetary = C
  lc_numeric = C
  lc_time = C
  listen_addresses = 
  log_checkpoints = on
  log_min_duration_statement = -1ms
  log_timezone = UTC
  maintenance_work_mem = 8388608kB
  max_connections = 300
  max_parallel_maintenance_workers = 16
  max_parallel_workers = 64
  max_parallel_workers_per_gather = 8
  max_wal_size = 102400MB
  max_worker_processes = 128
  min_wal_size = 8192MB
  pg_stat_statements.max = 10000
  random_page_cost = 1.1
  shared_buffers = 877101MB   (85% of 1007.7 GiB; env.txt originally printed setting||unit = 112268928||8kB)
  shared_preload_libraries = pg_stat_statements
  synchronous_commit = on
  track_io_timing = on
  unix_socket_directories = /tmp
  wal_buffers = 1GB
  wal_compression = pglz
  work_mem = 65536kB

invocation 2026-09-27T01:08:40Z: PHASE=all SCALES='s' BACKENDS='embedded sqlite-ext pg duckdb'
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509


invocation 2026-09-27T01:34:15Z: PHASE=load SCALES='m' BACKENDS='pg'
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
invocation 2026-09-27T01:34:15Z: PHASE=load SCALES='m' BACKENDS='embedded'
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T01:39:18Z: PHASE=load SCALES='l' BACKENDS='embedded'
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T01:44:01Z: PHASE=load SCALES='l' BACKENDS='pg'
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=16 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T02:03:48Z: PHASE=bench SCALES='m' BACKENDS='pg' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T02:19:48Z: PHASE=bench SCALES='m' BACKENDS='embedded' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T02:21:57Z: PHASE=all SCALES='m' BACKENDS='sqlite-ext duckdb' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 128' REPS=1 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=30 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=900 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509


invocation 2026-09-27T02:24:33Z: PHASE=bench SCALES='m' BACKENDS='embedded' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509
invocation 2026-09-27T02:24:33Z: PHASE=bench SCALES='l' BACKENDS='pg' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T02:54:00Z: PHASE=load SCALES='xl' BACKENDS='pg' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T03:01:38Z: PHASE=bench SCALES='m' BACKENDS='embedded' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T03:04:57Z: PHASE=bench SCALES='m' BACKENDS='embedded' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509


invocation 2026-09-27T03:22:10Z: PHASE=bench SCALES='xl' BACKENDS='pg' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=30
  PROBE_S=20 MIXED_S=30 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509
invocation 2026-09-27T03:22:10Z: PHASE=bench SCALES='m' BACKENDS='embedded' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=30 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T03:24:25Z: PHASE=bench SCALES='xl' BACKENDS='pg' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=30
  PROBE_S=20 MIXED_S=30 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T03:25:34Z: PHASE=bench SCALES='m' BACKENDS='embedded' cpu_affinity=0-127
  SCENARIOS='' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=30 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T03:33:17Z: PHASE=bench SCALES='xl' BACKENDS='pg' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=30
  PROBE_S=20 MIXED_S=30 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T03:34:12Z: PHASE=bench SCALES='l' BACKENDS='embedded' cpu_affinity=0-127
  SCENARIOS='point_lookup pull input_bindings ref_traversal predicate_scan aggregate since as_of' EXTRA='' CLIENTS='1 8 32 64 128' REPS=1 MIN_S=5 MIN_N=30 MAX_S=20
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T03:44:10Z: PHASE=bench SCALES='l xl' BACKENDS='pg' cpu_affinity=0-127
  SCENARIOS='' EXTRA='concurrency_sweep' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509


invocation 2026-09-27T03:46:58Z: PHASE=sustained SCALES='m' BACKENDS='embedded' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=1200 SUSTAINED_CLIENTS=8
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509
invocation 2026-09-27T03:46:58Z: PHASE=sustained SCALES='xl' BACKENDS='pg' cpu_affinity=0-127
  SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='write_mixed concurrency_sweep cold_vs_warm' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=1200 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

invocation 2026-09-27T04:08:20Z: PHASE=bench SCALES='s m l xl' BACKENDS='pg' cpu_affinity=0-127
  SCENARIOS='' EXTRA='concurrency_sweep' CLIENTS='1 8 32 64 128' REPS=3 MIN_S=10 MIN_N=30 MAX_S=60
  PROBE_S=20 MIXED_S=60 MIXED_READERS=8 SUSTAINED_S=0 SUSTAINED_CLIENTS=32
  LOAD_MAX_S=5400 EXT_LOAD_MAX_S=5400 PG_LOAD_JOBS=32 EXT_SCENARIO_FILTER=''
  warmup=3 calls (discarded) seed=20260509

pg_db_settings (ALTER DATABASE, per bench DB): mentat.max_result_rows=0, mentat.temp_file_limit=100GB (see logs/pg-db-settings.txt)
postmaster: numactl --interleave=all; synchronous_commit=on (durable)
engine: mentat v1.9.0 (tag 8c6c8816); suite commits 815164a1..HEAD touched only benchmarks/