>>> def get_data(): ... start_time = time.time() ... page_names = Page.objects.filter(last_rev__deleted=False).values('name') ... list(MetaData.objects.filter(key='X-Link').exclude(value__in=page_names).values_list('value').annotate(count=Count('value'))) ... return time.time() - start_time ... >>> get_data() 0.4878880977630615 >>> def get_data(): ... start_time = time.time() ... page_names = Page.objects.filter(last_rev__deleted=False).values('name') ... list(MetaData.objects.filter(key='X-Link').exclude(value__in=list(page_names)).values_list('value').annotate(count=Count('value'))) ... return time.time() - start_time ... >>> get_data() 1.398988962173462