Place des Entreprises Prod

.MD

AddSharedSatisfactionsJob

…

Most impactful sections

sql88%
code7%
redis2%
unknown1%
cache<1%
gc<1%


sql app/jobs/add_shared_satisfactions_job.rb:11	80%
Average Self 39ms Average calls 2.1x Total Self 82ms Total Children 0ms Total runtime 82ms SELECT DISTINCT "company_satisfactions"."id" FROM "company_satisfactions" INNER JOIN "shared_satisfactions" ON "shared_satisfactions"."company_satisfaction_id" = "company_satisfactions"."id" INNER JOIN "experts" ON "experts"."id" = "shared_satisfactions"."expert_id" INNER JOIN "antennes" ON "antennes"."id" = "experts"."antenne_id" WHERE "experts"."antenne_id" IN (?) SELECT "company_satisfactions"."id" FROM "company_satisfactions" INNER JOIN "shared_satisfactions" ON "company_satisfactions"."id" = "shared_satisfactions"."company_satisfaction_id" WHERE "shared_satisfactions"."user_id" = ? SELECT DISTINCT "company_satisfactions"."id" FROM "company_satisfactions" INNER JOIN "shared_satisfactions" ON "shared_satisfactions"."company_satisfaction_id" = "company_satisfactions"."id" INNER JOIN "experts" ON "experts"."id" = "shared_satisfactions"."expert_id" INNER JOIN "antennes" ON "antennes"."id" = "experts"."antenne_id" WHERE "experts"."antenne_id" = ?
code app/jobs/add_shared_satisfactions_job.rb:4	6%
Average Self 6.4ms Average calls 1x Total Self 6.4ms Total Children 94ms Total runtime 100ms `AddSharedSatisfactionsJob#perform`
sql app/jobs/add_shared_satisfactions_job.rb:8	5%
Average Self 5.2ms Average calls 1x Total Self 5.2ms Total Children 0ms Total runtime 5.2ms `SELECT DISTINCT "antennes".* FROM "antennes" INNER JOIN "user_rights" ON "antennes"."id" = "user_rights"."rightable_element_id" INNER JOIN "user_rights" "user_rights_antennes" ON "user_rights_antennes"."rightable_element_type" = ? AND "user_rights_antennes"."rightable_element_id" = "antennes"."id" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? AND "user_rights"."rightable_element_type" = ? ORDER BY "antennes"."id" ASC LIMIT ?`
redis app/models/antenne.rb:269	2%
Average Self 1.5ms Average calls 1.6x Total Self 2.5ms Total Children 0ms Total runtime 2.5ms `get`
sql app/jobs/add_shared_satisfactions_job.rb:5	2%
Average Self 1.8ms Average calls 1x Total Self 1.8ms Total Children 0ms Total runtime 1.8ms `SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?`
code vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13	<1%
Average Self 0.96ms Average calls 1x Total Self 0.96ms Total Children 100ms Total runtime 101ms `AddSharedSatisfactionsJob#perform`
cache app/models/antenne.rb:269	<1%
Average Self 0.38ms Average calls 1.6x Total Self 0.62ms Total Children 2.5ms Total runtime 3.1ms `read`
sql app/jobs/add_shared_satisfactions_job.rb:14	<1%
Average Self 1ms Average calls 0.58x Total Self 0.59ms Total Children 0.03ms Total runtime 0.63ms `SELECT "shared_satisfactions".* FROM "shared_satisfactions" WHERE "shared_satisfactions"."company_satisfaction_id" = ? AND "shared_satisfactions"."user_id" = ? ORDER BY "shared_satisfactions"."id" ASC LIMIT ? SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? BEGIN SELECT ? AS one FROM "shared_satisfactions" WHERE "shared_satisfactions"."user_id" = ? AND "shared_satisfactions"."company_satisfaction_id" = ? AND "shared_satisfactions"."expert_id" IS NULL LIMIT ? ROLLBACK`
gc ruby/gc.c	<1%
Average Self 0.95ms Average calls 0.33x Total Self 0.31ms Total Children 0ms Total runtime 0.31ms `GC.start`
sql app/models/antenne.rb:273	<1%
Average Self 1.1ms Average calls 0.14x Total Self 0.16ms Total Children 0ms Total runtime 0.16ms `SELECT "antennes"."id" FROM "antennes" WHERE "antennes"."parent_antenne_id" = ?`
sql app/jobs/add_shared_satisfactions_job.rb:13	<1%
Average Self 0.91ms Average calls 0.17x Total Self 0.15ms Total Children 0ms Total runtime 0.15ms `SELECT "antennes"."id" FROM "antennes" WHERE "antennes"."id" = ? SELECT "experts".* FROM "experts" INNER JOIN "matches" ON "experts"."id" = "matches"."expert_id" INNER JOIN "needs" ON "matches"."need_id" = "needs"."id" WHERE "needs"."id" = ? AND "matches"."status" = ? AND "experts"."antenne_id" = ? ORDER BY "experts"."id" ASC LIMIT ?`
code vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182	<1%
Average Self 0.09ms Average calls 1x Total Self 0.09ms Total Children 101ms Total runtime 101ms
code vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130	<1%
Average Self 0.05ms Average calls 1x Total Self 0.05ms Total Children 100ms Total runtime 100ms `AddSharedSatisfactionsJob`
sql app/models/user.rb:310	<1%
Average Self 0.47ms Average calls 0.08x Total Self 0.04ms Total Children 0ms Total runtime 0.04ms `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?`
sql app/models/antenne.rb:271	<1%
Average Self 0.83ms Average calls 0.03x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT "institutions".* FROM "institutions" WHERE "institutions"."id" = ? LIMIT ?`
sql app/models/user.rb:344	<1%
Average Self 2ms Average calls <0.01x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT DISTINCT "antennes".* FROM "antennes" INNER JOIN "user_rights" ON "antennes"."id" = "user_rights"."rightable_element_id" INNER JOIN "user_rights" "user_rights_antennes" ON "user_rights_antennes"."rightable_element_type" = ? AND "user_rights_antennes"."rightable_element_id" = "antennes"."id" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? AND "user_rights"."rightable_element_type" = ?`
sql app/jobs/add_shared_satisfactions_job.rb:12	<1%
Average Self 0.33ms Average calls 0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "company_satisfactions".* FROM "company_satisfactions" WHERE "company_satisfactions"."id" = ? ORDER BY "company_satisfactions"."id" ASC LIMIT ?`
sql app/models/user.rb:351	<1%
Average Self 1ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?`
sql app/models/user.rb:345	<1%
Average Self 0ms Average calls <0.01x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "antennes"."id" FROM "antennes" WHERE "antennes"."parent_antenne_id" = ?`

Slowest executions

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