pgbench (16.15)
WARNING:  mentat slow query (4808.0ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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
WARNING:  mentat slow query (4623.2ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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
WARNING:  mentat slow query (4594.1ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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
WARNING:  mentat slow query (4632.0ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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
WARNING:  mentat slow query (4613.0ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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
WARNING:  mentat slow query (4574.0ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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
WARNING:  mentat slow query (4586.8ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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
WARNING:  mentat slow query (4621.5ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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
WARNING:  mentat slow query (4589.3ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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
WARNING:  mentat slow query (4618.6ms > 100ms threshold): datalog=[:find ?i ?title ?priority :in $ ?min :where [?i :issue/state :state/open] [?i :issue/priority ?priority] [?i :issue/title ?title] [(>= ?priority ?min)]], sql=SELECT DISTINCT datoms0.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: /nvme/mentat/benchmarks/scale/pgbench/predicate_scan.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 10
number of failed transactions: 0 (0.000%)
latency average = 6645.137 ms
initial connection time = 1.303 ms
tps = 0.150486 (without initial connection time)