# CompanyEmails::SendRetentionEmailsJob

- **Period:** 23 Jun 22:17 UTC – 24 Jun 10:16 UTC
- **Throughput**: 0.0 / min
- **Average:** 2776.5 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/jobs/company_emails/send_retention_emails_job.rb:4 | 814.0 | 1.0 | 29.32% | `CompanyEmails::SendRetentionEmailsJob#perform` |
| sql | app/jobs/company_emails/send_retention_emails_job.rb:13 | 1.97 | 360.0 | 25.50% | `SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ? UPDATE…` |
| sql | app/models/diagnosis.rb:237 | 3.54 | 90.0 | 11.49% | `SELECT "solicitations".* FROM "solicitations" WHERE "solicitations"."id" = ? LI…` |
| sql | app/models/need.rb:466 | 2.26 | 90.0 | 7.31% | `UPDATE "diagnoses" SET "updated_at" = ? WHERE "diagnoses"."id" = ?` |
| sql | app/jobs/company_emails/send_retention_emails_job.rb:11 | 179.0 | 1.0 | 6.45% | `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "nee…` |
| sql | app/models/diagnosis.rb:134 | 1.87 | 90.0 | 6.05% | `SELECT "diagnoses".* FROM "diagnoses" INNER JOIN "solicitations" ON "solicitati…` |
| sql | app/models/diagnosis.rb:225 | 0.8 | 180.0 | 5.19% | `BEGIN SELECT "needs".* FROM "needs" WHERE "needs"."diagnosis_id" = ?` |
| sql | app/models/diagnosis.rb:231 | 0.98 | 90.0 | 3.17% | `SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?` |
| sql | app/models/need.rb:462 | 0.93 | 90.0 | 3.03% | `SELECT "matches".* FROM "matches" WHERE "matches"."need_id" = ?` |
| gc | ruby/gc.c | 60.0 | 1.0 | 2.16% | `GC.start` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/jobs/CompanyEmails::SendRetentionEmailsJob?range=12h)