care
care copied to clipboard
Fix N+1 queries in `/api/v1/getallfacilities/`
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) |