| Resource | Value |
|---|---|
| User CPU time | 139.336 msec |
| System CPU time | 0.936 msec |
| Total CPU time | 140.272 msec |
| Elapsed time | 172.868 msec |
| Context switches | 43 voluntary, 4 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SELECT COUNT(*) AS "__count"
FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:00:54.195356+00:00'::timestamptz)SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:00:54.195356+00:00'::timestamptz) |
0.27 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(30) polls = paginator.get_page(request.GET.get('page', 1)) /home/nathan/rb/site/./digg_paginator/utils.py in get_page(274) return self.page(page) /home/nathan/rb/site/./digg_paginator/utils.py in page(199) page = super(DiggPaginator, self).page(number, *args, **kwargs) /home/nathan/rb/site/./digg_paginator/utils.py in page(47) return super(ExPaginator, self).page(number) |
|||||||||||||||||||||
|
SELECT "countries_plus_country"."iso",
"countries_plus_country"."iso3", "countries_plus_country"."iso_numeric", "countries_plus_country"."fips", "countries_plus_country"."name", "countries_plus_country"."capital", "countries_plus_country"."area", "countries_plus_country"."population", "countries_plus_country"."continent", "countries_plus_country"."tld", "countries_plus_country"."currency_code", "countries_plus_country"."currency_symbol", "countries_plus_country"."currency_name", "countries_plus_country"."phone", "countries_plus_country"."postal_code_format", "countries_plus_country"."postal_code_regex", "countries_plus_country"."languages", "countries_plus_country"."geonameid", "countries_plus_country"."neighbours", "countries_plus_country"."equivalent_fips_code" FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21 |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20) geo_data = user.geo.get_user_currency() /home/nathan/rb/site/./geo/geo.py in get_user_currency(253) country = Country.objects.get(iso=country_code)
/home/nathan/rb/site/rb/templates/rb/includes/topbar.html |
|||||||||||||||||||||
|
SELECT "polls_poll"."id",
"polls_poll"."start_date", "polls_poll"."end_date", "polls_poll"."description", "polls_poll"."poll_type", "polls_poll"."is_active" FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:00:54.195356+00:00'::timestamptz) ORDER BY "polls_poll"."start_date" DESC LIMIT 10 OFFSET 20SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:00:54.195356+00:00'::timestamptz) ORDER BY "polls_poll"."start_date" DESC LIMIT 10 OFFSET 20 |
0.14 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls})
/home/nathan/rb/site/digg_paginator/templates/rb/render_paginator_new.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
8 similar queries.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", "polls_polloptions"."color" AS "option__color", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 55) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 55) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC |
1.29 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(82) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_list.html |
|||||||||||||||||||||
|
SELECT "django_content_type"."id",
"django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'polls' AND "django_content_type"."model" = 'poll') LIMIT 21SELECT ••• FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'polls' AND "django_content_type"."model" = 'poll') LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(71) qs = self.get_queryset(context) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_queryset(88) qs = super().get_queryset(context) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_queryset(17) ctype, object_pk = self.get_target_ctype_pk(context) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in get_target_ctype_pk(111) return ContentType.objects.get_for_model(obj), obj.pk
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '55' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '55' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
1.59 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 55)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 55) |
0.14 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
8 similar queries.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", "polls_polloptions"."color" AS "option__color", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC |
0.67 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(82) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_list.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '54' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '54' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
1.82 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54) |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
8 similar queries.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", "polls_polloptions"."color" AS "option__color", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 53) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 53) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC |
1.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(82) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_list.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '53' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '53' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
1.71 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 53)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 53) |
0.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
4 similar queries.
Duplicated 2 times.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52) GROUP BY 1, 2, 3 ORDER BY 4 DESCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52) GROUP BY 1, 2, 3 ORDER BY 4 DESC |
0.31 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(90) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_selection.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
4 similar queries.
Duplicated 2 times.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52) GROUP BY 1, 2, 3 ORDER BY 4 DESCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52) GROUP BY 1, 2, 3 ORDER BY 4 DESC |
0.29 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(90) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_selection.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '52' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '52' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
2.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52) |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
8 similar queries.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", "polls_polloptions"."color" AS "option__color", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 51) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 51) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC |
1.32 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(82) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_list.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '51' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '51' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
2.87 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 51)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 51) |
0.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
8 similar queries.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", "polls_polloptions"."color" AS "option__color", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 49) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 49) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC |
1.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(82) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_list.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '49' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '49' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
4.00 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 49)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 49) |
0.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
8 similar queries.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", "polls_polloptions"."color" AS "option__color", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 50) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 50) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC |
0.41 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(82) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_list.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '50' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '50' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
1.70 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 50)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 50) |
0.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
8 similar queries.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", "polls_polloptions"."color" AS "option__color", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 48) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 48) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC |
0.53 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(82) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_list.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '48' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '48' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
3.90 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 48)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 48) |
0.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
4 similar queries.
Duplicated 2 times.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45) GROUP BY 1, 2, 3 ORDER BY 4 DESCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45) GROUP BY 1, 2, 3 ORDER BY 4 DESC |
0.83 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(90) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_selection.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
4 similar queries.
Duplicated 2 times.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45) GROUP BY 1, 2, 3 ORDER BY 4 DESCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45) GROUP BY 1, 2, 3 ORDER BY 4 DESC |
0.28 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(90) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_selection.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '45' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '45' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
1.46 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45) |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT "polls_pollvote"."option_id" AS "option__id",
8 similar queries.
"polls_polloptions"."text" AS "option__text", "polls_polloptions"."value" AS "option__value", "polls_polloptions"."color" AS "option__color", COUNT("polls_pollvote"."id") AS "num" FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 47) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 47) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC |
0.42 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_results(82) total = sum(v['num'] for v in votes)
/home/nathan/rb/site/polls/templates/polls/poll_options_list.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
10 similar queries.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '47' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '47' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
1.86 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
10 similar queries.
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 47)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 47) |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./polls/views.py in all_polls(36) return render(request, 'polls/all_polls.html', {'polls': polls}) /home/nathan/rb/site/./polls/models.py in get_num_votes(97) return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
No messages logged.