# Admin::CreateRemindersRegistersJob

- **Period:** 23 Jun 13:28 UTC – 24 Jun 10:51 UTC
- **Throughput**: 0.0 / min
- **Average:** 16269.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/services/reminders_service.rb:21 | 4952.5 | 2.0 | 60.88% | `BEGIN SELECT DISTINCT "experts".* FROM "experts" INNER JOIN "experts_users" ON …` |
| code | app/jobs/admin/create_reminders_registers_job.rb:4 | 2135.0 | 1.0 | 13.12% | `Admin::CreateRemindersRegistersJob#perform` |
| sql | app/services/reminders_service.rb:39 | 1.7 | 771.0 | 8.07% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/services/reminders_service.rb:40 | 0.64 | 771.0 | 3.04% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/services/reminders_service.rb:51 | 0.33 | 1406.0 | 2.82% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/services/reminders_service.rb:26 | 1.43 | 258.0 | 2.27% | `SELECT ? AS one FROM "reminders_registers" WHERE "reminders_registers"."run_num…` |
| sql | app/services/reminders_service.rb:52 | 0.59 | 539.0 | 1.96% | `SELECT MAX("matches"."created_at") FROM "matches" WHERE "matches"."expert_id" =…` |
| sql | app/services/reminders_service.rb:99 | 0.36 | 747.0 | 1.67% | `SELECT "matches"."sent_at" FROM "matches" WHERE "matches"."expert_id" = ? AND "…` |
| sql | app/services/reminders_service.rb:98 | 0.35 | 747.0 | 1.60% | `SELECT "matches".* FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"…` |
| gc | ruby/gc.c | 27.71 | 7.0 | 1.19% | `GC.start` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/jobs/Admin::CreateRemindersRegistersJob?range=2026-06-23+13%3A28%3A11+UTC..2026-06-24+13%3A28%3A11+UTC)