bcgov / bcgov/wps

N+1 Query

Open
#5,616 0 comments 0 reactions 0 assignees View on GitHub
4Refinement Bug
Dominant language
Python
Stars
65
Forks
11
Avg merge
21h 25m
Merged PRs (30d)
70

Description

Sentry Issue: [BACKEND-NG](https://bcps-wps.sentry.io/issues/7615092937/?referrer=github_integration)
| | |
| ------------- | --------------- |
| **Offending Spans** | db - SELECT critical_hours.start_hour, critical...

Contributor guide

Open the contributing guide

Research direction

Start with the linked Sentry issue and its offending database span, then trace the query back to the relevant Python entry point. Identify where the repeated query is issued and determine how to verify that the N+1 behavior is gone; the payload names no source file or test, so the completion check is not yet specified.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.