Tests / stats/tests.py
TestStats::test_posts_from_yesterday_are_updated
First seen 2 years, 10 months ago in 1cd3a8d
CI
github-actions:test
4 runs
Average
222 ms
median 241 ms
max 287 ms
max 287 ms
Phases
Setup 2 ms
Call 218 ms
Teardown 0.72 ms
Categories
Database 216 ms
App code 2 ms
Other (Libraries, Unsampled, pytest) 4 ms
108 database queries per run
Needs 0 KB of memory (max 0 KB)
Duration per run
Where the time goes
Latest run in ci:github-actions:test, 9 hours ago ·
open run
call116 ms99.2%
CallInfo.from_call_pytest/runner.py:361116 ms99.2%
call_and_report.<locals>.<lambda>_pytest/runner.py:250116 ms99.2%
HookCaller.__call__pluggy/_hooks.py:512116 ms99.2%
PluginManager._hookexecpluggy/_manager.py:120116 ms99.2%
_multicallpluggy/_callers.py:121116 ms99.2%
pytest_runtest_call_pytest/runner.py:184116 ms99.2%
_django_setup_unittest.<locals>.non_debugging_runtestpytest_django/plugin.py:614116 ms99.2%
SimpleTestCase.__call__django/test/testcases.py:314116 ms99.2%
SimpleTestCase._setup_and_calldjango/test/testcases.py:369114 ms97.1%
TestCase.__call__<stdlib>/unittest/case.py:747114 ms97.1%
TestCase.run<stdlib>/unittest/case.py:691114 ms97.1%
TestCase._callTestMethod<stdlib>/unittest/case.py:637114 ms97.1%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:156 store_daily_stats()89 ms75.8%
store_daily_statsstats/models.py:20 ).count()52 ms44.8%
QuerySet.countdjango/db/models/query.py:67752 ms44.8%
Query.get_countdjango/db/models/sql/query.py:65752 ms44.8%
Query.get_aggregationdjango/db/models/sql/query.py:63950 ms42.7%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:162542 ms36.3%
CursorWrapper.executedjango/db/backends/utils.py:7942 ms36.3%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9242 ms36.3%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:10040 ms34.1%
CursorWrapper._executedjango/db/backends/utils.py:10540 ms34.1%
Cursor.executepsycopg/cursor.py:11340 ms34.1%
Connection.waitpsycopg/connection.py:49540 ms34.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:20624 ms20.3%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:28624 ms20.3%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:7824 ms20.3%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1022 ms2.1%
QueryStats.addflakytest/profiling/dbtrack.py:382 ms2.1%
normalize_sqlflakytest/profiling/dbtrack.py:251 ms1.1%
normalize_sqlflakytest/profiling/dbtrack.py:231 ms1.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16126 ms5.3%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7934 ms3.2%
SQLCompiler.get_from_clausedjango/db/models/sql/compiler.py:11604 ms3.2%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5794 ms3.2%
Join.as_sqldjango/db/models/sql/datastructures.py:884 ms3.2%
DatabaseOperations.prepare_join_on_clausedjango/db/backends/postgresql/operations.py:4024 ms3.2%
ForeignKey.db_typedjango/db/models/fields/related.py:13094 ms3.2%
BigAutoField.rel_db_typedjango/db/models/fields/__init__.py:29772 ms2.1%
Field.db_typedjango/db/models/fields/__init__.py:9251 ms1.1%
Field.db_typedjango/db/models/fields/__init__.py:9181 ms1.1%
Field.db_type_parametersdjango/db/models/fields/__init__.py:8821 ms1.1%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7681 ms1.1%
SQLCompiler.pre_sql_setupdjango/db/models/sql/compiler.py:891 ms1.1%
SQLCompiler.setup_querydjango/db/models/sql/compiler.py:781 ms1.1%
SQLCompiler.get_selectdjango/db/models/sql/compiler.py:3191 ms1.1%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5791 ms1.1%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7961 ms1.1%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5791 ms1.1%
WhereNode.as_sqldjango/db/models/sql/where.py:1511 ms1.1%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5791 ms1.1%
BuiltinLookup.as_sqldjango/db/models/lookups.py:2431 ms1.1%
BuiltinLookup.process_lhsdjango/db/models/lookups.py:2351 ms1.1%
Lookup.process_lhsdjango/db/models/lookups.py:1091 ms1.1%
BaseExpression.resolve_expressiondjango/db/models/expressions.py:2971 ms1.1%
BaseExpression.copydjango/db/models/expressions.py:4441 ms1.1%
copy<stdlib>/copy.py:1001 ms1.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16441 ms1.1%
DatabaseErrorWrapper.__call__.<locals>.innerdjango/db/utils.py:1011 ms1.1%
Cursor.fetchonepsycopg/cursor.py:2501 ms1.1%
Query.get_aggregationdjango/db/models/sql/query.py:4711 ms1.1%
Query.get_aggregationdjango/db/models/sql/query.py:4721 ms1.1%
store_daily_statsstats/models.py:12 f"{lang.code}_accounts": AccountLookup.objects.filter(language__icontains=lang.code + "\n").count()25 ms21.3%
QuerySet.countdjango/db/models/query.py:67722 ms19.2%
Query.get_countdjango/db/models/sql/query.py:65721 ms18.1%
Query.get_aggregationdjango/db/models/sql/query.py:63921 ms18.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:162521 ms18.1%
CursorWrapper.executedjango/db/backends/utils.py:7921 ms18.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9221 ms18.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:10021 ms18.1%
CursorWrapper._executedjango/db/backends/utils.py:10521 ms18.1%
Cursor.executepsycopg/cursor.py:11321 ms18.1%
Connection.waitpsycopg/connection.py:49521 ms18.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:20616 ms13.9%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:28616 ms13.9%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:7816 ms13.9%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:872 ms2.1%
QuerySet.filterdjango/db/models/query.py:16762 ms2.1%
QuerySet._filter_or_excludedjango/db/models/query.py:16942 ms2.1%
QuerySet._filter_or_exclude_inplacedjango/db/models/query.py:17042 ms2.1%
Query.add_qdjango/db/models/sql/query.py:16812 ms2.1%
Query._add_qdjango/db/models/sql/query.py:17132 ms2.1%
Query.build_filterdjango/db/models/sql/query.py:16131 ms1.1%
Query.build_filterdjango/db/models/sql/query.py:16111 ms1.1%
store_daily_statsstats/models.py:25 Daily.objects.update_or_create(date=today, defaults=account_defaults | post_defaults)5 ms4.3%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:875 ms4.3%
QuerySet.update_or_createdjango/db/models/query.py:10965 ms4.3%
QuerySet.get_or_createdjango/db/models/query.py:10545 ms4.3%
QuerySet.getdjango/db/models/query.py:7025 ms4.3%
QuerySet.__len__django/db/models/query.py:4215 ms4.3%
QuerySet._fetch_alldjango/db/models/query.py:22625 ms4.3%
ModelIterable.__iter__django/db/models/query.py:1034 ms3.2%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16254 ms3.2%
CursorWrapper.executedjango/db/backends/utils.py:794 ms3.2%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:924 ms3.2%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1004 ms3.2%
CursorWrapper._executedjango/db/backends/utils.py:1054 ms3.2%
Cursor.executepsycopg/cursor.py:1134 ms3.2%
Connection.waitpsycopg/connection.py:4954 ms3.2%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms2.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2862 ms2.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:782 ms2.1%
ModelIterable.__iter__django/db/models/query.py:1351 ms1.1%
SQLCompiler.results_iterdjango/db/models/sql/compiler.py:15781 ms1.1%
SQLCompiler.get_convertersdjango/db/models/sql/compiler.py:15271 ms1.1%
Col.get_db_convertersdjango/db/models/expressions.py:13841 ms1.1%
store_daily_statsstats/models.py:18 f"{lang.code}_posts": Post.objects.filter(4 ms3.2%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:872 ms2.1%
QuerySet.filterdjango/db/models/query.py:16762 ms2.1%
QuerySet._filter_or_excludedjango/db/models/query.py:16942 ms2.1%
QuerySet._filter_or_exclude_inplacedjango/db/models/query.py:17042 ms2.1%
Query.add_qdjango/db/models/sql/query.py:16812 ms2.1%
Query._add_qdjango/db/models/sql/query.py:17132 ms2.1%
Query.build_filterdjango/db/models/sql/query.py:15771 ms1.1%
Query.setup_joinsdjango/db/models/sql/query.py:19921 ms1.1%
Query.build_filterdjango/db/models/sql/query.py:16131 ms1.1%
store_daily_statsstats/models.py:15 account_defaults["total_accounts"] = Account.objects.filter(accountlookup__isnull=False).count()2 ms2.1%
QuerySet.countdjango/db/models/query.py:6772 ms2.1%
Query.get_countdjango/db/models/sql/query.py:6572 ms2.1%
Query.get_aggregationdjango/db/models/sql/query.py:6392 ms2.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16252 ms2.1%
CursorWrapper.executedjango/db/backends/utils.py:792 ms2.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms2.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1002 ms2.1%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms2.1%
Cursor.executepsycopg/cursor.py:1132 ms2.1%
Connection.waitpsycopg/connection.py:4952 ms2.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms2.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2862 ms2.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:782 ms2.1%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:93 account = Account.objects.create(7 ms6.4%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:877 ms6.4%
QuerySet.createdjango/db/models/query.py:7367 ms6.4%
Model.savedjango/db/models/base.py:9047 ms6.4%
Model.save_basedjango/db/models/base.py:9967 ms6.4%
Model._save_tabledjango/db/models/base.py:11997 ms6.4%
Model._do_insertdjango/db/models/base.py:12517 ms6.4%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:877 ms6.4%
QuerySet._insertdjango/db/models/query.py:21417 ms6.4%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19367 ms6.4%
CursorWrapper.executedjango/db/backends/utils.py:797 ms6.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:927 ms6.4%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1007 ms6.4%
CursorWrapper._executedjango/db/backends/utils.py:1057 ms6.4%
Cursor.executepsycopg/cursor.py:1137 ms6.4%
Connection.waitpsycopg/connection.py:4957 ms6.4%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:70 yesterday_stats = Daily.objects.create(6 ms5.3%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:876 ms5.3%
QuerySet.createdjango/db/models/query.py:7366 ms5.3%
Model.savedjango/db/models/base.py:9046 ms5.3%
Model.save_basedjango/db/models/base.py:9966 ms5.3%
Model._save_tabledjango/db/models/base.py:11996 ms5.3%
Model._do_insertdjango/db/models/base.py:12516 ms5.3%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:876 ms5.3%
QuerySet._insertdjango/db/models/query.py:21416 ms5.3%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19364 ms3.2%
CursorWrapper.executedjango/db/backends/utils.py:794 ms3.2%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:924 ms3.2%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1002 ms2.1%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms2.1%
Cursor.executepsycopg/cursor.py:1132 ms2.1%
Connection.waitpsycopg/connection.py:4952 ms2.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1021 ms1.1%
QueryStats.addflakytest/profiling/dbtrack.py:381 ms1.1%
normalize_sqlflakytest/profiling/dbtrack.py:241 ms1.1%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19352 ms2.1%
SQLInsertCompiler.as_sqldjango/db/models/sql/compiler.py:18201 ms1.1%
SQLInsertCompiler.as_sqldjango/db/models/sql/compiler.py:18941 ms1.1%
DatabaseOperations.bulk_insert_sqldjango/db/backends/postgresql/operations.py:1561 ms1.1%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:120 Post.objects.create(5 ms4.3%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:875 ms4.3%
QuerySet.createdjango/db/models/query.py:7362 ms2.1%
Model.savedjango/db/models/base.py:9042 ms2.1%
Model.save_basedjango/db/models/base.py:9962 ms2.1%
Model._save_tabledjango/db/models/base.py:11992 ms2.1%
Model._do_insertdjango/db/models/base.py:12512 ms2.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:872 ms2.1%
QuerySet._insertdjango/db/models/query.py:21412 ms2.1%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19362 ms2.1%
CursorWrapper.executedjango/db/backends/utils.py:792 ms2.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms2.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1002 ms2.1%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms2.1%
Cursor.executepsycopg/cursor.py:1132 ms2.1%
Connection.waitpsycopg/connection.py:4952 ms2.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms2.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2862 ms2.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:782 ms2.1%
QuerySet.createdjango/db/models/query.py:7341 ms1.1%
Model.__init__django/db/models/base.py:5201 ms1.1%
cached_property.__get__django/utils/functional.py:471 ms1.1%
Options.concrete_fieldsdjango/db/models/options.py:5821 ms1.1%
make_immutable_fields_listdjango/db/models/options.py:871 ms1.1%
ImmutableList.__new__django/utils/datastructures.py:2361 ms1.1%
Options.concrete_fields.<locals>.<genexpr>django/db/models/options.py:5831 ms1.1%
QuerySet.createdjango/db/models/query.py:7371 ms1.1%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:159 yesterday_stats.refresh_from_db()2 ms2.1%
Model.refresh_from_dbdjango/db/models/base.py:7882 ms2.1%
QuerySet.getdjango/db/models/query.py:7022 ms2.1%
QuerySet.__len__django/db/models/query.py:4212 ms2.1%
QuerySet._fetch_alldjango/db/models/query.py:22622 ms2.1%
ModelIterable.__iter__django/db/models/query.py:1032 ms2.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16121 ms1.1%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7961 ms1.1%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5791 ms1.1%
WhereNode.as_sqldjango/db/models/sql/where.py:1511 ms1.1%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5791 ms1.1%
Exact.as_sqldjango/db/models/lookups.py:4071 ms1.1%
BuiltinLookup.as_sqldjango/db/models/lookups.py:2431 ms1.1%
BuiltinLookup.process_lhsdjango/db/models/lookups.py:2351 ms1.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16251 ms1.1%
CursorWrapper.executedjango/db/backends/utils.py:791 ms1.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms1.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1001 ms1.1%
CursorWrapper._executedjango/db/backends/utils.py:1051 ms1.1%
Cursor.executepsycopg/cursor.py:1131 ms1.1%
Connection.waitpsycopg/connection.py:4951 ms1.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2061 ms1.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2861 ms1.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:781 ms1.1%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:119 AccountLookup.objects.create(account=account, language="python\n")1 ms1.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:871 ms1.1%
QuerySet.createdjango/db/models/query.py:7361 ms1.1%
Model.savedjango/db/models/base.py:9041 ms1.1%
Model.save_basedjango/db/models/base.py:9961 ms1.1%
Model._save_tabledjango/db/models/base.py:11991 ms1.1%
Model._do_insertdjango/db/models/base.py:12511 ms1.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:871 ms1.1%
QuerySet._insertdjango/db/models/query.py:21411 ms1.1%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19361 ms1.1%
CursorWrapper.executedjango/db/backends/utils.py:791 ms1.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms1.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1001 ms1.1%
CursorWrapper._executedjango/db/backends/utils.py:1051 ms1.1%
Cursor.executepsycopg/cursor.py:1131 ms1.1%
Connection.waitpsycopg/connection.py:4951 ms1.1%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:138 Post.objects.create(1 ms1.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:871 ms1.1%
QuerySet.createdjango/db/models/query.py:7361 ms1.1%
Model.savedjango/db/models/base.py:9041 ms1.1%
Model.save_basedjango/db/models/base.py:9961 ms1.1%
Model._save_tabledjango/db/models/base.py:11991 ms1.1%
Model._do_insertdjango/db/models/base.py:12511 ms1.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:871 ms1.1%
QuerySet._insertdjango/db/models/query.py:21411 ms1.1%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19361 ms1.1%
CursorWrapper.executedjango/db/backends/utils.py:791 ms1.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms1.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1001 ms1.1%
CursorWrapper._executedjango/db/backends/utils.py:1051 ms1.1%
Cursor.executepsycopg/cursor.py:1131 ms1.1%
Connection.waitpsycopg/connection.py:4951 ms1.1%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:164 today_stats = Daily.objects.get(date=today.date())1 ms1.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:871 ms1.1%
QuerySet.getdjango/db/models/query.py:7021 ms1.1%
QuerySet.__len__django/db/models/query.py:4211 ms1.1%
QuerySet._fetch_alldjango/db/models/query.py:22621 ms1.1%
ModelIterable.__iter__django/db/models/query.py:1031 ms1.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16251 ms1.1%
CursorWrapper.executedjango/db/backends/utils.py:791 ms1.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms1.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1021 ms1.1%
QueryStats.addflakytest/profiling/dbtrack.py:381 ms1.1%
normalize_sqlflakytest/profiling/dbtrack.py:231 ms1.1%
SimpleTestCase._setup_and_calldjango/test/testcases.py:3601 ms1.1%
TransactionTestCase._pre_setupdjango/test/testcases.py:1167 cls._fixture_setup()1 ms1.1%
TestCase._fixture_setupdjango/test/testcases.py:14811 ms1.1%
TestCase._enter_atomicsdjango/test/testcases.py:13991 ms1.1%
Atomic.__enter__django/db/transaction.py:2231 ms1.1%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms1.1%
BaseDatabaseWrapper.savepointdjango/db/backends/base/base.py:4001 ms1.1%
BaseDatabaseWrapper._savepointdjango/db/backends/base/base.py:3671 ms1.1%
CursorWrapper.executedjango/db/backends/utils.py:791 ms1.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms1.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1001 ms1.1%
CursorWrapper._executedjango/db/backends/utils.py:1031 ms1.1%
Cursor.executepsycopg/cursor.py:1131 ms1.1%
Connection.waitpsycopg/connection.py:4951 ms1.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2061 ms1.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2861 ms1.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:781 ms1.1%
SimpleTestCase._setup_and_calldjango/test/testcases.py:3721 ms1.1%
TransactionTestCase._post_teardowndjango/test/testcases.py:1243 self._fixture_teardown()1 ms1.1%
TestCase._fixture_teardowndjango/test/testcases.py:14981 ms1.1%
DatabaseWrapper.check_constraintsdjango/db/backends/postgresql/base.py:4951 ms1.1%
CursorWrapper.executedjango/db/backends/utils.py:791 ms1.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms1.1%
QueryTracker._django_wrapperflakytest/profiling/dbtrack.py:1001 ms1.1%
CursorWrapper._executedjango/db/backends/utils.py:1031 ms1.1%
Cursor.executepsycopg/cursor.py:1131 ms1.1%
Connection.waitpsycopg/connection.py:4951 ms1.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2061 ms1.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2861 ms1.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:781 ms1.1%
Estimated from 93 samples; phase durations are exact. Frames from pytest and pluggy are
shown
.
Hot lines in your code
|
stats/models.py:20
).count()
store_daily_stats
· Database
|
52 ms |
|
stats/models.py:12
f"{lang.code}_accounts": AccountLookup.objects.filter(language__icontains=lang.code + "\n").count()
store_daily_stats
· Database
|
25 ms |
|
stats/tests.py:93
account = Account.objects.create(
TestStats.test_posts_from_yesterday_are_updated
· Database
|
7 ms |
|
stats/tests.py:70
yesterday_stats = Daily.objects.create(
TestStats.test_posts_from_yesterday_are_updated
· Database
|
6 ms |
|
stats/tests.py:120
Post.objects.create(
TestStats.test_posts_from_yesterday_are_updated
· Database
|
5 ms |
|
stats/models.py:25
Daily.objects.update_or_create(date=today, defaults=account_defaults | post_defaults)
store_daily_stats
· Database
|
5 ms |
|
stats/models.py:18
f"{lang.code}_posts": Post.objects.filter(
store_daily_stats
· Database
|
4 ms |
|
stats/models.py:15
account_defaults["total_accounts"] = Account.objects.filter(accountlookup__isnull=False).count()
store_daily_stats
· Database
|
2 ms |
|
stats/tests.py:159
yesterday_stats.refresh_from_db()
TestStats.test_posts_from_yesterday_are_updated
· Database
|
2 ms |
|
stats/tests.py:119
AccountLookup.objects.create(account=account, language="python\n")
TestStats.test_posts_from_yesterday_are_updated
· Database
|
1 ms |
Fixtures
Exact setup time| _dj_autoclear_mailbox function | 0.06 ms |
| _template_string_if_invalid_marker function | 0.03 ms |
| _django_db_marker function | 0.03 ms |
| _django_isolate_apps function | 0.03 ms |
| _live_server_helper function | 0.03 ms |
| _django_clear_site_cache function | 0.02 ms |
| _django_set_urlconf function | 0.02 ms |
| monkeypatch function | 0.02 ms |
Database
108 queries · 71 ms
Repeated queries are usually N+1 lookups: fetch them once with select_related / prefetch_related (or selectinload).
44×
SELECT COUNT(*) AS "__count" FROM "accounts_accountlookup" WHERE UPPER("accounts_accountlookup"."language"::text) LIKE UPPER(%s)
44×
SELECT COUNT(*) AS "__count" FROM "posts_post" INNER JOIN "accounts_account" ON ("posts_post"."account_id" = "accounts_account"."id") INNER JOIN "accounts_accountlookup" ON ("accounts_account"."id" = "accounts_accountlookup"."account_id") WHERE UPPER("accounts_accountlookup"."language"::text) LIKE …
3×
SELECT "stats_daily"."id", "stats_daily"."date", "stats_daily"."total_accounts", "stats_daily"."python_accounts", "stats_daily"."javascript_accounts", "stats_daily"."typescript_accounts", "stats_daily"."rust_accounts", "stats_daily"."ruby_accounts", "stats_daily"."golang_accounts", "stats_daily"."j…
Biggest pieces of work
|
call test body
stats/tests.py:156
|
114 ms |
|
call _pre_setup
django/test/testcases.py:1167
|
1 ms |
|
call _post_teardown
django/test/testcases.py:1243
|
1 ms |
Reliability
5 results · 0 CI failures · 0 local failuresThis test hasn't failed recently.
History
Latest 50 results, oldest first in the strip| When | Environment | Outcome | Duration | |
|---|---|---|---|---|
| 9 hours ago | CI github-actions:test | passed | 117 ms | Profile |
| 9 hours ago | CI github-actions:test | passed | 213 ms | Profile |
| 9 hours ago | CI github-actions:test | passed | 268 ms | Profile |
| 14 hours ago | CI github-actions:test | passed | 287 ms | Profile |
| 14 hours ago | CI github-actions:test | passed | 140 ms | Run |
| 3 months, 3 weeks ago | CI github-actions | passed | 70 ms | Run |
| 3 months, 3 weeks ago | CI github-actions | passed | 109 ms | Run |
| 3 months, 3 weeks ago | CI github-actions | passed | 101 ms | Run |
| 3 months, 3 weeks ago | CI github-actions | passed | 106 ms | Run |
| 3 months, 3 weeks ago | CI github-actions | passed | 100 ms | Run |
| 3 months, 3 weeks ago | CI github-actions | passed | 102 ms | Run |
| 3 months, 3 weeks ago | CI github-actions | passed | 99 ms | Run |
| 3 months, 3 weeks ago | CI github-actions | passed | 106 ms | Run |
| 3 months, 3 weeks ago | CI github-actions | passed | 107 ms | Run |
| 3 months, 4 weeks ago | CI github-actions | passed | 106 ms | Run |
| 3 months, 4 weeks ago | CI github-actions | passed | 102 ms | Run |
| 3 months, 4 weeks ago | CI github-actions | passed | 115 ms | Run |
| 3 months, 4 weeks ago | CI github-actions | passed | 98 ms | Run |
| 3 months, 4 weeks ago | CI github-actions | passed | 105 ms | Run |
| 3 months, 4 weeks ago | CI github-actions | passed | 104 ms | Run |