PgHero
No long running queries
Connections healthy 14
Vacuuming healthy
No columns near integer overflow
No invalid indexes or constraints
21 duplicate indexes
No suggested indexes
37 slow queries

Duplicate Indexes

These indexes exist, but aren’t needed. Remove them for faster writes.

Details
On address_details 
addresable_id (addressable_id)
is covered by 
idx_address_patient (addressable_id, addressable_type)
On address_details 
idx_address_patient (addressable_id, addressable_type)
is covered by 
idx_address_patient_type_id (addressable_id, addressable_type, id DESC)
On appointment_details 
idx_appointment_details_appointment (appointment_id, id DESC)
is covered by 
idx_apd (appointment_id, id DESC)
On appointments 
idx_appointments_app_start (app_start_date_time)
is covered by 
index_app_start_end_date_time (app_start_date_time, app_end_date_time)
On appointments 
idx_appointments_start_date_time (app_start_date_time)
is covered by 
index_app_start_end_date_time (app_start_date_time, app_end_date_time)
On appointments 
idx_app_start (app_start_date_time)
is covered by 
index_app_start_end_date_time (app_start_date_time, app_end_date_time)
On appointments 
idx_appointments_start_srd (app_start_date_time, service_request_detail_id)
is covered by 
idx_appointments_start_service (app_start_date_time, service_request_detail_id)
On appointments 
idx_appointments_srd (service_request_detail_id)
is covered by 
appointments_service_request_detail_id_idx (service_request_detail_id)
On bill_details 
idx_bill_details_srd (service_request_detail_id)
is covered by 
idx_bd_srd (service_request_detail_id)
On investigation_request_details 
idx_ird_srd (service_request_detail_id)
is covered by 
idx_ird_srd_status (service_request_detail_id, status)
On investigation_request_details 
idx_ird_srd_status (service_request_detail_id, status)
is covered by 
idx_ird (service_request_detail_id, status)
On patient_referal_details 
idx_prd (patient_id, status, created_at DESC)
is covered by 
idx_patient_referral_patient_status_created (patient_id, status, created_at DESC)
On patient_referal_details 
idx_prd_patient_status_created (patient_id, status, created_at DESC)
is covered by 
idx_patient_referral_patient_status_created (patient_id, status, created_at DESC)
On provisional_diagnoses 
provisional_diagnoses_encounter_id_idx (encounter_id)
is covered by 
idx_pd_encounter_status (encounter_id, status)
On provisional_diagnoses 
provisional_diagnoses_patient_id_idx (patient_id)
is covered by 
idx_pd_patient_status_created (patient_id, status, created_on DESC)
On service_request_details 
idx_srd_created_at (created_at)
is covered by 
idx_srd_created (created_at)
On service_request_details 
idx_srd_service (service_id)
is covered by 
idx_srd_service_id_id (service_id, id)
On service_request_details 
idx_srd_service_id (service_id)
is covered by 
idx_srd_service_id_id (service_id, id)
On service_request_details 
service_request_details_service_request_id_idx (service_request_id)
is covered by 
idx_srd_service_request_id (service_request_id)
On transaction_details 
transaction_details_credit_account_id_idx (credit_account_id)
is covered by 
idx_td_credit_bill (credit_account_id, credit_account_type)
On transaction_details 
transaction_details_debit_account_id_idx (debit_account_id)
is covered by 
idx_td_debit_bill (debit_account_id, debit_account_type)

Slow Queries

Slow queries take 20 ms or more on average and have been called at least 100 times.

Explain queries to see where to add indexes.

Total Time Average Time Calls
713 min 3% 23 ms 1,864,321 cims2 · details 
SELECT     "lab_test_requests".* FROM       "lab_test_requests"  join lab_test_request_details as ltrd on lab_test_requests.id = ltrd.lab_test_request_id join lab_test_results as ltre on ltre.lab_test_request_detail_id = ltrd.id join service_requests as sr on sr.id = lab_test_requests.service_request_id join service_request_details as srd on srd.service_request_id= sr.id WHERE     (lab_test_requests.patient_id=$1 and srd.service_id in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21) 
    and ltre.result_value ilike $22 )
