>>> 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