# Stats::PublicController#load_data

- **Period:** 23 Jun 13:28 UTC – 24 Jun 10:28 UTC
- **Throughput**: 0.02 / min
- **Average:** 3056.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/services/stats/base_stats.rb:87 | 9502.75 | 0.15 | 46.07% | `SELECT COUNT(DISTINCT "solicitations"."id") FROM "solicitations" WHERE "solicit…` |
| sql | app/services/stats/needs/concerns/response_time.rb:18 | 779.79 | 1.04 | 26.46% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "match…` |
| sql | app/services/stats/solicitations/diagnoses.rb:18 | 385.86 | 1.04 | 13.09% | `SELECT COUNT(*) FROM "solicitations" INNER JOIN "diagnoses" ON "diagnoses"."sol…` |
| sql | app/services/stats/base_stats.rb:177 | 677.56 | 0.33 | 7.39% | `SELECT COUNT(DISTINCT "companies"."id") AS "count_companies_id", DATE_TRUNC(?, …` |
| sql | app/services/stats/needs/concerns/response_time.rb:17 | 32.46 | 1.04 | 1.10% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "match…` |

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