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/
