# Stats::PublicController#load_data

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

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/services/stats/base_stats.rb:87 | 8942.67 | 0.16 | 44.49% | `SELECT COUNT(DISTINCT "solicitations"."id") FROM "solicitations" WHERE "solicit…` |
| sql | app/services/stats/needs/concerns/response_time.rb:18 | 932.43 | 1.11 | 32.47% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "match…` |
| sql | app/services/stats/solicitations/diagnoses.rb:18 | 333.67 | 1.11 | 11.62% | `SELECT COUNT(*) FROM "solicitations" INNER JOIN "diagnoses" ON "diagnoses"."sol…` |
| sql | app/services/stats/base_stats.rb:177 | 467.17 | 0.32 | 4.65% | `SELECT COUNT(DISTINCT "companies"."id") AS "count_companies_id", DATE_TRUNC(?, …` |
| sql | app/services/stats/needs/concerns/response_time.rb:17 | 34.52 | 1.11 | 1.20% | `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=1d)