care icon indicating copy to clipboard operation
care copied to clipboard

N+1 Query `/api/v1/facility/`

Open sentry-io[bot] opened this issue 11 months ago • 2 comments

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
)
``

sentry-io[bot] avatar Feb 27 '24 05:02 sentry-io[bot]