batches-16.log
text/x-log
====================== eic 1 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191281
I/O Timings: shared read=3013.116
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191281
I/O Timings: shared read=3013.116
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 31.996
Prefetch Count: 163951
Prefetch Stalls: 1
Prefetch Skips: 9837060
Prefetch Resets: 3
Buffers: shared read=191281
I/O Timings: shared read=3013.116
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.550
Planning Time: 6.822 ms
Execution Time: 5279.929 ms
(20 rows)
Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util
nvme0n1p1 6710.00 268196.50 0.00 0.00 0.10 39.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.64 60.00
nvme0n1p1 7122.00 289432.00 0.00 0.00 0.09 40.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.63 62.00
nvme0n1p1 6811.00 276864.00 0.00 0.00 0.10 40.65 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.66 63.60
nvme0n1p1 7209.00 293144.00 0.00 0.00 0.09 40.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.65 72.80
nvme0n1p1 7519.00 306128.00 0.00 0.00 0.08 40.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.64 65.60
====================== eic 8 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2625.972
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2625.972
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 58.116
Prefetch Count: 163944
Prefetch Stalls: 1188
Prefetch Skips: 9836640
Prefetch Resets: 1190
Buffers: shared read=191271
I/O Timings: shared read=2625.972
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.656
Planning Time: 6.605 ms
Execution Time: 5102.460 ms
(20 rows)
Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util
nvme0n1p1 7681.00 278516.00 0.00 0.00 0.11 36.26 19.00 143.00 0.00 0.00 0.11 7.53 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 52.40
nvme0n1p1 8316.00 305400.00 0.00 0.00 0.11 36.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.89 62.00
nvme0n1p1 7695.00 282568.00 0.00 0.00 0.12 36.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.90 64.80
nvme0n1p1 8350.00 307192.00 0.00 0.00 0.11 36.79 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.89 55.60
nvme0n1p1 8399.00 308768.00 0.00 0.00 0.11 36.76 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 60.80
====================== eic 16 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2705.352
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2705.352
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 58.116
Prefetch Count: 163944
Prefetch Stalls: 1188
Prefetch Skips: 9836640
Prefetch Resets: 1190
Buffers: shared read=191271
I/O Timings: shared read=2705.352
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=3.004
Planning Time: 7.725 ms
Execution Time: 5308.190 ms
(20 rows)
Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util
nvme0n1p1 7107.00 256981.00 0.00 0.00 0.11 36.16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.78 51.60
nvme0n1p1 7879.00 289552.00 0.00 0.00 0.10 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.81 49.20
nvme0n1p1 7671.00 281904.00 0.00 0.00 0.11 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.82 55.20
nvme0n1p1 8136.00 298944.00 0.00 0.00 0.10 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.84 59.20
nvme0n1p1 7933.00 291688.00 0.00 0.00 0.11 36.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.85 56.80
====================== eic 32 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2931.130
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2931.130
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 58.116
Prefetch Count: 163944
Prefetch Stalls: 1188
Prefetch Skips: 9836640
Prefetch Resets: 1190
Buffers: shared read=191271
I/O Timings: shared read=2931.130
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.921
Planning Time: 6.654 ms
Execution Time: 5572.837 ms
(20 rows)
Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util
nvme0n1p1 6674.00 241316.00 0.00 0.00 0.12 36.16 1.00 9.50 0.00 0.00 0.00 9.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.79 61.20
nvme0n1p1 7342.00 269680.00 0.00 0.00 0.11 36.73 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.84 57.60
nvme0n1p1 7713.86 283516.83 0.00 0.00 0.11 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.85 59.41
nvme0n1p1 6987.00 256696.00 0.00 0.00 0.11 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.80 58.40
nvme0n1p1 7835.00 288344.00 0.00 0.00 0.10 36.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.80 54.00
====================== eic 64 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2661.311
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2661.311
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 58.116
Prefetch Count: 163944
Prefetch Stalls: 1188
Prefetch Skips: 9836640
Prefetch Resets: 1190
Buffers: shared read=191271
I/O Timings: shared read=2661.311
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.675
Planning Time: 6.858 ms
Execution Time: 5239.994 ms
(20 rows)
Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util
nvme0n1p1 6942.00 251236.00 0.00 0.00 0.12 36.19 1.00 9.50 0.00 0.00 0.00 9.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.85 62.00
nvme0n1p1 8176.00 300400.00 0.00 0.00 0.11 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 73.60
nvme0n1p1 7938.00 291496.00 0.00 0.00 0.11 36.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 72.80
nvme0n1p1 8235.00 302680.00 0.00 0.00 0.10 36.76 1.00 8.00 0.00 0.00 0.00 8.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 60.80
nvme0n1p1 8155.00 300080.00 0.00 0.00 0.10 36.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.85 59.60
====================== eic 128 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2607.508
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2607.508
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 58.116
Prefetch Count: 163944
Prefetch Stalls: 1188
Prefetch Skips: 9836640
Prefetch Resets: 1190
Buffers: shared read=191271
I/O Timings: shared read=2607.508
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.742
Planning Time: 7.629 ms
Execution Time: 5110.434 ms
(20 rows)
Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util
nvme0n1p1 7380.00 267116.50 0.00 0.00 0.12 36.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 70.40
nvme0n1p1 8236.00 302600.00 0.00 0.00 0.10 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 66.00
nvme0n1p1 7988.12 293394.06 0.00 0.00 0.11 36.73 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 61.78
nvme0n1p1 8310.00 305424.00 0.00 0.00 0.10 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 65.60
nvme0n1p1 8542.00 314264.00 0.00 0.00 0.10 36.79 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 60.00
====================== eic 256 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2540.047
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2540.047
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 58.116
Prefetch Count: 163944
Prefetch Stalls: 1188
Prefetch Skips: 9836640
Prefetch Resets: 1190
Buffers: shared read=191271
I/O Timings: shared read=2540.047
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.644
Planning Time: 6.982 ms
Execution Time: 5036.594 ms
(20 rows)
Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util
nvme0n1p1 7847.00 284436.00 0.00 0.00 0.11 36.25 1.00 9.50 0.00 0.00 0.00 9.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 56.80
nvme0n1p1 7730.00 284024.00 0.00 0.00 0.11 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 62.40
nvme0n1p1 8462.00 310752.00 0.00 0.00 0.10 36.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 62.80
nvme0n1p1 8352.00 307328.00 0.00 0.00 0.10 36.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 74.40
nvme0n1p1 8719.00 320712.00 0.00 0.00 0.10 36.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 55.60
====================== eic 512 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2510.486
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191271
I/O Timings: shared read=2510.486
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 58.116
Prefetch Count: 163944
Prefetch Stalls: 1188
Prefetch Skips: 9836640
Prefetch Resets: 1190
Buffers: shared read=191271
I/O Timings: shared read=2510.486
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.700
Planning Time: 7.197 ms
Execution Time: 5037.071 ms
(20 rows)
Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util
nvme0n1p1 7379.00 267108.50 0.00 0.00 0.12 36.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 60.80
nvme0n1p1 8128.00 298680.00 0.00 0.00 0.11 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 62.00
nvme0n1p1 8437.00 309752.00 0.00 0.00 0.11 36.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.89 53.60
nvme0n1p1 8609.00 316528.00 0.00 0.00 0.10 36.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 60.00
nvme0n1p1 8534.00 314016.00 0.00 0.00 0.10 36.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 68.80