[Subtask]: Add support for Metadata Metric-Driven refresh event

[Jzjsnow]

Search before asking

• [x] I have searched in the issues and found no similar issues.

Description

Introduce event-driven metrics from loaded metadata to determine if scans are needed.

• Analyze partition file size MSE from the loaded metadata.
• Trigger scans only if metrics indicate optimization necessity.

Parent issue

#3774

Are you willing to submit PR?

• [x] Yes I am willing to submit a PR!

Code of Conduct

• [x] I agree to follow this project's Code of Conduct