effective_io_concurrency=0 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=1454.570..1454.570 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=447.877..447.877 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 15.782 ms Execution time: 1455.336 ms (11 rows) effective_io_concurrency=1 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=8364.272..8364.272 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=448.043..448.043 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 15.036 ms Execution time: 8365.070 ms (11 rows) effective_io_concurrency=2 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=4791.196..4791.196 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=433.928..433.928 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 14.847 ms Execution time: 4791.961 ms (11 rows) effective_io_concurrency=4 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=4112.928..4112.928 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=470.873..470.873 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 14.694 ms Execution time: 4113.713 ms (11 rows) effective_io_concurrency=8 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=1584.067..1584.067 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=451.587..451.587 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 14.421 ms Execution time: 1584.862 ms (11 rows) effective_io_concurrency=16 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=1532.343..1532.343 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=429.148..429.148 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 14.802 ms Execution time: 1533.096 ms (11 rows) effective_io_concurrency=8 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=1493.721..1493.721 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=427.864..427.864 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 14.565 ms Execution time: 1494.494 ms (11 rows) effective_io_concurrency=4 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=3235.104..3235.104 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=435.009..435.009 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 14.289 ms Execution time: 3235.892 ms (11 rows) effective_io_concurrency=2 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=4623.565..4623.565 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=425.661..425.661 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 14.529 ms Execution time: 4624.334 ms (11 rows) effective_io_concurrency=1 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=7830.530..7830.530 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=435.078..435.078 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 14.361 ms Execution time: 7831.310 ms (11 rows) effective_io_concurrency=0 QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------ Bitmap Heap Scan on pgbench_accounts (cost=12838.24..357966.26 rows=1 width=97) (actual time=1421.417..1421.417 rows=0 loops=1) Recheck Cond: ((aid >= 1000) AND (aid <= 1000000)) Filter: (abalance <> 0) Rows Removed by Filter: 999001 Heap Blocks: exact=16378 Buffers: shared hit=2 read=19109 -> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..12838.24 rows=986230 width=0) (actual time=470.542..470.542 rows=999001 loops=1) Index Cond: ((aid >= 1000) AND (aid <= 1000000)) Buffers: shared hit=2 read=2731 Planning time: 14.907 ms Execution time: 1422.203 ms (11 rows)