Feature request: register pprof endpoint for profiling usage

Hi team, we've deployed clickhouse with this clickhouse operator in production.
Sometime we suffered OOM for CH metrics collector sidecar container, so I'm wondering if we could register pprof HTTP endpoint, so we could easily profile the process when needed?

• pprof is the standard package golang provides: https://pkg.go.dev/net/http/pprof
• There's no runtime performance or resource impact when no profiling request, in other words, it's request-based
• It provides a few useful information to inspect the process, including but not confined to memory, CPU, mutex, etc

I found others also met OOM issue in the past, which I believe also benefits from pprof endpoint: https://github.com/Altinity/clickhouse-operator/issues/176

Thank you!

Start by locating the Go HTTP server or metrics endpoint used by the operator and its ClickHouse metrics collector sidecar. Read the net/http/pprof documentation and inspect existing endpoint exposure and access controls; done means a pprof endpoint is available for profiling without affecting normal operation when unused.