Place des Entreprises Prod

.MD

Admin::CreateRemindersRegistersJob

…

Most impactful sections

sql81%
code17%
gc1%
unknown<1%


sql app/services/reminders_service.rb:21	51%
Average Self 3,427ms Average calls 2x Total Self 6,855ms Total Children 0ms Total runtime 6,855ms 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	17%
Average Self 2,296ms Average calls 1x Total Self 2,296ms Total Children 10,847ms Total runtime 13,144ms `Admin::CreateRemindersRegistersJob#perform`
sql app/services/reminders_service.rb:39	8%
Average Self 1.4ms Average calls 791x Total Self 1,095ms Total Children 0ms Total runtime 1,095ms `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	4%
Average Self 0.71ms Average calls 791x Total Self 559ms Total Children 0ms Total runtime 559ms `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	4%
Average Self 0.36ms Average calls 1,447x Total Self 518ms Total Children 0ms Total runtime 518ms `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	3%
Average Self 0.65ms Average calls 560x Total Self 364ms Total Children 0ms Total runtime 364ms `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:26	2%
Average Self 1.1ms Average calls 258x Total Self 292ms Total Children 0ms Total runtime 292ms `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:99	2%
Average Self 0.38ms Average calls 755x Total Self 285ms Total Children 0ms Total runtime 285ms `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 Average calls 755x Total Self 267ms Total Children 0ms Total runtime 267ms `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 30ms Average calls 5.5x Total Self 165ms Total Children 0ms Total runtime 165ms `GC.start`
sql app/services/reminders_service.rb:20	<1%
Average Self 0.68ms Average calls 165x Total Self 113ms Total Children 0ms Total runtime 113ms `UPDATE "experts" SET "updated_at" = ? WHERE "experts"."id" = ? COMMIT`
sql app/services/reminders_service.rb:28	<1%
Average Self 0.73ms Average calls 129x Total Self 94ms Total Children 0ms Total runtime 94ms `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.68ms Average calls 135x Total Self 92ms Total Children 0ms Total runtime 92ms `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.54ms Average calls 134x Total Self 72ms Total Children 0ms Total runtime 72ms `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.53ms Average calls 130x Total Self 69ms Total Children 0ms Total runtime 69ms `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.99ms Average calls 35x Total Self 34ms Total Children 0ms Total runtime 34ms `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 29ms Average calls 1x Total Self 29ms Total Children 0ms Total runtime 29ms `SELECT MAX("reminders_registers"."run_number") FROM "reminders_registers"`
sql app/services/reminders_service.rb:92	<1%
Average Self 0.81ms Average calls 36x 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:90	<1%
Average Self 0.78ms Average calls 34x Total Self 26ms Total Children 0ms Total runtime 26ms `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.64ms Average calls 35x Total Self 22ms Total Children 0ms Total runtime 22ms `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.58ms Average calls 18x Total Self 10ms Total Children 0ms Total runtime 10ms `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 8ms Average calls 1x Total Self 8ms Total Children 13,144ms Total runtime 13,152ms `Admin::CreateRemindersRegistersJob#perform`
sql app/services/reminders_service.rb:76	<1%
Average Self 0.65ms Average calls 10x Total Self 6.5ms Total Children 0ms Total runtime 6.5ms `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 0.5ms Average calls 1x Total Self 0.5ms Total Children 13,152ms Total runtime 13,152ms
code vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 13,144ms Total runtime 13,144ms `Admin::CreateRemindersRegistersJob`

Slowest executions

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