Feature request: register pprof endpoint for profiling usage

[dentiny]

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: #176

Thank you!