Created
August 26, 2025 19:20
-
-
Save mdcallag/56bdde9d321d5d498c8e209f8fc32ad1 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- 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, 298234 remain, 298058 scanned (99.94% of total) | |
| tuples: 10624 removed, 10004525 remain, 0 are dead but not yet removable | |
| removable cutoff: 1450147223, which was 1 XIDs old when operation ended | |
| frozen: 2889 pages from table (0.97% of total) had 86232 tuples frozen | |
| index scan needed: 132758 pages from table (44.51% of total) had 170893 dead item identifiers removed | |
| index "sbtest1_pkey": pages: 27434 in total, 0 newly deleted, 0 currently deleted, 0 reusable | |
| index "k_1": pages: 48575 in total, 0 newly deleted, 465 currently deleted, 465 reusable | |
| 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: 805538 hits, 0 misses, 0 dirtied | |
| WAL usage: 409094 records, 0 full page images, 23566320 bytes | |
| system usage: CPU: user: 2.26 s, system: 0.48 s, elapsed: 2.83 s | |
| INFO: analyzing "public.sbtest1" | |
| INFO: "sbtest1": scanned 30000 of 298234 pages, containing 1005940 live rows and 0 dead rows; 30000 rows in sample, 10000184 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, 298324 remain, 297119 scanned (99.60% of total), 8867 eagerly scanned | |
| tuples: 6353 removed, 10020689 remain, 0 are dead but not yet removable | |
| removable cutoff: 1446785447, which was 0 XIDs old when operation ended | |
| frozen: 720 pages from table (0.24% of total) had 21791 tuples frozen | |
| visibility map: 87107 pages set all-visible, 1761 pages set all-frozen (511 were all-visible) | |
| index scan needed: 55543 pages from table (18.62% of total) had 60965 dead item identifiers removed | |
| index "sbtest1_pkey": pages: 27500 in total, 0 newly deleted, 0 currently deleted, 0 reusable | |
| index "k_1": pages: 48436 in total, 0 newly deleted, 351 currently deleted, 351 reusable | |
| 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: 726281 hits, 0 reads, 0 dirtied | |
| WAL usage: 208857 records, 0 full page images, 11720552 bytes, 0 buffers full | |
| system usage: CPU: user: 1.76 s, system: 0.40 s, elapsed: 2.16 s | |
| INFO: analyzing "public.sbtest1" | |
| INFO: "sbtest1": scanned 30000 of 298324 pages, containing 1004924 live rows and 0 dead rows; 30000 rows in sample, 9993098 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: 30281 hits, 0 reads, 0 dirtied | |
| WAL usage: 43 records, 0 full page images, 23330 bytes, 0 buffers full | |
| system usage: CPU: user: 0.17 s, system: 0.01 s, elapsed: 0.18 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, 297214 remain, 295367 scanned (99.38% of total), 6450 eagerly scanned | |
| tuples: 20959 removed, 10062140 remain, 0 are dead but not yet removable | |
| removable cutoff: 1429041396, which was 4 XIDs old when operation ended | |
| new relfrozenxid: 1379041838, which is 3522288 XIDs ahead of previous value | |
| frozen: 16101 pages from table (5.42% of total) had 487270 tuples frozen | |
| visibility map: 279714 pages set all-visible, 17895 pages set all-frozen (599 were all-visible) | |
| index scan needed: 246075 pages from table (82.79% of total) had 485569 dead item identifiers removed | |
| index "sbtest1_pkey": pages: 27429 in total, 0 newly deleted, 0 currently deleted, 0 reusable | |
| index "k_1": pages: 48430 in total, 0 newly deleted, 353 currently deleted, 353 reusable | |
| I/O timings: read: 0.000 ms, write: 0.000 ms | |
| avg read rate: 0.000 MB/s, avg write rate: 0.006 MB/s | |
| buffer usage: 913234 hits, 0 reads, 3 dirtied | |
| WAL usage: 632304 records, 3 full page images, 38852406 bytes, 1321 buffers full | |
| system usage: CPU: user: 2.78 s, system: 0.84 s, elapsed: 3.85 s | |
| INFO: analyzing "public.sbtest1" | |
| INFO: "sbtest1": scanned 30000 of 297214 pages, containing 1009381 live rows and 0 dead rows; 30000 rows in sample, 10000072 estimated total rows | |
| INFO: finished analyzing table "ib.public.sbtest1" | |
| I/O timings: read: 0.000 ms, write: 0.049 ms | |
| avg read rate: 0.000 MB/s, avg write rate: 0.082 MB/s | |
| buffer usage: 30280 hits, 0 reads, 2 dirtied | |
| WAL usage: 42 records, 0 full page images, 23238 bytes, 0 buffers full | |
| system usage: CPU: user: 0.18 s, system: 0.00 s, elapsed: 0.18 s | |
| VACUUM |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment