pg-aggregate-m-c1-r3 / PostgreSQL Extension Network

pgbench (16.15)
WARNING:  mentat slow query (1560.5ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1546.4ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1538.7ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1542.6ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1541.3ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1526.8ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1532.8ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1511.2ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1515.7ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1516.8ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1508.5ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1514.2ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1515.0ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1509.2ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1509.2ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1511.4ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1510.4ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1510.9ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1514.9ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1553.7ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1552.1ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1554.1ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1552.1ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1549.3ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1544.4ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1550.1ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1554.9ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1552.2ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1550.7ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1553.7ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1550.3ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1548.8ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1554.7ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1554.9ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1547.4ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1555.8ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1550.2ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1552.9ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1558.5ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
WARNING:  mentat slow query (1552.3ms > 100ms threshold): datalog=[:find ?state (count ?i) :where [?i :issue/state ?state]], sql=SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(DISTINCT da
transaction type: /nvme/mentat/benchmarks/scale/pgbench/aggregate.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: 40
number of failed transactions: 0 (0.000%)
latency average = 1538.608 ms
initial connection time = 1.135 ms
tps = 0.649938 (without initial connection time)
PGXN

PostgreSQL Extension Network

Contents
