How django load cached result for django prefetch_related? I need to know for debugging it

manpreet Best Answer 2 years ago

Looks like some of my code fails to properly use a prefetched query (Using Django/Graphene), resulting in 2N+1 queries...

From my understanding, when the property is accessed, django will grab that from prefetch cache if it is prefetched, or grab from DB if not prefetched.

So the problem is likely that the code access the property in such a way Django thinks it's not prefetched.

So the question is, how can I access the cached result for Django prefetch_related?

Which code does the actual grabbing of data (executing raw SQL or get cache) in Django?

Sorry if I misunderstood anything since my knowledge of Django is quite limited.