706 min 3% 46 ms 926,565 cims1 · details 
SELECT     sr.id as Request_id ,sr.request_date, sr.requested_by_id, sg.name as Service_group,s.name ,srd.billing_status,ltrd.id as ltrdid,inv.id as invid,ltrd.status as Lab_Status,inv.status As Imaging_Status,srd.id as ser_req_lab FROM       "service_requests"  as sr join service_request_details as srd on sr.id = srd.service_request_id
                               join services as s on srd.service_id = s.id
                              join service_groups as sg on s.service_group_id =sg.id
                               left join lab_test_request_details as ltrd on srd.id = ltrd.service_request_detail_id
                               left outer join investigation_request_details as inv on srd.id = inv.service_request_detail_id WHERE     (sg.clinical_system_id in ($1) and sr.Patient_id =$2) ORDER BY  sr.id desc
629 min 3% 25 ms 1,526,116 erps1 · details 
UPDATE "extids" SET "current_value" = $1, "lock_version" = $2, "updated_at" = $3  WHERE (("extids"."id" = $4 AND "extids"."lock_version" = $5))
329 min 2% 1,332 ms 14,800 pghero · details 
SELECT n.nspname AS table_schema, c.relname AS table, attname AS column, format_type(a.atttypid, a.atttypmod) AS column_type, pg_get_expr(d.adbin, d.adrelid) AS default_value FROM pg_catalog.pg_attribute a INNER JOIN pg_catalog.pg_class c ON c.oid = a.attrelid INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace INNER JOIN pg_catalog.pg_attrdef d ON (a.attrelid, a.attnum) = (d.adrelid, d.adnum) WHERE NOT a.attisdropped AND a.attnum > $1 AND pg_get_expr(d.adbin, d.adrelid) LIKE $2 AND n.nspname NOT LIKE $3 /*pghero*/
269 min 1% 46 ms 348,581 erps2 · details 
UPDATE "extids" SET "current_value" = $1, "lock_version" = $2, "updated_at" = $3  WHERE (("extids"."id" = $4 AND "extids"."lock_version" = $5))
173 min 0.8% 34 ms 308,855 cims1 · details 
SELECT     sr.id as Request_id ,sr.request_date, sr.requested_by_id, sg.name as Service_group,s.name,srd.id as request_detail_id,srd.billing_status,ltrd.id as ltrdid,inv.id as invid,ltrd.status as Lab_Status,inv.status As Imaging_Status,srd.id as inv_serv_req_det FROM       "service_requests"  as sr join service_request_details as srd on sr.id = srd.service_request_id
                               join services as s on srd.service_id = s.id
                              join service_groups as sg on s.service_group_id =sg.id
                               left join lab_test_request_details as ltrd on srd.id = ltrd.service_request_detail_id
                               left outer join investigation_request_details as inv on srd.id = inv.service_request_detail_id WHERE     (sg.clinical_system_id in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10) and sr.Patient_id =$11) ORDER BY  sr.id desc
165 min 0.8% 23 ms 433,680 erps1 · details 
SELECT     COUNT(*) AS count_id FROM       "appointments"  INNER JOIN "appointment_details" ON "appointments".id = "appointment_details".appointment_id WHERE     (("appointment_details".schedulable_entity_id = $1)) AND (((app_start_date_time >= $2 and app_start_date_time < $3) or (app_end_date_time >= $4 and app_end_date_time < $5))) AND (status = $6)
162 min 0.8% 33 ms 292,464 cims1 · details 
SELECT     COUNT(lts.id) AS count_id FROM       "lab_test_requests"  as ltr inner join lab_test_request_details as ltrd on ltr.id = ltrd.lab_test_request_id inner join lab_test_results as lts on lts.lab_test_request_detail_id = ltrd.id WHERE     (ltr.patient_id =$1  and lts.service_unit_id=$2 and ltrd.created_at <$3 and ltrd.id !=$4 and ltrd.status=$5)
153 min 0.7% 47 ms 194,289 cims2 · details 
SELECT     sr.id as Request_id ,sr.request_date, sr.requested_by_id, sg.name as Service_group,s.name ,srd.billing_status,ltrd.id as ltrdid,inv.id as invid,ltrd.status as Lab_Status,inv.status As Imaging_Status,srd.id as ser_req_lab FROM       "service_requests"  as sr join service_request_details as srd on sr.id = srd.service_request_id
                               join services as s on srd.service_id = s.id
                              join service_groups as sg on s.service_group_id =sg.id
                               left join lab_test_request_details as ltrd on srd.id = ltrd.service_request_detail_id
                               left outer join investigation_request_details as inv on srd.id = inv.service_request_detail_id WHERE     (sg.clinical_system_id in ($1) and sr.Patient_id =$2) ORDER BY  sr.id desc
