date_utc: 2026-09-28T01:01:50Z
host: ip-172-31-2-164.us-east-2.compute.internal
instance_type: c7i.8xlarge
kernel: 6.12.103-129.197.amzn2023.x86_64
cpu_model: Intel(R) Xeon(R) Platinum 8488C
cpus: 32
sockets/numa: 1 1
mem_total_gib: 61.8
hugepages: HugePages_Total:=0 HugePages_Free:=0 Hugepagesize:=2048
thp: always [madvise] never
governor: n/a
numa_balancing: 0
overcommit: 0
pg_numactl: numactl --interleave=all (postmaster)
storage:
NAME SIZE TYPE MODEL MOUNTPOINT
nvme0n1 150G disk Amazon Elastic Block Store
├─nvme0n1p1 150G part /
├─nvme0n1p127 1M part
└─nvme0n1p128 10M part /boot/efi
mdstat:
Personalities :
unused devices: <none>
data_fs: /dev/nvme0n1p1 xfs 150G 47G 104G 31% /
mentat_git: final
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=/home/ec2-user/pg16rel' '--with-icu' 'CFLAGS=-O2 -g'
postgresql.conf (non-default settings):
DateStyle = ISO, MDY
TimeZone = UTC
application_name = psql
autovacuum_max_workers = 6
autovacuum_vacuum_cost_limit = 4000
checkpoint_completion_target = 0.9
checkpoint_timeout = 30min
client_min_messages = warning
default_text_search_config = pg_catalog.english
dynamic_shared_memory_type = posix
effective_cache_size = 48GB
effective_io_concurrency = 256
lc_messages = C
lc_monetary = C
lc_numeric = C
lc_time = C
listen_addresses =
log_timezone = UTC
maintenance_work_mem = 4GB
max_connections = 200
max_parallel_maintenance_workers = 8
max_parallel_workers = 32
max_parallel_workers_per_gather = 4
max_wal_size = 50GB
max_worker_processes = 64
min_wal_size = 4GB
port = 5432
random_page_cost = 1.1
shared_buffers = 16GB
shared_preload_libraries = pg_stat_statements
track_io_timing = on
unix_socket_directories = /tmp
wal_buffers = 256MB
work_mem = 64MB
invocation 2026-09-28T01:01:51Z: PHASE=bench SCALES='s m' BACKENDS='pg' cpu_affinity=0-31
SCENARIOS='point_lookup ref_traversal aggregate predicate_scan pull as_of since input_bindings' EXTRA='concurrency_sweep' CLIENTS='1 8 32' 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
