# Admin::StatisticsQuizController#index

- **Period:** 12 Jun 18:17 UTC – 13 Jun 06:16 UTC
- **Throughput**: 0.0 / min
- **Average:** 547.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/facades/admin/statistics_quiz.rb:43 | 144.33 | 1.0 | 26.38% | `SELECT COUNT(DISTINCT "quiz_answers"."user_id") FROM "quiz_answers" INNER JOIN …` |
| view | app/views/admin/statistics_quiz/index.html.erb | 83.67 | 1.0 | 15.29% |  |
| sql | app/views/admin/statistics_quiz/index.html.erb:18 | 71.67 | 1.0 | 13.10% | `SELECT COUNT(DISTINCT "quiz_answers"."user_id") AS "count_quiz_answers_user_id"…` |
| sql | app/views/admin/statistics_quiz/index.html.erb:9 | 44.0 | 1.0 | 8.04% | `SELECT COUNT(*) AS "count_all", DATE_TRUNC(?, "quiz_answers"."created_at"::time…` |
| sql | app/facades/admin/statistics_quiz.rb:35 | 40.33 | 1.0 | 7.37% | `SELECT COUNT(*) FROM "quiz_answers" INNER JOIN "quiz_propositions" ON "quiz_pro…` |
| sql | app/facades/admin/statistics_quiz.rb:73 | 40.0 | 1.0 | 7.31% | `SELECT COUNT("answers"."id") AS "count_answers_id", "quiz_questions"."categoris…` |
| sql | app/facades/admin/statistics_quiz.rb:66 | 16.67 | 2.0 | 6.09% | `SELECT user_id, COUNT(DISTINCT DATE(created_at)) as distinct_days FROM "quiz_an…` |
| gc | ruby/gc.c | 17.67 | 1.0 | 3.23% | `GC.start` |
| sql | app/views/admin/statistics_quiz/index.html.erb:48 | 1.4 | 10.0 | 2.56% | `SELECT COUNT(*) FROM "quiz_answers" INNER JOIN "quiz_questions" ON "quiz_answer…` |
| sql | app/facades/admin/statistics_quiz.rb:39 | 3.67 | 3.0 | 2.01% | `SELECT COUNT(DISTINCT "quiz_answers"."user_id") FROM "quiz_answers"` |
| sql | app/facades/admin/statistics_quiz.rb:31 | 7.67 | 1.0 | 1.40% | `SELECT COUNT(*) FROM "quiz_answers" WHERE (created_at > ?)` |
| code | app/controllers/admin/statistics_quiz_controller.rb:5 | 6.33 | 1.0 | 1.16% | `Admin::StatisticsQuizController#index` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135493/requests/Admin::StatisticsQuizController%23index?range=12h)