138 min 0.6% 253 ms 32,568 erps1 · details 
SELECT     distinct(bd.*) FROM       "bill_details"  as bd inner join bills as b on b.id=bd.bill_id inner join itemwise_corporate_coverages as iwcc on iwcc.corporate_id = b.corporate_id WHERE     (iwcc.corporate_id=$1 and bd.bill_id=$2 and bd.patient_share > $3)
130 min 0.6% 25 ms 315,492 erps1 · details 
SELECT     "item_reorder_levels".* FROM       "item_reorder_levels"  WHERE     (item_id=$1 and inventory_head_id=$2) LIMIT $3
122 min 0.6% 187 ms 39,281 cims1 · details 
SELECT     "icd10_codes".* FROM       "icd10_codes"  WHERE     (icd_name ilike $1) ORDER BY  icd_name LIMIT $2
116 min 0.5% 409 ms 16,925 pghero · details 
SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), $1, $2) AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), $3, $4) AS using, indisunique AS unique, indisprimary AS primary, indisvalid AS valid, indexprs::text, indpred::text, pg_get_indexdef(i.indexrelid) AS definition FROM pg_index i INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_class ix ON ix.oid = i.indexrelid LEFT JOIN pg_stat_user_indexes ui ON ui.indexrelid = i.indexrelid WHERE schemaname IS NOT NULL ORDER BY 1, 2 /*pghero*/
110 min 0.5% 77 ms 85,251 erps1 · details 
SELECT * FROM ( SELECT     DISTINCT ON ("patients".id) "patients".id, patients.id AS alias_0 FROM       "patients" LEFT OUTER JOIN "address_details" ON "address_details"."addressable_id" = "patients"."id" AND "address_details"."addressable_type" = $1 WHERE     (patients.extid not ilike $2) AND (address_details.mobile_no =$3) AND (patients.id in (select patient_id from visits where location_id = $4))) AS id_list ORDER BY id_list.alias_0  LIMIT $5 OFFSET $6
100 min 0.5% 124 ms 48,226 erps1 · details 
SELECT COUNT(*) AS count_id FROM (SELECT $1 FROM "transaction_details"  WHERE     ("transaction_details".ip_supplementary_bill_id = $2) AND ("transaction_details"."narration" = $3)) AS subquery
95 min 0.4% 26 ms 218,281 erps1 · details 
INSERT INTO "family_banks" ("amount", "bill_extid", "bill_id", "bill_ref_number", "business_short_code", "callback_message", "callback_received_at", "checkout_request_id", "created_at", "created_by", "invoice_number", "is_updated", "kyc_name", "location_id", "merchant_request_identifier", "message", "msisdn", "org_account_balance", "patient_id", "payment_date", "phone_number", "provider", "result_code", "result_desc", "trans_amount", "trans_id", "trans_time", "transaction_id", "transaction_status", "transaction_type", "updated_at", "visit_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32) RETURNING "id"
89 min 0.4% 58 ms 91,603 cims1 · details 
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  date(a.app_start_date_time) <= $5 and a.app_status = $6  and srd.billing_status != $7 and srd.billing_status = $8 and sq.clinician_id in ($9) and sq.location_id = $10 and a.is_telemedicine is null) ORDER BY  a.patient_criticality_id desc
89 min 0.4% 20 ms 260,939 cims1 · details 
SELECT COUNT(*) AS count_id FROM (SELECT $1 FROM "service_requests"  WHERE     ("service_requests".patient_id = $2)) AS subquery
68 min 0.3% 27 ms 151,329 erps1 · details 
SELECT     itd.* FROM       "inv_tran_details"  as itd inner join inventory_transactions as it on it.id = itd.inventory_transaction_id inner join item_with_details as iwd on itd.item_with_detail_id = iwd.id WHERE     (it.reference2 = $1 and iwd.item_id = $2) ORDER BY  it.id desc LIMIT $3
63 min 0.3% 132 ms 28,542 erps1 · details 
SELECT     "patients".* FROM       "patients"  WHERE     (patients.extid not ilike $1) AND (lower(patients.name) iLIKE $2) AND (lower(patients.last_name) iLIKE $3) AND (patients.id in (select patient_id from visits where location_id = $4)) ORDER BY  patients.id LIMIT $5 OFFSET $6
62 min 0.3% 71 ms 52,422 cims1 · details 
SELECT     ocpd.narration as narration,ocpd.created_by as created_by,ocpd.created_at as created_at,ocpd.opd_card_prescription_id,ocpd.include_note_in_dashboard,ocp.patient_id,ocpd.id,ocpd.narration_type as narration_type FROM       "opd_card_prescription_details"  as ocpd inner join opd_card_prescriptions as ocp on ocp.id =  ocpd.opd_card_prescription_id WHERE     (ocp.patient_id=$1 and ocpd.narration_type in ($2,$3) and ocpd.status=$4) ORDER BY  ocpd.opd_card_prescription_id desc,ocpd.created_at desc
61 min 0.3% 20 ms 180,115 cims2 · details 
SELECT     "bills".* FROM       "bills"  WHERE     ("bills"."service_request_id" = $1) LIMIT $2
59 min 0.3% 118 ms 29,859 erps1 · details 
SELECT     "patients".* FROM       "patients"  WHERE     (patients.extid not ilike $1) AND (lower(patients.name) iLIKE $2) AND (lower(patients.last_name) iLIKE $3) ORDER BY  patients.id
57 min 0.3% 41 ms 84,460 erps1 · details 
SELECT * FROM mpesa_payments WHERE TRIM(merchant_request_identifier) = $1
53 min 0.2% 147 ms 21,665 pghero · details 
SELECT n.nspname AS schema, c.relname AS relation, CASE c.relkind WHEN $1 THEN $2 WHEN $3 then $4 ELSE $5 END AS type, pg_table_size(c.oid) AS size_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname NOT IN ($6, $7) AND n.nspname !~ $8 AND c.relkind IN ($9, $10, $11) ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/
51 min 0.2% 33 ms 92,909 erps1 · details 
SELECT b.id as id,b.final_amount as final_amount, sum(bd.net_amount+bd.corporate_covered_amount) as net_amount ,b.narration as narration
                              FROM bills  as b 
                              inner join bill_details as bd on b.id = bd.bill_id
                              inner join visits as v on v.id = b.visit_id
                              inner join patients as p on p.id = v.patient_id
                              inner join corporates as c on v.corporate_id = c.id
                              inner join department_service_groups as dsg on dsg.id = bd.department_service_group_id                              
                              WHERE (bd.status = $1 and bd.is_cancelled != $2 and ((v.patient_type=$3) or (v.patient_type=$4 and b.narration=$5)) and date(bill_date) >= $6 and date(bill_date) <= $7 and dsg.id = $8 and bd.location_id =$9)
                              GROUP BY b.id,b.narration,b.final_amount
                              ORDER BY b.id
