2025-08-08 15:08: CPU pressure spike on the primary node for ci database

source

There is a spike in planning time for couple of queires

source

• 5203370346919232571

  /*application:web,correlation_id:0c0efd634e06c4da4bfb14323f9da892,db_config_database:gitlabhq_production,db_config_name:ci_replica*/ SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."coverage", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."commit_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."project_id", "p_ci_builds"."runner_id", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."user_id", "p_ci_builds"."execution_config_id", "p_ci_builds"."upstream_pipeline_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."token_encrypted" IN ($2, $3) LIMIT $4

• 3034279205402869503

  /*application:sidekiq,correlation_id:3c25c2660a19357faa1e9a5965117adc,jid:5b8170f809d0ede01d464b73,endpoint_id:Ci::DestroyOldPipelinesWorker,db_config_database:gitlabhq_production_sidekiq,db_config_name:ci_replica*/ WITH RECURSIVE "base_and_ancestors" AS ((SELECT "p_ci_pipelines".* FROM "p_ci_pipelines" WHERE "p_ci_pipelines"."id" = $1)
  UNION
  (SELECT "p_ci_pipelines".* FROM "p_ci_pipelines", "base_and_ancestors", "ci_sources_pipelines" WHERE "ci_sources_pipelines"."source_pipeline_id" = "p_ci_pipelines"."id" AND "ci_sources_pipelines"."pipeline_id" = "base_and_ancestors"."id" AND $2)), "base_and_descendants" AS ((SELECT "p_ci_pipelines".* FROM "p_ci_pipelines" WHERE "p_ci_pipelines"."id" = $3)
  UNION
  (SELECT "p_ci_pipelines".* FROM "p_ci_pipelines", "base_and_descendants", "ci_sources_pipelines" WHERE "ci_sources_pipelines"."pipeline_id" = "p_ci_pipelines"."id" AND "ci_sources_pipelines"."source_pipeline_id" = "base_and_descendants"."id" AND $4)) SELECT "p_ci_pipelines".* FROM ((SELECT "p_ci_pipelines".* FROM "base_and_ancestors" AS "p_ci_pipelines")
  UNION
  (SELECT "p_ci_pipelines".* FROM "base_and_descendants" AS "p_ci_pipelines")) p_ci_pipelines