Place des Entreprises Prod

.MD

Annuaire::UsersController#import_create

…

Most impactful sections

code49%
sql45%
gc4%
rack1%
unknown<1%
view<1%
queue<1%
cache<1%
redis<1%


code app/controllers/annuaire/users_controller.rb:55	49%
Average Self 1,015ms Average calls 1x Total Self 1,015ms Total Children 954ms Total runtime 1,970ms `Annuaire::UsersController#import_create`
sql app/services/csv_import/user_importer.rb:109	12%
Average Self 0.48ms Average calls 540x Total Self 258ms Total Children 0ms Total runtime 258ms `SELECT "experts_subjects".* FROM "experts_subjects" WHERE "experts_subjects"."expert_id" = ? AND "experts_subjects"."institution_subject_id" = ? LIMIT ?`
sql app/services/csv_import/base_importer.rb:40	8%
Average Self 0.95ms Average calls 181x Total Self 173ms Total Children 0ms Total runtime 173ms SELECT "user_rights".* FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? UPDATE "users" SET "updated_at" = ?, "job" = ?, "imported_at" = ? WHERE "users"."id" = ? UPDATE "users" SET "updated_at" = ?, "imported_at" = ? WHERE "users"."id" = ? UPDATE "users" SET "updated_at" = ?, "full_name" = ?, "imported_at" = ? WHERE "users"."id" = ? UPDATE "users" SET "updated_at" = ?, "job" = ?, "full_name" = ?, "imported_at" = ? WHERE "users"."id" = ? SELECT ? AS one FROM "users" WHERE "users"."email" = ? LIMIT ? INSERT INTO "users" ("email", "encrypted_password", "reset_password_token", "reset_password_sent_at", "remember_created_at", "sign_in_count", "current_sign_in_at", "last_sign_in_at", "current_sign_in_ip", "last_sign_in_ip", "created_at", "updated_at", "phone_number", "job", "full_name", "antenne_id", "invitation_token", "invitation_created_at", "invitation_sent_at", "invitation_accepted_at", "invitation_limit", "inviter_id", "invitations_count", "deleted_at", "cgu_accepted_at", "app_info", "demo_invited_at", "absence_start_at", "absence_end_at", "imported_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING "id" UPDATE "users" SET "updated_at" = ?, "phone_number" = ?, "job" = ?, "full_name" = ?, "imported_at" = ? WHERE "users"."id" = ?
sql app/services/csv_import/user_importer.rb:36	7%
Average Self 1.7ms Average calls 91x Total Self 150ms Total Children 0ms Total runtime 150ms `SELECT "users".* FROM "users" WHERE "users"."email" = ? LIMIT ?`
gc ruby/gc.c	4%
Average Self 80ms Average calls 1x Total Self 80ms Total Children 0ms Total runtime 80ms `GC.start`
sql app/models/antenne.rb:292	3%
Average Self 0.68ms Average calls 91x Total Self 62ms Total Children 0ms Total runtime 62ms `SELECT "antennes".* FROM "antennes" WHERE "antennes"."institution_id" = ? AND "antennes"."deleted_at" IS NULL AND (lower(name) = ?) LIMIT ?`
sql app/services/csv_import/user_importer.rb:74	3%
Average Self 0.62ms Average calls 90x Total Self 55ms Total Children 0ms Total runtime 55ms `SELECT "experts".* FROM "experts" INNER JOIN "antennes" ON "experts"."antenne_id" = "antennes"."id" WHERE "antennes"."institution_id" = ? AND "antennes"."deleted_at" IS NULL AND "experts"."deleted_at" IS NULL AND "experts"."email" = ? LIMIT ?`
sql app/services/csv_import/user_importer.rb:21	2%
Average Self 0.55ms Average calls 92x Total Self 51ms Total Children 0ms Total runtime 51ms `BEGIN SELECT "institutions".* FROM "institutions" WHERE "institutions"."name" IS NULL LIMIT ?`
sql app/services/csv_import/user_importer.rb:140	2%
Average Self 0.55ms Average calls 90x Total Self 49ms Total Children 0ms Total runtime 49ms `SELECT "territorial_zones".* FROM "territorial_zones" WHERE "territorial_zones"."zoneable_id" = ? AND "territorial_zones"."zoneable_type" = ?`
sql app/services/csv_import/user_importer.rb:51	2%
Average Self 0.55ms Average calls 89x Total Self 49ms Total Children 0ms Total runtime 49ms `SELECT "experts".* FROM "experts" INNER JOIN "experts_users" ON "experts"."id" = "experts_users"."expert_id" WHERE "experts_users"."user_id" = ? AND "experts"."deleted_at" IS NULL`
sql app/models/user.rb:310	2%
Average Self 0.58ms Average calls 81x Total Self 47ms Total Children 0ms Total runtime 47ms `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/method_override.rb:19	1%
Average Self 22ms Average calls 1x Total Self 22ms Total Children 1,975ms Total runtime 1,997ms `Rack::MethodOverride`
sql app/services/csv_import/user_importer.rb:52	<1%
Average Self 1.7ms Average calls 9.5x Total Self 16ms Total Children 0ms Total runtime 16ms `INSERT INTO "experts_users" ("expert_id", "user_id") VALUES (?, ?)`
sql app/services/csv_import/base_importer.rb:51	<1%
Average Self 0.11ms Average calls 91x Total Self 10ms Total Children 0ms Total runtime 10ms `SELECT "experts_subjects".* FROM "experts_subjects" WHERE "experts_subjects"."expert_id" = ? SELECT "experts".* FROM "experts" INNER JOIN "experts_users" ON "experts"."id" = "experts_users"."expert_id" WHERE "experts_users"."user_id" = ? AND "experts"."deleted_at" IS NULL`
queue queue	<1%
Average Self 7.5ms Average calls 1x Total Self 7.5ms Total Children 0ms Total runtime 7.5ms
sql app/models/institution_subject.rb:95	<1%
Average Self 0.13ms Average calls 42x Total Self 5.5ms Total Children 0ms Total runtime 5.5ms `SELECT "cooperations"."name" FROM "cooperations" INNER JOIN "cooperation_themes" ON "cooperations"."id" = "cooperation_themes"."cooperation_id" WHERE "cooperation_themes"."theme_id" = ?`
sql app/models/institution_subject.rb:86	<1%
Average Self 0.19ms Average calls 18x Total Self 3.5ms Total Children 0ms Total runtime 3.5ms `SELECT "institutions_subjects".* FROM "institutions_subjects" WHERE "institutions_subjects"."institution_id" = ? SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" IN (?) SELECT "themes".* FROM "themes" WHERE "themes"."id" IN (?)`
view app/views/annuaire/base/_import_errors.html.haml	<1%
Average Self 6ms Average calls 0.5x Total Self 3ms Total Children 0ms Total runtime 3ms
view app/views/annuaire/users/import.html.haml	<1%
Average Self 5ms Average calls 0.5x Total Self 2.5ms Total Children 5ms Total runtime 7.5ms
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104	<1%
Average Self 2ms Average calls 1x Total Self 2ms Total Children 1,970ms Total runtime 1,972ms `Rack::Attack`
view app/views/annuaire/base/_header.html.haml	<1%
Average Self 3ms Average calls 0.5x Total Self 1.5ms Total Children 0ms Total runtime 1.5ms
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/tempfile_reaper.rb:16	<1%
Average Self 1.5ms Average calls 1x Total Self 1.5ms Total Children 1,972ms Total runtime 1,973ms `Rack::TempfileReaper`
view app/views/application/_head.html.haml	<1%
Average Self 2ms Average calls 0.5x Total Self 1ms Total Children 1ms Total runtime 2ms
view app/views/application/_navbar.html.haml	<1%
Average Self 1ms Average calls 0.5x Total Self 0.5ms Total Children 0.5ms Total runtime 1ms
view app/views/application/_footer.html.haml	<1%
Average Self 1ms Average calls 0.5x Total Self 0.5ms Total Children 0ms Total runtime 0.5ms
sql app/models/user.rb:326	<1%
Average Self 0.25ms Average calls 2x Total Self 0.5ms Total Children 0ms Total runtime 0.5ms `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?`
sql app/services/csv_import/base_importer.rb:24	<1%
Average Self 0.5ms Average calls 1x Total Self 0.5ms Total Children 0ms Total runtime 0.5ms `ROLLBACK`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-timeout-0.7.0/lib/rack/timeout/core.rb:90	<1%
Average Self 0.5ms Average calls 1x Total Self 0.5ms Total Children 1,974ms Total runtime 1,975ms `Rack::Timeout`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/cookies.rb:706	<1%
Average Self 0.5ms Average calls 1x Total Self 0.5ms Total Children 1,973ms Total runtime 1,974ms `ActionDispatch::Cookies`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/callbacks.rb:28	<1%
Average Self 0.5ms Average calls 1x Total Self 0.5ms Total Children 1,974ms Total runtime 1,974ms `ActionDispatch::Callbacks`
view app/views/layouts/application.html.haml	<1%
Average Self 1ms Average calls 0.5x Total Self 0.5ms Total Children 4.5ms Total runtime 5ms
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/ssl.rb:88	<1%
Average Self 0.5ms Average calls 1x Total Self 0.5ms Total Children 1,997ms Total runtime 1,998ms `ActionDispatch::SSL`
rack /app/vendor/bundle/ruby/4.0.0/gems/ip_anonymizer-0.4.0/lib/ip_anonymizer/mask_ip.rb:7	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,974ms Total runtime 1,974ms `IpAnonymizer::MaskIp`
redis app/helpers/badges_helper.rb:4	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms `get`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/remote_ip.rb:95	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,974ms Total runtime 1,974ms `ActionDispatch::RemoteIp`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/request_id.rb:31	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,975ms Total runtime 1,975ms `ActionDispatch::RequestId`
sql app/controllers/annuaire/users_controller.rb:59	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "antennes"."id" FROM "antennes" WHERE "antennes"."id" IN (?)`
sql app/controllers/annuaire/base_controller.rb:8	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "institutions".* FROM "institutions" WHERE "institutions"."slug" = ? LIMIT ?`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/http/content_security_policy.rb:37	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,973ms Total runtime 1,973ms `ActionDispatch::ContentSecurityPolicy::Middleware`
sql vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC LIMIT ?`
sql app/helpers/badges_helper.rb:4	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT COUNT(*) AS "size", MAX("badges"."updated_at") AS timestamp FROM "badges"`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/static.rb:26	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,997ms Total runtime 1,997ms `ActionDispatch::Static`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/debug_exceptions.rb:30	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,974ms Total runtime 1,974ms `ActionDispatch::DebugExceptions`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/show_exceptions.rb:31	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,974ms Total runtime 1,974ms `ActionDispatch::ShowExceptions`
rack /app/vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,997ms Total runtime 1,997ms `ActiveSupport::Cache::Strategy::LocalCache::Middleware`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,997ms Total runtime 1,997ms `ActionDispatch::Executor`
rack /app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/rack/logger.rb:20	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,974ms Total runtime 1,974ms `Rails::Rack::Logger`
rack /app/vendor/bundle/ruby/4.0.0/gems/warden-1.2.9/lib/warden/manager.rb:30	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,972ms Total runtime 1,972ms `Warden::Manager`
view app/views/shared/_favicon.html.erb	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/shared/_skiplinks.html.haml	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/shared/_flashes.html.haml	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/shared/_user_impersonate.html.haml	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/shared/_environment_ribbon.html.haml	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/shared/_matomo.html.erb	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/shared/_tarteaucitron.html.erb	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
cache app/helpers/badges_helper.rb:4	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0.5ms Total runtime 0.5ms `read`
view app/views/annuaire/users/_import_buttons.html.haml	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/annuaire/base/_menu_link.html.haml	<1%
Average Self 0ms Average calls 1.5x Total Self 0ms Total Children 0ms Total runtime 0ms
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/etag.rb:28	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,973ms Total runtime 1,973ms `Rack::ETag`
view app/views/application/_tarteaucitron.html.erb	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/shared/_dsfr_api.html.erb	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
rack ActionDispatch::Flash	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,973ms Total runtime 1,973ms
view app/views/application/navbar/_admin.html.haml	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/application/_questionnaire.html.haml	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/annuaire/base/_menu.html.haml	<1%
Average Self 0ms Average calls 0.5x Total Self 0ms Total Children 0ms Total runtime 0ms
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/conditional_get.rb:28	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,973ms Total runtime 1,973ms `Rack::ConditionalGet`
code /app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/engine.rb:532	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,998ms Total runtime 1,998ms `Rails::Engine#call`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/head.rb:14	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,973ms Total runtime 1,973ms `Rack::Head`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/sendfile.rb:130	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,997ms Total runtime 1,997ms `Rack::Sendfile`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/runtime.rb:22	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,997ms Total runtime 1,997ms `Rack::Runtime`
rack /app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/rack/silence_request.rb:27	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,974ms Total runtime 1,974ms `Rails::Rack::SilenceRequest`
rack /app/vendor/bundle/ruby/4.0.0/gems/appsignal-4.8.4/lib/appsignal/rack/abstract_middleware.rb:26	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,974ms Total runtime 1,974ms `Appsignal::Rack::RailsInstrumentation`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/events.rb:126	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,998ms Total runtime 1,998ms `Appsignal::Rack::EventMiddleware`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-session-2.1.2/lib/rack/session/abstract/id.rb:267	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 1,973ms Total runtime 1,973ms `ActionDispatch::Session::CookieStore`

Slowest executions

loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-