Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:e8d9864413418295d9c500d97c260372

Last active August 26, 2025 19:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mdcallag/e8d9864413418295d9c500d97c260372 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mdcallag/e8d9864413418295d9c500d97c260372 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
--- postgres 17.6
pg_vac starts at Mon Aug 4 01:41:58 AM UTC 2025 with sleep_secs = 110
nr is :: 50000000 :: and ntabs is :: 1 ::
vac_args is (verbose, analyze, index_cleanup ON)
After load: wait for vacuum 0
Checkpoint started at Mon Aug 4 01:42:12 AM UTC 2025
CHECKPOINT
Checkpoint done at Mon Aug 4 01:42:26 AM UTC 2025
Sleep 82
vac_pg done after 110 at Mon Aug 4 01:43:48 AM UTC 2025
--- postgres 18beta2
pg_vac starts at Tue Aug 5 07:44:21 AM UTC 2025 with sleep_secs = 110
nr is :: 50000000 :: and ntabs is :: 1 ::
vac_args is (verbose, analyze, index_cleanup ON)
After load: wait for vacuum 0
Checkpoint started at Tue Aug 5 07:44:30 AM UTC 2025
CHECKPOINT
Checkpoint done at Tue Aug 5 07:44:45 AM UTC 2025
Sleep 86
vac_pg done after 110 at Tue Aug 5 07:46:11 AM UTC 2025
--- postgres 18beta3
pg_vac starts at Sat Aug 16 05:34:47 AM UTC 2025 with sleep_secs = 110
nr is :: 50000000 :: and ntabs is :: 1 ::
vac_args is (verbose, analyze, index_cleanup ON)
After load: wait for vacuum 0
Checkpoint started at Sat Aug 16 05:34:52 AM UTC 2025
CHECKPOINT
Checkpoint done at Sat Aug 16 05:35:07 AM UTC 2025
Sleep 90
vac_pg done after 110 at Sat Aug 16 05:36:37 AM UTC 2025
--- Postgres 17.5
INFO: vacuuming "ib.public.sbtest1"
INFO: launched 0 parallel vacuum workers for index vacuuming (planned: 1)
INFO: finished vacuuming "ib.public.sbtest1": index scans: 1
pages: 0 removed, 1456722 remain, 1456722 scanned (100.00% of total)
tuples: 214621 removed, 50000000 remain, 0 are dead but not yet removable
removable cutoff: 98494381, which was 0 XIDs old when operation ended
new relfrozenxid: 72066772, which is 24494677 XIDs ahead of previous value
frozen: 28 pages from table (0.00% of total) had 981 tuples frozen
index scan needed: 1148577 pages from table (78.85% of total) had 2079847 dead item identifiers removed
index "sbtest1_pkey": pages: 137099 in total, 0 newly deleted, 0 currently deleted, 0 reusable
index "k_1": pages: 120388 in total, 0 newly deleted, 0 currently deleted, 0 reusable
I/O timings: read: 0.000 ms, write: 0.000 ms
avg read rate: 0.000 MB/s, avg write rate: 134.986 MB/s
buffer usage: 4320102 hits, 0 misses, 230454 dirtied
WAL usage: 2926126 records, 346 full page images, 179686265 bytes
system usage: CPU: user: 12.35 s, system: 0.93 s, elapsed: 13.33 s
INFO: analyzing "public.sbtest1"
INFO: "sbtest1": scanned 30000 of 1456722 pages, containing 1029524 live rows and 0 dead rows; 30000 rows in sample, 49991009 estimated total rows
VACUUM
--- Postgres 18beta2
INFO: vacuuming "ib.public.sbtest1"
INFO: launched 0 parallel vacuum workers for index vacuuming (planned: 1)
INFO: finished vacuuming "ib.public.sbtest1": index scans: 1
pages: 0 removed, 1449831 remain, 1372754 scanned (94.68% of total), 43580 eagerly scanned
tuples: 66935 removed, 50013808 remain, 0 are dead but not yet removable
removable cutoff: 96799663, which was 0 XIDs old when operation ended
frozen: 9 pages from table (0.00% of total) had 324 tuples frozen
visibility map: 238334 pages set all-visible, 556 pages set all-frozen (3 were all-visible)
index scan needed: 142417 pages from table (9.82% of total) had 148962 dead item identifiers removed
index "sbtest1_pkey": pages: 137099 in total, 0 newly deleted, 0 currently deleted, 0 reusable
index "k_1": pages: 120393 in total, 0 newly deleted, 0 currently deleted, 0 reusable
I/O timings: read: 0.000 ms, write: 0.000 ms
avg read rate: 0.000 MB/s, avg write rate: 20.945 MB/s
buffer usage: 3146074 hits, 0 reads, 22489 dirtied
WAL usage: 623656 records, 280 full page images, 37427641 bytes, 0 buffers full
system usage: CPU: user: 7.51 s, system: 0.87 s, elapsed: 8.38 s
INFO: analyzing "public.sbtest1"
INFO: "sbtest1": scanned 30000 of 1449831 pages, containing 1034430 live rows and 0 dead rows; 30000 rows in sample, 49991623 estimated total rows
INFO: finished analyzing table "ib.public.sbtest1"
I/O timings: read: 0.000 ms, write: 0.000 ms
avg read rate: 0.000 MB/s, avg write rate: 0.118 MB/s
buffer usage: 30313 hits, 0 reads, 3 dirtied
WAL usage: 43 records, 0 full page images, 23403 bytes, 0 buffers full
system usage: CPU: user: 0.19 s, system: 0.00 s, elapsed: 0.19 s
VACUUM
--- postgres 18beta3
INFO: vacuuming "ib.public.sbtest1"
INFO: launched 0 parallel vacuum workers for index vacuuming (planned: 1)
INFO: finished vacuuming "ib.public.sbtest1": index scans: 1
pages: 0 removed, 1453807 remain, 594059 scanned (40.86% of total), 0 eagerly scanned
tuples: 38765 removed, 50022146 remain, 0 are dead but not yet removable
removable cutoff: 95775289, which was 0 XIDs old when operation ended
frozen: 0 pages from table (0.00% of total) had 0 tuples frozen
visibility map: 70566 pages set all-visible, 192 pages set all-frozen (0 were all-visible)
index scan needed: 43776 pages from table (3.01% of total) had 44411 dead item identifiers removed
index "sbtest1_pkey": pages: 137098 in total, 0 newly deleted, 0 currently deleted, 0 reusable
index "k_1": pages: 120437 in total, 0 newly deleted, 0 currently deleted, 0 reusable
I/O timings: read: 0.000 ms, write: 0.000 ms
avg read rate: 0.000 MB/s, avg write rate: 5.279 MB/s
buffer usage: 1490042 hits, 0 reads, 3791 dirtied
WAL usage: 227971 records, 0 full page images, 12744034 bytes, 0 buffers full
system usage: CPU: user: 4.88 s, system: 0.72 s, elapsed: 5.61 s
INFO: analyzing "public.sbtest1"
INFO: "sbtest1": scanned 30000 of 1453807 pages, containing 1031106 live rows and 0 dead rows; 30000 rows in sample, 49967637 estimated total rows
INFO: finished analyzing table "ib.public.sbtest1"
I/O timings: read: 0.000 ms, write: 0.000 ms
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 30322 hits, 0 reads, 0 dirtied
WAL usage: 42 records, 0 full page images, 23315 bytes, 0 buffers full
system usage: CPU: user: 0.18 s, system: 0.03 s, elapsed: 0.21 s
VACUUM
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment