# Stats::TeamController#load_data

- **Period:** 23 Jun 06:04 UTC – 24 Jun 06:03 UTC
- **Throughput**: 0.18 / min
- **Average:** 1983.8 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| queue | queue | 399.74 | 1.0 | 20.15% |  |
| sql | app/helpers/seo/data_preparation.rb:31 | 23559.0 | 0.02 | 18.70% | `SELECT "institutions".* FROM "institutions" INNER JOIN "logos" ON "logos"."logo…` |
| sql | app/services/stats/acquisitions/by_new_companies.rb:25 | 14672.6 | 0.02 | 14.56% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| sql | app/services/stats/acquisitions/by_new_companies.rb:28 | 12784.0 | 0.01 | 7.61% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| sql | app/services/stats/needs/concerns/response_time.rb:18 | 448.25 | 0.33 | 7.47% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "match…` |
| sql | app/services/stats/base_stats.rb:177 | 361.47 | 0.27 | 4.88% | `SELECT COUNT(DISTINCT "companies"."id") AS "count_companies_id", DATE_TRUNC(?, …` |
| sql | app/services/stats/acquisitions/base.rb:22 | 93.31 | 0.78 | 3.67% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| sql | app/services/stats/base_stats.rb:87 | 695.71 | 0.07 | 2.35% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "diagnoses" ON "dia…` |
| sql | app/services/stats/base_stats.rb:83 | 167.0 | 0.2 | 1.69% | `SELECT "subject"."label" FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id…` |
| sql | app/services/stats/matches/taking_care_time.rb:22 | 58.96 | 0.5 | 1.50% | `SELECT COUNT(*) FROM "matches" INNER JOIN "needs" ON "needs"."id" = "matches"."…` |
| sql | app/services/stats/acquisitions/base.rb:26 | 37.9 | 0.78 | 1.49% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| sql | app/services/stats/acquisitions/base.rb:23 | 37.01 | 0.78 | 1.45% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/Stats::TeamController%23load_data?range=1d)