# Admin::CreateRemindersRegistersJob

- **Period:** 23 Jun 10:09 UTC – 23 Jun 13:28 UTC
- **Throughput**: 0.01 / min
- **Average:** 10367.3 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/services/reminders_service.rb:21 | 1902.5 | 2.0 | 36.70% | `BEGIN SELECT DISTINCT "experts".* FROM "experts" INNER JOIN "experts_users" ON …` |
| code | app/jobs/admin/create_reminders_registers_job.rb:4 | 2458.0 | 1.0 | 23.71% | `Admin::CreateRemindersRegistersJob#perform` |
| sql | app/services/reminders_service.rb:39 | 1.08 | 812.0 | 8.46% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/services/reminders_service.rb:40 | 0.77 | 812.0 | 6.02% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/services/reminders_service.rb:51 | 0.39 | 1488.0 | 5.58% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/services/reminders_service.rb:52 | 0.7 | 582.0 | 3.95% | `SELECT MAX("matches"."created_at") FROM "matches" WHERE "matches"."expert_id" =…` |
| sql | app/services/reminders_service.rb:99 | 0.39 | 763.0 | 2.88% | `SELECT "matches"."sent_at" FROM "matches" WHERE "matches"."expert_id" = ? AND "…` |
| sql | app/services/reminders_service.rb:98 | 0.36 | 763.0 | 2.64% | `SELECT "matches".* FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"…` |
| sql | app/services/reminders_service.rb:26 | 0.83 | 258.0 | 2.07% | `SELECT ? AS one FROM "reminders_registers" WHERE "reminders_registers"."run_num…` |
| gc | ruby/gc.c | 34.0 | 4.0 | 1.31% | `GC.start` |
| sql | app/services/reminders_service.rb:20 | 0.75 | 165.0 | 1.20% | `UPDATE "experts" SET "updated_at" = ? WHERE "experts"."id" = ? COMMIT` |
| sql | app/services/reminders_service.rb:59 | 0.8 | 135.0 | 1.04% | `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_regi…` |
| sql | app/services/reminders_service.rb:28 | 0.81 | 129.0 | 1.00% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |

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