On Mon, Mar 8, 2021, at 2:32 AM, Masahiko Sawada wrote: > * Proposed idea > LOG: automatic vacuum of table "postgres.public.test": index scans: 1 > pages: 0 removed, 443 remain, 0 skipped due to pins, 0 skipped frozen > tuples: 1000 removed, 99000 remain, 0 are dead but not yet removable, > oldest xmin: 545 > indexes: "postgres.public.test_idx1" 276 pages, 0 newly deleted, 0 > currently deleted, 0 reusable. > "postgres.public.test_idx2" 300 pages, 10 newly deleted, 0 currently > deleted, 3 reusable. > "postgres.public.test_idx2" 310 pages, 4 newly deleted, 0 currently > deleted, 0 reusable. Instead of using "indexes:" and add a list of indexes (one on each line), it would be more parse-friendly if it prints one index per line using 'index "postgres.public.idxname" 123 pages, 45 newly deleted, 67 currently deleted, 8 reusable.'.
> It still lacks some of what VACUUM VERBOSE shows (e.g., each index > vacuum execution time etc) but it would be enough information to know > the index page statistics. Probably we can output those by default > without adding a new parameter controlling that. Perfect is the enemy of the good. Let start with this piece of information. -- Euler Taveira EDB https://www.enterprisedb.com/
