Do not scan entire /var/opt/gitlab for stale pids (16.6 backport)

What does this MR do and why?

Backport !7264 (merged) to %16.6.

Related issues

Relates #8323 (closed)

Relates #6926

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• This MR is backporting a bug fix, documentation update, or spec fix, previously merged in the default branch. !7264 (merged)
• The original MR has been deployed to GitLab.com (not applicable for documentation or spec changes). workflowproduction
• This MR has a severity label assigned (if applicable). severity1

Note to the merge request author and maintainer

The process of backporting bug fixes into stable branches is tracked as part of an internal pilot. If you have questions about this process, please:

• Refer to the internal pilot issue for feedback or questions.
• Refer to the patch release runbook for engineers and maintainers for guidance.