50 min 0.2% 77 ms 39,037 cims1 · details 
SELECT     "patients".* FROM       "patients"  WHERE     (patients.id in (select patient_id from visits where location_id = $1)) AND (RIGHT(patients.extid, $2) = $3) AND (patients.id in (select patient_id from visits where location_id = $4)) LIMIT $5 OFFSET $6
46 min 0.2% 58 ms 47,171 cims1 · details 
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
44 min 0.2% 41 ms 65,331 cims1 · details 
SELECT     ltrd.id as detail_id,ltrd.lab_test_request_id as lab_test_request_id,ltrd.begin_specimen_received_time as spec_procedure_time, s.id as service_id,
     s.name as service_name,s.is_vantana, sp.name as specimen_name,lt.patient_id,ltrd.urgent_check,ltp.status as ltp_status, ltp.extid,ltp.priority_comments, ltrd.status as ltrd_status,s.report_type,
     ltp.indications,ltp.specimen_prefix as specimen_prefix,ltp.specimen_number as specimen_number,ltrd.station_id,ltrd.service_request_detail_id,(p.name||$1||p.last_name) as pat_name,p.extid as pat_extid,lt.visit_id as visit_id, v.patient_type,v.clinician_id as cli_id,
     sr.is_cpoe_request,stn.name as station_name,srd.order_remarks,p.title_id,p.id as pat_id,p.age as pat_age,p.gender_id as pat_gender, ltp.id as specimen_id,ltrd.specimen_received_time,ltrd.status FROM       "lab_test_request_details"  as ltrd
     inner join lab_test_requests as lt on lt.id =ltrd.lab_test_request_id
     inner join cross_location_orders as clo on clo.lab_test_request_detail_id=ltrd.id
     inner join services as s on s.id = ltrd.service_id
     inner join specimens as sp on sp.id = ltrd.specimen_id
     inner join lab_test_specimens as ltp on ltp.lab_test_request_detail_id = ltrd.id
     inner join patients as p on lt.patient_id = p.id
     inner join visits as v on v.id=lt.visit_id
     inner join service_request_details as srd on srd.id = ltrd.service_request_detail_id
     inner join service_requests as sr on srd.service_request_id=sr.id
     inner join stations as stn on stn.id=ltrd.station_id WHERE     (ltrd.specimen_recieved = $2 and (ltrd.status = $3  or ltrd.status = $4 or ltrd.status = $5) and ltrd.sending_approval is null and ltp.status = $6 and (date(ltrd.begin_specimen_received_time) >= $7 and date(ltrd.begin_specimen_received_time) <= $8) and s.id in(select id from services where service_group_id in(select service_group_id from service_groups_stations where (station_id = $9 ))) and ((s.report_type= $10) or (s.report_type = $11) or (s.report_type = $12) or (s.report_type = $13)) and lt.location_id = $14 and clo.to_location_id = $15 and clo.status = $16) ORDER BY  ltp.extid,lt.emergency desc,srd.is_urgent desc
