# Manager::StatsController#load_data

- **Period:** 23 Jun 13:28 UTC – 24 Jun 12:33 UTC
- **Throughput**: 0.05 / min
- **Average:** 245.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/services/stats/base_stats.rb:83 | 351.07 | 0.21 | 30.69% | `SELECT "subject"."label" FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id…` |
| queue | queue | 64.23 | 1.0 | 26.20% |  |
| view | app/views/stats/_load_stats.html.haml | 13.51 | 1.0 | 5.51% |  |
| sql | app/services/stats/base_stats.rb:177 | 39.35 | 0.29 | 4.59% | `SELECT COUNT(DISTINCT "needs"."id") AS "count_id", DATE_TRUNC(?, Needs.created_…` |
| sql | app/controllers/manager/stats_controller.rb:64 | 9.6 | 1.0 | 3.92% | `SELECT ? AS one FROM "needs" INNER JOIN "matches" ON "matches"."need_id" = "nee…` |
| code | app/controllers/manager/stats_controller.rb:31 | 5.47 | 1.0 | 2.23% | `Manager::StatsController#load_data` |
| gc | ruby/gc.c | 9.03 | 0.56 | 2.05% | `GC.start` |
| sql | vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158 | 3.56 | 1.0 | 1.45% | `SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC …` |
| sql | app/services/stats/matches/taking_care_time.rb:22 | 2.68 | 1.11 | 1.22% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" INNER JOIN "needs" ON "nee…` |
| sql | app/services/stats/matches/taking_care_time.rb:23 | 2.59 | 1.11 | 1.18% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" INNER JOIN "needs" ON "nee…` |

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