Place des Entreprises Prod

.MD

CompanyEmails::SendIntelligentRetentionEmailsJob

…

Most impactful sections

sql71%
code27%
unknown2%
gc<1%


sql app/jobs/company_emails/send_intelligent_retention_emails_job.rb:11	37%
Average Self 9.1ms Calls 9x Total Self 82ms Total Children 0ms Total runtime 82ms `SELECT "needs".* FROM "needs" INNER JOIN "matches" ON "matches"."need_id" = "needs"."id" WHERE "needs"."status" IN (?) AND "matches"."status" IN (?) AND "needs"."subject_id" = ? AND "needs"."retention_sent_at" IS NULL AND "needs"."created_at" >= ? GROUP BY "needs"."id" HAVING (MIN(matches.closed_at) BETWEEN ? AND ?)`
code app/jobs/company_emails/send_intelligent_retention_emails_job.rb:4	24%
Average Self 52ms Calls 1x Total Self 52ms Total Children 158ms Total runtime 210ms `CompanyEmails::SendIntelligentRetentionEmailsJob#perform`
sql app/jobs/company_emails/send_intelligent_retention_emails_job.rb:13	18%
Average Self 5.7ms Calls 7x Total Self 40ms Total Children 0ms Total runtime 40ms SELECT "subject_answers".* FROM "subject_answers" WHERE "subject_answers"."type" = ? AND "subject_answers"."subject_questionable_id" = ? AND "subject_answers"."subject_questionable_type" = ? UPDATE "needs" SET "updated_at" = ?, "retention_sent_at" = ? WHERE "needs"."id" = ? SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ? SELECT "solicitations".* FROM "solicitations" WHERE "solicitations"."id" = ? LIMIT ? UPDATE "diagnoses" SET "updated_at" = ? WHERE "diagnoses"."id" = ? UPDATE "solicitations" SET "updated_at" = ? WHERE "solicitations"."id" = ? COMMIT
sql app/jobs/company_emails/send_intelligent_retention_emails_job.rb:9	5%
Average Self 1.3ms Calls 9x Total Self 12ms Total Children 0ms Total runtime 12ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
sql app/jobs/company_emails/send_intelligent_retention_emails_job.rb:5	5%
Average Self 12ms Calls 1x Total Self 12ms Total Children 0ms Total runtime 12ms `SELECT "email_retentions".* FROM "email_retentions" ORDER BY "email_retentions"."id" ASC LIMIT ?`
sql app/models/concerns/mandatory_answers.rb:30	5%
Average Self 2.5ms Calls 4x Total Self 10ms Total Children 0ms Total runtime 10ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ? BEGIN SELECT "subject_questions"."id" FROM "subject_questions" WHERE "subject_questions"."subject_id" = ? SELECT "subject_answers".* FROM "subject_answers" WHERE "subject_answers"."type" = ? AND "subject_answers"."subject_questionable_id" = ? AND "subject_answers"."subject_questionable_type" = ? AND "subject_answers"."subject_question_id" NOT IN (?)`
code vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13	4%
Average Self 8ms Calls 1x Total Self 8ms Total Children 210ms Total runtime 218ms `CompanyEmails::SendIntelligentRetentionEmailsJob#perform`
gc ruby/gc.c	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms `GC.start`
sql app/models/concerns/mandatory_answers.rb:24	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "subject_questions"."id" FROM "subject_questions" WHERE "subject_questions"."subject_id" = ?`
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 210ms Total runtime 210ms `CompanyEmails::SendIntelligentRetentionEmailsJob`
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 218ms Total runtime 218ms
sql app/models/concerns/mandatory_answers.rb:19	<1%
Average Self 0ms Calls 2x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT ? AS one FROM "subject_questions" WHERE "subject_questions"."subject_id" = ? LIMIT ?`

Slowest executions

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