Place des Entreprises Prod

.MD

Admin::CreateRemindersRegistersJob

…

Most impactful sections

sql75%
code24%
gc1%
unknown<1%


sql app/services/reminders_service.rb:21	37%
Average Self 1,902ms Calls 2x Total Self 3,805ms Total Children 0ms Total runtime 3,805ms BEGIN SELECT DISTINCT "experts".* FROM "experts" INNER JOIN "experts_users" ON "experts_users"."expert_id" = "experts"."id" INNER JOIN "users" ON "users"."deleted_at" IS NULL AND "users"."id" = "experts_users"."user_id" INNER JOIN "matches" ON "matches"."sent_at" IS NOT NULL AND "matches"."expert_id" = "experts"."id" LEFT OUTER JOIN "reminders_registers" ON "reminders_registers"."expert_id" = "experts"."id" WHERE "experts"."deleted_at" IS NULL AND "matches"."archived_at" IS NULL AND "matches"."status" = ? ORDER BY "experts"."id" ASC LIMIT ?
code app/jobs/admin/create_reminders_registers_job.rb:4	24%
Average Self 2,458ms Calls 1x Total Self 2,458ms Total Children 7,763ms Total runtime 10,221ms `Admin::CreateRemindersRegistersJob#perform`
sql app/services/reminders_service.rb:39	8%
Average Self 1.1ms Calls 812x Total Self 877ms Total Children 0ms Total runtime 877ms `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL AND "matches"."status" = ? AND "matches"."status" = ? AND "matches"."sent_at" >= ?`
sql app/services/reminders_service.rb:40	6%
Average Self 0.77ms Calls 812x Total Self 624ms Total Children 0ms Total runtime 624ms `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL AND "matches"."status" = ? AND "matches"."status" = ? AND "matches"."sent_at" >= ? AND "matches"."sent_at" <= ?`
sql app/services/reminders_service.rb:51	6%
Average Self 0.39ms Calls 1,488x Total Self 579ms Total Children 0ms Total runtime 579ms `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL AND "matches"."status" = ? AND "matches"."status" = ? AND "matches"."sent_at" >= ? AND "matches"."sent_at" <= ? SELECT DISTINCT "matches".* FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL AND "matches"."status" = ? AND "matches"."status" = ? AND "matches"."sent_at" >= ?`
sql app/services/reminders_service.rb:52	4%
Average Self 0.7ms Calls 582x Total Self 410ms Total Children 0ms Total runtime 410ms `SELECT MAX("matches"."created_at") FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL AND "matches"."status" = ? AND "matches"."status" = ? AND "matches"."sent_at" >= ?`
sql app/services/reminders_service.rb:99	3%
Average Self 0.39ms Calls 763x Total Self 299ms Total Children 0ms Total runtime 299ms `SELECT "matches"."sent_at" FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL AND "matches"."id" != ?`
sql app/services/reminders_service.rb:98	3%
Average Self 0.36ms Calls 763x Total Self 274ms Total Children 0ms Total runtime 274ms `SELECT "matches".* FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL ORDER BY "matches"."sent_at" DESC LIMIT ?`
sql app/services/reminders_service.rb:26	2%
Average Self 0.83ms Calls 258x Total Self 215ms Total Children 0ms Total runtime 215ms `SELECT ? AS one FROM "reminders_registers" WHERE "reminders_registers"."run_number" = ? AND "reminders_registers"."expert_id" = ? LIMIT ? INSERT INTO "reminders_registers" ("category", "basket", "expert_id", "processed", "created_at", "updated_at", "run_number", "expired_count") VALUES (?, ?, ?, ?, ?, ?, ?, ?) RETURNING "id"`
gc ruby/gc.c	1%
Average Self 34ms Calls 4x Total Self 136ms Total Children 0ms Total runtime 136ms `GC.start`
sql app/services/reminders_service.rb:20	1%
Average Self 0.75ms Calls 165x Total Self 124ms Total Children 0ms Total runtime 124ms `UPDATE "experts" SET "updated_at" = ? WHERE "experts"."id" = ? COMMIT`
sql app/services/reminders_service.rb:59	1%
Average Self 0.8ms Calls 135x Total Self 108ms Total Children 0ms Total runtime 108ms `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_registers"."expert_id" = ? AND "reminders_registers"."run_number" = ? LIMIT ?`
sql app/services/reminders_service.rb:28	1%
Average Self 0.81ms Calls 129x Total Self 104ms Total Children 0ms Total runtime 104ms `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL AND "matches"."status" = ? AND "matches"."archived_at" IS NULL AND "matches"."status" = ? AND "matches"."sent_at" <= ?`
sql app/services/reminders_service.rb:71	<1%
Average Self 0.57ms Calls 138x Total Self 79ms Total Children 0ms Total runtime 79ms `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_registers"."run_number" = ? AND "reminders_registers"."category" IN (?) SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ?`
sql app/services/reminders_service.rb:72	<1%
Average Self 0.58ms Calls 130x Total Self 76ms Total Children 0ms Total runtime 76ms `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_registers"."run_number" = ? SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ?`
sql app/services/reminders_service.rb:82	<1%
Average Self 1.2ms Calls 35x Total Self 42ms Total Children 0ms Total runtime 42ms `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL AND "matches"."status" = ? AND "matches"."archived_at" IS NULL AND "matches"."status" = ? AND "matches"."sent_at" <= ?`
sql app/services/reminders_service.rb:92	<1%
Average Self 1ms Calls 36x Total Self 36ms Total Children 0ms Total runtime 36ms `SELECT ? AS one FROM "reminders_registers" WHERE "reminders_registers"."run_number" = ? AND "reminders_registers"."expert_id" = ? LIMIT ? INSERT INTO "reminders_registers" ("category", "basket", "expert_id", "processed", "created_at", "updated_at", "run_number", "expired_count") VALUES (?, ?, ?, ?, ?, ?, ?, ?) RETURNING "id"`
sql app/models/reminders_register.rb:43	<1%
Average Self 34ms Calls 1x Total Self 34ms Total Children 0ms Total runtime 34ms `SELECT MAX("reminders_registers"."run_number") FROM "reminders_registers"`
sql app/services/reminders_service.rb:90	<1%
Average Self 0.85ms Calls 34x Total Self 29ms Total Children 0ms Total runtime 29ms `SELECT ? AS one FROM "reminders_registers" WHERE "reminders_registers"."run_number" = ? AND "reminders_registers"."expert_id" = ? LIMIT ? INSERT INTO "reminders_registers" ("category", "basket", "expert_id", "processed", "created_at", "updated_at", "run_number", "expired_count") VALUES (?, ?, ?, ?, ?, ?, ?, ?) RETURNING "id"`
sql app/services/reminders_service.rb:81	<1%
Average Self 0.69ms Calls 35x Total Self 24ms Total Children 0ms Total runtime 24ms `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_registers"."expert_id" = ? AND "reminders_registers"."run_number" = ? LIMIT ?`
sql app/services/reminders_service.rb:77	<1%
Average Self 0.67ms Calls 18x Total Self 12ms Total Children 0ms Total runtime 12ms `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_registers"."run_number" = ? AND "reminders_registers"."category" = ? AND "reminders_registers"."processed" = ? SELECT "experts".* FROM "experts" WHERE "experts"."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 9ms Calls 1x Total Self 9ms Total Children 10,221ms Total runtime 10,230ms `Admin::CreateRemindersRegistersJob#perform`
sql app/services/reminders_service.rb:76	<1%
Average Self 1ms Calls 2x Total Self 2ms Total Children 0ms Total runtime 2ms `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_registers"."run_number" = ? AND "reminders_registers"."category" = ? AND "reminders_registers"."processed" = ? SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ?`
code vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 10,230ms Total runtime 10,230ms
code vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 10,221ms Total runtime 10,221ms `Admin::CreateRemindersRegistersJob`

Slowest executions

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