Tests / stats/tests.py
TestStats::test_posts_from_yesterday_are_updated
First seen 2 years, 11 months ago in 1cd3a8d
CI
github-actions:test
11 runs
Average
202 ms
median 198 ms
max 287 ms
max 287 ms
Phases
Setup 6 ms
Call 195 ms
Teardown 0.57 ms
Categories
Database 198 ms
App code 1 ms
Test code 0.11 ms
Other (Libraries, pytest, Unsampled) 3 ms
108 database queries per run
Needs 2 KB of memory (max 20 KB)
Duration per run
Where the time goes
Latest run in ci:github-actions:test, 7 hours ago ·
open run
setup14 ms6.9%
TestCase.setUpClassdjango/test/testcases.py:1426 cls.cls_atomics = cls._enter_atomics()14 ms6.9%
TestCase._enter_atomicsdjango/test/testcases.py:139914 ms6.9%
Atomic.__enter__django/db/transaction.py:21014 ms6.9%
BaseDatabaseWrapper.get_autocommitdjango/db/backends/base/base.py:45414 ms6.9%
SimpleTestCase.ensure_connection_patch_method.<locals>.patched_ensure_connectiondjango/test/testcases.py:30414 ms6.9%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:2614 ms6.9%
BaseDatabaseWrapper.ensure_connectiondjango/db/backends/base/base.py:27914 ms6.9%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:2614 ms6.9%
BaseDatabaseWrapper.connectdjango/db/backends/base/base.py:25614 ms6.9%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:2614 ms6.9%
DatabaseWrapper.get_new_connectiondjango/db/backends/postgresql/base.py:34514 ms6.9%
Connection.connectpsycopg/connection.py:10914 ms6.9%
wait_connpsycopg/waiting.py:1417 ms3.4%
EpollSelector.select<stdlib>/selectors.py:4527 ms3.4%
wait_connpsycopg/waiting.py:1457 ms3.4%
BaseConnection._connect_genpsycopg/_connection_base.py:4397 ms3.4%
call190 ms93.0%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:156 store_daily_stats()141 ms69.2%
store_daily_statsstats/models.py:20 ).count()65 ms31.9%
QuerySet.countdjango/db/models/query.py:67765 ms31.9%
Query.get_countdjango/db/models/sql/query.py:65765 ms31.9%
Query.get_aggregationdjango/db/models/sql/query.py:63955 ms27.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:162536 ms17.6%
CursorWrapper.executedjango/db/backends/utils.py:7936 ms17.6%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9236 ms17.6%
CursorWrapper._executedjango/db/backends/utils.py:10535 ms17.0%
Cursor.executepsycopg/cursor.py:11335 ms17.0%
Connection.waitpsycopg/connection.py:49535 ms17.0%
BaseCursor._execute_genpsycopg/_cursor_base.py:20626 ms12.9%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:28626 ms12.9%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:7826 ms12.9%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:162314 ms6.8%
CursorWrapper.executedjango/db/backends/utils.py:7910 ms4.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9210 ms4.7%
CursorWrapper._executedjango/db/backends/utils.py:10510 ms4.7%
Cursor.executepsycopg/cursor.py:11310 ms4.7%
Connection.waitpsycopg/connection.py:49510 ms4.7%
BaseCursor._execute_genpsycopg/_cursor_base.py:20610 ms4.7%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:28610 ms4.7%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:7810 ms4.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:263 ms1.4%
BaseDatabaseWrapper.cursordjango/db/backends/base/base.py:3201 ms0.7%
BaseDatabaseWrapper._cursordjango/db/backends/base/base.py:2981 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:-11 ms0.7%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16126 ms2.7%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7931 ms0.7%
SQLCompiler.get_from_clausedjango/db/models/sql/compiler.py:11601 ms0.7%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5791 ms0.7%
Join.as_sqldjango/db/models/sql/datastructures.py:881 ms0.7%
DatabaseOperations.prepare_join_on_clausedjango/db/backends/postgresql/operations.py:4021 ms0.7%
ForeignKey.db_typedjango/db/models/fields/related.py:13091 ms0.7%
BigAutoField.rel_db_typedjango/db/models/fields/__init__.py:29771 ms0.7%
Field.__init__django/db/models/fields/__init__.py:2621 ms0.7%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:9821 ms0.7%
CursorWrapper.executedjango/db/backends/utils.py:791 ms0.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms0.7%
CursorWrapper._executedjango/db/backends/utils.py:1051 ms0.7%
Cursor.executepsycopg/cursor.py:1131 ms0.7%
Connection.waitpsycopg/connection.py:4951 ms0.7%
BaseCursor._execute_genpsycopg/_cursor_base.py:2061 ms0.7%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2861 ms0.7%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:781 ms0.7%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7681 ms0.7%
SQLCompiler.pre_sql_setupdjango/db/models/sql/compiler.py:891 ms0.7%
SQLCompiler.setup_querydjango/db/models/sql/compiler.py:781 ms0.7%
SQLCompiler.get_selectdjango/db/models/sql/compiler.py:3191 ms0.7%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5791 ms0.7%
Query.get_aggregationdjango/db/models/sql/query.py:6381 ms0.7%
Query.get_aggregationdjango/db/models/sql/query.py:4911 ms0.7%
Expression.__hash__django/db/models/expressions.py:5621 ms0.7%
cached_property.__get__django/utils/functional.py:471 ms0.7%
Expression.identitydjango/db/models/expressions.py:5521 ms0.7%
Query.get_aggregationdjango/db/models/sql/query.py:6441 ms0.7%
Query.get_aggregationdjango/db/models/sql/query.py:4721 ms0.7%
Count.resolve_expressiondjango/db/models/aggregates.py:3121 ms0.7%
Aggregate.resolve_expressiondjango/db/models/aggregates.py:1251 ms0.7%
BaseExpression.resolve_expressiondjango/db/models/expressions.py:2971 ms0.7%
Func.copydjango/db/models/expressions.py:11371 ms0.7%
BaseExpression.copydjango/db/models/expressions.py:4441 ms0.7%
copy<stdlib>/copy.py:1001 ms0.7%
Query.get_aggregationdjango/db/models/sql/query.py:6331 ms0.7%
store_daily_statsstats/models.py:12 f"{lang.code}_accounts": AccountLookup.objects.filter(language__icontains=lang.code + "\n").count()53 ms25.8%
QuerySet.countdjango/db/models/query.py:67746 ms22.4%
Query.get_countdjango/db/models/sql/query.py:65746 ms22.4%
Query.get_aggregationdjango/db/models/sql/query.py:63942 ms20.4%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:162539 ms19.0%
CursorWrapper.executedjango/db/backends/utils.py:7939 ms19.0%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9239 ms19.0%
CursorWrapper._executedjango/db/backends/utils.py:10539 ms19.0%
Cursor.executepsycopg/cursor.py:11339 ms19.0%
Connection.waitpsycopg/connection.py:49539 ms19.0%
BaseCursor._execute_genpsycopg/_cursor_base.py:2067 ms3.4%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2867 ms3.4%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:787 ms3.4%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16231 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms0.7%
BaseDatabaseWrapper.cursordjango/db/backends/base/base.py:3201 ms0.7%
BaseDatabaseWrapper._cursordjango/db/backends/base/base.py:2981 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms0.7%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16441 ms0.7%
DatabaseErrorWrapper.__call__.<locals>.innerdjango/db/utils.py:1011 ms0.7%
Query.get_aggregationdjango/db/models/sql/query.py:4721 ms0.7%
Count.resolve_expressiondjango/db/models/aggregates.py:3121 ms0.7%
Aggregate.resolve_expressiondjango/db/models/aggregates.py:1251 ms0.7%
BaseExpression.resolve_expressiondjango/db/models/expressions.py:3011 ms0.7%
Query.get_aggregationdjango/db/models/sql/query.py:6441 ms0.7%
SQLCompiler.get_convertersdjango/db/models/sql/compiler.py:15191 ms0.7%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:877 ms3.4%
QuerySet.filterdjango/db/models/query.py:16767 ms3.4%
QuerySet._filter_or_excludedjango/db/models/query.py:16946 ms2.7%
QuerySet._filter_or_exclude_inplacedjango/db/models/query.py:17044 ms2.0%
Query.add_qdjango/db/models/sql/query.py:16814 ms2.0%
Query._add_qdjango/db/models/sql/query.py:17133 ms1.4%
Query.build_filterdjango/db/models/sql/query.py:16131 ms0.7%
Query.build_lookupdjango/db/models/sql/query.py:14401 ms0.7%
Query.build_filterdjango/db/models/sql/query.py:16111 ms0.7%
Query._get_coldjango/db/models/sql/query.py:4561 ms0.7%
QuerySet._filter_or_exclude_inplacedjango/db/models/query.py:16981 ms0.7%
store_daily_statsstats/models.py:25 Daily.objects.update_or_create(date=today, defaults=account_defaults | post_defaults)19 ms9.5%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:8719 ms9.5%
QuerySet.update_or_createdjango/db/models/query.py:109617 ms8.1%
QuerySet.get_or_createdjango/db/models/query.py:10548 ms4.1%
QuerySet.getdjango/db/models/query.py:7028 ms4.1%
QuerySet.__len__django/db/models/query.py:4218 ms4.1%
QuerySet._fetch_alldjango/db/models/query.py:22628 ms4.1%
ModelIterable.__iter__django/db/models/query.py:1038 ms4.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16257 ms3.4%
CursorWrapper.executedjango/db/backends/utils.py:797 ms3.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:927 ms3.4%
CursorWrapper._executedjango/db/backends/utils.py:1057 ms3.4%
Cursor.executepsycopg/cursor.py:1137 ms3.4%
Connection.waitpsycopg/connection.py:4957 ms3.4%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16121 ms0.7%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7681 ms0.7%
SQLCompiler.pre_sql_setupdjango/db/models/sql/compiler.py:891 ms0.7%
SQLCompiler.setup_querydjango/db/models/sql/compiler.py:781 ms0.7%
SQLCompiler.get_selectdjango/db/models/sql/compiler.py:3191 ms0.7%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5791 ms0.7%
QuerySet.get_or_createdjango/db/models/query.py:10616 ms2.7%
QuerySet.createdjango/db/models/query.py:7366 ms2.7%
Model.savedjango/db/models/base.py:9046 ms2.7%
Model.save_basedjango/db/models/base.py:9966 ms2.7%
Model._save_tabledjango/db/models/base.py:11996 ms2.7%
Model._do_insertdjango/db/models/base.py:12516 ms2.7%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:876 ms2.7%
QuerySet._insertdjango/db/models/query.py:21416 ms2.7%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19366 ms2.7%
CursorWrapper.executedjango/db/backends/utils.py:796 ms2.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:926 ms2.7%
CursorWrapper._executedjango/db/backends/utils.py:1056 ms2.7%
Cursor.executepsycopg/cursor.py:1136 ms2.7%
Connection.waitpsycopg/connection.py:4956 ms2.7%
BaseCursor._execute_genpsycopg/_cursor_base.py:2053 ms1.4%
BaseCursor._convert_querypsycopg/_cursor_base.py:4653 ms1.4%
PostgresClientQuery.convertpsycopg/_queries.py:2843 ms1.4%
_query2pg_client_nocachepsycopg/_queries.py:3293 ms1.4%
_split_querypsycopg/_queries.py:3851 ms0.7%
_split_querypsycopg/_queries.py:4251 ms0.7%
BaseCursor._execute_genpsycopg/_cursor_base.py:2061 ms0.7%
QuerySet.get_or_createdjango/db/models/query.py:10593 ms1.4%
Atomic.__enter__django/db/transaction.py:2231 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms0.7%
BaseDatabaseWrapper.savepointdjango/db/backends/base/base.py:4001 ms0.7%
BaseDatabaseWrapper._savepointdjango/db/backends/base/base.py:3671 ms0.7%
CursorWrapper.executedjango/db/backends/utils.py:791 ms0.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms0.7%
CursorWrapper._executedjango/db/backends/utils.py:1031 ms0.7%
Cursor.executepsycopg/cursor.py:1131 ms0.7%
Connection.waitpsycopg/connection.py:4951 ms0.7%
Atomic.__exit__django/db/transaction.py:2591 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms0.7%
BaseDatabaseWrapper.savepoint_commitdjango/db/backends/base/base.py:4311 ms0.7%
BaseDatabaseWrapper._savepoint_commitdjango/db/backends/base/base.py:3751 ms0.7%
CursorWrapper.executedjango/db/backends/utils.py:791 ms0.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms0.7%
CursorWrapper._executedjango/db/backends/utils.py:1031 ms0.7%
Cursor.executepsycopg/cursor.py:1131 ms0.7%
Connection.waitpsycopg/connection.py:4951 ms0.7%
QuerySet.update_or_createdjango/db/models/query.py:10933 ms1.4%
Atomic.__enter__django/db/transaction.py:2231 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms0.7%
BaseDatabaseWrapper.savepointdjango/db/backends/base/base.py:4001 ms0.7%
BaseDatabaseWrapper._savepointdjango/db/backends/base/base.py:3671 ms0.7%
CursorWrapper.executedjango/db/backends/utils.py:791 ms0.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms0.7%
CursorWrapper._executedjango/db/backends/utils.py:1031 ms0.7%
Cursor.executepsycopg/cursor.py:1131 ms0.7%
Connection.waitpsycopg/connection.py:4951 ms0.7%
Atomic.__exit__django/db/transaction.py:2591 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms0.7%
BaseDatabaseWrapper.savepoint_commitdjango/db/backends/base/base.py:4311 ms0.7%
BaseDatabaseWrapper._savepoint_commitdjango/db/backends/base/base.py:3751 ms0.7%
CursorWrapper.executedjango/db/backends/utils.py:791 ms0.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms0.7%
CursorWrapper._executedjango/db/backends/utils.py:1031 ms0.7%
Cursor.executepsycopg/cursor.py:1131 ms0.7%
Connection.waitpsycopg/connection.py:4951 ms0.7%
store_daily_statsstats/models.py:18 f"{lang.code}_posts": Post.objects.filter(4 ms2.0%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:873 ms1.4%
QuerySet.filterdjango/db/models/query.py:16763 ms1.4%
QuerySet._filter_or_excludedjango/db/models/query.py:16941 ms0.7%
QuerySet._filter_or_exclude_inplacedjango/db/models/query.py:17041 ms0.7%
Query.add_qdjango/db/models/sql/query.py:16811 ms0.7%
Query._add_qdjango/db/models/sql/query.py:17131 ms0.7%
Query.build_filterdjango/db/models/sql/query.py:15771 ms0.7%
Query.setup_joinsdjango/db/models/sql/query.py:19421 ms0.7%
QuerySet._filter_or_excludedjango/db/models/query.py:16891 ms0.7%
QuerySet._chaindjango/db/models/query.py:22341 ms0.7%
QuerySet._clonedjango/db/models/query.py:22471 ms0.7%
Query.chaindjango/db/models/sql/query.py:4391 ms0.7%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:93 account = Account.objects.create(14 ms6.8%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:8714 ms6.8%
QuerySet.createdjango/db/models/query.py:73614 ms6.8%
Model.savedjango/db/models/base.py:90414 ms6.8%
Model.save_basedjango/db/models/base.py:99612 ms6.1%
Model._save_tabledjango/db/models/base.py:119912 ms6.1%
Model._do_insertdjango/db/models/base.py:125112 ms6.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:8712 ms6.1%
QuerySet._insertdjango/db/models/query.py:214112 ms6.1%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:193611 ms5.4%
CursorWrapper.executedjango/db/backends/utils.py:7911 ms5.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9211 ms5.4%
CursorWrapper._executedjango/db/backends/utils.py:10511 ms5.4%
Cursor.executepsycopg/cursor.py:11311 ms5.4%
Connection.waitpsycopg/connection.py:49511 ms5.4%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19341 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms0.7%
BaseDatabaseWrapper.cursordjango/db/backends/base/base.py:3201 ms0.7%
BaseDatabaseWrapper._cursordjango/db/backends/base/base.py:2981 ms0.7%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:261 ms0.7%
DatabaseWrapper.create_cursordjango/db/backends/postgresql/base.py:4421 ms0.7%
Model.save_basedjango/db/models/base.py:9931 ms0.7%
Model._save_parentsdjango/db/models/base.py:10671 ms0.7%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:70 yesterday_stats = Daily.objects.create(8 ms4.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:878 ms4.1%
QuerySet.createdjango/db/models/query.py:7368 ms4.1%
Model.savedjango/db/models/base.py:9048 ms4.1%
Model.save_basedjango/db/models/base.py:9968 ms4.1%
Model._save_tabledjango/db/models/base.py:11997 ms3.4%
Model._do_insertdjango/db/models/base.py:12517 ms3.4%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:877 ms3.4%
QuerySet._insertdjango/db/models/query.py:21417 ms3.4%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19367 ms3.4%
CursorWrapper.executedjango/db/backends/utils.py:797 ms3.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:927 ms3.4%
CursorWrapper._executedjango/db/backends/utils.py:1057 ms3.4%
Cursor.executepsycopg/cursor.py:1137 ms3.4%
Connection.waitpsycopg/connection.py:4957 ms3.4%
Model._save_tabledjango/db/models/base.py:12001 ms0.7%
ModelBase._base_managerdjango/db/models/base.py:4551 ms0.7%
cached_property.__get__django/utils/functional.py:471 ms0.7%
Options.base_managerdjango/db/models/options.py:5001 ms0.7%
BaseManager.__init__django/db/models/manager.py:291 ms0.7%
BaseManager._set_creation_counterdjango/db/models/manager.py:1331 ms0.7%
TransactionTestCase._post_teardowndjango/test/testcases.py:1243 self._fixture_teardown()8 ms4.1%
TestCase._fixture_teardowndjango/test/testcases.py:14986 ms2.7%
DatabaseWrapper.check_constraintsdjango/db/backends/postgresql/base.py:4953 ms1.4%
CursorWrapper.executedjango/db/backends/utils.py:793 ms1.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:923 ms1.4%
CursorWrapper._executedjango/db/backends/utils.py:1033 ms1.4%
Cursor.executepsycopg/cursor.py:1133 ms1.4%
Connection.waitpsycopg/connection.py:4953 ms1.4%
DatabaseWrapper.check_constraintsdjango/db/backends/postgresql/base.py:4963 ms1.4%
CursorWrapper.executedjango/db/backends/utils.py:793 ms1.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:923 ms1.4%
CursorWrapper._executedjango/db/backends/utils.py:1033 ms1.4%
Cursor.executepsycopg/cursor.py:1133 ms1.4%
Connection.waitpsycopg/connection.py:4953 ms1.4%
TestCase._fixture_teardowndjango/test/testcases.py:14973 ms1.4%
TestCase._should_check_constraintsdjango/test/testcases.py:15063 ms1.4%
DatabaseWrapper.is_usabledjango/db/backends/postgresql/base.py:5043 ms1.4%
Cursor.executepsycopg/cursor.py:1133 ms1.4%
Connection.waitpsycopg/connection.py:4953 ms1.4%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:164 today_stats = Daily.objects.get(date=today.date())7 ms3.4%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:877 ms3.4%
QuerySet.getdjango/db/models/query.py:7027 ms3.4%
QuerySet.__len__django/db/models/query.py:4217 ms3.4%
QuerySet._fetch_alldjango/db/models/query.py:22627 ms3.4%
ModelIterable.__iter__django/db/models/query.py:1037 ms3.4%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16256 ms2.7%
CursorWrapper.executedjango/db/backends/utils.py:796 ms2.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:926 ms2.7%
CursorWrapper._executedjango/db/backends/utils.py:1054 ms2.0%
Cursor.executepsycopg/cursor.py:1134 ms2.0%
Connection.waitpsycopg/connection.py:4954 ms2.0%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16121 ms0.7%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7681 ms0.7%
SQLCompiler.pre_sql_setupdjango/db/models/sql/compiler.py:891 ms0.7%
SQLCompiler.setup_querydjango/db/models/sql/compiler.py:781 ms0.7%
SQLCompiler.get_selectdjango/db/models/sql/compiler.py:3191 ms0.7%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5791 ms0.7%
Col.as_sqldjango/db/models/expressions.py:13691 ms0.7%
TransactionTestCase._pre_setupdjango/test/testcases.py:1167 cls._fixture_setup()4 ms2.0%
TestCase._fixture_setupdjango/test/testcases.py:14814 ms2.0%
TestCase._enter_atomicsdjango/test/testcases.py:13994 ms2.0%
Atomic.__enter__django/db/transaction.py:2234 ms2.0%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:264 ms2.0%
BaseDatabaseWrapper.savepointdjango/db/backends/base/base.py:4004 ms2.0%
BaseDatabaseWrapper._savepointdjango/db/backends/base/base.py:3674 ms2.0%
CursorWrapper.executedjango/db/backends/utils.py:794 ms2.0%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:924 ms2.0%
CursorWrapper._executedjango/db/backends/utils.py:1034 ms2.0%
Cursor.executepsycopg/cursor.py:1134 ms2.0%
Connection.waitpsycopg/connection.py:4954 ms2.0%
BaseCursor._execute_genpsycopg/_cursor_base.py:2043 ms1.4%
BaseCursor._start_querypsycopg/_cursor_base.py:3873 ms1.4%
BaseConnection._start_querypsycopg/_connection_base.py:5533 ms1.4%
BaseConnection._exec_commandpsycopg/_connection_base.py:4743 ms1.4%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:119 AccountLookup.objects.create(account=account, language="python\n")3 ms1.4%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:873 ms1.4%
QuerySet.createdjango/db/models/query.py:7363 ms1.4%
Model.savedjango/db/models/base.py:9043 ms1.4%
Model.save_basedjango/db/models/base.py:9963 ms1.4%
Model._save_tabledjango/db/models/base.py:11993 ms1.4%
Model._do_insertdjango/db/models/base.py:12513 ms1.4%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:873 ms1.4%
QuerySet._insertdjango/db/models/query.py:21413 ms1.4%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19363 ms1.4%
CursorWrapper.executedjango/db/backends/utils.py:793 ms1.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:923 ms1.4%
CursorWrapper._executedjango/db/backends/utils.py:1053 ms1.4%
Cursor.executepsycopg/cursor.py:1133 ms1.4%
Connection.waitpsycopg/connection.py:4953 ms1.4%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:120 Post.objects.create(3 ms1.4%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:873 ms1.4%
QuerySet.createdjango/db/models/query.py:7363 ms1.4%
Model.savedjango/db/models/base.py:9043 ms1.4%
Model.save_basedjango/db/models/base.py:9963 ms1.4%
Model._save_tabledjango/db/models/base.py:11993 ms1.4%
Model._do_insertdjango/db/models/base.py:12513 ms1.4%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:873 ms1.4%
QuerySet._insertdjango/db/models/query.py:21413 ms1.4%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19363 ms1.4%
CursorWrapper.executedjango/db/backends/utils.py:793 ms1.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:923 ms1.4%
CursorWrapper._executedjango/db/backends/utils.py:1053 ms1.4%
Cursor.executepsycopg/cursor.py:1133 ms1.4%
Connection.waitpsycopg/connection.py:4953 ms1.4%
TestStats.test_posts_from_yesterday_are_updatedstats/tests.py:159 yesterday_stats.refresh_from_db()1 ms0.7%
Model.refresh_from_dbdjango/db/models/base.py:7881 ms0.7%
QuerySet.getdjango/db/models/query.py:7021 ms0.7%
QuerySet.__len__django/db/models/query.py:4211 ms0.7%
QuerySet._fetch_alldjango/db/models/query.py:22621 ms0.7%
ModelIterable.__iter__django/db/models/query.py:1031 ms0.7%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16121 ms0.7%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7681 ms0.7%
SQLCompiler.pre_sql_setupdjango/db/models/sql/compiler.py:891 ms0.7%
SQLCompiler.setup_querydjango/db/models/sql/compiler.py:781 ms0.7%
SQLCompiler.get_selectdjango/db/models/sql/compiler.py:3191 ms0.7%
Estimated from 147 samples; phase durations are exact. Frames from pytest and pluggy are
hidden
.
Hot lines in your code
|
stats/models.py:20
).count()
store_daily_stats
· Database
|
65 ms |
|
stats/models.py:12
f"{lang.code}_accounts": AccountLookup.objects.filter(language__icontains=lang.code + "\n").count()
store_daily_stats
· Database
|
53 ms |
|
stats/models.py:25
Daily.objects.update_or_create(date=today, defaults=account_defaults | post_defaults)
store_daily_stats
· Database
|
19 ms |
|
stats/tests.py:93
account = Account.objects.create(
TestStats.test_posts_from_yesterday_are_updated
· Database
|
14 ms |
|
stats/tests.py:70
yesterday_stats = Daily.objects.create(
TestStats.test_posts_from_yesterday_are_updated
· Database
|
8 ms |
|
stats/tests.py:164
today_stats = Daily.objects.get(date=today.date())
TestStats.test_posts_from_yesterday_are_updated
· Database
|
7 ms |
|
stats/models.py:18
f"{lang.code}_posts": Post.objects.filter(
store_daily_stats
· Database
|
4 ms |
|
stats/tests.py:119
AccountLookup.objects.create(account=account, language="python\n")
TestStats.test_posts_from_yesterday_are_updated
· Database
|
3 ms |
|
stats/tests.py:120
Post.objects.create(
TestStats.test_posts_from_yesterday_are_updated
· Database
|
3 ms |
|
stats/tests.py:159
yesterday_stats.refresh_from_db()
TestStats.test_posts_from_yesterday_are_updated
· Database
|
1 ms |
Fixtures
Exact setup time| _unittest_setUpClass_fixture_TestStats class | 12 ms |
| _django_setup_unittest class | 0.42 ms |
| _django_isolate_apps function | 0.10 ms |
| _django_set_urlconf function | 0.06 ms |
| _django_db_marker function | 0.06 ms |
| _template_string_if_invalid_marker function | 0.06 ms |
| _live_server_helper function | 0.05 ms |
| _dj_autoclear_mailbox function | 0.04 ms |
| _django_clear_site_cache function | 0.03 ms |
| monkeypatch function | 0.03 ms |
Database
108 queries · 134 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
|
177 ms |
|
setup setUpClass
django/test/testcases.py:1426
|
14 ms |
|
call _post_teardown
django/test/testcases.py:1243
|
8 ms |
|
call _pre_setup
django/test/testcases.py:1167
|
4 ms |
Reliability
12 results · 0 CI failures · 0 local failuresThis test hasn't failed recently.
History
Latest 12 results, oldest first in the strip| When | Environment | Outcome | Duration | |
|---|---|---|---|---|
| 7 hours ago | CI github-actions:test | passed | 204 ms | Profile |
| 16 hours ago | CI github-actions:test | passed | 198 ms | Profile |
| 22 hours ago | CI github-actions:test | passed | 212 ms | Profile |
| 1 week, 5 days ago | CI github-actions:test | passed | 198 ms | Profile |
| 2 weeks, 2 days ago | CI github-actions:test | passed | 173 ms | Profile |
| 2 weeks, 2 days ago | CI github-actions:test | passed | 171 ms | Profile |
| 2 weeks, 4 days ago | CI github-actions:test | passed | 177 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 117 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 213 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 268 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 287 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 140 ms | Run |