Place des Entreprises Prod

.MD

Admin::CreateRemindersRegistersJob

…

Most impactful sections

sql86%
code13%
gc1%
unknown<1%


sql app/services/reminders_service.rb:21	61%
Average Self 4,952ms Calls 2x Total Self 9,905ms Total Children 0ms Total runtime 9,905ms 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	13%
Average Self 2,135ms Calls 1x Total Self 2,135ms Total Children 13,932ms Total runtime 16,067ms `Admin::CreateRemindersRegistersJob#perform`
sql app/services/reminders_service.rb:39	8%
Average Self 1.7ms Calls 771x Total Self 1,313ms Total Children 0ms Total runtime 1,313ms `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	3%
Average Self 0.64ms Calls 771x Total Self 494ms Total Children 0ms Total runtime 494ms `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	3%
Average Self 0.33ms Calls 1,406x Total Self 458ms Total Children 0ms Total runtime 458ms `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:26	2%
Average Self 1.4ms Calls 258x Total Self 369ms Total Children 0ms Total runtime 369ms `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:52	2%
Average Self 0.59ms Calls 539x Total Self 319ms Total Children 0ms Total runtime 319ms `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	2%
Average Self 0.36ms Calls 747x Total Self 272ms Total Children 0ms Total runtime 272ms `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	2%
Average Self 0.35ms Calls 747x Total Self 261ms Total Children 0ms Total runtime 261ms `SELECT "matches".* FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."sent_at" IS NOT NULL ORDER BY "matches"."sent_at" DESC LIMIT ?`
gc ruby/gc.c	1%
Average Self 27ms Calls 7x Total Self 194ms Total Children 0ms Total runtime 194ms `GC.start`
sql app/services/reminders_service.rb:20	<1%
Average Self 0.62ms Calls 165x Total Self 102ms Total Children 0ms Total runtime 102ms `UPDATE "experts" SET "updated_at" = ? WHERE "experts"."id" = ? COMMIT`
sql app/services/reminders_service.rb:28	<1%
Average Self 0.65ms Calls 129x Total Self 84ms Total Children 0ms Total runtime 84ms `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:59	<1%
Average Self 0.57ms Calls 136x Total Self 77ms Total Children 0ms Total runtime 77ms `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_registers"."expert_id" = ? AND "reminders_registers"."run_number" = ? LIMIT ?`
sql app/services/reminders_service.rb:71	<1%
Average Self 0.5ms Calls 130x Total Self 65ms Total Children 0ms Total runtime 65ms `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.48ms Calls 130x Total Self 63ms Total Children 0ms Total runtime 63ms `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 0.77ms Calls 35x Total Self 27ms Total Children 0ms Total runtime 27ms `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/models/reminders_register.rb:43	<1%
Average Self 25ms Calls 1x Total Self 25ms Total Children 0ms Total runtime 25ms `SELECT MAX("reminders_registers"."run_number") FROM "reminders_registers"`
sql app/services/reminders_service.rb:90	<1%
Average Self 0.71ms Calls 34x Total Self 24ms Total Children 0ms Total runtime 24ms `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:92	<1%
Average Self 0.61ms Calls 36x Total Self 22ms Total Children 0ms Total runtime 22ms `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.6ms Calls 35x Total Self 21ms Total Children 0ms Total runtime 21ms `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_registers"."expert_id" = ? AND "reminders_registers"."run_number" = ? LIMIT ?`
sql app/services/reminders_service.rb:76	<1%
Average Self 0.61ms Calls 18x Total Self 11ms Total Children 0ms Total runtime 11ms `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 ?`
sql app/services/reminders_service.rb:77	<1%
Average Self 0.5ms Calls 18x Total Self 9ms Total Children 0ms Total runtime 9ms `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 7ms Calls 1x Total Self 7ms Total Children 16,067ms Total runtime 16,074ms `Admin::CreateRemindersRegistersJob#perform`
code vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 16,074ms Total runtime 16,075ms
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 16,067ms Total runtime 16,067ms `Admin::CreateRemindersRegistersJob`

Slowest executions

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