# Admin::CreateRemindersRegistersJob

- **Period:** 23 Jun 08:11 UTC – 24 Jun 08:10 UTC
- **Throughput**: 0.0 / min
- **Average:** 13318.2 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/services/reminders_service.rb:21 | 3427.5 | 2.0 | 51.47% | `BEGIN SELECT DISTINCT "experts".* FROM "experts" INNER JOIN "experts_users" ON …` |
| code | app/jobs/admin/create_reminders_registers_job.rb:4 | 2296.5 | 1.0 | 17.24% | `Admin::CreateRemindersRegistersJob#perform` |
| sql | app/services/reminders_service.rb:39 | 1.38 | 791.5 | 8.22% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/services/reminders_service.rb:40 | 0.71 | 791.5 | 4.20% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/services/reminders_service.rb:51 | 0.36 | 1447.0 | 3.89% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/services/reminders_service.rb:52 | 0.65 | 560.5 | 2.74% | `SELECT MAX("matches"."created_at") FROM "matches" WHERE "matches"."expert_id" =…` |
| sql | app/services/reminders_service.rb:26 | 1.13 | 258.0 | 2.19% | `SELECT ? AS one FROM "reminders_registers" WHERE "reminders_registers"."run_num…` |
| sql | app/services/reminders_service.rb:99 | 0.38 | 755.0 | 2.14% | `SELECT "matches"."sent_at" FROM "matches" WHERE "matches"."expert_id" = ? AND "…` |
| sql | app/services/reminders_service.rb:98 | 0.35 | 755.0 | 2.01% | `SELECT "matches".* FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"…` |
| gc | ruby/gc.c | 30.0 | 5.5 | 1.24% | `GC.start` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/jobs/Admin::CreateRemindersRegistersJob?range=1d)