# Manager::StatsController#load_data

- **Period:** 23 Jun 18:04 UTC – 24 Jun 06:03 UTC
- **Throughput**: 0.04 / min
- **Average:** 264.4 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/services/stats/base_stats.rb:83 | 477.33 | 0.21 | 38.68% | `SELECT "facilities"."naf_code_a10" FROM "companies" LEFT OUTER JOIN "facilities…` |
| queue | queue | 61.71 | 1.0 | 23.34% |  |
| view | app/views/stats/_load_stats.html.haml | 13.14 | 1.0 | 4.97% |  |
| sql | app/services/stats/base_stats.rb:177 | 45.63 | 0.29 | 4.93% | `SELECT COUNT(*) AS "count_all", DATE_TRUNC(?, diagnoses.created_at) AS "date_tr…` |
| gc | ruby/gc.c | 9.5 | 0.57 | 2.05% | `GC.start` |
| sql | app/controllers/manager/stats_controller.rb:64 | 5.11 | 1.0 | 1.93% | `SELECT ? AS one FROM "needs" INNER JOIN "matches" ON "matches"."need_id" = "nee…` |
| code | app/controllers/manager/stats_controller.rb:31 | 5.07 | 1.0 | 1.92% | `Manager::StatsController#load_data` |
| sql | vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158 | 4.43 | 1.0 | 1.67% | `SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC …` |
| sql | app/services/stats/matches/taking_care.rb:19 | 5.11 | 0.68 | 1.31% | `SELECT COUNT(*) FROM "matches" INNER JOIN "needs" ON "needs"."id" = "matches"."…` |
| sql | app/services/stats/matches/taking_care_time.rb:23 | 2.24 | 1.36 | 1.15% | `SELECT COUNT(*) FROM "matches" INNER JOIN "needs" ON "needs"."id" = "matches"."…` |
| sql | app/services/stats/matches/taking_care_time.rb:22 | 2.24 | 1.36 | 1.15% | `SELECT COUNT(*) FROM "matches" INNER JOIN "needs" ON "needs"."id" = "matches"."…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/Manager::StatsController%23load_data?range=12h)