====================== 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