SELECT     distinct(patients.*),patients.id as patient_id, visits.id as visit_id,e.id as encounter_id,
                   patients.name as patient_name,patients.age as patient_age, 
                   inpatient_details.admission_time as doa, inpatient_details.clinical_status as cs, inpatient_details.admit_clinician_id as admit_clinician_id,
                   inpatient_details.consult_clinician_id as consult_clinician_id,
                   stations.name as name,station_units.name as bed_number, 
                   visits.emergency_status as e_status, case when corporates.display_name = $1 then corporates.name else corporates.display_name end
                   as corporate_name  FROM       "inpatient_details"  INNER JOIN "bed_allocations" ON "bed_allocations"."inpatient_detail_id" = "inpatient_details"."id" 
                  INNER JOIN "stations" ON "stations"."id" = "bed_allocations"."station_id" 
                  INNER JOIN "station_groups" ON "station_groups"."id" = "stations"."station_group_id" 
                  INNER JOIN "station_units" ON "station_units"."id" = "bed_allocations"."station_unit_id" 
                  INNER JOIN "visits" ON "visits"."id" = "inpatient_details"."visit_id" 
                  INNER JOIN encounters as e on e.visit_id=visits.id
                  INNER JOIN "corporates" ON "corporates"."id" = "inpatient_details"."corporate_id" 
                  INNER JOIN "patients" ON "patients"."id" = "inpatient_details"."patient_id" WHERE     (e.status=$2 and visits.patient_type = $3 and inpatient_details.discharge_time is null and bed_allocations.status = $4 and inpatient_details.location_id = $5) ORDER BY  doa desc

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
bed_allocations	10355	id PRIMARY inpatient_detail_id status
corporates	23	id PRIMARY name
encounters	241178	id PRIMARY patient_id visit_id
inpatient_details	7028	id PRIMARY visit_id
patients	128968	id PRIMARY blood_group_id extid photograph_id
station_groups	18	id PRIMARY
station_units	1428	id PRIMARY
stations	337	id PRIMARY
visits	378042	id PRIMARY extid patient_id