$ bash ./vacuumbenchone.sh 100 0.8
dropping old tables...
creating tables...
generating data...
100000 of 10000000 tuples (1%) done (elapsed 0.06 s, remaining 5.78 s)
200000 of 10000000 tuples (2%) done (elapsed 0.12 s, remaining 6.04 s)
300000 of 10000000 tuples (3%) done (elapsed 0.19 s, remaining 5.99 s)
400000 of 10000000 tuples (4%) done (elapsed 0.25 s, remaining 6.02 s)
500000 of 10000000 tuples (5%) done (elapsed 0.32 s, remaining 6.03 s)
600000 of 10000000 tuples (6%) done (elapsed 0.38 s, remaining 5.94 s)
700000 of 10000000 tuples (7%) done (elapsed 0.45 s, remaining 5.96 s)
800000 of 10000000 tuples (8%) done (elapsed 0.51 s, remaining 5.91 s)
900000 of 10000000 tuples (9%) done (elapsed 0.58 s, remaining 5.84 s)
1000000 of 10000000 tuples (10%) done (elapsed 0.64 s, remaining 5.79 s)
1100000 of 10000000 tuples (11%) done (elapsed 0.71 s, remaining 5.77 s)
1200000 of 10000000 tuples (12%) done (elapsed 0.78 s, remaining 5.76 s)
1300000 of 10000000 tuples (13%) done (elapsed 0.86 s, remaining 5.75 s)
1400000 of 10000000 tuples (14%) done (elapsed 0.95 s, remaining 5.86 s)
1500000 of 10000000 tuples (15%) done (elapsed 1.04 s, remaining 5.87 s)
1600000 of 10000000 tuples (16%) done (elapsed 1.11 s, remaining 5.83 s)
1700000 of 10000000 tuples (17%) done (elapsed 1.18 s, remaining 5.75 s)
1800000 of 10000000 tuples (18%) done (elapsed 1.25 s, remaining 5.69 s)
1900000 of 10000000 tuples (19%) done (elapsed 1.32 s, remaining 5.62 s)
2000000 of 10000000 tuples (20%) done (elapsed 1.41 s, remaining 5.62 s)
2100000 of 10000000 tuples (21%) done (elapsed 1.50 s, remaining 5.63 s)
2200000 of 10000000 tuples (22%) done (elapsed 1.57 s, remaining 5.55 s)
2300000 of 10000000 tuples (23%) done (elapsed 1.66 s, remaining 5.54 s)
2400000 of 10000000 tuples (24%) done (elapsed 1.73 s, remaining 5.47 s)
2500000 of 10000000 tuples (25%) done (elapsed 1.79 s, remaining 5.38 s)
2600000 of 10000000 tuples (26%) done (elapsed 1.87 s, remaining 5.31 s)
2700000 of 10000000 tuples (27%) done (elapsed 1.94 s, remaining 5.25 s)
2800000 of 10000000 tuples (28%) done (elapsed 2.01 s, remaining 5.16 s)
2900000 of 10000000 tuples (29%) done (elapsed 2.09 s, remaining 5.11 s)
3000000 of 10000000 tuples (30%) done (elapsed 2.16 s, remaining 5.04 s)
3100000 of 10000000 tuples (31%) done (elapsed 2.23 s, remaining 4.96 s)
3200000 of 10000000 tuples (32%) done (elapsed 2.30 s, remaining 4.89 s)
3300000 of 10000000 tuples (33%) done (elapsed 2.37 s, remaining 4.82 s)
3400000 of 10000000 tuples (34%) done (elapsed 2.43 s, remaining 4.72 s)
3500000 of 10000000 tuples (35%) done (elapsed 2.51 s, remaining 4.66 s)
3600000 of 10000000 tuples (36%) done (elapsed 2.58 s, remaining 4.58 s)
3700000 of 10000000 tuples (37%) done (elapsed 2.64 s, remaining 4.50 s)
3800000 of 10000000 tuples (38%) done (elapsed 2.74 s, remaining 4.47 s)
3900000 of 10000000 tuples (39%) done (elapsed 2.94 s, remaining 4.59 s)
4000000 of 10000000 tuples (40%) done (elapsed 3.37 s, remaining 5.06 s)
4100000 of 10000000 tuples (41%) done (elapsed 3.91 s, remaining 5.62 s)
4200000 of 10000000 tuples (42%) done (elapsed 4.15 s, remaining 5.73 s)
4300000 of 10000000 tuples (43%) done (elapsed 4.38 s, remaining 5.81 s)
4400000 of 10000000 tuples (44%) done (elapsed 4.55 s, remaining 5.79 s)
4500000 of 10000000 tuples (45%) done (elapsed 7.86 s, remaining 9.61 s)
4600000 of 10000000 tuples (46%) done (elapsed 7.93 s, remaining 9.31 s)
4700000 of 10000000 tuples (47%) done (elapsed 8.00 s, remaining 9.02 s)
4800000 of 10000000 tuples (48%) done (elapsed 8.06 s, remaining 8.73 s)
4900000 of 10000000 tuples (49%) done (elapsed 8.13 s, remaining 8.46 s)
5000000 of 10000000 tuples (50%) done (elapsed 8.20 s, remaining 8.20 s)
5100000 of 10000000 tuples (51%) done (elapsed 8.26 s, remaining 7.93 s)
5200000 of 10000000 tuples (52%) done (elapsed 8.32 s, remaining 7.68 s)
5300000 of 10000000 tuples (53%) done (elapsed 8.39 s, remaining 7.44 s)
5400000 of 10000000 tuples (54%) done (elapsed 8.47 s, remaining 7.22 s)
5500000 of 10000000 tuples (55%) done (elapsed 8.57 s, remaining 7.01 s)
5600000 of 10000000 tuples (56%) done (elapsed 8.69 s, remaining 6.83 s)
5700000 of 10000000 tuples (57%) done (elapsed 8.77 s, remaining 6.62 s)
5800000 of 10000000 tuples (58%) done (elapsed 8.86 s, remaining 6.42 s)
5900000 of 10000000 tuples (59%) done (elapsed 8.94 s, remaining 6.21 s)
6000000 of 10000000 tuples (60%) done (elapsed 9.02 s, remaining 6.01 s)
6100000 of 10000000 tuples (61%) done (elapsed 9.08 s, remaining 5.81 s)
6200000 of 10000000 tuples (62%) done (elapsed 9.26 s, remaining 5.67 s)
6300000 of 10000000 tuples (63%) done (elapsed 9.52 s, remaining 5.59 s)
6400000 of 10000000 tuples (64%) done (elapsed 9.87 s, remaining 5.55 s)
6500000 of 10000000 tuples (65%) done (elapsed 10.17 s, remaining 5.48 s)
6600000 of 10000000 tuples (66%) done (elapsed 10.59 s, remaining 5.45 s)
6700000 of 10000000 tuples (67%) done (elapsed 10.80 s, remaining 5.32 s)
6800000 of 10000000 tuples (68%) done (elapsed 11.04 s, remaining 5.20 s)
6900000 of 10000000 tuples (69%) done (elapsed 11.30 s, remaining 5.08 s)
7000000 of 10000000 tuples (70%) done (elapsed 11.62 s, remaining 4.98 s)
7100000 of 10000000 tuples (71%) done (elapsed 11.98 s, remaining 4.90 s)
7200000 of 10000000 tuples (72%) done (elapsed 12.35 s, remaining 4.80 s)
7300000 of 10000000 tuples (73%) done (elapsed 12.66 s, remaining 4.68 s)
7400000 of 10000000 tuples (74%) done (elapsed 13.02 s, remaining 4.57 s)
7500000 of 10000000 tuples (75%) done (elapsed 13.38 s, remaining 4.46 s)
7600000 of 10000000 tuples (76%) done (elapsed 13.76 s, remaining 4.34 s)
7700000 of 10000000 tuples (77%) done (elapsed 14.40 s, remaining 4.30 s)
7800000 of 10000000 tuples (78%) done (elapsed 14.85 s, remaining 4.19 s)
7900000 of 10000000 tuples (79%) done (elapsed 15.19 s, remaining 4.04 s)
8000000 of 10000000 tuples (80%) done (elapsed 15.55 s, remaining 3.89 s)
8100000 of 10000000 tuples (81%) done (elapsed 15.88 s, remaining 3.73 s)
8200000 of 10000000 tuples (82%) done (elapsed 16.33 s, remaining 3.58 s)
8300000 of 10000000 tuples (83%) done (elapsed 16.80 s, remaining 3.44 s)
8400000 of 10000000 tuples (84%) done (elapsed 17.24 s, remaining 3.28 s)
8500000 of 10000000 tuples (85%) done (elapsed 17.71 s, remaining 3.13 s)
8600000 of 10000000 tuples (86%) done (elapsed 18.19 s, remaining 2.96 s)
8700000 of 10000000 tuples (87%) done (elapsed 25.14 s, remaining 3.76 s)
8800000 of 10000000 tuples (88%) done (elapsed 25.21 s, remaining 3.44 s)
8900000 of 10000000 tuples (89%) done (elapsed 25.29 s, remaining 3.13 s)
9000000 of 10000000 tuples (90%) done (elapsed 25.35 s, remaining 2.82 s)
9100000 of 10000000 tuples (91%) done (elapsed 25.42 s, remaining 2.51 s)
9200000 of 10000000 tuples (92%) done (elapsed 33.92 s, remaining 2.95 s)
9300000 of 10000000 tuples (93%) done (elapsed 34.00 s, remaining 2.56 s)
9400000 of 10000000 tuples (94%) done (elapsed 34.06 s, remaining 2.17 s)
9500000 of 10000000 tuples (95%) done (elapsed 34.13 s, remaining 1.80 s)
9600000 of 10000000 tuples (96%) done (elapsed 34.20 s, remaining 1.42 s)
9700000 of 10000000 tuples (97%) done (elapsed 34.27 s, remaining 1.06 s)
9800000 of 10000000 tuples (98%) done (elapsed 34.33 s, remaining 0.70 s)
9900000 of 10000000 tuples (99%) done (elapsed 34.40 s, remaining 0.35 s)
10000000 of 10000000 tuples (100%) done (elapsed 34.47 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
DELETE 7999944
CHECKPOINT
INFO:  vacuuming "public.pgbench_accounts"
INFO:  scanned index "pgbench_accounts_pkey" to remove 7999944 row versions
DETAIL:  CPU: user: 1.50 s, system: 0.27 s, elapsed: 21.61 s
INFO:  scanned index "seq_1" to remove 7999944 row versions
DETAIL:  CPU: user: 1.24 s, system: 0.17 s, elapsed: 7.68 s
INFO:  scanned index "seq_2" to remove 7999944 row versions
DETAIL:  CPU: user: 1.48 s, system: 0.22 s, elapsed: 11.63 s
INFO:  scanned index "seq_3" to remove 7999944 row versions
DETAIL:  CPU: user: 1.60 s, system: 0.28 s, elapsed: 13.25 s
INFO:  scanned index "seq_4" to remove 7999944 row versions
DETAIL:  CPU: user: 1.54 s, system: 0.21 s, elapsed: 13.91 s
INFO:  scanned index "seq_5" to remove 7999944 row versions
DETAIL:  CPU: user: 1.20 s, system: 0.12 s, elapsed: 5.21 s
INFO:  scanned index "seq_6" to remove 7999944 row versions
DETAIL:  CPU: user: 1.61 s, system: 0.23 s, elapsed: 13.82 s
INFO:  scanned index "seq_7" to remove 7999944 row versions
DETAIL:  CPU: user: 1.50 s, system: 0.20 s, elapsed: 15.91 s
INFO:  scanned index "seq_8" to remove 7999944 row versions
DETAIL:  CPU: user: 1.46 s, system: 0.21 s, elapsed: 16.45 s
INFO:  scanned index "seq_9" to remove 7999944 row versions
DETAIL:  CPU: user: 1.51 s, system: 0.20 s, elapsed: 15.01 s
INFO:  scanned index "seq_10" to remove 7999944 row versions
DETAIL:  CPU: user: 1.12 s, system: 0.16 s, elapsed: 3.64 s
INFO:  scanned index "random_1" to remove 7999944 row versions
DETAIL:  CPU: user: 6.72 s, system: 0.30 s, elapsed: 17.71 s
INFO:  scanned index "random_2" to remove 7999944 row versions
DETAIL:  CPU: user: 6.17 s, system: 0.36 s, elapsed: 16.66 s
INFO:  scanned index "random_3" to remove 7999944 row versions
DETAIL:  CPU: user: 6.65 s, system: 0.33 s, elapsed: 18.87 s
INFO:  scanned index "random_4" to remove 7999944 row versions
DETAIL:  CPU: user: 6.05 s, system: 0.30 s, elapsed: 17.52 s
INFO:  scanned index "random_5" to remove 7999944 row versions
DETAIL:  CPU: user: 6.24 s, system: 0.34 s, elapsed: 16.89 s
INFO:  scanned index "random_6" to remove 7999944 row versions
DETAIL:  CPU: user: 6.29 s, system: 0.32 s, elapsed: 17.21 s
INFO:  scanned index "random_7" to remove 7999944 row versions
DETAIL:  CPU: user: 6.51 s, system: 0.34 s, elapsed: 16.12 s
INFO:  scanned index "random_8" to remove 7999944 row versions
DETAIL:  CPU: user: 6.54 s, system: 0.28 s, elapsed: 17.74 s
INFO:  scanned index "random_9" to remove 7999944 row versions
DETAIL:  CPU: user: 6.60 s, system: 0.37 s, elapsed: 17.03 s
INFO:  scanned index "random_10" to remove 7999944 row versions
DETAIL:  CPU: user: 6.64 s, system: 0.36 s, elapsed: 16.69 s
INFO:  "pgbench_accounts": removed 7999944 row versions in 163935 pages
DETAIL:  CPU: user: 1.20 s, system: 0.24 s, elapsed: 14.19 s
INFO:  index "pgbench_accounts_pkey" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_1" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_2" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_3" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_4" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_5" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_6" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_7" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_8" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_9" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "seq_10" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_1" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_2" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_3" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_4" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_5" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_6" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_7" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_8" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_9" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  index "random_10" now contains 2000056 row versions in 27422 pages
DETAIL:  7999944 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  "pgbench_accounts": found 7999944 removable, 2000056 nonremovable row versions in 163935 out of 163935 pages
DETAIL:  0 dead row versions cannot be removed yet, oldest xmin: 1625
There were 0 unused item pointers.
Skipped 0 pages due to buffer pins, 0 frozen pages.
0 pages are entirely empty.
CPU: user: 82.66 s, system: 6.13 s, elapsed: 327.50 s.
VACUUM

real	5m27.527s
user	0m0.000s
sys	0m0.008s
