[PR] Add native VACUUM work statistics [cloudberry]

["Alena0704 (via GitHub)" <gi...@apache.org>]

Alena0704 opened a new pull request, #2105:
URL: https://github.com/apache/cloudberry/pull/2105

   ### What does this PR do?
   
   Make VACUUM work available through native cumulative statistics for tables,
   indexes and databases.
   
   Collect tuple removal, remaining and missed dead tuples, scanned and removed
   pages, freezing work, newly all-visible pages, and freeze-age-driven vacuums.
   For append-optimized tables, collect segment counts, completed compactions,
   moved tuples and remaining hidden rows.
   
   Report index work as per-call deltas and correct SP-GiST accounting for
   previously empty pages. Database totals exclude separate index reports to
   avoid double counting.
   
   Store dead_tuples and total_file_segs as last-run samples; other work counters
   accumulate. Use ordinary statistics snapshots, resets, DROP handling and
   clean-shutdown persistence.
   
   Measurement, cumulative storage, and catalog functions/views are introduced
   in separate commits.
   
   ### Impact
   
   Makes VACUUM work statistics available for heap, AO/AOCO tables and indexes
   without an extension. Native cumulative counters are updated when
   track_counts is enabled and exposed through local and cluster-wide views.
   
   Adds counter maintenance during VACUUM and increases relation and database
   statistics entry sizes. Bumps the catalog and cumulative-statistics file
   versions; development clusters initialized with the previous catalog version
   require initdb.
   
   ### Type of Change
   - [ ] Bug fix (non-breaking change)
   - [x] New feature (non-breaking change)
   - [ ] Breaking change (fix or feature with breaking changes)
   - [x] Documentation update
   
   ### Test Plan
   <!-- How did you test these changes? -->
   - [ ] Unit tests added/updated
   - [x] Integration tests added/updated
   - [ ] Passed `make installcheck`
   - [ ] Passed `make -C src/test installcheck-cbdb-parallel`
   
   ### Checklist
   - [x] Followed [contribution guide](https://cloudberry.apache.org/contribute/code)
   - [ ] Added/updated documentation
   - [ ] Reviewed code for security implications
   - [ ] This PR contains AI-assisted code generation
   - [ ] Requested review from [cloudberry committers](https://github.com/orgs/apache/teams/cloudberry-committers)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org