# Annuaire::UsersController#create_territorial_coverage

- **Period:** 24 Jun 02:11 UTC – 24 Jun 08:10 UTC
- **Throughput**: 0.02 / min
- **Average:** 125.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/annuaire/users_controller.rb:66 | 37.43 | 1.0 | 29.92% | `Annuaire::UsersController#create_territorial_coverage` |
| sql | app/controllers/annuaire/users_controller.rb:148 | 1.97 | 5.0 | 7.88% | `SELECT experts.*, antennes.name as antenne_name FROM "experts" INNER JOIN "ante…` |
| sql | app/services/create_territorial_coverage.rb:23 | 2.64 | 2.0 | 4.23% | `SELECT "themes".* FROM "themes" INNER JOIN "subjects" ON "themes"."id" = "subje…` |
| sql | app/services/create_territorial_coverage.rb:120 | 2.5 | 2.0 | 4.00% | `SELECT "institutions".* FROM "institutions" WHERE "institutions"."id" = ? LIMIT…` |
| sql | app/services/create_territorial_coverage.rb:262 | 4.14 | 1.0 | 3.31% | `SELECT "cooperations".* FROM "cooperations" INNER JOIN "cooperation_themes" ON …` |
| queue | queue | 3.57 | 1.0 | 2.86% |  |
| sql | app/controllers/annuaire/users_controller.rb:115 | 3.57 | 1.0 | 2.86% | `SELECT "antennes".* FROM "antennes" LEFT OUTER JOIN "experts" ON "experts"."del…` |
| cache | app/models/concerns/with_territorial_zones.rb:29 | 1.2 | 2.86 | 2.74% | `read` |
| sql | app/services/create_territorial_coverage.rb:32 | 1.64 | 2.0 | 2.63% | `SELECT DISTINCT "experts".* FROM "experts" INNER JOIN "experts_subjects" ON "ex…` |
| sql | app/services/create_territorial_coverage.rb:54 | 0.82 | 4.0 | 2.63% | `SELECT "experts".* FROM "experts" INNER JOIN "experts_subjects" ON "experts"."i…` |
| sql | app/services/create_territorial_coverage.rb:73 | 3.29 | 1.0 | 2.63% | `SELECT "experts"."id" AS t0_r0, "experts"."email" AS t0_r1, "experts"."phone_nu…` |
| redis | app/models/concerns/with_territorial_zones.rb:29 | 1.5 | 2.0 | 2.40% | `get` |
| sql | app/models/expert.rb:147 | 2.86 | 1.0 | 2.28% | `SELECT "experts"."id" FROM "experts" INNER JOIN "experts_subjects" ON "experts"…` |
| sql | app/models/concerns/with_territorial_zones.rb:27 | 1.0 | 2.86 | 2.28% | `SELECT "territorial_zones"."id" FROM "territorial_zones" WHERE "territorial_zon…` |
| sql | app/controllers/annuaire/users_controller.rb:99 | 1.36 | 2.0 | 2.17% | `SELECT ? AS one FROM "experts" INNER JOIN "experts_users" ON "experts"."id" = "…` |
| sql | app/services/create_territorial_coverage.rb:290 | 1.36 | 2.0 | 2.17% | `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ? SELECT ? …` |
| redis | app/controllers/annuaire/users_controller.rb:68 | 1.29 | 2.0 | 2.06% | `get` |
| gc | ruby/gc.c | 6.0 | 0.43 | 2.06% | `GC.start` |
| sql | app/controllers/annuaire/users_controller.rb:130 | 2.43 | 1.0 | 1.94% | `SELECT "antennes".* FROM "antennes" WHERE "antennes"."institution_id" = ? AND "…` |
| sql | app/controllers/annuaire/users_controller.rb:98 | 2.0 | 1.0 | 1.60% | `SELECT DISTINCT "users".* FROM "users" INNER JOIN "user_rights" ON "users"."id"…` |
| sql | vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158 | 1.86 | 1.0 | 1.48% | `SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC …` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104 | 1.43 | 1.0 | 1.14% | `Rack::Attack` |
| sql | app/controllers/annuaire/users_controller.rb:88 | 1.43 | 1.0 | 1.14% | `SELECT "users".* FROM "users" LEFT OUTER JOIN experts_users ON experts_users.us…` |
| sql | app/controllers/annuaire/base_controller.rb:8 | 1.43 | 1.0 | 1.14% | `SELECT "institutions".* FROM "institutions" WHERE "institutions"."slug" = ? LIM…` |
| sql | app/models/user.rb:326 | 1.43 | 1.0 | 1.14% | `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_…` |
| sql | app/services/create_territorial_coverage.rb:121 | 1.29 | 1.0 | 1.03% | `SELECT "antennes"."id" FROM "antennes" WHERE "antennes"."deleted_at" IS NULL AN…` |
| sql | app/controllers/annuaire/users_controller.rb:67 | 1.29 | 1.0 | 1.03% | `SELECT "institutions_subjects".* FROM "institutions_subjects" WHERE "institutio…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/Annuaire::UsersController%23create_territorial_coverage?range=6h)