Refactor the code needed to dump python profiles into the `Debugging`
module and re-use it in legacy athena and CA. The dump of the temporary
profile for `--drop-and-reload` is no longer needed either if we dump
the profile before the reload (and the second part of the job has no
interesting profile data anyway).