SELECT COUNT(*) AS count_id FROM (SELECT $1 FROM "patients"  WHERE     (patients.extid not ilike $2) AND (lower(patients.name) iLIKE $3) AND (patients.id in (select patient_id from visits where location_id = $4))) AS subquery

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
patients	105280	id PRIMARY blood_group_id extid photograph_id
visits	293578	id PRIMARY extid patient_id