Migrate metricsdb to clickhouse

We need to migrate metricsdb from our existing PostgreSQL database to ClickHouse to improve query performance and scalability for our pipelines and workloads. This issue tracks the planning, execution, and verification steps of the migration process.