feat: log total bytes gathered when max scatter-gather bytes limit is reached

[TessaIO]

Fixes #18840.

Description

log total bytes gathered when max scatter-gather bytes limit is reached

Release note

---

log total bytes gathered when max scatter-gather bytes limit is reached

---

This PR has:

• [x] been self-reviewed.
  • [ ] using the concurrency checklist (Remove this item if the PR doesn't have any relation to concurrency.)
• [x] added documentation for new or modified features or behaviors.
• [x] a release note entry in the PR description.
• [x] added Javadocs for most classes and all non-trivial methods. Linked related entities via Javadoc links.
• [x] added or updated version, license, or notice information in licenses.yaml
• [x] added comments explaining the "why" and the intent of the code wherever would not be obvious for an unfamiliar reader.
• [x] added unit tests or modified existing tests to cover new code paths, ensuring the threshold for code coverage is met.
• [x] added integration tests.
• [x] been tested in a test Druid cluster.

[TessaIO]

@abhishekrb19 thanks for the suggestion, I think it would be cleaner if the test coverage is addressed in a separate PR as this one is solely focused on improving the logs. wdyt?

[TessaIO]

@abhishekrb19 thanks for the review, updated!

[TessaIO]

@abhishekrb19 done