Moderate Testing Question 129 of 228

How can you catch N+1 queries in tests?

Python & Django · Speak this in 60–90 seconds · Faridabad & Delhi NCR

PICTURE THIS: DATA SPLIT

Train 70%Val 15%Test 15%

Fit on train, tune on val, report on test once.

Simple meaning

assertNumQueries(n) on TestCase fails when the count drifts.

1

WHY — Testing instead of guessing?

Why interviewers care about Testing:

This is a process

question about Testing.

Panels listen for order,

trade-offs, and what you would actually do on a Python project - not buzzwords.

Stay structured

Name the idea, why it exists, then one short example.

Close cleanly

End with when you use it and one common pitfall.

2

STEPS — What happens step by step?

Before you speak the answer, walk the interviewer through these steps:

  1. 1
    assertNumQueries(n) on TestCase fails

    when the count drifts.

  2. 2
    Combine it with select_related

    in the view so the expected n stays small.

  3. 3
    Debug toolbar is for

    local hunting

  4. 4
    the assertion is what

    keeps the regression out of CI.

  5. 5
    Common mistake

    What juniors usually get wrong.

  6. 6
    Close

    When you pick this over the alternative.

3

EXAMPLE — See it in action

Here's a short line you can speak, broken into clear beats:

Say this line
“Combine it with select_related in the view so the expected n stays small.”
Break into beats
Combineitwithselectrelatedin
Speaking order
2987408337471632900

Note: Adapt this scaffold to your own project — keep it under 60–90 seconds.

Key takeaway

assertNumQueries(n) on TestCase fails when the count drifts. Combine it with select_related in the view so the expected n stays small.

Previous question Next question
Chat with us