Round 1: 100k: 8 minutes 47 seconds 1k: 0 minutes 8 seconds %timeit {c['_type']: c['count'] for c in repo_version.content.values('_type').annotate(count=Count('_type'))} 121 ms ± 1.01 ms per loop (mean ± std. dev. of 7 runs, 10 loops each) %timeit list(Content.objects.filter(pk__in=repo_version.content)) 845 ms ± 3.26 ms per loop (mean ± std. dev. of 7 runs, 1 loop each) Round 2 (101,000 pre-existing units): 100k: 13 minutes 27 seconds 1k: 0 minutes 9 seconds %timeit {c['_type']: c['count'] for c in repo_version.content.values('_type').annotate(count=Count('_type'))} 220 ms ± 4.19 ms per loop (mean ± std. dev. of 7 runs, 1 loop each) %timeit list(Content.objects.filter(pk__in=repo_version.content)) 1.72 s ± 20.9 ms per loop (mean ± std. dev. of 7 runs, 1 loop each) Round 3 (202,000 pre-existing units): 100k: 16 minutes 36 seconds 1k: 0 minutes 13 seconds %timeit {c['_type']: c['count'] for c in repo_version.content.values('_type').annotate(count=Count('_type'))} 328 ms ± 5.86 ms per loop (mean ± std. dev. of 7 runs, 1 loop each) %timeit list(Content.objects.filter(pk__in=repo_version.content)) 2.58 s ± 20.8 ms per loop (mean ± std. dev. of 7 runs, 1 loop each) Round 4 (303,000 pre-existing units): 100k: 24 minutes 49 seconds 1k: 0 minutes 24 seconds %timeit {c['_type']: c['count'] for c in repo_version.content.values('_type').annotate(count=Count('_type'))} 785 ms ± 59.1 ms per loop (mean ± std. dev. of 7 runs, 1 loop each) %timeit list(Content.objects.filter(pk__in=repo_version.content)) 3.44 s ± 11.3 ms per loop (mean ± std. dev. of 7 runs, 1 loop each) Round 5 (fresh repo, background 404,000 pre-existing units): 100k: 13 minutes 13 seconds 1k: 0 minutes 14 seconds %timeit {c['_type']: c['count'] for c in repo_version.content.values('_type').annotate(count=Count('_type'))} 224 ms ± 5.28 ms per loop (mean ± std. dev. of 7 runs, 1 loop each) %timeit list(Content.objects.filter(pk__in=repo_version.content)) 1.34 s ± 10 ms per loop (mean ± std. dev. of 7 runs, 1 loop each) Final database size: 521 MB List of relations Schema | Name | Type | Owner | Size | Description --------+---------------------------------------+----------+-------+------------+------------- public | auth_group | table | pulp | 0 bytes | public | auth_group_id_seq | sequence | pulp | 8192 bytes | public | auth_group_permissions | table | pulp | 0 bytes | public | auth_group_permissions_id_seq | sequence | pulp | 8192 bytes | public | auth_permission | table | pulp | 40 kB | public | auth_permission_id_seq | sequence | pulp | 8192 bytes | public | auth_user | table | pulp | 16 kB | public | auth_user_groups | table | pulp | 0 bytes | public | auth_user_groups_id_seq | sequence | pulp | 8192 bytes | public | auth_user_id_seq | sequence | pulp | 8192 bytes | public | auth_user_user_permissions | table | pulp | 0 bytes | public | auth_user_user_permissions_id_seq | sequence | pulp | 8192 bytes | public | django_admin_log | table | pulp | 8192 bytes | public | django_admin_log_id_seq | sequence | pulp | 8192 bytes | public | django_content_type | table | pulp | 8192 bytes | public | django_content_type_id_seq | sequence | pulp | 8192 bytes | public | django_migrations | table | pulp | 16 kB | public | django_migrations_id_seq | sequence | pulp | 8192 bytes | public | django_session | table | pulp | 8192 bytes | public | file_filecontent | table | pulp | 53 MB | public | file_filepublisher | table | pulp | 8192 bytes | public | file_fileremote | table | pulp | 8192 bytes | public | pulp_app_artifact | table | pulp | 8192 bytes | public | pulp_app_artifact__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_content | table | pulp | 33 MB | public | pulp_app_content__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_contentartifact | table | pulp | 33 MB | public | pulp_app_contentartifact__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_contentguard | table | pulp | 8192 bytes | public | pulp_app_contentguard__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_createdresource | table | pulp | 8192 bytes | public | pulp_app_createdresource__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_distribution | table | pulp | 8192 bytes | public | pulp_app_distribution__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_exporter | table | pulp | 8192 bytes | public | pulp_app_exporter__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_progressreport | table | pulp | 56 kB | public | pulp_app_progressreport__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_publication | table | pulp | 0 bytes | public | pulp_app_publication__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_publishedartifact | table | pulp | 0 bytes | public | pulp_app_publishedartifact__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_publishedmetadata | table | pulp | 8192 bytes | public | pulp_app_publishedmetadata__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_publisher | table | pulp | 8192 bytes | public | pulp_app_publisher__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_remote | table | pulp | 16 kB | public | pulp_app_remote__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_remoteartifact | table | pulp | 84 MB | public | pulp_app_remoteartifact__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_repository | table | pulp | 16 kB | public | pulp_app_repository__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_repositorycontent | table | pulp | 33 MB | public | pulp_app_repositorycontent__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_repositoryversion | table | pulp | 8192 bytes | public | pulp_app_repositoryversion__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_reservedresource | table | pulp | 16 kB | public | pulp_app_reservedresource__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_task | table | pulp | 16 kB | public | pulp_app_task__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_taskreservedresource | table | pulp | 8192 bytes | public | pulp_app_taskreservedresource__id_seq | sequence | pulp | 8192 bytes | public | pulp_app_worker | table | pulp | 40 kB | public | pulp_app_worker__id_seq | sequence | pulp | 8192 bytes | (64 rows)