# Stats::PublicController#load_data

- **Period:** 24 Jun 02:00 UTC – 24 Jun 07:59 UTC
- **Throughput**: 0.03 / min
- **Average:** 2537.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/services/stats/needs/concerns/response_time.rb:18 | 1052.71 | 1.27 | 52.81% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "match…` |
| sql | app/services/stats/base_stats.rb:87 | 2382.0 | 0.18 | 17.07% | `SELECT COUNT(DISTINCT "solicitations"."id") FROM "solicitations" WHERE "solicit…` |
| sql | app/services/stats/solicitations/diagnoses.rb:18 | 336.93 | 1.27 | 16.90% | `SELECT COUNT(*) FROM "solicitations" INNER JOIN "diagnoses" ON "diagnoses"."sol…` |
| sql | app/services/stats/base_stats.rb:177 | 465.67 | 0.27 | 5.01% | `SELECT COUNT(DISTINCT "companies"."id") AS "count_companies_id", DATE_TRUNC(?, …` |
| queue | queue | 49.27 | 1.0 | 1.94% |  |
| sql | app/services/stats/needs/concerns/response_time.rb:17 | 27.14 | 1.27 | 1.36% | `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=6h)