pgbench (16.15)
transaction type: multiple scripts
scaling factor: 1
query mode: simple
number of clients: 64
number of threads: 64
maximum number of tries: 1
duration: 10 s
number of transactions actually processed: 319114
number of failed transactions: 0 (0.000%)
latency average = 2.004 ms
initial connection time = 13.209 ms
tps = 31937.790196 (without initial connection time)
SQL script 1: /nvme/mentat/benchmarks/scale/pgbench/point_lookup.sql
- weight: 1 (targets 33.3% of total)
- 106574 transactions (33.4% of total, tps = 10666.213492)
- number of failed transactions: 0 (0.000%)
- latency average = 2.015 ms
- latency stddev = 0.566 ms
SQL script 2: /nvme/mentat/benchmarks/scale/pgbench/ref_traversal.sql
- weight: 1 (targets 33.3% of total)
- 106216 transactions (33.3% of total, tps = 10630.383886)
- number of failed transactions: 0 (0.000%)
- latency average = 3.036 ms
- latency stddev = 0.766 ms
SQL script 3: /nvme/mentat/benchmarks/scale/pgbench/pull.sql
- weight: 1 (targets 33.3% of total)
- 106169 transactions (33.3% of total, tps = 10625.679999)
- number of failed transactions: 0 (0.000%)
- latency average = 0.950 ms
- latency stddev = 0.283 ms