Tests / confs/tests.py
TestLegacyConferenceDataMigration::test_drops_legacy_tables_when_uniques_are_mysql_style_indexes
First seen 12 hours ago in 0c23747
CI
github-actions:test
4 runs
Average
1.51 s
median 1.61 s
max 2.05 s
max 2.05 s
Phases
Setup 3 ms
Call 1.48 s
Teardown 25 ms
Categories
Migrations 858 ms
Database 70 ms
Test code 0.82 ms
Other (DB schema, Imports, Libraries, pytest, ...) 579 ms
231 database queries per run
Needs 359 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
setup1 ms0.2%
call758 ms99.8%
TestLegacyConferenceDataMigration.test_drops_legacy_tables_when_uniques_are_mysql_style_indexesconfs/tests.py:450 self._migrate(from_targets)252 ms33.1%
TestLegacyConferenceDataMigration._migrateconfs/tests.py:432 executor.migrate(targets)234 ms30.8%
MigrationExecutor.migratedjango/db/migrations/executor.py:143232 ms30.5%
MigrationExecutor._migrate_all_backwardsdjango/db/migrations/executor.py:221141 ms18.6%
MigrationExecutor.unapply_migrationdjango/db/migrations/executor.py:28796 ms12.6%
Migration.unapplydjango/db/migrations/migration.py:19371 ms9.3%
SeparateDatabaseAndState.database_backwardsdjango/db/migrations/operations/special.py:5855 ms7.3%
DeleteModel.database_backwardsdjango/db/migrations/operations/models.py:40455 ms7.3%
BaseDatabaseSchemaEditor.create_modeldjango/db/backends/base/schema.py:52450 ms6.6%
DatabaseSchemaEditor.executedjango/db/backends/postgresql/schema.py:4550 ms6.6%
BaseDatabaseSchemaEditor.executedjango/db/backends/base/schema.py:21150 ms6.6%
CursorWrapper.executedjango/db/backends/utils.py:7950 ms6.6%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9250 ms6.6%
CursorWrapper._executedjango/db/backends/utils.py:10350 ms6.6%
Cursor.executepsycopg/cursor.py:11350 ms6.6%
Connection.waitpsycopg/connection.py:49550 ms6.6%
BaseCursor._execute_genpsycopg/_cursor_base.py:2066 ms0.8%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2865 ms0.7%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:785 ms0.7%
1 smaller frames hidden
BaseDatabaseSchemaEditor.create_modeldjango/db/backends/base/schema.py:5445 ms0.7%
BaseDatabaseSchemaEditor._model_indexes_sqldjango/db/backends/base/schema.py:16995 ms0.7%
DatabaseSchemaEditor._field_indexes_sqldjango/db/backends/postgresql/schema.py:635 ms0.7%
DeleteModel.database_backwardsdjango/db/migrations/operations/models.py:40410 ms1.3%
BaseDatabaseSchemaEditor.create_modeldjango/db/backends/base/schema.py:52410 ms1.3%
DatabaseSchemaEditor.executedjango/db/backends/postgresql/schema.py:4510 ms1.3%
BaseDatabaseSchemaEditor.executedjango/db/backends/base/schema.py:21110 ms1.3%
CursorWrapper.executedjango/db/backends/utils.py:7910 ms1.3%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9210 ms1.3%
CursorWrapper._executedjango/db/backends/utils.py:10310 ms1.3%
Cursor.executepsycopg/cursor.py:11310 ms1.3%
Connection.waitpsycopg/connection.py:49510 ms1.3%
2 smaller frames hidden
Migration.unapplydjango/db/migrations/migration.py:16621 ms2.8%
SeparateDatabaseAndState.state_forwardsdjango/db/migrations/operations/special.py:3121 ms2.8%
RemoveConstraint.state_forwardsdjango/db/migrations/operations/models.py:12099 ms1.2%
ProjectState.remove_constraintdjango/db/migrations/state.py:2499 ms1.2%
ProjectState._remove_optiondjango/db/migrations/state.py:2159 ms1.2%
ProjectState.reload_modeldjango/db/migrations/state.py:4268 ms1.0%
ProjectState._reloaddjango/db/migrations/state.py:4618 ms1.0%
StateApps.render_multipledjango/db/migrations/state.py:6918 ms1.0%
ModelState.renderdjango/db/migrations/state.py:9825 ms0.7%
1 smaller frames hidden
1 smaller frames hidden
AlterTogetherOptionOperation.state_forwardsdjango/db/migrations/operations/models.py:6576 ms0.8%
ProjectState.alter_model_optionsdjango/db/migrations/state.py:1906 ms0.8%
ProjectState.reload_modeldjango/db/migrations/state.py:4265 ms0.7%
ProjectState._reloaddjango/db/migrations/state.py:4615 ms0.7%
StateApps.render_multipledjango/db/migrations/state.py:6915 ms0.7%
1 smaller frames hidden
2 smaller frames hidden
2 smaller frames hidden
MigrationExecutor.unapply_migrationdjango/db/migrations/executor.py:28438 ms5.0%
BaseDatabaseSchemaEditor.__exit__django/db/backends/base/schema.py:17638 ms5.0%
DatabaseSchemaEditor.executedjango/db/backends/postgresql/schema.py:4538 ms5.0%
BaseDatabaseSchemaEditor.executedjango/db/backends/base/schema.py:21135 ms4.6%
CursorWrapper.executedjango/db/backends/utils.py:7935 ms4.6%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9235 ms4.6%
CursorWrapper._executedjango/db/backends/utils.py:10335 ms4.6%
Cursor.executepsycopg/cursor.py:11335 ms4.6%
Connection.waitpsycopg/connection.py:49535 ms4.6%
BaseCursor._execute_genpsycopg/_cursor_base.py:20611 ms1.5%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:28610 ms1.3%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:7810 ms1.3%
1 smaller frames hidden
1 smaller frames hidden
MigrationExecutor.unapply_migrationdjango/db/migrations/executor.py:2888 ms1.0%
MigrationExecutor.record_migrationdjango/db/migrations/executor.py:2778 ms1.0%
MigrationRecorder.record_unapplieddjango/db/migrations/recorder.py:1078 ms1.0%
QuerySet.deletedjango/db/models/query.py:13575 ms0.7%
2 smaller frames hidden
MigrationExecutor._migrate_all_backwardsdjango/db/migrations/executor.py:21654 ms7.1%
Migration.mutate_statedjango/db/migrations/migration.py:9154 ms7.1%
CreateModel.state_forwardsdjango/db/migrations/operations/models.py:8628 ms3.6%
ProjectState.add_modeldjango/db/migrations/state.py:12628 ms3.6%
ProjectState.reload_modeldjango/db/migrations/state.py:42626 ms3.5%
ProjectState._reloaddjango/db/migrations/state.py:46126 ms3.5%
StateApps.render_multipledjango/db/migrations/state.py:69126 ms3.5%
ModelState.renderdjango/db/migrations/state.py:98921 ms2.8%
ModelBase.__new__django/db/models/base.py:2148 ms1.0%
ModelBase.add_to_classdjango/db/models/base.py:3948 ms1.0%
7 smaller frames hidden
ModelState.renderdjango/db/migrations/state.py:9825 ms0.7%
1 smaller frames hidden
AlterTogetherOptionOperation.state_forwardsdjango/db/migrations/operations/models.py:65713 ms1.7%
ProjectState.alter_model_optionsdjango/db/migrations/state.py:19013 ms1.7%
ProjectState.reload_modeldjango/db/migrations/state.py:42613 ms1.7%
ProjectState._reloaddjango/db/migrations/state.py:46113 ms1.7%
StateApps.render_multipledjango/db/migrations/state.py:69113 ms1.7%
ModelState.renderdjango/db/migrations/state.py:9899 ms1.2%
ModelBase.__new__django/db/models/base.py:3778 ms1.0%
deepcopy<stdlib>/copy.py:1578 ms1.0%
_reconstruct<stdlib>/copy.py:2558 ms1.0%
deepcopy<stdlib>/copy.py:1318 ms1.0%
_deepcopy_dict<stdlib>/copy.py:2028 ms1.0%
deepcopy<stdlib>/copy.py:1108 ms1.0%
<GC>~8 ms1.0%
1 smaller frames hidden
1 smaller frames hidden
AlterField.state_forwardsdjango/db/migrations/operations/fields.py:22710 ms1.3%
ProjectState.alter_fielddjango/db/migrations/state.py:3058 ms1.0%
ProjectState.reload_modeldjango/db/migrations/state.py:4268 ms1.0%
ProjectState._reloaddjango/db/migrations/state.py:4618 ms1.0%
StateApps.render_multipledjango/db/migrations/state.py:6918 ms1.0%
ModelState.renderdjango/db/migrations/state.py:9895 ms0.7%
1 smaller frames hidden
1 smaller frames hidden
3 smaller frames hidden
MigrationExecutor._migrate_all_backwardsdjango/db/migrations/executor.py:21023 ms3.0%
Migration.mutate_statedjango/db/migrations/migration.py:9121 ms2.8%
SeparateDatabaseAndState.state_forwardsdjango/db/migrations/operations/special.py:3121 ms2.8%
AlterTogetherOptionOperation.state_forwardsdjango/db/migrations/operations/models.py:65710 ms1.3%
ProjectState.alter_model_optionsdjango/db/migrations/state.py:19010 ms1.3%
ProjectState.reload_modeldjango/db/migrations/state.py:4268 ms1.0%
ProjectState._reloaddjango/db/migrations/state.py:4618 ms1.0%
StateApps.render_multipledjango/db/migrations/state.py:6918 ms1.0%
ModelState.renderdjango/db/migrations/state.py:9825 ms0.7%
1 smaller frames hidden
1 smaller frames hidden
RemoveConstraint.state_forwardsdjango/db/migrations/operations/models.py:12098 ms1.0%
ProjectState.remove_constraintdjango/db/migrations/state.py:2498 ms1.0%
ProjectState._remove_optiondjango/db/migrations/state.py:2158 ms1.0%
ProjectState.reload_modeldjango/db/migrations/state.py:4268 ms1.0%
ProjectState._reloaddjango/db/migrations/state.py:4616 ms0.8%
StateApps.render_multipledjango/db/migrations/state.py:6916 ms0.8%
ModelState.renderdjango/db/migrations/state.py:9895 ms0.7%
1 smaller frames hidden
1 smaller frames hidden
2 smaller frames hidden
1 smaller frames hidden
MigrationExecutor._migrate_all_backwardsdjango/db/migrations/executor.py:20611 ms1.5%
cached_property.__get__django/utils/functional.py:4711 ms1.5%
ProjectState.appsdjango/db/migrations/state.py:59211 ms1.5%
__init____init__:-111 ms1.5%
StateApps.__init__django/db/migrations/state.py:65310 ms1.3%
StateApps.render_multipledjango/db/migrations/state.py:69110 ms1.3%
ModelState.renderdjango/db/migrations/state.py:9825 ms0.7%
ModelState.renderdjango/db/migrations/state.py:9895 ms0.7%
1 smaller frames hidden
1 smaller frames hidden
1 smaller frames hidden
TestLegacyConferenceDataMigration._migrateconfs/tests.py:431 executor.loader.build_graph()10 ms1.3%
MigrationLoader.build_graphdjango/db/migrations/loader.py:2885 ms0.7%
2 smaller frames hidden
TestLegacyConferenceDataMigration._migrateconfs/tests.py:430 executor = MigrationExecutor(connection)8 ms1.0%
__init____init__:-18 ms1.0%
MigrationExecutor.__init__django/db/migrations/executor.py:188 ms1.0%
__init____init__:-18 ms1.0%
MigrationLoader.__init__django/db/migrations/loader.py:598 ms1.0%
MigrationLoader.build_graphdjango/db/migrations/loader.py:2885 ms0.7%
2 smaller frames hidden
TestLegacyConferenceDataMigration.test_drops_legacy_tables_when_uniques_are_mysql_style_indexesconfs/tests.py:452181 ms23.9%
TestLegacyConferenceDataMigration._migrateconfs/tests.py:432 executor.migrate(targets)157 ms20.7%
MigrationExecutor.migratedjango/db/migrations/executor.py:137147 ms19.4%
MigrationExecutor._migrate_all_forwardsdjango/db/migrations/executor.py:169130 ms17.1%
MigrationExecutor.apply_migrationdjango/db/migrations/executor.py:257120 ms15.7%
Migration.applydjango/db/migrations/migration.py:13291 ms11.9%
SeparateDatabaseAndState.database_forwardsdjango/db/migrations/operations/special.py:3943 ms5.6%
DeleteModel.database_forwardsdjango/db/migrations/operations/models.py:39943 ms5.6%
BaseDatabaseSchemaEditor.delete_modeldjango/db/backends/base/schema.py:55943 ms5.6%
DatabaseSchemaEditor.executedjango/db/backends/postgresql/schema.py:4843 ms5.6%
BaseDatabaseSchemaEditor.executedjango/db/backends/base/schema.py:21143 ms5.6%
CursorWrapper.executedjango/db/backends/utils.py:7943 ms5.6%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9243 ms5.6%
CursorWrapper._executedjango/db/backends/utils.py:10343 ms5.6%
Cursor.executepsycopg/cursor.py:11343 ms5.6%
Connection.waitpsycopg/connection.py:49543 ms5.6%
RunPython.database_forwardsdjango/db/migrations/operations/special.py:20340 ms5.3%
migrate_legacy_conferencesconfs/migrations/0033_remove_legacy_conference_tables.py:55516 ms2.2%
migrate_legacy_pairconfs/migrations/0033_remove_legacy_conference_tables.py:4076 ms0.8%
_pk_batchesconfs/migrations/0033_remove_legacy_conference_tables.py:214 rows = list(model.objects.filter(pk__gt=last_pk).order_by("pk")[:batch_size])6 ms0.8%
QuerySet.__iter__django/db/models/query.py:4396 ms0.8%
QuerySet._fetch_alldjango/db/models/query.py:22626 ms0.8%
ModelIterable.__iter__django/db/models/query.py:1036 ms0.8%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16255 ms0.7%
CursorWrapper.executedjango/db/backends/utils.py:795 ms0.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:925 ms0.7%
CursorWrapper._executedjango/db/backends/utils.py:1055 ms0.7%
Cursor.executepsycopg/cursor.py:1135 ms0.7%
Connection.waitpsycopg/connection.py:4955 ms0.7%
BaseCursor._execute_genpsycopg/_cursor_base.py:2065 ms0.7%
1 smaller frames hidden
migrate_legacy_pairconfs/migrations/0033_remove_legacy_conference_tables.py:398 legacy_accounts = list(account_model.objects.all())5 ms0.7%
QuerySet.__iter__django/db/models/query.py:4395 ms0.7%
QuerySet._fetch_alldjango/db/models/query.py:22625 ms0.7%
ModelIterable.__iter__django/db/models/query.py:1035 ms0.7%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16255 ms0.7%
CursorWrapper.executedjango/db/backends/utils.py:795 ms0.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:925 ms0.7%
CursorWrapper._executedjango/db/backends/utils.py:1055 ms0.7%
Cursor.executepsycopg/cursor.py:1135 ms0.7%
Connection.waitpsycopg/connection.py:4955 ms0.7%
migrate_legacy_pairconfs/migrations/0033_remove_legacy_conference_tables.py:4195 ms0.7%
_refresh_account_countsconfs/migrations/0033_remove_legacy_conference_tables.py:325 counts = list(5 ms0.7%
QuerySet.__iter__django/db/models/query.py:4395 ms0.7%
QuerySet._fetch_alldjango/db/models/query.py:22625 ms0.7%
ValuesIterable.__iter__django/db/models/query.py:2475 ms0.7%
SQLCompiler.results_iterdjango/db/models/sql/compiler.py:15745 ms0.7%
migrate_legacy_conferencesconfs/migrations/0033_remove_legacy_conference_tables.py:55015 ms2.0%
_get_or_create_conferenceconfs/migrations/0033_remove_legacy_conference_tables.py:388 conference, _created = conference_model.objects.get_or_create(slug=spec["slug"], defaults=defaults)15 ms2.0%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:8715 ms2.0%
QuerySet.get_or_createdjango/db/models/query.py:106110 ms1.3%
QuerySet.createdjango/db/models/query.py:73610 ms1.3%
Model.savedjango/db/models/base.py:90410 ms1.3%
Model.save_basedjango/db/models/base.py:99610 ms1.3%
Model._save_tabledjango/db/models/base.py:119910 ms1.3%
Model._do_insertdjango/db/models/base.py:125110 ms1.3%
BaseManager._get_queryset_methods.<locals>.create_method.<locals>.manager_methoddjango/db/models/manager.py:8710 ms1.3%
QuerySet._insertdjango/db/models/query.py:214110 ms1.3%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19355 ms0.7%
SQLInsertCompiler.as_sqldjango/db/models/sql/compiler.py:18805 ms0.7%
SQLInsertCompiler.assemble_as_sqldjango/db/backends/postgresql/compiler.py:555 ms0.7%
SQLInsertCompiler.assemble_as_sqldjango/db/models/sql/compiler.py:17975 ms0.7%
<GC>~5 ms0.7%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19365 ms0.7%
CursorWrapper.executedjango/db/backends/utils.py:795 ms0.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:925 ms0.7%
CursorWrapper._executedjango/db/backends/utils.py:1055 ms0.7%
Cursor.executepsycopg/cursor.py:1135 ms0.7%
Connection.waitpsycopg/connection.py:4955 ms0.7%
QuerySet.get_or_createdjango/db/models/query.py:10545 ms0.7%
QuerySet.getdjango/db/models/query.py:7025 ms0.7%
QuerySet.__len__django/db/models/query.py:4215 ms0.7%
QuerySet._fetch_alldjango/db/models/query.py:22625 ms0.7%
migrate_legacy_conferencesconfs/migrations/0033_remove_legacy_conference_tables.py:5516 ms0.8%
1 smaller frames hidden
DeleteModel.database_forwardsdjango/db/migrations/operations/models.py:3995 ms0.7%
BaseDatabaseSchemaEditor.delete_modeldjango/db/backends/base/schema.py:5595 ms0.7%
DatabaseSchemaEditor.executedjango/db/backends/postgresql/schema.py:485 ms0.7%
BaseDatabaseSchemaEditor.executedjango/db/backends/base/schema.py:2115 ms0.7%
CursorWrapper.executedjango/db/backends/utils.py:795 ms0.7%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:925 ms0.7%
CursorWrapper._executedjango/db/backends/utils.py:1035 ms0.7%
Cursor.executepsycopg/cursor.py:1135 ms0.7%
Connection.waitpsycopg/connection.py:4955 ms0.7%
1 smaller frames hidden
Migration.applydjango/db/migrations/migration.py:11828 ms3.6%
SeparateDatabaseAndState.state_forwardsdjango/db/migrations/operations/special.py:3128 ms3.6%
AlterTogetherOptionOperation.state_forwardsdjango/db/migrations/operations/models.py:6579 ms1.2%
ProjectState.alter_model_optionsdjango/db/migrations/state.py:1909 ms1.2%
ProjectState.reload_modeldjango/db/migrations/state.py:4266 ms0.8%
ProjectState._reloaddjango/db/migrations/state.py:4616 ms0.8%
StateApps.render_multipledjango/db/migrations/state.py:6915 ms0.7%
1 smaller frames hidden
1 smaller frames hidden
RemoveConstraint.state_forwardsdjango/db/migrations/operations/models.py:12099 ms1.2%
ProjectState.remove_constraintdjango/db/migrations/state.py:2499 ms1.2%
ProjectState._remove_optiondjango/db/migrations/state.py:2159 ms1.2%
ProjectState.reload_modeldjango/db/migrations/state.py:4269 ms1.2%
ProjectState._reloaddjango/db/migrations/state.py:4618 ms1.0%
StateApps.render_multipledjango/db/migrations/state.py:6918 ms1.0%
1 smaller frames hidden
RemoveIndex.state_forwardsdjango/db/migrations/operations/models.py:9616 ms0.8%
ProjectState.remove_indexdjango/db/migrations/state.py:2296 ms0.8%
ProjectState._remove_optiondjango/db/migrations/state.py:2156 ms0.8%
ProjectState.reload_modeldjango/db/migrations/state.py:4266 ms0.8%
ProjectState._reloaddjango/db/migrations/state.py:4616 ms0.8%
StateApps.render_multipledjango/db/migrations/state.py:6916 ms0.8%
2 smaller frames hidden
1 smaller frames hidden
MigrationExecutor.apply_migrationdjango/db/migrations/executor.py:2546 ms0.8%
BaseDatabaseSchemaEditor.__exit__django/db/backends/base/schema.py:1786 ms0.8%
Atomic.__exit__django/db/transaction.py:2756 ms0.8%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:266 ms0.8%
BaseDatabaseWrapper.commitdjango/db/backends/base/base.py:3276 ms0.8%
BaseDatabaseWrapper._commitdjango/db/backends/base/base.py:3036 ms0.8%
Connection.commitpsycopg/connection.py:3096 ms0.8%
Connection.waitpsycopg/connection.py:4956 ms0.8%
1 smaller frames hidden
MigrationExecutor._migrate_all_forwardsdjango/db/migrations/executor.py:16618 ms2.3%
cached_property.__get__django/utils/functional.py:4718 ms2.3%
ProjectState.appsdjango/db/migrations/state.py:59218 ms2.3%
__init____init__:-118 ms2.3%
StateApps.__init__django/db/migrations/state.py:65318 ms2.3%
StateApps.render_multipledjango/db/migrations/state.py:69118 ms2.3%
ModelState.renderdjango/db/migrations/state.py:98211 ms1.5%
Field.clonedjango/db/models/fields/__init__.py:7125 ms0.7%
1 smaller frames hidden
ModelState.renderdjango/db/migrations/state.py:9896 ms0.8%
MigrationExecutor.migratedjango/db/migrations/executor.py:1365 ms0.7%
2 smaller frames hidden
TestLegacyConferenceDataMigration._migrateconfs/tests.py:431 executor.loader.build_graph()13 ms1.7%
MigrationLoader.build_graphdjango/db/migrations/loader.py:2826 ms0.8%
MigrationLoader.build_graphdjango/db/migrations/loader.py:2885 ms0.7%
1 smaller frames hidden
TestLegacyConferenceDataMigration._migrateconfs/tests.py:430 executor = MigrationExecutor(connection)11 ms1.5%
__init____init__:-111 ms1.5%
MigrationExecutor.__init__django/db/migrations/executor.py:1811 ms1.5%
__init____init__:-111 ms1.5%
MigrationLoader.__init__django/db/migrations/loader.py:5911 ms1.5%
MigrationLoader.build_graphdjango/db/migrations/loader.py:2826 ms0.8%
MigrationLoader.build_graphdjango/db/migrations/loader.py:2885 ms0.7%
TransactionTestCase._post_teardowndjango/test/testcases.py:1243 self._fixture_teardown()176 ms23.2%
TransactionTestCase._fixture_teardowndjango/test/testcases.py:1278176 ms23.2%
call_commanddjango/core/management/__init__.py:195176 ms23.2%
BaseCommand.executedjango/core/management/base.py:466176 ms23.2%
Command.handledjango/core/management/commands/flush.py:71128 ms16.9%
BaseDatabaseOperations.execute_sql_flushdjango/db/backends/base/operations.py:49396 ms12.6%
CursorWrapper.executedjango/db/backends/utils.py:7996 ms12.6%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9296 ms12.6%
CursorWrapper._executedjango/db/backends/utils.py:10394 ms12.4%
Cursor.executepsycopg/cursor.py:11394 ms12.4%
Connection.waitpsycopg/connection.py:49594 ms12.4%
BaseDatabaseOperations.execute_sql_flushdjango/db/backends/base/operations.py:48733 ms4.3%
Atomic.__exit__django/db/transaction.py:27533 ms4.3%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:2633 ms4.3%
BaseDatabaseWrapper.commitdjango/db/backends/base/base.py:32733 ms4.3%
BaseDatabaseWrapper._commitdjango/db/backends/base/base.py:30333 ms4.3%
Connection.commitpsycopg/connection.py:30933 ms4.3%
Connection.waitpsycopg/connection.py:49533 ms4.3%
Command.handledjango/core/management/commands/flush.py:8944 ms5.8%
emit_post_migrate_signaldjango/core/management/sql.py:5244 ms5.8%
Signal.senddjango/dispatch/dispatcher.py:24944 ms5.8%
create_permissionsdjango/contrib/auth/management/__init__.py:6215 ms2.0%
create_contenttypesdjango/contrib/contenttypes/management/__init__.py:1309 ms1.2%
QuerySet.__iter__django/db/models/query.py:4399 ms1.2%
QuerySet._fetch_alldjango/db/models/query.py:22629 ms1.2%
FlatValuesListIterable.__iter__django/db/models/query.py:3029 ms1.2%
SQLCompiler.results_iterdjango/db/models/sql/compiler.py:15749 ms1.2%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16259 ms1.2%
CursorWrapper.executedjango/db/backends/utils.py:799 ms1.2%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:929 ms1.2%
CursorWrapper._executedjango/db/backends/utils.py:1059 ms1.2%
Cursor.executepsycopg/cursor.py:1139 ms1.2%
Connection.waitpsycopg/connection.py:4959 ms1.2%
create_contenttypesdjango/contrib/contenttypes/management/__init__.py:1406 ms0.8%
QuerySet.bulk_createdjango/db/models/query.py:9006 ms0.8%
QuerySet._batched_insertdjango/db/models/query.py:21796 ms0.8%
QuerySet._insertdjango/db/models/query.py:21416 ms0.8%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:19366 ms0.8%
CursorWrapper.executedjango/db/backends/utils.py:796 ms0.8%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:926 ms0.8%
CursorWrapper._executedjango/db/backends/utils.py:1056 ms0.8%
Cursor.executepsycopg/cursor.py:1136 ms0.8%
Connection.waitpsycopg/connection.py:4956 ms0.8%
create_permissionsdjango/contrib/auth/management/__init__.py:10814 ms1.8%
QuerySet.bulk_createdjango/db/models/query.py:90014 ms1.8%
QuerySet._batched_insertdjango/db/models/query.py:217914 ms1.8%
QuerySet._insertdjango/db/models/query.py:214114 ms1.8%
SQLInsertCompiler.execute_sqldjango/db/models/sql/compiler.py:193614 ms1.8%
CursorWrapper.executedjango/db/backends/utils.py:7914 ms1.8%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9214 ms1.8%
CursorWrapper._executedjango/db/backends/utils.py:10514 ms1.8%
Cursor.executepsycopg/cursor.py:11314 ms1.8%
Connection.waitpsycopg/connection.py:49514 ms1.8%
create_permissionsdjango/contrib/auth/management/__init__.py:888 ms1.0%
QuerySet.__iter__django/db/models/query.py:4398 ms1.0%
QuerySet._fetch_alldjango/db/models/query.py:22628 ms1.0%
ValuesListIterable.__iter__django/db/models/query.py:2638 ms1.0%
SQLCompiler.results_iterdjango/db/models/sql/compiler.py:15748 ms1.0%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16256 ms0.8%
CursorWrapper.executedjango/db/backends/utils.py:796 ms0.8%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:926 ms0.8%
CursorWrapper._executedjango/db/backends/utils.py:1056 ms0.8%
Cursor.executepsycopg/cursor.py:1136 ms0.8%
Connection.waitpsycopg/connection.py:4956 ms0.8%
1 smaller frames hidden
2 smaller frames hidden
2 smaller frames hidden
TestLegacyConferenceDataMigration.test_drops_legacy_tables_when_uniques_are_mysql_style_indexesconfs/tests.py:45174 ms9.8%
TestLegacyConferenceDataMigration._replace_unique_constraints_with_mysql_style_indexesconfs/tests.py:472 constraints = connection.introspection.get_constraints(cursor, table)35 ms4.6%
DatabaseIntrospection.get_constraintsdjango/db/backends/postgresql/introspection.py:25119 ms2.5%
CursorWrapper.executedjango/db/backends/utils.py:7919 ms2.5%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9219 ms2.5%
CursorWrapper._executedjango/db/backends/utils.py:10519 ms2.5%
Cursor.executepsycopg/cursor.py:11319 ms2.5%
Connection.waitpsycopg/connection.py:49519 ms2.5%
DatabaseIntrospection.get_constraintsdjango/db/backends/postgresql/introspection.py:21415 ms2.0%
CursorWrapper.executedjango/db/backends/utils.py:7915 ms2.0%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9215 ms2.0%
CursorWrapper._executedjango/db/backends/utils.py:10515 ms2.0%
Cursor.executepsycopg/cursor.py:11315 ms2.0%
Connection.waitpsycopg/connection.py:49515 ms2.0%
BaseCursor._execute_genpsycopg/_cursor_base.py:2068 ms1.0%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2868 ms1.0%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:788 ms1.0%
TestLegacyConferenceDataMigration._replace_unique_constraints_with_mysql_style_indexesconfs/tests.py:476 cursor.execute(f"ALTER TABLE {quote(table)} DROP CONSTRAINT IF EXISTS {quote(name)}")19 ms2.5%
CursorWrapper.executedjango/db/backends/utils.py:7919 ms2.5%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9219 ms2.5%
CursorWrapper._executedjango/db/backends/utils.py:10319 ms2.5%
Cursor.executepsycopg/cursor.py:11319 ms2.5%
Connection.waitpsycopg/connection.py:49519 ms2.5%
BaseCursor._execute_genpsycopg/_cursor_base.py:2065 ms0.7%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2865 ms0.7%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:785 ms0.7%
TestLegacyConferenceDataMigration._replace_unique_constraints_with_mysql_style_indexesconfs/tests.py:480 cursor.execute(f"CREATE UNIQUE INDEX {quote(index_name)} ON {quote(table)} ({columns})")16 ms2.2%
CursorWrapper.executedjango/db/backends/utils.py:7916 ms2.2%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9216 ms2.2%
CursorWrapper._executedjango/db/backends/utils.py:10316 ms2.2%
Cursor.executepsycopg/cursor.py:11316 ms2.2%
Connection.waitpsycopg/connection.py:49516 ms2.2%
BaseCursor._execute_genpsycopg/_cursor_base.py:2066 ms0.8%
BaseCursor._maybe_prepare_genpsycopg/_cursor_base.py:2866 ms0.8%
ClientCursorMixin._execute_sendpsycopg/client_cursor.py:786 ms0.8%
1 smaller frames hidden
TestLegacyConferenceDataMigration.test_drops_legacy_tables_when_uniques_are_mysql_style_indexesconfs/tests.py:44744 ms5.8%
TestLegacyConferenceDataMigration._leaf_targetsconfs/tests.py:412 executor = MigrationExecutor(connection)44 ms5.8%
__init____init__:-144 ms5.8%
MigrationExecutor.__init__django/db/migrations/executor.py:1844 ms5.8%
__init____init__:-144 ms5.8%
MigrationLoader.__init__django/db/migrations/loader.py:5944 ms5.8%
MigrationLoader.build_graphdjango/db/migrations/loader.py:28838 ms5.0%
MigrationRecorder.applied_migrationsdjango/db/migrations/recorder.py:8926 ms3.5%
MigrationRecorder.has_tabledjango/db/migrations/recorder.py:6418 ms2.3%
BaseDatabaseIntrospection.table_namesdjango/db/backends/base/introspection.py:7018 ms2.3%
BaseDatabaseIntrospection.table_names.<locals>.get_namesdjango/db/backends/base/introspection.py:6318 ms2.3%
DatabaseIntrospection.get_table_listdjango/db/backends/postgresql/introspection.py:6718 ms2.3%
CursorWrapper.executedjango/db/backends/utils.py:7918 ms2.3%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:9218 ms2.3%
CursorWrapper._executedjango/db/backends/utils.py:10318 ms2.3%
Cursor.executepsycopg/cursor.py:11318 ms2.3%
Connection.waitpsycopg/connection.py:49518 ms2.3%
MigrationRecorder.has_tabledjango/db/migrations/recorder.py:639 ms1.2%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:269 ms1.2%
BaseDatabaseWrapper.cursordjango/db/backends/base/base.py:3209 ms1.2%
BaseDatabaseWrapper._cursordjango/db/backends/base/base.py:2969 ms1.2%
SimpleTestCase.ensure_connection_patch_method.<locals>.patched_ensure_connectiondjango/test/testcases.py:3049 ms1.2%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:269 ms1.2%
BaseDatabaseWrapper.ensure_connectiondjango/db/backends/base/base.py:2799 ms1.2%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:269 ms1.2%
BaseDatabaseWrapper.connectdjango/db/backends/base/base.py:2569 ms1.2%
async_unsafe.<locals>.decorator.<locals>.innerdjango/utils/asyncio.py:269 ms1.2%
DatabaseWrapper.get_new_connectiondjango/db/backends/postgresql/base.py:3459 ms1.2%
Connection.connectpsycopg/connection.py:1099 ms1.2%
MigrationRecorder.applied_migrationsdjango/db/migrations/recorder.py:9211 ms1.5%
QuerySet.__iter__django/db/models/query.py:43911 ms1.5%
QuerySet._fetch_alldjango/db/models/query.py:226211 ms1.5%
ModelIterable.__iter__django/db/models/query.py:13610 ms1.3%
Model.from_dbdjango/db/models/base.py:62510 ms1.3%
Model.__init__django/db/models/base.py:61510 ms1.3%
Signal.senddjango/dispatch/dispatcher.py:21910 ms1.3%
<GC>~10 ms1.3%
MigrationLoader.build_graphdjango/db/migrations/loader.py:2825 ms0.7%
1 smaller frames hidden
TestLegacyConferenceDataMigration.test_drops_legacy_tables_when_uniques_are_mysql_style_indexesconfs/tests.py:45820 ms2.7%
TestLegacyConferenceDataMigration._migrateconfs/tests.py:430 executor = MigrationExecutor(connection)9 ms1.2%
__init____init__:-19 ms1.2%
MigrationExecutor.__init__django/db/migrations/executor.py:189 ms1.2%
__init____init__:-19 ms1.2%
MigrationLoader.__init__django/db/migrations/loader.py:599 ms1.2%
TestLegacyConferenceDataMigration._migrateconfs/tests.py:431 executor.loader.build_graph()8 ms1.0%
MigrationLoader.build_graphdjango/db/migrations/loader.py:2825 ms0.7%
1 smaller frames hidden
1 smaller frames hidden
TestLegacyConferenceDataMigration.test_drops_legacy_tables_when_uniques_are_mysql_style_indexesconfs/tests.py:4488 ms1.0%
TestLegacyConferenceDataMigration._targets_withconfs/tests.py:4188 ms1.0%
TestLegacyConferenceDataMigration._leaf_targetsconfs/tests.py:412 executor = MigrationExecutor(connection)8 ms1.0%
__init____init__:-18 ms1.0%
MigrationExecutor.__init__django/db/migrations/executor.py:188 ms1.0%
__init____init__:-18 ms1.0%
MigrationLoader.__init__django/db/migrations/loader.py:598 ms1.0%
1 smaller frames hidden
Estimated from 604 samples; phase durations are exact. Frames from pytest and pluggy are
hidden
.
Hot lines in your code
|
confs/tests.py:432
executor.migrate(targets)
TestLegacyConferenceDataMigration._migrate
· Migrations
|
351 ms |
|
confs/tests.py:412
executor = MigrationExecutor(connection)
TestLegacyConferenceDataMigration._leaf_targets
· Migrations
|
52 ms |
|
confs/tests.py:472
constraints = connection.introspection.get_constraints(cursor, table)
TestLegacyConferenceDataMigration._replace_unique_constraints_with_mysql_style_indexes
· Database
|
35 ms |
|
confs/tests.py:431
executor.loader.build_graph()
TestLegacyConferenceDataMigration._migrate
· Migrations
|
30 ms |
|
confs/tests.py:430
executor = MigrationExecutor(connection)
TestLegacyConferenceDataMigration._migrate
· Migrations
|
28 ms |
|
confs/tests.py:476
cursor.execute(f"ALTER TABLE {quote(table)} DROP CONSTRAINT IF EXISTS {quote(name)}")
TestLegacyConferenceDataMigration._replace_unique_constraints_with_mysql_style_indexes
· Database
|
19 ms |
|
confs/tests.py:480
cursor.execute(f"CREATE UNIQUE INDEX {quote(index_name)} ON {quote(table)} ({columns})")
TestLegacyConferenceDataMigration._replace_unique_constraints_with_mysql_style_indexes
· Database
|
16 ms |
|
confs/migrations/0033_remove_legacy_conference_tables.py:388
conference, _created = conference_model.objects.get_or_create(slug=spec["slug"], defaults=defaults)
_get_or_create_conference
· Migrations
|
15 ms |
|
confs/migrations/0033_remove_legacy_conference_tables.py:214
rows = list(model.objects.filter(pk__gt=last_pk).order_by("pk")[:batch_size])
_pk_batches
· Migrations
|
8 ms |
|
confs/migrations/0033_remove_legacy_conference_tables.py:325
counts = list(
_refresh_account_counts
· Migrations
|
6 ms |
Fixtures
Exact setup time| _live_server_helper function | 0.24 ms |
| _dj_autoclear_mailbox function | 0.12 ms |
| _django_db_marker function | 0.07 ms |
| _template_string_if_invalid_marker function | 0.04 ms |
| _django_clear_site_cache function | 0.03 ms |
| _django_isolate_apps function | 0.03 ms |
| _django_set_urlconf function | 0.02 ms |
| monkeypatch function | 0.02 ms |
Database
228 queries · 359 ms
Repeated queries are usually N+1 lookups: fetch them once with select_related / prefetch_related (or selectinload).
22×
SELECT "django_content_type"."model" AS "model" FROM "django_content_type" WHERE "django_content_type"."app_label" = %s
13×
SELECT c.relname, CASE WHEN c.relispartition THEN ? WHEN c.relkind IN (…) THEN ? ELSE ? END, obj_description(c.oid, ?) FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN (…) AND n.nspname NOT IN (…) AND pg_catalog.pg_table_is_visible(c.oid)
11×
SELECT "django_migrations"."id", "django_migrations"."app", "django_migrations"."name", "django_migrations"."applied" FROM "django_migrations"
11×
SELECT "django_content_type"."id", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."app_label" = %s AND "django_content_type"."model" IN (…))
11×
SELECT "auth_permission"."content_type_id" AS "content_type", "auth_permission"."codename" AS "codename" FROM "auth_permission" INNER JOIN "django_content_type" ON ("auth_permission"."content_type_id" = "django_content_type"."id") WHERE "auth_permission"."content_type_id" IN (…) ORDER BY "django_co…
Biggest pieces of work
|
call test body
confs/tests.py:450
|
582 ms |
|
call _post_teardown
django/test/testcases.py:1243
|
176 ms |
|
setup sysmon_py_start
coverage/sysmon.py:365
|
0.60 ms |
| setup pytest internals | 0.60 ms |
Reliability
5 results · 0 CI failures · 0 local failuresThis test hasn't failed recently.
History
Latest 5 results, oldest first in the strip| When | Environment | Outcome | Duration | |
|---|---|---|---|---|
| 7 hours ago | CI github-actions:test | passed | 760 ms | Profile |
| 7 hours ago | CI github-actions:test | passed | 1.73 s | Profile |
| 7 hours ago | CI github-actions:test | passed | 2.05 s | Profile |
| 12 hours ago | CI github-actions:test | passed | 1.49 s | Profile |
| 12 hours ago | CI github-actions:test | passed | 1.19 s | Run |