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

Fix N+1 queries in /api/v1/getallfacilities/ #1335

Closed
Tracked by #1333
sainak opened this issue Jun 2, 2023 · 0 comments
Closed
Tracked by #1333

Fix N+1 queries in /api/v1/getallfacilities/ #1335

sainak opened this issue Jun 2, 2023 · 0 comments
Assignees
Labels
good first issue Good for newcomers

Comments

@sainak
Copy link
Member

sainak commented Jun 2, 2023

Sentry Issue: CARE-M3
Sentry Issue: CARE-KX

Transaction Name /api/v1/getallfacilities/
Parent Span django.view - facility-list
Repeating Spans (0) db - SELECT COUNT(*) AS __count FROM facility_bed WHERE (facility_bed.deleted = %s AND facility_bed.facility_id = %s)
db - SELECT users_ward.id, users_ward.local_body_id, users_ward.name, users_ward.number FROM users_ward WHERE users_ward.id = %s
db - SELECT COUNT(*) AS __count FROM facility_patientregistration WHERE (facility_patientregistration.deleted = %s AND facility_patientregistration.facility_id = %s AND facility_patientregistration.is_active = %s)

Sentry Issue: CARE-M2

Transaction Name /api/v1/facility/
Parent Span django.view - facility-list
Repeating Spans (0) db - SELECT COUNT(*) AS __count FROM facility_patientregistration WHERE (facility_patientregistration.deleted = %s AND facility_patientregistration.facility_id = %s AND facility_patientregistration.is_active = %s)
db - SELECT COUNT(*) AS __count FROM facility_bed WHERE (facility_bed.deleted = %s AND facility_bed.facility_id = %s)
@sainak sainak mentioned this issue Jun 2, 2023
7 tasks
@sainak sainak added the good first issue Good for newcomers label Jun 6, 2023
@sainak sainak self-assigned this Jun 6, 2023
@sainak sainak closed this as not planned Won't fix, can't repro, duplicate, stale Dec 31, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first issue Good for newcomers
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants