tim_wilson <tim.wilson@xxxxxxxxxxx> writes: > Thanks for you response Tom: > but what does index_scans:0 mean? vs index scans: 1? I believe the former means that VACUUM found no removable tuples, so it had no need to make any passes over the table's indexes. (Ordinarily you wouldn't see the number of scans as more than 1, unless VACUUM removed quite a lot of dead tuples, more than it could remember within maintenance_work_mem; in which case it would make multiple passes over the indexes to remove index entries.) regards, tom lane
