[Subtask]: Implement table self-optimizing metric collection

[hameizi]

Search before asking

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

Description

Implement table self-optimizing metric collection

Design: https://docs.google.com/document/d/1PL2Dbcd3ChnXo8872ffzgoGYYX7CO7qSUWXc5rYO4MU/edit#heading=h.4boepjbyxjk7

Parent issue

#1528

Are you willing to submit PR?

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

Code of Conduct

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

[huyuanfeng2018]

I can try this, plz Assignees me