# Conseiller::Diagnoses::StepsController#update_matches

- **Period:** 23 Jun 06:34 UTC – 24 Jun 06:33 UTC
- **Throughput**: 0.09 / min
- **Average:** 108.0 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/conseiller/diagnoses/steps_controller.rb:56 | 4.43 | 6.87 | 28.18% | `BEGIN SELECT "needs".* FROM "needs" WHERE "needs"."diagnosis_id" = ? AND "needs…` |
| sql | app/controllers/conseiller/diagnoses/steps_controller.rb:58 | 5.15 | 4.0 | 19.08% | `SELECT "landings".* FROM "landings" WHERE "landings"."id" = ? LIMIT ? SELECT "l…` |
| code | app/controllers/conseiller/diagnoses/steps_controller.rb:49 | 20.46 | 1.0 | 18.95% | `Conseiller::Diagnoses::StepsController#update_matches` |
| sql | app/models/diagnosis.rb:159 | 12.11 | 1.0 | 11.21% | `UPDATE "matches" "__active_record_update_alias" SET "sent_at" = ? FROM "matches…` |
| sql | app/models/expert.rb:316 | 2.74 | 1.57 | 3.99% | `SELECT COUNT(*) FROM (SELECT ? AS one FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/models/concerns/mandatory_answers.rb:30 | 0.64 | 4.85 | 2.87% | `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ? SELECT "s…` |
| queue | queue | 1.22 | 1.0 | 1.13% |  |

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