# CreateAutomaticDiagnosisJob

- **Period:** 24 Jun 05:20 UTC – 24 Jun 06:19 UTC
- **Throughput**: 0.02 / min
- **Average:** 3048.2 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/jobs/create_automatic_diagnosis_job.rb:2 | 2090.0 | 1.0 | 68.56% | `CreateAutomaticDiagnosisJob#perform` |
| sql | app/models/expert.rb:256 | 417.0 | 1.0 | 13.68% | `SELECT "experts"."id" FROM "experts" LEFT OUTER JOIN "antennes" ON "antennes"."…` |
| sql | app/models/expert.rb:247 | 93.0 | 1.0 | 3.05% | `SELECT "experts"."id" FROM "experts" INNER JOIN "territorial_zones" ON "territo…` |
| sql | app/services/diagnosis_creation/find_relevant_expert_subjects.rb:36 | 77.0 | 1.0 | 2.53% | `SELECT "experts_subjects".* FROM "experts_subjects" INNER JOIN "experts" ON "ex…` |
| gc | ruby/gc.c | 52.0 | 1.0 | 1.71% | `GC.start` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:53 | 48.0 | 1.0 | 1.57% | `SELECT ? AS one FROM "facilities" WHERE "facilities"."siret" = ? AND "facilitie…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/jobs/CreateAutomaticDiagnosisJob?range=1h)