Report the number of skipped frozen pages by manual VACUUM
Masahiko Sawada <sawada.mshk@gmail.com>
From: Masahiko Sawada <sawada.mshk@gmail.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2017-02-23T16:30:50Z
Lists: pgsql-hackers
Attachments
- report_frozen_skipped_pages_v1.patch (application/octet-stream) patch v1
Hi all, The autovacuum reports the number of skipped frozen pages to the VACUUM output. But these information is not appeared by manual VACUUM. This information is useful for the user to check efficiency of VACUUM. Attached patch add this information to VACUUM output. * Example =# VACUUM VERBOSE test INFO: vacuuming "public.test" INFO: "test": found 0 removable, 56 nonremovable row versions in 1 out of 45 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. Skipped 0 pages due to buffer pins, 44 frozen pages. 0 pages are entirely empty. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. VACUUM I'll register it to next CF. Regards, -- Masahiko Sawada NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
Commits
-
Make VACUUM VERBOSE report the number of skipped frozen pages.
- 70adf2fbe18f 10.0 landed
-
Allow vacuums to report oldestxmin
- 9eb344faf54a 10.0 cited