|
sql
app/jobs/company_emails/send_intelligent_retention_emails_job.rb:13
|
42%
|
app/jobs/company_emails/send_intelligent_retention_emails_job.rb:13
- Average Self
-
3ms
- Calls
- 328x
- Total Self
- 972ms
- Total Children
- 0ms
- Total runtime
- 972ms
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
|
|
code
app/jobs/company_emails/send_intelligent_retention_emails_job.rb:4
|
31%
|
app/jobs/company_emails/send_intelligent_retention_emails_job.rb:4
- Average Self
-
707ms
- Calls
- 1x
- Total Self
- 707ms
- Total Children
- 1,536ms
- Total runtime
- 2,243ms
CompanyEmails::SendIntelligentRetentionEmailsJob#perform
|
|
sql
app/models/concerns/mandatory_answers.rb:30
|
17%
|
app/models/concerns/mandatory_answers.rb:30
- Average Self
-
1.9ms
- Calls
- 204x
- Total Self
- 388ms
- Total Children
- 62ms
- Total runtime
- 450ms
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 (?)
SELECT "subject_answers".* FROM "subject_answers" WHERE "subject_answers"."type" = ? AND "subject_answers"."subject_questionable_id" = ? AND "subject_answers"."subject_questionable_type" = ? AND ?=?
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" != ?
|
|
sql
app/jobs/company_emails/send_intelligent_retention_emails_job.rb:11
|
4%
|
app/jobs/company_emails/send_intelligent_retention_emails_job.rb:11
- Average Self
-
10ms
- Calls
- 9x
- Total Self
- 91ms
- Total Children
- 0ms
- Total runtime
- 91ms
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 ?)
|
|
gc
ruby/gc.c
|
3%
|
ruby/gc.c
- Average Self
-
30ms
- Calls
- 2x
- Total Self
- 60ms
- Total Children
- 0ms
- Total runtime
- 60ms
GC.start
|
|
sql
app/models/concerns/mandatory_answers.rb:19
|
3%
|
app/models/concerns/mandatory_answers.rb:19
- Average Self
-
0.59ms
- Calls
- 102x
- Total Self
- 60ms
- Total Children
- 0ms
- Total runtime
- 60ms
SELECT ? AS one FROM "subject_questions" WHERE "subject_questions"."subject_id" = ? LIMIT ?
|
|
sql
app/jobs/company_emails/send_intelligent_retention_emails_job.rb:5
|
<1%
|
app/jobs/company_emails/send_intelligent_retention_emails_job.rb: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/jobs/company_emails/send_intelligent_retention_emails_job.rb:9
|
<1%
|
app/jobs/company_emails/send_intelligent_retention_emails_job.rb:9
- Average Self
-
0.78ms
- Calls
- 9x
- Total Self
- 7ms
- Total Children
- 0ms
- Total runtime
- 7ms
SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?
|
|
sql
app/models/concerns/mandatory_answers.rb:24
|
<1%
|
app/models/concerns/mandatory_answers.rb:24
- Average Self
-
0.14ms
- Calls
- 22x
- Total Self
- 3ms
- Total Children
- 0ms
- Total runtime
- 3ms
SELECT "subject_questions"."id" FROM "subject_questions" WHERE "subject_questions"."subject_id" = ?
|
|
code
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13
|
<1%
|
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 2,243ms
- Total runtime
- 2,244ms
CompanyEmails::SendIntelligentRetentionEmailsJob#perform
|
|
code
vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130
|
<1%
|
vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130
- Average Self
-
0ms
- Calls
- 1x
- Total Self
- 0ms
- Total Children
- 2,243ms
- Total runtime
- 2,243ms
CompanyEmails::SendIntelligentRetentionEmailsJob
|
|
code
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182
|
<1%
|
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182
- Average Self
-
0ms
- Calls
- 1x
- Total Self
- 0ms
- Total Children
- 2,244ms
- Total runtime
- 2,244ms
|