Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

N+1 Query /api/v1/facility/ #1920

Open
sentry-io bot opened this issue Feb 27, 2024 · 2 comments · May be fixed by #2089
Open

N+1 Query /api/v1/facility/ #1920

sentry-io bot opened this issue Feb 27, 2024 · 2 comments · May be fixed by #2089

Comments

@sentry-io
Copy link

sentry-io bot commented Feb 27, 2024

Sentry Issue: CARE-PH
https://coronasafe-network.sentry.io/share/issue/92f8f9cc0b0e46ef96ff42a8c25f7c1f/

Offending Spans db - SELECT COUNT(*) AS "__count" FROM "facilit...
SELECT COUNT(*) AS __count
FROM facility_patientregistration
WHERE (
  NOT facility_patientregistration.deleted AND facility_patientregistration.facility_id = %s AND
    facility_patientregistration.is_active
)

	

SELECT COUNT(*) AS __count
FROM facility_bed
WHERE (
  NOT facility_bed.deleted AND facility_bed.facility_id = %s
)
``
@aeswibon
Copy link
Member

Would like to work on this issue.

@rithviknishad
Copy link
Member

image

@AnkurPrabhu AnkurPrabhu linked a pull request Apr 15, 2024 that will close this issue
4 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants