Filter build by partition_id

What does this MR do and why?

Ref: #423054 (closed)

What does this MR do and why?

Following up !137553 (merged)

This MR allows to make sure we always fetch a given build record in the proper partition where the data is in by including partition_id in the where clause for the following models:

• Ci::Pipeline#downstream_bridges.any?
• Ci::BuildDependencies

This will allow us to take advantage of partition pruning and select the right partition automatically without scanning all of them.

Example of updated query

SELECT 1 AS one
FROM "p_ci_builds"
WHERE "p_ci_builds"."type" = 'Ci::Bridge'
AND "p_ci_builds"."upstream_pipeline_id" = 561
+ AND "p_ci_builds"."partition_id" = 100
LIMIT 1

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.