pgbench (16.15) WARNING: mentat slow query (116.7ms > 100ms threshold): datalog=[:find ?i ?title ?state :in $ ?email :where [?u :user/email ?email] [?i :issue/assignee ?u] [?i :issue/title ?title] [?i :issue/state ?state]], sql=SELECT DISTINCT datoms1.e::TEXT, CASE datoms2.value_type_tag WHEN 0 THEN datoms2.v_ref::TEXT WHEN 1 THEN datoms2.v_bool::TEXT WHEN 2 THEN datoms2.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms2.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms2.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms2.v_text WHEN 8 THEN ':' || datoms2.v_keyword WHEN 10 THEN datoms2.v_uuid::TEXT WHEN 11 THEN encode(datoms2.v_bytes, 'hex') ELSE NULL::T transaction type: multiple scripts scaling factor: 1 query mode: simple number of clients: 32 number of threads: 32 maximum number of tries: 1 duration: 10 s number of transactions actually processed: 10529 number of failed transactions: 0 (0.000%) latency average = 30.516 ms initial connection time = 7.486 ms tps = 1048.642407 (without initial connection time) SQL script 1: /nvme/mentat/benchmarks/scale/pgbench/point_lookup.sql - weight: 1 (targets 33.3% of total) - 3463 transactions (32.9% of total, tps = 344.899673) - number of failed transactions: 0 (0.000%) - latency average = 44.461 ms - latency stddev = 2.314 ms SQL script 2: /nvme/mentat/benchmarks/scale/pgbench/ref_traversal.sql - weight: 1 (targets 33.3% of total) - 3548 transactions (33.7% of total, tps = 353.365302) - number of failed transactions: 0 (0.000%) - latency average = 45.653 ms - latency stddev = 2.343 ms SQL script 3: /nvme/mentat/benchmarks/scale/pgbench/pull.sql - weight: 1 (targets 33.3% of total) - 3505 transactions (33.3% of total, tps = 349.082689) - number of failed transactions: 0 (0.000%) - latency average = 1.057 ms - latency stddev = 0.536 ms