[Feature]: Add metric collection for ams

[hameizi]

Description

We will add metric collection for AMS to provide more metrics to describe the states of tables and optimizer, among others.

Use case/motivation

No response

Describe the solution

https://docs.google.com/document/d/1FS3yskgiZCH2WQkLyOTvtMX6RcakgzyzzooQ31wGdNI/edit#

Subtasks

Metric Framework

• [Subtask]: Add metric collection API #1765

Metric Collection

• [Subtask]: Implement table self-optimizing metric collection #1766
• [Subtask]: Implement optimizer-group metric collection #1769
• [Subtask]: Table refresh metric collection #2495

Metric Reporter

• [Subtask]: Implement Promethues Exporter as MetricReport plugin #2494

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

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

[shidayang]

@zhongqishang cc

[baiyangtx]

Metrics design for table self-optimizing https://docs.google.com/document/d/1PL2Dbcd3ChnXo8872ffzgoGYYX7CO7qSUWXc5rYO4MU/edit

[zhoujinsong]

Close as completed.