pgbench (16.15)
transaction type: multiple scripts
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
maximum number of tries: 1
duration: 10 s
number of transactions actually processed: 1012
number of failed transactions: 0 (0.000%)
latency average = 9.880 ms
initial connection time = 1.942 ms
tps = 101.216033 (without initial connection time)
SQL script 1: /nvme/mentat/benchmarks/scale/pgbench/point_lookup.sql
- weight: 1 (targets 33.3% of total)
- 340 transactions (33.6% of total, tps = 34.005386)
- number of failed transactions: 0 (0.000%)
- latency average = 13.577 ms
- latency stddev = 0.237 ms
SQL script 2: /nvme/mentat/benchmarks/scale/pgbench/ref_traversal.sql
- weight: 1 (targets 33.3% of total)
- 350 transactions (34.6% of total, tps = 35.005545)
- number of failed transactions: 0 (0.000%)
- latency average = 14.594 ms
- latency stddev = 0.337 ms
SQL script 3: /nvme/mentat/benchmarks/scale/pgbench/pull.sql
- weight: 1 (targets 33.3% of total)
- 322 transactions (31.8% of total, tps = 32.205101)
- number of failed transactions: 0 (0.000%)
- latency average = 0.843 ms
- latency stddev = 0.105 ms