# Conseiller::Diagnoses::StepsController#matches

- **Period:** 24 Jun 02:14 UTC – 24 Jun 08:13 UTC
- **Throughput**: 0.17 / min
- **Average:** 363.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| view | app/views/conseiller/diagnoses/steps/matches.html.haml | 140.38 | 1.0 | 38.67% |  |
| sql | app/models/expert.rb:256 | 57.45 | 1.08 | 17.14% | `SELECT "experts"."id" FROM "experts" LEFT OUTER JOIN "antennes" ON "antennes"."…` |
| gc | ruby/gc.c | 43.19 | 1.13 | 13.48% | `GC.start` |
| code | app/controllers/conseiller/diagnoses/steps_controller.rb:43 | 19.05 | 1.0 | 5.25% | `Conseiller::Diagnoses::StepsController#matches` |
| sql | app/models/expert.rb:247 | 10.66 | 1.08 | 3.18% | `SELECT "experts"."id" FROM "experts" INNER JOIN "territorial_zones" ON "territo…` |
| sql | app/services/diagnosis_creation/find_relevant_expert_subjects.rb:36 | 7.72 | 1.08 | 2.30% | `SELECT "experts_subjects".* FROM "experts_subjects" INNER JOIN "experts" ON "ex…` |
| sql | app/models/expert_subject.rb:99 | 0.82 | 9.15 | 2.07% | `SELECT "match_filters".* FROM "match_filters" INNER JOIN "experts" ON "match_fi…` |
| view | app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml | 4.28 | 1.0 | 1.18% |  |
| view | app/views/conseiller/diagnoses/steps/_expert_content.html.haml | 1.88 | 2.27 | 1.18% |  |
| sql | app/views/conseiller/diagnoses/steps/_expert_content.html.haml:7 | 1.78 | 2.27 | 1.11% | `SELECT "users".* FROM "users" INNER JOIN "experts_users" ON "users"."id" = "exp…` |
| sql | app/services/diagnosis_creation/find_relevant_expert_subjects.rb:31 | 0.95 | 3.95 | 1.03% | `SELECT ? AS one FROM "subject_answer_groupings" INNER JOIN "subject_answers" ON…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/Conseiller::Diagnoses::StepsController%23matches?range=6h)