pgbench (16.15)
transaction type: multiple scripts
scaling factor: 1
query mode: simple
number of clients: 32
number of threads: 32
maximum number of tries: 1
duration: 10 s
number of transactions actually processed: 306776
number of failed transactions: 0 (0.000%)
latency average = 1.043 ms
initial connection time = 7.633 ms
tps = 30693.357970 (without initial connection time)
SQL script 1: /home/ec2-user/mentat/benchmarks/scale/pgbench/point_lookup.sql
- weight: 1 (targets 33.3% of total)
- 101553 transactions (33.1% of total, tps = 10160.516409)
- number of failed transactions: 0 (0.000%)
- latency average = 0.418 ms
- latency stddev = 0.055 ms
SQL script 2: /home/ec2-user/mentat/benchmarks/scale/pgbench/ref_traversal.sql
- weight: 1 (targets 33.3% of total)
- 101883 transactions (33.2% of total, tps = 10193.533360)
- number of failed transactions: 0 (0.000%)
- latency average = 1.610 ms
- latency stddev = NaN ms
SQL script 3: /home/ec2-user/mentat/benchmarks/scale/pgbench/pull.sql
- weight: 1 (targets 33.3% of total)
- 100988 transactions (32.9% of total, tps = 10103.987387)
- number of failed transactions: 0 (0.000%)
- latency average = 1.170 ms
- latency stddev = NaN ms