An endpoint gets slower as results grow

ERROR CODES YOU MAY SEE

A code is a clue. Use its meaning and surrounding evidence to narrow the cause.

57014PostgreSQL SQLSTATE · platform

The query was canceled (query_canceled).

Read the accompanying message to identify the cancellation cause. Check timeouts and query traces; cancellation alone does not establish N+1 access.

Official reference for 57014 (opens in new tab)Code definition reviewed 2026-09-30

THE PRINCIPLE

Observe query count and shape—not only endpoint duration.

FIRST MOVES

1. Trace database calls and confirm whether query count grows linearly with rows.
2. Fetch related data in a join, batch query, or dataloader based on access shape.
3. Select only required fields and confirm supporting indexes with EXPLAIN ANALYZE.
4. Add a query-count or production-shaped performance regression test.

TOOLS: THEN → NOW

PATTERN SNAPSHOT

const orders = await db.order.findMany({
  where: { userId },
  include: { merchant: true },
  take: 50,
});