# CreateAutomaticDiagnosisJob

- **Period:** 23 Jun 10:09 UTC – 23 Jun 13:28 UTC
- **Throughput**: 0.33 / min
- **Average:** 2700.4 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/jobs/create_automatic_diagnosis_job.rb:2 | 1978.7 | 1.0 | 73.27% | `CreateAutomaticDiagnosisJob#perform` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:50 | 215.92 | 0.94 | 7.51% | `SELECT "facilities".* FROM "facilities" WHERE "facilities"."siret" = ? LIMIT ?` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:22 | 117.75 | 0.97 | 4.23% | `SELECT "companies".* FROM "companies" WHERE "companies"."siren" = ? LIMIT ?` |
| sql | app/models/expert.rb:256 | 94.17 | 0.89 | 3.12% | `SELECT "experts"."id" FROM "experts" LEFT OUTER JOIN "antennes" ON "antennes"."…` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:53 | 32.63 | 1.82 | 2.20% | `SELECT ? AS one FROM "facilities" WHERE "facilities"."siret" = ? LIMIT ? INSERT…` |
| gc | ruby/gc.c | 44.4 | 1.26 | 2.07% | `GC.start` |
| sql | app/models/expert.rb:247 | 32.68 | 0.89 | 1.08% | `SELECT "experts"."id" FROM "experts" INNER JOIN "territorial_zones" ON "territo…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/jobs/CreateAutomaticDiagnosisJob?range=2026-06-23+10%3A09%3A45+UTC..2026-06-23+13%3A28%3A11+UTC)