batches-64.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=3341.988
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191281
I/O Timings: shared read=3341.988
-> 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=3341.988
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.595
Planning Time: 4.711 ms
Execution Time: 5948.513 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 6046.00 241029.00 0.00 0.00 0.09 39.87 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.57 59.20
nvme0n1p1 6368.00 258944.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.56 60.00
nvme0n1p1 6323.00 257136.00 0.00 0.00 0.09 40.67 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.57 58.40
nvme0n1p1 6258.00 254328.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.57 54.80
nvme0n1p1 6414.00 260896.00 0.00 0.00 0.09 40.68 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.56 63.60
====================== eic 8 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191411
I/O Timings: shared read=763.833
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191411
I/O Timings: shared read=763.833
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 143.923
Prefetch Count: 164063
Prefetch Stalls: 1
Prefetch Skips: 9843780
Prefetch Resets: 3
Buffers: shared read=191411
I/O Timings: shared read=763.833
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.601
Planning Time: 7.373 ms
Execution Time: 3045.476 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 11406.00 458925.00 0.00 0.00 0.09 40.24 14.00 97.50 0.00 0.00 0.07 6.96 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.08 86.00
nvme0n1p1 12564.00 510848.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 1.15 90.40
nvme0n1p1 12666.00 515376.00 0.00 0.00 0.09 40.69 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 1.09 90.80
====================== eic 16 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191561
I/O Timings: shared read=780.076
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191561
I/O Timings: shared read=780.076
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 271.761
Prefetch Count: 164191
Prefetch Stalls: 1
Prefetch Skips: 9851460
Prefetch Resets: 3
Buffers: shared read=191561
I/O Timings: shared read=780.076
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.581
Planning Time: 7.476 ms
Execution Time: 3025.995 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 11731.00 472197.00 0.00 0.00 0.09 40.25 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 1.09 90.40
nvme0n1p1 12446.00 505944.00 0.00 0.00 0.09 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 1.14 90.40
nvme0n1p1 12751.00 518936.00 0.00 0.00 0.09 40.70 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 1.10 95.60
====================== eic 32 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1283.840
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1283.840
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 253.411
Prefetch Count: 164010
Prefetch Stalls: 355
Prefetch Skips: 9840600
Prefetch Resets: 357
Buffers: shared read=191348
I/O Timings: shared read=1283.840
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.693
Planning Time: 7.426 ms
Execution Time: 3618.736 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 10195.00 398333.00 0.00 0.00 0.11 39.07 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 1.12 52.40
nvme0n1p1 10506.00 414456.00 0.00 0.00 0.11 39.45 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 1.16 54.80
nvme0n1p1 10899.00 430776.00 0.00 0.00 0.11 39.52 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 1.17 55.20
====================== eic 64 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1427.778
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1427.778
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 253.411
Prefetch Count: 164010
Prefetch Stalls: 355
Prefetch Skips: 9840600
Prefetch Resets: 357
Buffers: shared read=191348
I/O Timings: shared read=1427.778
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=3.138
Planning Time: 7.869 ms
Execution Time: 3829.833 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 9217.00 359565.00 0.00 0.00 0.11 39.01 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 1.01 48.00
nvme0n1p1 10042.00 396664.00 0.00 0.00 0.11 39.50 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 1.07 50.40
nvme0n1p1 10162.00 401184.00 0.00 0.00 0.11 39.48 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 1.11 53.60
====================== eic 128 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1374.205
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1374.205
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 253.411
Prefetch Count: 164010
Prefetch Stalls: 355
Prefetch Skips: 9840600
Prefetch Resets: 357
Buffers: shared read=191348
I/O Timings: shared read=1374.205
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.979
Planning Time: 7.543 ms
Execution Time: 3808.224 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 9641.00 376724.00 0.00 0.00 0.11 39.08 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 1.06 51.20
nvme0n1p1 10193.00 401992.00 0.00 0.00 0.11 39.44 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 1.10 50.80
nvme0n1p1 10332.00 408664.00 0.00 0.00 0.11 39.55 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 1.10 51.20
====================== eic 256 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1330.131
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1330.131
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 253.411
Prefetch Count: 164010
Prefetch Stalls: 355
Prefetch Skips: 9840600
Prefetch Resets: 357
Buffers: shared read=191348
I/O Timings: shared read=1330.131
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=2.566
Planning Time: 6.547 ms
Execution Time: 3674.986 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 10039.00 391733.00 0.00 0.00 0.11 39.02 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 1.10 51.60
nvme0n1p1 10422.00 411928.00 0.00 0.00 0.11 39.52 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 1.15 53.60
nvme0n1p1 10843.00 427872.00 0.00 0.00 0.11 39.46 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 1.16 51.20
====================== eic 512 ========================
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Aggregate (actual rows=1.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1367.977
-> Limit (actual rows=10000000.00 loops=1)
Buffers: shared read=191348
I/O Timings: shared read=1367.977
-> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1)
Index Searches: 1
Prefetch Distance: 253.411
Prefetch Count: 164010
Prefetch Stalls: 355
Prefetch Skips: 9840600
Prefetch Resets: 357
Buffers: shared read=191348
I/O Timings: shared read=1367.977
Planning:
Buffers: shared hit=46 read=22
I/O Timings: shared read=3.124
Planning Time: 8.065 ms
Execution Time: 3828.742 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 9439.00 368301.00 0.00 0.00 0.11 39.02 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 1.04 51.20
nvme0n1p1 10048.00 396720.00 0.00 0.00 0.11 39.48 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 1.09 51.60
nvme0n1p1 10251.00 405160.00 0.00 0.00 0.11 39.52 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 1.09 51.20