SELECT COUNT(*) AS count_id FROM (SELECT $1 FROM "patients"  WHERE     (patients.extid not ilike $2) AND (lower(patients.last_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	46604	id PRIMARY blood_group_id photograph_id
visits	107838	id PRIMARY patient_id