pgbench (16.15)
transaction type: multiple scripts
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
maximum number of tries: 1
duration: 10 s
number of transactions actually processed: 2653
number of failed transactions: 0 (0.000%)
latency average = 30.193 ms
initial connection time = 2.889 ms
tps = 264.962306 (without initial connection time)
SQL script 1: /nvme/mentat/benchmarks/scale/pgbench/point_lookup.sql
- weight: 1 (targets 33.3% of total)
- 880 transactions (33.2% of total, tps = 87.887987)
- number of failed transactions: 0 (0.000%)
- latency average = 44.476 ms
- latency stddev = 2.561 ms
SQL script 2: /nvme/mentat/benchmarks/scale/pgbench/ref_traversal.sql
- weight: 1 (targets 33.3% of total)
- 874 transactions (32.9% of total, tps = 87.288750)
- number of failed transactions: 0 (0.000%)
- latency average = 45.626 ms
- latency stddev = 1.819 ms
SQL script 3: /nvme/mentat/benchmarks/scale/pgbench/pull.sql
- weight: 1 (targets 33.3% of total)
- 896 transactions (33.8% of total, tps = 89.485950)
- number of failed transactions: 0 (0.000%)
- latency average = 0.999 ms
- latency stddev = 0.212 ms