40 min 0.2% 31 ms 76,882 erps1 · details 
SELECT     "generic_names".* FROM       "generic_names"  WHERE     (status=$1 and healthcare_institution_id=$2) ORDER BY  lower(name)
40 min 0.2% 25 ms 93,675 cims1 · details 
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
40 min 0.2% 25 ms 93,854 erps1 · details 
UPDATE "encounters" SET "closed_by" = $1, "comments" = $2, "status" = $3, "updated_at" = $4, "updated_by" = $5  WHERE ("encounters"."id" = $6)
38 min 0.2% 35 ms 65,136 cims2 · details 
SELECT     COUNT(lts.id) AS count_id FROM       "lab_test_requests"  as ltr inner join lab_test_request_details as ltrd on ltr.id = ltrd.lab_test_request_id inner join lab_test_results as lts on lts.lab_test_request_detail_id = ltrd.id WHERE     (ltr.patient_id =$1  and lts.service_unit_id=$2 and ltrd.created_at <$3 and ltrd.id !=$4 and ltrd.status=$5)
38 min 0.2% 22 ms 105,152 erps2 · details 
INSERT INTO "bill_details" ("actual_clinician_share", "amount", "anesthetist_charge", "anesthetist_id", "bed_category_id", "bill_category_id", "bill_detail_date", "bill_id", "billing_status", "ceo_discount", "cgst_amount", "cgst_percentage", "clinician_id", "corporate_category_id", "corporate_covered_amount", "corporate_id", "corporate_share", "created_at", "created_by", "credit_note_referal_id", "cs_mig_status", "cssd_pack_id", "department_clinician_id", "department_service_group_id", "disc_perc_mast_amt", "disc_perc_tpa_amt", "discipline_id", "discount_1mg_ip_percentage", "discount_1mg_op_percentage", "discount_amount", "discount_percentage", "dissc_amount", "doctor_share_amount", "drug_prescription_detail_id", "free_bed_days", "from_date", "has_ip_deposit_adjustment", "has_prior_approval", "has_seen", "healthcare_institution_id", "igst_amount", "igst_percentage", "insurance_id", "inventory_transaction_id", "is_applied_final_discount", "is_cancelled", "is_checked", "is_discount_in_percentage", "is_external", "is_fullfilled", "is_internal", "is_luxury_tax", "is_original", "is_return_after_settlement", "is_waive_off", "item_with_detail_id", "line_item_type", "location_id", "master_item_disc", "mg_status", "narration", "net_amount", "new_tpa_disc", "not_covered_in_package", "old_c_amount", "package_covered_amount", "package_covered_quantity", "package_item_id", "parent_id", "patient_id", "patient_share", "patient_share_credit_adjusted", "patient_type", "performed_clinician_charge", "performed_clinician_id", "pharmacy_bill_without_payment", "quantity", "rate_varies", "referal_clinician_id", "reference_1", "reference_2", "reference_3", "reference_clinician_id", "referral_source_id", "referral_type", "refferal_category_id", "remarks", "return_after_discharge_remark", "return_reason", "selling_price", "service_id", "service_rendered_date", "service_request_detail_id", "sgst_amount", "sgst_percentage", "source_type_name", "station_id", "station_name", "station_unit_id", "status", "surgeon_fee_percentage", "surgery_bill_detail_id", "tax_amount", "tax_profile_id", "taxable_amount", "to_date", "tpa_disc", "trustee_disc", "trustee_disc_amount", "unit_price", "updated_at", "updated_by", "visit_id", "waive_off_amount", "waive_off_bill", "waive_off_percentage") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116) RETURNING "id"
37 min 0.2% 157 ms 14,295 erps1 · details 
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
37 min 0.2% 144 ms 15,471 cims1 · details 
SELECT     "pains".* FROM       "pains"  WHERE     (patient_id=$1)
37 min 0.2% 241 ms 9,165 pghero · details 
SELECT last_value FROM "public"."maternity_triage_parameters_id_seq" UNION ALL SELECT last_value FROM "public"."clinical_note_edits_id_seq" UNION ALL SELECT last_value FROM "public"."clinical_note_visits_id_seq" UNION ALL SELECT last_value FROM "public"."organisms_antibiotics_mappings_id_seq" UNION ALL SELECT last_value FROM "public"."postmortem_injuries_id_seq" UNION ALL SELECT last_value FROM "public"."quotations_suppliers_id_seq" UNION ALL SELECT last_value FROM "public"."account_closures_id_seq" UNION ALL SELECT last_value FROM "logging"."t_history_id_seq" UNION ALL SELECT last_value FROM "public"."abdomino_pelvic_ultrasounds_id_seq" UNION ALL SELECT last_value FROM "public"."acc_acccombination_id_seq" UNION ALL SELECT last_value FROM "public"."acc_accgroups_id_seq" UNION ALL SELECT last_value FROM "public"."acc_accholiday_id_seq" UNION ALL SELECT last_value FROM "public"."acc_accprivilege_id_seq" UNION ALL SELECT last_value FROM "public"."acc_accterminal_id_seq" UNION ALL SELECT last_value FROM "public"."acc_acctimezone_id_seq" UNION ALL SELECT last_value FROM "public"."accident_emergencies_id_seq" UNION ALL SELECT last_value FROM "public"."accident_emergency_details_id_seq" UNION ALL SELECT last_value FROM "public"."account_closures_approvals_id_seq" UNION ALL SELECT last_value FROM "public"."account_components_mappings_id_seq" UNION ALL SELECT last_value FROM "public"."account_configurations_id_seq" UNION ALL SELECT last_value FROM "public"."account_group_types_id_seq" UNION ALL SELECT last_value FROM "public"."account_groups_id_seq" UNION ALL SELECT last_value FROM "public"."account_items_mappings_id_seq" UNION ALL SELECT last_value FROM "public"."account_package_group_mappings_id_seq" UNION ALL SELECT last_value FROM "public"."account_services_mappings_id_seq" UNION ALL SELECT last_value FROM "public"."account_tds_mappings_id_seq" UNION ALL SELECT last_value FROM "public"."accounts_tax_rules_mappings_id_seq" UNION ALL SELECT last_value FROM "public"."accpac_batches_id_seq" UNION ALL SELECT last_value FROM "public"."accpac_customer_receipts_id_seq" UNION ALL SELECT last_value FROM "public"."acs_registry_reports_id_seq" UNION ALL SELECT last_value FROM "public"."action_group_partials_id_seq" UNION ALL SELECT last_value FROM "public"."birth_history_seconds_id_seq" UNION ALL SELECT last_value FROM "public"."action_groups_composite_partials_id_seq" UNION ALL SELECT last_value FROM "public"."action_groups_controller_actions_id_seq" UNION ALL SELECT last_value FROM "public"."action_groups_menu_contexts_id_seq" UNION ALL SELECT last_value FROM "public"."action_items_id_seq" UNION ALL SELECT last_value FROM "public"."active_in_patients_id_seq" UNION ALL SELECT last_value FROM "public"."active_problems_id_seq" UNION ALL SELECT last_value FROM "public"."actual_inv_transactions_id_seq" UNION ALL SELECT last_value FROM "public"."actual_monthly_tax_details_id_seq" UNION ALL SELECT last_value FROM "public"."add_and_update_targets_id_seq" UNION ALL SELECT last_value FROM "public"."addendum_procedure_notes_id_seq" UNION ALL SELECT last_value FROM "public"."additional_procedures_id_seq" UNION ALL SELECT last_value FROM "public"."address_details_id_seq" UNION ALL SELECT last_value FROM "public"."address_locations_id_seq" UNION ALL SELECT last_value FROM "public"."address_sub_locations_id_seq" UNION ALL SELECT last_value FROM "public"."admission_purposes_id_seq" UNION ALL SELECT last_value FROM "public"."adt_requests_id_seq" UNION ALL SELECT last_value FROM "public"."advancedetails_id_seq" UNION ALL SELECT last_value FROM "public"."advance_used_registers_id_seq" UNION ALL SELECT last_value FROM "public"."advance_visits_id_seq" UNION ALL SELECT last_value FROM "public"."advance_visits_bills_id_seq" UNION ALL SELECT last_value FROM "public"."advice_nonbillable_details_id_seq" UNION ALL SELECT last_value FROM "public"."advice_nonbillables_id_seq" UNION ALL SELECT last_value FROM "public"."ages_id_seq" UNION ALL SELECT last_value FROM "public"."ai_tmmt_test_map_mast_t_id_seq" UNION ALL SELECT last_value FROM "public"."aldrete_scores_id_seq" UNION ALL SELECT last_value FROM "public"."allergy_histories_id_seq" UNION ALL SELECT last_value FROM "public"."allowance_deduction_calc_details_id_seq" UNION ALL SELECT last_value FROM "public"."allowance_deduction_details_id_seq" UNION ALL SELECT last_value FROM "public"."allowance_deductions_id_seq" UNION ALL SELECT last_value FROM "public"."anaesthesia_axons_id_seq" UNION ALL SELECT last_value FROM "public"."anaesthetic_records_id_seq" UNION ALL SELECT last_value FROM "public"."anaesthetic_sheets_id_seq" UNION ALL SELECT last_value FROM "public"."anesthesia_types_id_seq" UNION ALL SELECT last_value FROM "public"."angiograms_id_seq" UNION ALL SELECT last_value FROM "public"."annual_diabetic_visits_id_seq" UNION ALL SELECT last_value FROM "public"."ant_order_set_details_id_seq" UNION ALL SELECT last_value FROM "public"."ante_order_set_details_id_seq" UNION ALL SELECT last_value FROM "public"."antenatal_check_up_records_id_seq" UNION ALL SELECT last_value FROM "public"."antenatal_checkup_records_id_seq" UNION ALL SELECT last_value FROM "public"."antenatal_ordersets1_id_seq" UNION ALL SELECT last_value FROM "public"."anthropometry_details_id_seq" UNION ALL SELECT last_value FROM "public"."antibiotic_drugs_id_seq" UNION ALL SELECT last_value FROM "public"."antordersets_id_seq" UNION ALL SELECT last_value FROM "public"."apacheis_id_seq" UNION ALL SELECT last_value FROM "public"."appointment_categories_id_seq" UNION ALL SELECT last_value FROM "public"."appointment_details_id_seq" UNION ALL SELECT last_value FROM "public"."appointment_purposes_id_seq" UNION ALL SELECT last_value FROM "public"."appointments_id_seq" UNION ALL SELECT last_value FROM "public"."appraisal_training_type_details_id_seq" UNION ALL SELECT last_value FROM "public"."approval_designations_id_seq" UNION ALL SELECT last_value FROM "public"."approval_details_id_seq" UNION ALL SELECT last_value FROM "public"."approval_functionalities_id_seq" UNION ALL SELECT last_value FROM "public"."approval_level_designations_id_seq" UNION ALL SELECT last_value FROM "public"."areas_id_seq" UNION ALL SELECT last_value FROM "public"."arterial_cvps_id_seq" UNION ALL SELECT last_value FROM "public"."assesmentof_dysfluencies_id_seq" UNION ALL SELECT last_value FROM "public"."assessment_by_paediatrician_nine_months_id_seq" UNION ALL SELECT last_value FROM "public"."assessment_by_paediatrician_three_four_months_id_seq" UNION ALL SELECT last_value FROM "public"."assessment_categories_id_seq" UNION ALL SELECT last_value FROM "public"."assessment_cerebral_palsies_id_seq" UNION ALL SELECT last_value FROM "public"."assessment_child_learning_difficultues_id_seq" UNION ALL SELECT last_value FROM "public"."assessment_language_developments_id_seq" UNION ALL SELECT last_value FROM "public"."assessment_protocols_id_seq" UNION ALL SELECT last_value FROM "public"."assessmentfor_articulation_disorders_id_seq" UNION ALL SELECT last_value FROM "public"."assessmentfor_cerebral_palsies_id_seq" UNION ALL SELECT last_value FROM "public"."assessmentfor_neurogenic_communications_id_seq" UNION ALL SELECT last_value FROM "public"."asset_account_mappings_id_seq" UNION ALL SELECT last_value FROM "public"."asset_components_id_seq" UNION ALL SELECT last_value FROM "public"."asset_consumble_details_id_seq" UNION ALL SELECT last_value FROM "public"."asset_depreciation_histories_id_seq" UNION ALL SELECT last_value FROM "public"."asset_depreciation_requests_id_seq" UNION ALL SELECT last_value FROM "public"."asset_insurence_details_id_seq" UNION ALL SELECT last_value FROM "public"."asset_locations_id_seq" UNION ALL SELECT last_value FROM "public"."asset_names_id_seq" UNION ALL SELECT last_value FROM "public"."asset_operators_id_seq" UNION ALL SELECT last_value FROM "public"."asset_preventive_maintenance_schedules_id_seq" UNION ALL SELECT last_value FROM "public"."asset_shutdown_histories_id_seq" UNION ALL SELECT last_value FROM "public"."asset_warranty_details_id_seq" UNION ALL SELECT last_value FROM "public"."assets_id_seq" UNION ALL SELECT last_value FROM "public"."associated_healthcare_institutions_id_seq" UNION ALL SELECT last_value FROM "public"."associated_persons_id_seq" UNION ALL SELECT last_value FROM "public"."asymptomatic_symptoms_id_seq" UNION ALL SELECT last_value FROM "public"."att_attcalclog_id_seq" UNION ALL SELECT last_value FROM "public"."att_attreportsetting_id_seq" UNION ALL SELECT last_value FROM "public"."att_attschedule_id_seq" UNION ALL SELECT last_value FROM "public"."att_attshift_id_seq" UNION ALL SELECT last_value FROM "public"."att_breaktime_id_seq" UNION ALL SELECT last_value FROM "public"."att_clientdetails_id_seq" UNION ALL SELECT last_value FROM "public"."att_departmentschedule_id_seq" UNION ALL SELECT last_value FROM "public"."att_deptattrule_id_seq" UNION ALL SELECT last_value FROM "public"."att_holiday_id_seq" UNION ALL SELECT last_value FROM "public"."att_leavecategory_id_seq" UNION ALL SELECT last_value FROM "public"."att_leaveschedule_id_seq" UNION ALL SELECT last_value FROM "public"."att_leavesettings_id_seq" UNION ALL SELECT last_value FROM "public"."att_outdooremployeeschedule_id_seq" UNION ALL SELECT last_value FROM "public"."att_outdoorscheduleplanner_id_seq" UNION ALL SELECT last_value FROM "public"."att_outdoortrack_id_seq" UNION ALL SELECT last_value FROM "public"."att_payloadmulpunchset_id_seq" UNION ALL SELECT last_value FROM "public"."att_reportparam_id_seq" UNION ALL SELECT last_value FROM "public"."att_shiftdetail_id_seq" UNION ALL SELECT last_value FROM "public"."att_tempschedule_id_seq" UNION ALL SELECT last_value FROM "public"."att_timeinterval_id_seq" UNION ALL SELECT last_value FROM "public"."att_timeinterval_break_time_id_seq" UNION ALL SELECT last_value FROM "public"."att_trainingcategory_id_seq" UNION ALL SELECT last_value FROM "public"."attendance_spoc_masters_id_seq" UNION ALL SELECT last_value FROM "public"."attendent