flakytest.dev anze3db fedidevs
Docs Sign In
Tests / starter_packs/tests.py

TestShareStarterPack::test_order_by_htmx_swaps_account_list

First seen 3 weeks ago in 0c23747
CI github-actions:test 11 runs
Average
157 ms
median 131 ms
max 270 ms
Phases
Setup 2 ms Call 154 ms Teardown 0.59 ms
Categories
Database 55 ms Test code 0.66 ms App code 0.08 ms Other (Libraries, Templates, pytest, Unsampled, ...) 101 ms

19 database queries per run

Needs 299 KB of memory (max 1 MB)

Duration per run

Where the time goes

Latest run in ci:github-actions:test, 7 hours ago · open run
Show pytest frames
setup3 ms2.4%
call119 ms97.3%
TransactionTestCase._post_teardowndjango/test/testcases.py:1243 self._fixture_teardown()59 ms48.0%
TestCase._fixture_teardowndjango/test/testcases.py:149859 ms48.0%
DatabaseWrapper.check_constraintsdjango/db/backends/postgresql/base.py:49559 ms48.0%
CursorWrapper.executedjango/db/backends/utils.py:7959 ms48.0%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9259 ms48.0%
CursorWrapper._executedjango/db/backends/utils.py:10359 ms48.0%
Cursor.executepsycopg/cursor.py:11359 ms48.0%
Connection.waitpsycopg/connection.py:49559 ms48.0%
BaseCursor._execute_genpsycopg/_cursor_base.py:20659 ms48.0%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:28659 ms48.0%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:7859 ms48.0%
TestShareStarterPack.test_order_by_htmx_swaps_account_liststarter_packs/tests.py:805 response = self.client.get(38 ms30.7%
Client.getdjango/test/client.py:113338 ms30.7%
RequestFactory.getdjango/test/client.py:47538 ms30.7%
RequestFactory.genericdjango/test/client.py:67138 ms30.7%
Client.requestdjango/test/client.py:109138 ms30.7%
ClientHandler.__call__django/test/client.py:17338 ms30.7%
BaseHandler.load_middlewaredjango/core/handlers/base.py:6338 ms30.7%
WhiteNoiseMiddleware.__init__whitenoise/middleware.py:10438 ms30.7%
WhiteNoise.add_fileswhitenoise/base.py:10838 ms30.7%
WhiteNoise.update_files_dictionarywhitenoise/base.py:12029 ms24.0%
WhiteNoise.add_file_to_dictionarywhitenoise/base.py:13126 ms21.3%
WhiteNoise.get_static_filewhitenoise/base.py:21716 ms13.3%
StaticFile.__init__whitenoise/responders.py:737 ms5.3%
StaticFile.get_headerswhitenoise/responders.py:1763 ms2.7%
formatdate<stdlib>/email/utils.py:2663 ms2.7%
StaticFile.get_headerswhitenoise/responders.py:1672 ms1.3%
StaticFile.get_headerswhitenoise/responders.py:1702 ms1.3%
StaticFile.__init__whitenoise/responders.py:727 ms5.3%
StaticFile.get_file_statswhitenoise/responders.py:1615 ms4.0%
__init____init__:-12 ms1.3%
FileEntry.__init__whitenoise/responders.py:2632 ms1.3%
FileEntry.stat_regular_filewhitenoise/responders.py:2762 ms1.3%
<GC>~2 ms1.3%
StaticFile.get_headerswhitenoise/responders.py:1782 ms1.3%
parsedate<stdlib>/email/_parseaddr.py:1852 ms1.3%
StaticFile.__init__whitenoise/responders.py:752 ms1.3%
Headers.__getitem__<stdlib>/wsgiref/headers.py:832 ms1.3%
Headers.get<stdlib>/wsgiref/headers.py:1062 ms1.3%
StaticFile.__init__whitenoise/responders.py:742 ms1.3%
parsedate<stdlib>/email/_parseaddr.py:1852 ms1.3%
WhiteNoise.get_static_filewhitenoise/base.py:2125 ms4.0%
WhiteNoise.add_cache_headerswhitenoise/base.py:2335 ms4.0%
WhiteNoiseMiddleware.immutable_file_testwhitenoise/middleware.py:1765 ms4.0%
WhiteNoiseMiddleware.get_static_urlwhitenoise/middleware.py:1975 ms4.0%
URLMixin.urldebug_toolbar/panels/staticfiles.py:205 ms4.0%
HashedFilesMixin.urldjango/contrib/staticfiles/storage.py:2353 ms2.7%
HashedFilesMixin._urldjango/contrib/staticfiles/storage.py:2163 ms2.7%
FileSystemStorage.urldjango/core/files/storage/filesystem.py:2073 ms2.7%
urljoin<stdlib>/urllib/parse.py:7653 ms2.7%
WhiteNoise.get_static_filewhitenoise/base.py:2115 ms4.0%
WhiteNoise.add_mime_headerswhitenoise/base.py:2302 ms1.3%
StaticFile.__init__whitenoise/responders.py:732 ms1.3%
StaticFile.get_headerswhitenoise/responders.py:1802 ms1.3%
WhiteNoise.update_files_dictionarywhitenoise/base.py:1158 ms6.7%
scantreewhitenoise/base.py:2718 ms6.7%
scantreewhitenoise/base.py:2718 ms6.7%
scantreewhitenoise/base.py:2715 ms4.0%
scantreewhitenoise/base.py:2715 ms4.0%
scantreewhitenoise/base.py:2715 ms4.0%
scantreewhitenoise/base.py:2735 ms4.0%
scantreewhitenoise/base.py:2733 ms2.7%
TestShareStarterPack.test_order_by_htmx_swaps_account_liststarter_packs/tests.py:804 accounts = self._set_up_orderable_accounts()23 ms18.7%
TestShareStarterPack._set_up_orderable_accountsstarter_packs/tests.py:764 Account.objects.bulk_update(accounts, ["followers_count", "display_name", "created_at", "last_status_at"])16 ms13.3%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:8716 ms13.3%
QuerySet.bulk_updatedjango/db/models/query.py:103011 ms9.3%
QuerySet.updatedjango/db/models/query.py:142110 ms8.0%
SQLUpdateCompiler.execute_sqldjango/db/models/sql/compiler.py:212110 ms8.0%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16257 ms5.3%
CursorWrapper.executedjango/db/backends/utils.py:797 ms5.3%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:927 ms5.3%
CursorWrapper._executedjango/db/backends/utils.py:1057 ms5.3%
Cursor.executepsycopg/cursor.py:1137 ms5.3%
Connection.waitpsycopg/connection.py:4957 ms5.3%
BaseCursor._execute_genpsycopg/_cursor_base.py:2067 ms5.3%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2867 ms5.3%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:787 ms5.3%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16123 ms2.7%
SQLUpdateCompiler.as_sqldjango/db/models/sql/compiler.py:20863 ms2.7%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5773 ms2.7%
Cast.as_postgresqldjango/db/models/functions/comparison.py:533 ms2.7%
Cast.as_sqldjango/db/models/functions/comparison.py:183 ms2.7%
Func.as_sqldjango/db/models/expressions.py:11113 ms2.7%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5793 ms2.7%
Case.as_sqldjango/db/models/expressions.py:17833 ms2.7%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5793 ms2.7%
Value.as_sqldjango/db/models/expressions.py:11723 ms2.7%
QuerySet.updatedjango/db/models/query.py:13952 ms1.3%
UpdateQuery.add_update_valuesdjango/db/models/sql/subqueries.py:1042 ms1.3%
UpdateQuery.add_update_fieldsdjango/db/models/sql/subqueries.py:1192 ms1.3%
BaseExpression.resolve_expressiondjango/db/models/expressions.py:3012 ms1.3%
BaseExpression.resolve_expressiondjango/db/models/expressions.py:3012 ms1.3%
When.resolve_expressiondjango/db/models/expressions.py:16762 ms1.3%
BaseExpression.resolve_expressiondjango/db/models/expressions.py:3012 ms1.3%
Q.resolve_expressiondjango/db/models/query_utils.py:1062 ms1.3%
Query._add_qdjango/db/models/sql/query.py:17282 ms1.3%
JoinPromoter.update_join_typesdjango/db/models/sql/query.py:28982 ms1.3%
QuerySet.bulk_updatedjango/db/models/query.py:10205 ms4.0%
deconstructible.<locals>.decorator.<locals>.__new__django/utils/deconstruct.py:175 ms4.0%
deconstructible.<locals>.decorator.<locals>.__new__django/utils/deconstruct.py:185 ms4.0%
TestShareStarterPack._set_up_orderable_accountsstarter_packs/tests.py:767 StarterPackAccount.objects.filter(pk=spa.pk).update(created_at=now - datetime.timedelta(hours=i))3 ms2.7%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:872 ms1.3%
QuerySet.filterdjango/db/models/query.py:16762 ms1.3%
QuerySet._filter_or_excludedjango/db/models/query.py:16942 ms1.3%
QuerySet._filter_or_exclude_inplacedjango/db/models/query.py:17042 ms1.3%
Query.add_qdjango/db/models/sql/query.py:16812 ms1.3%
Query._add_qdjango/db/models/sql/query.py:17132 ms1.3%
Query.build_filterdjango/db/models/sql/query.py:16132 ms1.3%
QuerySet.updatedjango/db/models/query.py:14212 ms1.3%
SQLUpdateCompiler.execute_sqldjango/db/models/sql/compiler.py:21212 ms1.3%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16252 ms1.3%
CursorWrapper.executedjango/db/backends/utils.py:792 ms1.3%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms1.3%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms1.3%
Cursor.executepsycopg/cursor.py:1132 ms1.3%
Connection.waitpsycopg/connection.py:4952 ms1.3%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms1.3%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2862 ms1.3%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:782 ms1.3%
TestShareStarterPack._set_up_orderable_accountsstarter_packs/tests.py:766 for i, spa in enumerate(StarterPackAccount.objects.order_by("id")):2 ms1.3%
QuerySet.__iter__django/db/models/query.py:4392 ms1.3%
QuerySet._fetch_alldjango/db/models/query.py:22622 ms1.3%
ModelIterable.__iter__django/db/models/query.py:1032 ms1.3%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16252 ms1.3%
CursorWrapper.executedjango/db/backends/utils.py:792 ms1.3%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms1.3%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms1.3%
Cursor.executepsycopg/cursor.py:1132 ms1.3%
Connection.waitpsycopg/connection.py:4952 ms1.3%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms1.3%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2862 ms1.3%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:782 ms1.3%
teardown0.37 ms0.3%
Estimated from 78 samples; phase durations are exact. Frames from pytest and pluggy are hidden .

Hot lines in your code

starter_packs/tests.py:805
response = self.client.get(
TestShareStarterPack.test_order_by_htmx_swaps_account_list · Libraries
38 ms
starter_packs/tests.py:764
Account.objects.bulk_update(accounts, ["followers_count", "display_name", "created_at", "last_status_at"])
TestShareStarterPack._set_up_orderable_accounts · Database
16 ms
starter_packs/tests.py:767
StarterPackAccount.objects.filter(pk=spa.pk).update(created_at=now - datetime.timedelta(hours=i))
TestShareStarterPack._set_up_orderable_accounts · Database
3 ms
starter_packs/tests.py:804
accounts = self._set_up_orderable_accounts()
TestShareStarterPack.test_order_by_htmx_swaps_account_list · Test code
2 ms
starter_packs/tests.py:766
for i, spa in enumerate(StarterPackAccount.objects.order_by("id")):
TestShareStarterPack._set_up_orderable_accounts · Database
2 ms

Fixtures

Exact setup time
_django_db_marker function 0.21 ms
_template_string_if_invalid_marker function 0.06 ms
_django_isolate_apps function 0.06 ms
_dj_autoclear_mailbox function 0.06 ms
_django_set_urlconf function 0.05 ms
_live_server_helper function 0.05 ms
_django_clear_site_cache function 0.04 ms
monkeypatch function 0.03 ms

Database

19 queries · 19 ms

Repeated queries are usually N+1 lookups: fetch them once with select_related / prefetch_related (or selectinload).

5× 
UPDATE "starter_packs_starterpackaccount" SET "created_at" = %s WHERE "starter_packs_starterpackaccount"."id" = %s

Biggest pieces of work

call test body
starter_packs/tests.py:804
 60 ms
call _post_teardown
django/test/testcases.py:1243
 59 ms
setup pytest internals 3 ms
teardown pytest internals 0.37 ms

Reliability

12 results · 0 CI failures · 0 local failures

This test hasn't failed recently.

History

Latest 12 results, oldest first in the strip
When Environment Outcome Duration Commit
7 hours ago CI github-actions:test passed 123 ms c28a326 main Profile
16 hours ago CI github-actions:test passed 85 ms 9b8826a main Profile
22 hours ago CI github-actions:test passed 135 ms 4f01055 main Profile
1 week, 5 days ago CI github-actions:test passed 102 ms 8ab642e main Profile
2 weeks, 2 days ago CI github-actions:test passed 104 ms 9b75244 main Profile
2 weeks, 2 days ago CI github-actions:test passed 131 ms 9603516 main Profile
2 weeks, 4 days ago CI github-actions:test passed 184 ms 615a272 main Profile
3 weeks ago CI github-actions:test passed 94 ms d923a46 main Profile
3 weeks ago CI github-actions:test passed 241 ms 82997f8 main Profile
3 weeks ago CI github-actions:test passed 270 ms 623aa3e main Profile
3 weeks ago CI github-actions:test passed 258 ms ab6465a main Profile
3 weeks ago CI github-actions:test passed 116 ms 0c23747 main Run