p 184875/2021-01-20 03:20:02 PST LOG: automatic vacuum of table "regression.public.pgbench_accounts": index scans: 1 pages: 0 removed, 3636364 remain, 4 skipped due to pins, 135904 skipped frozen tuples: 489197 removed, 200708461 remain, 708441 are dead but not yet removable, oldest xmin: 100063379 buffer usage: 7844412 hits, 3394356 misses, 3840063 dirtied avg read rate: 16.395 MB/s, avg write rate: 18.547 MB/s system usage: CPU: user: 228.03 s, system: 109.38 s, elapsed: 1617.51 s WAL usage: 7997485 records, 3847296 full page images, 28974392927 bytes -- p 192246/2021-01-20 10:21:10 PST LOG: automatic aggressive vacuum to prevent wraparound of table "regression.public.pgbench_accounts": index scans: 1 pages: 0 removed, 3636364 remain, 0 skipped due to pins, 75160 skipped frozen tuples: 478321 removed, 200719664 remain, 719664 are dead but not yet removable, oldest xmin: 200051691 buffer usage: 7842156 hits, 3596103 misses, 4021713 dirtied avg read rate: 16.007 MB/s, avg write rate: 17.901 MB/s system usage: CPU: user: 268.91 s, system: 152.14 s, elapsed: 1755.14 s WAL usage: 8355914 records, 4197453 full page images, 31439961509 bytes -- p 202988/2021-01-20 17:04:32 PST LOG: automatic aggressive vacuum of table "regression.public.pgbench_accounts": index scans: 1 pages: 0 removed, 3636364 remain, 0 skipped due to pins, 72333 skipped frozen tuples: 461652 removed, 200740441 remain, 740488 are dead but not yet removable, oldest xmin: 303318755 buffer usage: 2784423 hits, 2184110 misses, 2140091 dirtied avg read rate: 14.719 MB/s, avg write rate: 14.423 MB/s system usage: CPU: user: 253.33 s, system: 155.56 s, elapsed: 1159.26 s WAL usage: 4123147 records, 2025541 full page images, 15054982327 bytes -- p 203596/2021-01-20 17:34:08 PST LOG: automatic vacuum of table "regression.public.pgbench_accounts": index scans: 1 pages: 0 removed, 3636364 remain, 0 skipped due to pins, 110839 skipped frozen tuples: 289983 removed, 200663603 remain, 663603 are dead but not yet removable, oldest xmin: 318283196 buffer usage: 7770830 hits, 3679088 misses, 3178761 dirtied avg read rate: 19.971 MB/s, avg write rate: 17.255 MB/s system usage: CPU: user: 197.36 s, system: 65.85 s, elapsed: 1439.21 s WAL usage: 7559115 records, 3744079 full page images, 27971870881 bytes -- p 215108/2021-01-21 00:44:08 PST LOG: automatic aggressive vacuum of table "regression.public.pgbench_accounts": index scans: 1 pages: 0 removed, 3636364 remain, 0 skipped due to pins, 114919 skipped frozen tuples: 248566 removed, 200666743 remain, 666743 are dead but not yet removable, oldest xmin: 432034864 buffer usage: 7755512 hits, 3717941 misses, 3161927 dirtied avg read rate: 20.574 MB/s, avg write rate: 17.497 MB/s system usage: CPU: user: 182.69 s, system: 55.97 s, elapsed: 1411.82 s WAL usage: 7357854 records, 3134635 full page images, 23391701173 bytes -- p 219344/2021-01-21 03:31:49 PST LOG: automatic aggressive vacuum of table "regression.public.pgbench_accounts": index scans: 1 pages: 0 removed, 3636364 remain, 0 skipped due to pins, 74044 skipped frozen tuples: 474704 removed, 200727039 remain, 727039 are dead but not yet removable, oldest xmin: 535373084 buffer usage: 3060017 hits, 2310541 misses, 2117761 dirtied avg read rate: 15.810 MB/s, avg write rate: 14.491 MB/s system usage: CPU: user: 265.96 s, system: 144.36 s, elapsed: 1141.72 s WAL usage: 4430826 records, 2313365 full page images, 17243237934 bytes -- p 219821/2021-01-21 03:58:18 PST LOG: automatic vacuum of table "regression.public.pgbench_accounts": index scans: 1 pages: 0 removed, 3636364 remain, 2 skipped due to pins, 117800 skipped frozen tuples: 254462 removed, 200672271 remain, 672271 are dead but not yet removable, oldest xmin: 546920768 buffer usage: 7755270 hits, 3750754 misses, 3961656 dirtied avg read rate: 18.595 MB/s, avg write rate: 19.640 MB/s system usage: CPU: user: 189.02 s, system: 57.89 s, elapsed: 1575.87 s WAL usage: 7323381 records, 3382354 full page images, 25238367511 bytes