Add more logging instruments to CI pipeline creation

What does this MR do and why?

This MR adds more logging instruments to the CI pipeline creation process.

We log the total of content fetching but we don't log what type of files consume the most time. This will help us to debug the slowness of pipeline content fetching.

Related to: #344829 (comment 960358538)

MR acceptance checklist

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

• I have evaluated the MR acceptance checklist for this MR.