cli: add signal handler to launch pprof endpoints

[cockroach-teamcity]

cockroachdb/cockroach#75678 --- Release note (ops change): sending a cockroach process, including one running a client command, a SIGUSR2 signal now causes it to open an http port that is serving the basic go performance inspection endpoints for use with pprof.

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB docs!