NPM metadata endpoints: high CPU duration

🔥 Problem

This Kibana dashboard suggests that, on several occurences, the cpu_s is > than db_duration_s. This means that the backend is spending quite a large amount of time in executing its logic.

This happens in the npm Registry metadata endpoints at both levels: project and instance.

This is impact quite largely the grouppackage registry error budget.

🚒 Solution

• Investigation where the time is spent and check if it can be optimized.