Tests / stats/tests.py
TestStarterPackStats::test_starter_pack_stats
First seen 1 year, 7 months ago in a5bb63b
CI
github-actions:test
11 runs
Average
66 ms
median 65 ms
max 113 ms
max 113 ms
Phases
Setup 17 ms
Call 46 ms
Teardown 3 ms
Categories
Database 60 ms
Factories 3 ms
Other (pytest, Unsampled, Libraries, Mocking) 3 ms
25 database queries per run
Needs 1 KB of memory (max 4 KB)
Duration per run
Where the time goes
Latest run in ci:github-actions:test, 7 hours ago ·
open run
setup20 ms31.6%
TestCase.setUpClassdjango/test/testcases.py:1426 cls.cls_atomics = cls._enter_atomics()20 ms31.6%
TestCase._enter_atomicsdjango/test/testcases.py:139920 ms31.6%
Atomic.__enter__django/db/transaction.py:21020 ms31.6%
BaseDatabaseWrapper.get_autocommitdjango/db/backends/base/base.py:45420 ms31.6%
SimpleTestCase.ensure_connection_patch_method.<locals>.patched_ensure_connectiondjango/test/testcases.py:30420 ms31.6%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:2620 ms31.6%
BaseDatabaseWrapper.ensure_connectiondjango/db/backends/base/base.py:27920 ms31.6%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:2620 ms31.6%
BaseDatabaseWrapper.connectdjango/db/backends/base/base.py:25620 ms31.6%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:2620 ms31.6%
DatabaseWrapper.get_new_connectiondjango/db/backends/postgresql/base.py:34520 ms31.6%
Connection.connectpsycopg/connection.py:10920 ms31.6%
wait_connpsycopg/waiting.py:14118 ms27.2%
EpollSelector.select<stdlib>/selectors.py:45218 ms27.2%
wait_connpsycopg/waiting.py:1453 ms4.3%
BaseConnection._connect_genpsycopg/_connection_base.py:4393 ms4.3%
call38 ms58.7%
TestStarterPackStats.test_starter_pack_statsstats/tests.py:173 self.starter_pack = baker.make(StarterPack)12 ms18.5%
makemodel_bakery/baker.py:17512 ms18.5%
Baker.makemodel_bakery/baker.py:45412 ms18.5%
Baker._makemodel_bakery/baker.py:5298 ms12.4%
Baker.generate_valuemodel_bakery/baker.py:10198 ms12.4%
gen_relatedmodel_bakery/random_gen.py:4548 ms12.4%
makemodel_bakery/baker.py:1758 ms12.4%
Baker.makemodel_bakery/baker.py:4548 ms12.4%
Baker._makemodel_bakery/baker.py:5428 ms12.4%
Baker.instancemodel_bakery/baker.py:6598 ms12.4%
AbstractBaseUser.savedjango/contrib/auth/base_user.py:626 ms9.3%
Model.savedjango/db/models/base.py:9046 ms9.3%
Model.save_basedjango/db/models/base.py:9966 ms9.3%
Model._save_tabledjango/db/models/base.py:11996 ms9.3%
Model._do_insertdjango/db/models/base.py:12516 ms9.3%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:876 ms9.3%
QuerySet._insertdjango/db/models/query.py:21416 ms9.3%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19366 ms9.3%
CursorWrapper.executedjango/db/backends/utils.py:796 ms9.3%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:926 ms9.3%
CursorWrapper._executedjango/db/backends/utils.py:1056 ms9.3%
Cursor.executepsycopg/cursor.py:1136 ms9.3%
Connection.waitpsycopg/connection.py:4956 ms9.3%
BaseCursor._execute_genpsycopg/_cursor_base.py:2066 ms9.3%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2866 ms9.3%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:786 ms9.3%
Baker._makemodel_bakery/baker.py:5424 ms6.2%
Baker.instancemodel_bakery/baker.py:6594 ms6.2%
Model.savedjango/db/models/base.py:9044 ms6.2%
Model.save_basedjango/db/models/base.py:9964 ms6.2%
Model._save_tabledjango/db/models/base.py:11994 ms6.2%
Model._do_insertdjango/db/models/base.py:12514 ms6.2%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:874 ms6.2%
QuerySet._insertdjango/db/models/query.py:21414 ms6.2%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19364 ms6.2%
CursorWrapper.executedjango/db/backends/utils.py:794 ms6.2%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:924 ms6.2%
CursorWrapper._executedjango/db/backends/utils.py:1054 ms6.2%
Cursor.executepsycopg/cursor.py:1134 ms6.2%
Connection.waitpsycopg/connection.py:4954 ms6.2%
BaseCursor._execute_genpsycopg/_cursor_base.py:2064 ms6.2%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2864 ms6.2%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:784 ms6.2%
TestStarterPackStats.test_starter_pack_statsstats/tests.py:188 baker.make(10 ms15.4%
makemodel_bakery/baker.py:17510 ms15.4%
Baker.makemodel_bakery/baker.py:45410 ms15.4%
Baker._makemodel_bakery/baker.py:54210 ms15.4%
Baker.instancemodel_bakery/baker.py:6598 ms12.4%
Model.savedjango/db/models/base.py:9048 ms12.4%
Model.save_basedjango/db/models/base.py:9968 ms12.4%
Model._save_tabledjango/db/models/base.py:11998 ms12.4%
Model._do_insertdjango/db/models/base.py:12518 ms12.4%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:878 ms12.4%
QuerySet._insertdjango/db/models/query.py:21418 ms12.4%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19368 ms12.4%
CursorWrapper.executedjango/db/backends/utils.py:798 ms12.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:928 ms12.4%
CursorWrapper._executedjango/db/backends/utils.py:1058 ms12.4%
Cursor.executepsycopg/cursor.py:1138 ms12.4%
Connection.waitpsycopg/connection.py:4958 ms12.4%
BaseCursor._execute_genpsycopg/_cursor_base.py:2068 ms12.4%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2868 ms12.4%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:788 ms12.4%
Baker.instancemodel_bakery/baker.py:6652 ms3.1%
Baker._handle_auto_nowmodel_bakery/baker.py:7882 ms3.1%
QuerySet.updatedjango/db/models/query.py:14212 ms3.1%
SQLUpdateCompiler.execute_sqldjango/db/models/sql/compiler.py:21212 ms3.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16252 ms3.1%
CursorWrapper.executedjango/db/backends/utils.py:792 ms3.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms3.1%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms3.1%
Cursor.executepsycopg/cursor.py:1132 ms3.1%
Connection.waitpsycopg/connection.py:4952 ms3.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms3.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2862 ms3.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:782 ms3.1%
TestStarterPackStats.test_starter_pack_statsstats/tests.py:191 baker.make(6 ms9.3%
makemodel_bakery/baker.py:1756 ms9.3%
Baker.makemodel_bakery/baker.py:4546 ms9.3%
Baker._makemodel_bakery/baker.py:5426 ms9.3%
Baker.instancemodel_bakery/baker.py:6314 ms6.2%
Model.__init__django/db/models/base.py:5862 ms3.1%
Model.savedjango/db/models/base.py:9042 ms3.1%
Model.save_basedjango/db/models/base.py:9962 ms3.1%
Model._save_tabledjango/db/models/base.py:11992 ms3.1%
Model._do_insertdjango/db/models/base.py:12512 ms3.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:872 ms3.1%
QuerySet._insertdjango/db/models/query.py:21412 ms3.1%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19362 ms3.1%
CursorWrapper.executedjango/db/backends/utils.py:792 ms3.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms3.1%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms3.1%
Cursor.executepsycopg/cursor.py:1132 ms3.1%
Connection.waitpsycopg/connection.py:4952 ms3.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms3.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2862 ms3.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:782 ms3.1%
Baker.instancemodel_bakery/baker.py:6592 ms3.1%
Model.savedjango/db/models/base.py:9042 ms3.1%
Model.save_basedjango/db/models/base.py:9962 ms3.1%
Model._save_tabledjango/db/models/base.py:11992 ms3.1%
Model._do_insertdjango/db/models/base.py:12512 ms3.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:872 ms3.1%
QuerySet._insertdjango/db/models/query.py:21412 ms3.1%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19492 ms3.1%
TestStarterPackStats.test_starter_pack_statsstats/tests.py:196 baker.make(FollowAllClick, starter_pack=self.starter_pack, user=self.user2, created_at=self.last_week)4 ms6.2%
makemodel_bakery/baker.py:1754 ms6.2%
Baker.makemodel_bakery/baker.py:4544 ms6.2%
Baker._makemodel_bakery/baker.py:5424 ms6.2%
Baker.instancemodel_bakery/baker.py:6592 ms3.1%
Model.savedjango/db/models/base.py:9042 ms3.1%
Model.save_basedjango/db/models/base.py:9962 ms3.1%
Model._save_tabledjango/db/models/base.py:11992 ms3.1%
Model._do_insertdjango/db/models/base.py:12512 ms3.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:872 ms3.1%
QuerySet._insertdjango/db/models/query.py:21412 ms3.1%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19362 ms3.1%
CursorWrapper.executedjango/db/backends/utils.py:792 ms3.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms3.1%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms3.1%
Cursor.executepsycopg/cursor.py:1132 ms3.1%
Connection.waitpsycopg/connection.py:4952 ms3.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms3.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2862 ms3.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:782 ms3.1%
Baker.instancemodel_bakery/baker.py:6652 ms3.1%
Baker._handle_auto_nowmodel_bakery/baker.py:7882 ms3.1%
QuerySet.updatedjango/db/models/query.py:14212 ms3.1%
SQLUpdateCompiler.execute_sqldjango/db/models/sql/compiler.py:21212 ms3.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16252 ms3.1%
CursorWrapper.executedjango/db/backends/utils.py:792 ms3.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms3.1%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms3.1%
Cursor.executepsycopg/cursor.py:1132 ms3.1%
Connection.waitpsycopg/connection.py:4952 ms3.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms3.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2862 ms3.1%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:782 ms3.1%
TransactionTestCase._pre_setupdjango/test/testcases.py:1167 cls._fixture_setup()2 ms3.1%
TestCase._fixture_setupdjango/test/testcases.py:14812 ms3.1%
TestCase._enter_atomicsdjango/test/testcases.py:13992 ms3.1%
Atomic.__enter__django/db/transaction.py:2232 ms3.1%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:262 ms3.1%
BaseDatabaseWrapper.savepointdjango/db/backends/base/base.py:4002 ms3.1%
BaseDatabaseWrapper._savepointdjango/db/backends/base/base.py:3672 ms3.1%
CursorWrapper.executedjango/db/backends/utils.py:792 ms3.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms3.1%
CursorWrapper._executedjango/db/backends/utils.py:1032 ms3.1%
Cursor.executepsycopg/cursor.py:1132 ms3.1%
Connection.waitpsycopg/connection.py:4952 ms3.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2042 ms3.1%
BaseCursor._start_querypsycopg/_cursor_base.py:3872 ms3.1%
BaseConnection._start_querypsycopg/_connection_base.py:5532 ms3.1%
BaseConnection._exec_commandpsycopg/_connection_base.py:4742 ms3.1%
TestStarterPackStats.test_starter_pack_statsstats/tests.py:202 baker.make(2 ms3.1%
makemodel_bakery/baker.py:1752 ms3.1%
Baker.makemodel_bakery/baker.py:4542 ms3.1%
Baker._makemodel_bakery/baker.py:5422 ms3.1%
Baker.instancemodel_bakery/baker.py:6592 ms3.1%
Model.savedjango/db/models/base.py:9042 ms3.1%
Model.save_basedjango/db/models/base.py:9962 ms3.1%
Model._save_tabledjango/db/models/base.py:11992 ms3.1%
Model._do_insertdjango/db/models/base.py:12512 ms3.1%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:872 ms3.1%
QuerySet._insertdjango/db/models/query.py:21412 ms3.1%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19362 ms3.1%
CursorWrapper.executedjango/db/backends/utils.py:792 ms3.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms3.1%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms3.1%
Cursor.executepsycopg/cursor.py:1132 ms3.1%
Connection.waitpsycopg/connection.py:4952 ms3.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2052 ms3.1%
BaseCursor._convert_querypsycopg/_cursor_base.py:4652 ms3.1%
PostgresClientQuery.convertpsycopg/_queries.py:2732 ms3.1%
PostgresQuery._ensure_bytespsycopg/_queries.py:1672 ms3.1%
TestStarterPackStats.test_starter_pack_statsstats/tests.py:2062 ms3.1%
starter_pack_statsstats/management/commands/dailypackstats.py:12 for starter_pack in starter_packs:2 ms3.1%
QuerySet.__iter__django/db/models/query.py:4392 ms3.1%
QuerySet._fetch_alldjango/db/models/query.py:22622 ms3.1%
ModelIterable.__iter__django/db/models/query.py:1032 ms3.1%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16252 ms3.1%
CursorWrapper.executedjango/db/backends/utils.py:792 ms3.1%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms3.1%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms3.1%
Cursor.executepsycopg/cursor.py:1132 ms3.1%
Connection.waitpsycopg/connection.py:4952 ms3.1%
BaseCursor._execute_genpsycopg/_cursor_base.py:2062 ms3.1%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:3182 ms3.1%
BaseCursor._set_resultspsycopg/_cursor_base.py:5352 ms3.1%
Estimated from 70 samples; phase durations are exact. Frames from pytest and pluggy are
hidden
.
Hot lines in your code
|
stats/tests.py:173
self.starter_pack = baker.make(StarterPack)
TestStarterPackStats.test_starter_pack_stats
· Database
|
12 ms |
|
stats/tests.py:188
baker.make(
TestStarterPackStats.test_starter_pack_stats
· Database
|
10 ms |
|
stats/tests.py:191
baker.make(
TestStarterPackStats.test_starter_pack_stats
· Database
|
6 ms |
|
stats/tests.py:196
baker.make(FollowAllClick, starter_pack=self.starter_pack, user=self.user2, created_at=self.last_week)
TestStarterPackStats.test_starter_pack_stats
· Database
|
4 ms |
|
stats/tests.py:202
baker.make(
TestStarterPackStats.test_starter_pack_stats
· Database
|
2 ms |
|
stats/management/commands/dailypackstats.py:12
for starter_pack in starter_packs:
starter_pack_stats
· Database
|
2 ms |
Fixtures
Exact setup time| _unittest_setUpClass_fixture_TestStarterPackStats class | 19 ms |
| _django_setup_unittest class | 0.32 ms |
| _django_db_marker function | 0.05 ms |
| _template_string_if_invalid_marker function | 0.05 ms |
| _dj_autoclear_mailbox function | 0.05 ms |
| _django_isolate_apps function | 0.05 ms |
| _live_server_helper function | 0.04 ms |
| _django_set_urlconf function | 0.04 ms |
| _django_clear_site_cache function | 0.03 ms |
| monkeypatch function | 0.02 ms |
Database
25 queries · 25 ms
Repeated queries are usually N+1 lookups: fetch them once with select_related / prefetch_related (or selectinload).
5×
INSERT INTO "auth_user" ("password", "last_login", "is_superuser", "username", "first_name", "last_name", "email", "is_staff", "is_active", "date_joined") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s) RETURNING "auth_user"."id"
5×
INSERT INTO "stats_followallclick" ("user_id", "starter_pack_id", "created_at") VALUES (%s, %s, %s) RETURNING "stats_followallclick"."id"
5×
UPDATE "stats_followallclick" SET "created_at" = %s WHERE "stats_followallclick"."id" = %s
Biggest pieces of work
|
call test body
stats/tests.py:188
|
36 ms |
|
setup setUpClass
django/test/testcases.py:1426
|
20 ms |
|
call _pre_setup
django/test/testcases.py:1167
|
2 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 | 65 ms | Profile |
| 16 hours ago | CI github-actions:test | passed | 38 ms | Profile |
| 22 hours ago | CI github-actions:test | passed | 66 ms | Profile |
| 1 week, 5 days ago | CI github-actions:test | passed | 49 ms | Profile |
| 2 weeks, 2 days ago | CI github-actions:test | passed | 57 ms | Profile |
| 2 weeks, 2 days ago | CI github-actions:test | passed | 60 ms | Profile |
| 2 weeks, 4 days ago | CI github-actions:test | passed | 66 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 45 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 90 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 83 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 113 ms | Profile |
| 3 weeks ago | CI github-actions:test | passed | 42 ms | Run |