SELECT     a.*,e.id as encounter_id FROM       "appointments"  as a inner join visits as v on a.visit_id=v.id inner join encounters as e on v.id = e.visit_id
                                                                                inner join service_request_details as srd on srd.id=a.service_request_detail_id                                                                                                         inner join service_requests as sq on sq.id=srd.service_request_id WHERE     (a.check1 is null and e.status = $1  and e.name !=$2 and v.patient_type =$3 and date(a.app_start_date_time) = $4 and a.app_status = $5  and srd.billing_status != $6 and sq.clinician_id in ($7) and sq.location_id = $8 and a.is_telemedicine = $9 and a.txnstatus=$10) ORDER BY  a.app_start_date_time asc

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
appointments	178210	id PRIMARY app_start_date, app_end_date, app_start_time, app_end_time app_start_date_time, app_end_date_time patient_criticality_id patient_id pre_id service_request_detail_id visit_id
encounters	182199	id PRIMARY patient_id visit_id
service_request_details	516676	id PRIMARY placer_order_number UNIQUE service_request_id
service_requests	360370	id PRIMARY visit_id
visits	293578	id PRIMARY extid patient_id