As33
@periodic/
arsenic
single_query
ℹ️ Info

No N+1 patterns detected on this request

Query executed as intended without N+1 patterns. Good relational data access pattern.

What triggers this signal

typescript
// single_query fires when a request results in exactly one DB query
// with no N+1 pattern detected. It's the healthy counterpart to n_plus_one.

// This pattern triggers single_query — one query, all data in one round trip
const user = await prisma.user.findUnique({
  where: { id },
  include: { profile: true, posts: { take: 10 } }, // joined, not looped
});

// Use in your exporter to confirm key routes stay efficient
const monitor = createMonitor({
  emitPositiveSignals: true,
  exporter: (event) => {
    if (event.signals.includes('single_query') && event.requestContext?.path === '/api/dashboard') {
      metrics.increment('db.single_query.dashboard');
    }
  },
});