# Stats::TeamController#load_data

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

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/helpers/seo/data_preparation.rb:31 | 36159.0 | 0.01 | 25.33% | `SELECT "institutions".* FROM "institutions" INNER JOIN "logos" ON "logos"."logo…` |
| sql | app/services/stats/acquisitions/by_new_companies.rb:25 | 27901.0 | 0.01 | 19.55% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| queue | queue | 366.18 | 1.0 | 17.19% |  |
| sql | app/services/stats/needs/concerns/response_time.rb:18 | 445.38 | 0.31 | 6.55% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "match…` |
| sql | app/services/stats/base_stats.rb:177 | 480.36 | 0.27 | 6.06% | `SELECT COUNT(DISTINCT "companies"."id") AS "count_companies_id", DATE_TRUNC(?, …` |
| sql | app/services/stats/base_stats.rb:83 | 259.63 | 0.2 | 2.46% | `SELECT "subject"."label" FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id…` |
| sql | app/services/stats/matches/taking_care_time.rb:22 | 56.13 | 0.78 | 2.05% | `SELECT COUNT(*) FROM "matches" INNER JOIN "needs" ON "needs"."id" = "matches"."…` |
| sql | app/services/stats/acquisitions/base.rb:22 | 48.74 | 0.81 | 1.84% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| sql | app/services/stats/matches/taking_care_time.rb:23 | 37.41 | 0.78 | 1.36% | `SELECT COUNT(*) FROM "matches" INNER JOIN "needs" ON "needs"."id" = "matches"."…` |
| sql | app/services/stats/base_stats.rb:87 | 384.22 | 0.07 | 1.21% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "diagnoses" ON "dia…` |
| sql | app/services/stats/matches/positioning.rb:16 | 64.04 | 0.39 | 1.17% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" INNER JOIN "needs" ON "nee…` |
| sql | app/services/stats/matches/not_positioning.rb:18 | 57.94 | 0.39 | 1.06% | `SELECT COUNT(DISTINCT "matches"."id") FROM "matches" INNER JOIN "needs" ON "nee…` |

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