[PR] Add local VACUUM resource reporting through ext_vacuum_statistics [cloudberry]

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

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

   ### What does this PR do?
   
   Add ext_vacuum_statistics to accumulate and expose VACUUM resource usage for
   heap tables, indexes and databases.
   
   Connect the core instrumentation to a custom cumulative statistics kind.
   Expose buffer activity, I/O timing, WAL usage and basic vacuum work through
   local views in the ext_vacuum_statistics schema.
   
   Provide collection control, privileged reset functions, clean-shutdown
   persistence and transactional cleanup of statistics for dropped objects.
   Preserve counters when DROP is rolled back and prevent stale statistics
   from being reused with an object's OID.
   
   ### Impact
   Makes cumulative VACUUM resource usage available through SQL for each table, index and database. Comparing buffer activity, WAL generation and I/O time with native work counters helps identify expensive relations and assess the cost of vacuuming them.
   Resource collection and resets are independent of native work statistics, allowing separate measurement intervals without duplicating counters or clearing core statistics.
   
   ### 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
   
   ### Breaking Changes
   <!-- Remove if not applicable. If yes, explain impact and migration path -->
   
   ### 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