# Stats::PublicController#index

- **Period:** 24 Jun 03:08 UTC – 24 Jun 06:07 UTC
- **Throughput**: 0.01 / min
- **Average:** 464.3 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/services/stats/base_stats.rb:177 | 245.0 | 1.0 | 52.77% | `SELECT COUNT(*) AS "count_all", DATE_TRUNC(?, Needs.created_at) AS "date_trunc_…` |
| sql | app/services/stats/needs/done_with_help_column.rb:23 | 47.0 | 2.0 | 20.24% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| sql | app/services/stats/base_stats.rb:83 | 79.0 | 1.0 | 17.01% | `SELECT "needs"."status" FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id"…` |
| view | app/views/stats/_main_stats_chart.haml | 7.0 | 1.0 | 1.51% |  |
| queue | queue | 6.0 | 1.0 | 1.29% |  |
| code | app/controllers/stats/public_controller.rb:10 | 5.0 | 1.0 | 1.08% | `Stats::PublicController#index` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/Stats::PublicController%23index?range=3h)