# ReportsController#stats

- **Period:** 24 Jun 02:11 UTC – 24 Jun 08:10 UTC
- **Throughput**: 0.01 / min
- **Average:** 277.2 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/reports/stats.html.haml:25 | 12.37 | 10.0 | 44.62% | `SELECT "active_storage_attachments".* FROM "active_storage_attachments" WHERE "…` |
| sql | app/controllers/reports_controller.rb:44 | 51.67 | 1.0 | 18.64% | `SELECT "activity_reports"."start_date", "activity_reports"."end_date" FROM "act…` |
| sql | app/views/reports/stats.html.haml:10 | 2.73 | 5.0 | 4.93% | `SELECT "activity_reports".* FROM "activity_reports" WHERE "activity_reports"."r…` |
| view | app/views/reports/stats.html.haml | 12.0 | 1.0 | 4.33% |  |
| code | app/controllers/reports_controller.rb:13 | 11.0 | 1.0 | 3.97% | `ReportsController#stats` |
| sql | app/views/application/navbar/_app.html.haml:4 | 9.0 | 1.0 | 3.25% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| view | app/views/application/navbar/_app.html.haml | 7.0 | 1.0 | 2.53% |  |
| sql | app/policies/need_policy.rb:13 | 3.33 | 1.0 | 1.20% | `SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?` |
| sql | app/helpers/badges_helper.rb:4 | 3.0 | 1.0 | 1.08% | `SELECT COUNT(*) AS "size", MAX("badges"."updated_at") AS timestamp FROM "badges"` |
| redis | app/helpers/badges_helper.rb:4 | 3.0 | 1.0 | 1.08% | `get` |
| sql | app/views/application/navbar/_app.html.haml:2 | 3.0 | 1.0 | 1.08% | `SELECT "experts".* FROM "experts" INNER JOIN "experts_users" ON "experts"."id" …` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/ReportsController%23stats?range=6h)