explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qM1W

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 66.385 ↓ 0.0 0 1

Unique (cost=2,354,413.19..2,354,438.29 rows=200 width=4) (actual time=66.385..66.385 rows=0 loops=1)

  • Output: (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN xref.new_referral_id WHEN (xref.claim_id IS NOT NULL) THEN xref.claim_id WHEN (xref.stay_id IS NOT NULL) THEN xref.stay_id WHEN (xref.patient_id IS NOT NULL) THEN xref.patient_id ELSE NULL::integer END)
2. 0.005 66.385 ↓ 0.0 0 1

Sort (cost=2,354,413.19..2,354,425.74 rows=5,020 width=4) (actual time=66.385..66.385 rows=0 loops=1)

  • Output: (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN xref.new_referral_id WHEN (xref.claim_id IS NOT NULL) THEN xref.claim_id WHEN (xref.stay_id IS NOT NULL) THEN xref.stay_id WHEN (xref.patient_id IS NOT NULL) THEN xref.patient_id ELSE NULL::integer END)
  • Sort Key: (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN xref.new_referral_id WHEN (xref.claim_id IS NOT NULL) THEN xref.claim_id WHEN (xref.stay_id IS NOT NULL) THEN xref.stay_id WHEN (xref.patient_id IS NOT NULL) THEN xref.patient_id ELSE NULL::integer END)
  • Sort Method: quicksort Memory: 25kB
3. 0.003 66.380 ↓ 0.0 0 1

Hash Join (cost=2,353,560.83..2,354,104.62 rows=5,020 width=4) (actual time=66.380..66.380 rows=0 loops=1)

  • Output: (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN xref.new_referral_id WHEN (xref.claim_id IS NOT NULL) THEN xref.claim_id WHEN (xref.stay_id IS NOT NULL) THEN xref.stay_id WHEN (xref.patient_id IS NOT NULL) THEN xref.patient_id ELSE NULL::integer END)
  • Inner Unique: true
  • Hash Cond: (task.id_ = max_id.max_id)
4. 0.000 0.000 ↓ 0.0 0

Unique (cost=2,173,726.52..2,174,153.46 rows=5,175 width=727) (never executed)

  • Output: task.id_, task.name_, task.description_, task.actorid_, (CASE WHEN ((task.name_)::text = 'manual-task'::text) THEN 'person'::text ELSE 'system'::text END), ((SubPlan 1)), (COALESCE((SubPlan 2), (CASE WHEN (((task.name_)::text = 'customerServiceSwimlaneAssignment'::text) OR ((task.name_)::text = 'referralHoldTask'::text) OR ((task.name_)::text = 'processReferralOnHold'::text)) THEN 'ClinAssistCustomerService'::text WHEN (((task.name_)::text = 'processNewReferral'::text) OR ((task.name_)::text = 'intakeSwimlaneAssignment'::text)) THEN 'ClinAssistAdmin'::text ELSE NULL::text END)::character varying)), task.duedate_, ((task.duedate_)::date), (to_char(task.duedate_, 'HH12:MI:SS AM'::text)), task.start_, task.end_, task.priority_, (CASE WHEN ((('now'::cstring)::date > task.duedate_) AND (task.end_ IS NULL)) THEN true ELSE false END), (CASE WHEN task.issuspended_ THEN 'Suspended'::text WHEN task.iscancelled_ THEN 'Cancelled'::text WHEN (task.end_ IS NOT NULL) THEN 'Ended'::text WHEN (task.start_ IS NOT NULL) THEN 'Started'::text ELSE 'Not Started'::text END), (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END), (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN 'newReferralId'::text WHEN (xref.claim_id IS NOT NULL) THEN 'claimId'::text WHEN (xref.stay_id IS NOT NULL) THEN 'stayId'::text WHEN (xref.patient_id IS NOT NULL) THEN 'patientId'::text ELSE NULL::text END), (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN xref.new_referral_id WHEN (xref.claim_id IS NOT NULL) THEN xref.claim_id WHEN (xref.stay_id IS NOT NULL) THEN xref.stay_id WHEN (xref.patient_id IS NOT NULL) THEN xref.patient_id ELSE NULL::integer END), (COALESCE((SubPlan 3), (SubPlan 4), (SubPlan 5), COALESCE((SubPlan 6), (SubPlan 7)))), (COALESCE((SubPlan 8), (SubPlan 9), (SubPlan 10), (SubPlan 11), (SubPlan 12))), (COALESCE((SubPlan 13), ((SubPlan 14))::text, ((SubPlan 15))::text, ((SubPlan 16))::text)), (COALESCE((SubPlan 17), (SubPlan 18), (SubPlan 19))), (COALESCE((SubPlan 20), (SubPlan 21))), (COALESCE((SubPlan 22), (SubPlan 23))), ((SubPlan 24)), task.create_, task.procinst_, ((SubPlan 25)), ((SubPlan 26)), (COALESCE((SubPlan 27), false)), ((SubPlan 28)), (((SubPlan 29))::text)
5. 0.000 0.000 ↓ 0.0 0

Sort (cost=2,173,726.52..2,173,739.46 rows=5,175 width=727) (never executed)

  • Output: task.id_, task.name_, task.description_, task.actorid_, (CASE WHEN ((task.name_)::text = 'manual-task'::text) THEN 'person'::text ELSE 'system'::text END), ((SubPlan 1)), (COALESCE((SubPlan 2), (CASE WHEN (((task.name_)::text = 'customerServiceSwimlaneAssignment'::text) OR ((task.name_)::text = 'referralHoldTask'::text) OR ((task.name_)::text = 'processReferralOnHold'::text)) THEN 'ClinAssistCustomerService'::text WHEN (((task.name_)::text = 'processNewReferral'::text) OR ((task.name_)::text = 'intakeSwimlaneAssignment'::text)) THEN 'ClinAssistAdmin'::text ELSE NULL::text END)::character varying)), task.duedate_, ((task.duedate_)::date), (to_char(task.duedate_, 'HH12:MI:SS AM'::text)), task.start_, task.end_, task.priority_, (CASE WHEN ((('now'::cstring)::date > task.duedate_) AND (task.end_ IS NULL)) THEN true ELSE false END), (CASE WHEN task.issuspended_ THEN 'Suspended'::text WHEN task.iscancelled_ THEN 'Cancelled'::text WHEN (task.end_ IS NOT NULL) THEN 'Ended'::text WHEN (task.start_ IS NOT NULL) THEN 'Started'::text ELSE 'Not Started'::text END), (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END), (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN 'newReferralId'::text WHEN (xref.claim_id IS NOT NULL) THEN 'claimId'::text WHEN (xref.stay_id IS NOT NULL) THEN 'stayId'::text WHEN (xref.patient_id IS NOT NULL) THEN 'patientId'::text ELSE NULL::text END), (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN xref.new_referral_id WHEN (xref.claim_id IS NOT NULL) THEN xref.claim_id WHEN (xref.stay_id IS NOT NULL) THEN xref.stay_id WHEN (xref.patient_id IS NOT NULL) THEN xref.patient_id ELSE NULL::integer END), (COALESCE((SubPlan 3), (SubPlan 4), (SubPlan 5), COALESCE((SubPlan 6), (SubPlan 7)))), (COALESCE((SubPlan 8), (SubPlan 9), (SubPlan 10), (SubPlan 11), (SubPlan 12))), (COALESCE((SubPlan 13), ((SubPlan 14))::text, ((SubPlan 15))::text, ((SubPlan 16))::text)), (COALESCE((SubPlan 17), (SubPlan 18), (SubPlan 19))), (COALESCE((SubPlan 20), (SubPlan 21))), (COALESCE((SubPlan 22), (SubPlan 23))), ((SubPlan 24)), task.create_, task.procinst_, ((SubPlan 25)), ((SubPlan 26)), (COALESCE((SubPlan 27), false)), ((SubPlan 28)), (((SubPlan 29))::text)
  • Sort Key: task.create_ DESC, task.id_, task.name_, task.description_, task.actorid_, (CASE WHEN ((task.name_)::text = 'manual-task'::text) THEN 'person'::text ELSE 'system'::text END), ((SubPlan 1)), (COALESCE((SubPlan 2), (CASE WHEN (((task.name_)::text = 'customerServiceSwimlaneAssignment'::text) OR ((task.name_)::text = 'referralHoldTask'::text) OR ((task.name_)::text = 'processReferralOnHold'::text)) THEN 'ClinAssistCustomerService'::text WHEN (((task.name_)::text = 'processNewReferral'::text) OR ((task.name_)::text = 'intakeSwimlaneAssignment'::text)) THEN 'ClinAssistAdmin'::text ELSE NULL::text END)::character varying)), task.duedate_, ((task.duedate_)::date), (to_char(task.duedate_, 'HH12:MI:SS AM'::text)), task.start_, task.end_, task.priority_, (CASE WHEN ((('now'::cstring)::date > task.duedate_) AND (task.end_ IS NULL)) THEN true ELSE false END), (CASE WHEN task.issuspended_ THEN 'Suspended'::text WHEN task.iscancelled_ THEN 'Cancelled'::text WHEN (task.end_ IS NOT NULL) THEN 'Ended'::text WHEN (task.start_ IS NOT NULL) THEN 'Started'::text ELSE 'Not Started'::text END), (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END), (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN 'newReferralId'::text WHEN (xref.claim_id IS NOT NULL) THEN 'claimId'::text WHEN (xref.stay_id IS NOT NULL) THEN 'stayId'::text WHEN (xref.patient_id IS NOT NULL) THEN 'patientId'::text ELSE NULL::text END), (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN xref.new_referral_id WHEN (xref.claim_id IS NOT NULL) THEN xref.claim_id WHEN (xref.stay_id IS NOT NULL) THEN xref.stay_id WHEN (xref.patient_id IS NOT NULL) THEN xref.patient_id ELSE NULL::integer END), (COALESCE((SubPlan 3), (SubPlan 4), (SubPlan 5), COALESCE((SubPlan 6), (SubPlan 7)))), (COALESCE((SubPlan 8), (SubPlan 9), (SubPlan 10), (SubPlan 11), (SubPlan 12))), (COALESCE((SubPlan 13), ((SubPlan 14))::text, ((SubPlan 15))::text, ((SubPlan 16))::text)), (COALESCE((SubPlan 17), (SubPlan 18), (SubPlan 19))), (COALESCE((SubPlan 20), (SubPlan 21))), (COALESCE((SubPlan 22), (SubPlan 23))), ((SubPlan 24)), task.procinst_, ((SubPlan 25)), ((SubPlan 26)), (COALESCE((SubPlan 27), false)), ((SubPlan 28)), (((SubPlan 29))::text)
6. 0.000 0.000 ↓ 0.0 0

Gather (cost=36,982.41..2,173,407.29 rows=5,175 width=727) (never executed)

  • Output: task.id_, task.name_, task.description_, task.actorid_, CASE WHEN ((task.name_)::text = 'manual-task'::text) THEN 'person'::text ELSE 'system'::text END, (SubPlan 1), COALESCE((SubPlan 2), (CASE WHEN (((task.name_)::text = 'customerServiceSwimlaneAssignment'::text) OR ((task.name_)::text = 'referralHoldTask'::text) OR ((task.name_)::text = 'processReferralOnHold'::text)) THEN 'ClinAssistCustomerService'::text WHEN (((task.name_)::text = 'processNewReferral'::text) OR ((task.name_)::text = 'intakeSwimlaneAssignment'::text)) THEN 'ClinAssistAdmin'::text ELSE NULL::text END)::character varying), task.duedate_, (task.duedate_)::date, to_char(task.duedate_, 'HH12:MI:SS AM'::text), task.start_, task.end_, task.priority_, CASE WHEN ((('now'::cstring)::date > task.duedate_) AND (task.end_ IS NULL)) THEN true ELSE false END, CASE WHEN task.issuspended_ THEN 'Suspended'::text WHEN task.iscancelled_ THEN 'Cancelled'::text WHEN (task.end_ IS NOT NULL) THEN 'Ended'::text WHEN (task.start_ IS NOT NULL) THEN 'Started'::text ELSE 'Not Started'::text END, CASE WHEN (xref.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END, CASE WHEN (xref.new_referral_id IS NOT NULL) THEN 'newReferralId'::text WHEN (xref.claim_id IS NOT NULL) THEN 'claimId'::text WHEN (xref.stay_id IS NOT NULL) THEN 'stayId'::text WHEN (xref.patient_id IS NOT NULL) THEN 'patientId'::text ELSE NULL::text END, CASE WHEN (xref.new_referral_id IS NOT NULL) THEN xref.new_referral_id WHEN (xref.claim_id IS NOT NULL) THEN xref.claim_id WHEN (xref.stay_id IS NOT NULL) THEN xref.stay_id WHEN (xref.patient_id IS NOT NULL) THEN xref.patient_id ELSE NULL::integer END, COALESCE((SubPlan 3), (SubPlan 4), (SubPlan 5), COALESCE((SubPlan 6), (SubPlan 7))), COALESCE((SubPlan 8), (SubPlan 9), (SubPlan 10), (SubPlan 11), (SubPlan 12)), COALESCE((SubPlan 13), ((SubPlan 14))::text, ((SubPlan 15))::text, ((SubPlan 16))::text), COALESCE((SubPlan 17), (SubPlan 18), (SubPlan 19)), COALESCE((SubPlan 20), (SubPlan 21)), COALESCE((SubPlan 22), (SubPlan 23)), (SubPlan 24), task.create_, task.procinst_, (SubPlan 25), (SubPlan 26), COALESCE((SubPlan 27), false), (SubPlan 28), ((SubPlan 29))::text
  • Workers Planned: 2
  • Workers Launched: 0
7. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=35,982.41..107,332.96 rows=2,156 width=157) (never executed)

  • Output: task.id_, task.name_, task.description_, task.actorid_, task.duedate_, task.start_, task.end_, task.priority_, task.issuspended_, task.iscancelled_, task.token_, task.create_, task.procinst_, xref.new_referral_id, xref.claim_id, xref.stay_id, xref.patient_id
  • Hash Cond: (task.id_ = xref.task_id)
  • Filter: (CASE WHEN (xref.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END = 'Claim'::text)
8. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on jbpm.jbpm_taskinstance task (cost=0.00..37,571.35 rows=431,261 width=141) (never executed)

  • Output: task.id_, task.name_, task.description_, task.actorid_, task.duedate_, task.start_, task.end_, task.priority_, task.issuspended_, task.iscancelled_, task.token_, task.create_, task.procinst_
  • Filter: (((task.name_)::text <> 'New Secure Message'::text) AND ((task.name_)::text <> 'Process ClinAssist Referral'::text))
9. 0.000 0.000 ↓ 0.0 0

Hash (cost=17,251.96..17,251.96 rows=1,020,196 width=24) (never executed)

  • Output: xref.new_referral_id, xref.claim_id, xref.stay_id, xref.patient_id, xref.task_id
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.task_entity_xref xref (cost=0.00..17,251.96 rows=1,020,196 width=24) (never executed)

  • Output: xref.new_referral_id, xref.claim_id, xref.stay_id, xref.patient_id, xref.task_id
11.          

SubPlan (forGather)

12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..16.74 rows=1 width=32) (never executed)

  • Output: (((contact.first_name)::text || ' '::text) || (contact.last_name)::text)
  • Inner Unique: true
13. 0.000 0.000 ↓ 0.0 0

Index Scan using email_config_email_address_idx on public.email_config email (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Output: email.id, email.contact_id, email.email_address, email.send_notifications
  • Index Cond: ((email.email_address)::text = (task.actorid_)::text)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact (cost=0.42..8.44 rows=1 width=20) (never executed)

  • Output: contact.id, contact.prefix, contact.first_name, contact.last_name, contact.postfix, contact.generic_name, contact.password, contact.html_mail, contact.registration_key, contact.note, contact.contact_type_id, contact.company_id, contact.address_id, contact.not_allowed_to_login, contact.role, contact.dont_send_referral_confirmation, contact.enable_company_wide_referral_view, contact.change_password_next_login, contact.last_password_change, contact.temporary_password_created, contact.last_login, contact.clatrackingsheetextendeddatatablestate, contact.mytasksextendeddatatablestate, contact.referrallistextendeddatatablestate, contact.teamtasksextendeddatatablestate, contact.unassignedtasksextendeddatatablestate, contact.loginfailurecount, contact.lastloginfailuredate, contact.useragent, contact.ipaddress, contact.entitytasksextendeddatatablestate, contact.lineitemextendeddatatablestate, contact.active, contact.setinactiveby, contact.setinactivedate, contact.createdby, contact.createddate, contact.lastupdatedby, contact.updateddate, contact.clientportalclaimextendeddatatablestate, contact.provider_id, contact.closedreferrallistextendeddatatablestate, contact.middle_initial
  • Index Cond: (contact.id = email.contact_id)
15. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..17.84 rows=1 width=20) (never executed)

  • Output: pooledactor.actorid_
  • Inner Unique: true
16. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..17.40 rows=1 width=28) (never executed)

  • Output: swimlaneinstance.swimlane_, pooledactor.actorid_
  • Join Filter: (taskinstance.swimlaninstance_ = pooledactor.swimlaneinstance_)
17. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..16.89 rows=1 width=24) (never executed)

  • Output: taskinstance.swimlaninstance_, swimlaneinstance.id_, swimlaneinstance.swimlane_
  • Inner Unique: true
18. 0.000 0.000 ↓ 0.0 0

Index Scan using jbpm_taskinstance_pkey on jbpm.jbpm_taskinstance taskinstance (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Output: taskinstance.id_, taskinstance.class_, taskinstance.version_, taskinstance.name_, taskinstance.description_, taskinstance.actorid_, taskinstance.create_, taskinstance.start_, taskinstance.end_, taskinstance.duedate_, taskinstance.priority_, taskinstance.iscancelled_, taskinstance.issuspended_, taskinstance.isopen_, taskinstance.issignalling_, taskinstance.isblocking_, taskinstance.task_, taskinstance.token_, taskinstance.procinst_, taskinstance.swimlaninstance_, taskinstance.taskmgmtinstance_
  • Index Cond: (taskinstance.id_ = task.id_)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using jbpm_swimlaneinstance_pkey on jbpm.jbpm_swimlaneinstance swimlaneinstance (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Output: swimlaneinstance.id_, swimlaneinstance.version_, swimlaneinstance.name_, swimlaneinstance.actorid_, swimlaneinstance.swimlane_, swimlaneinstance.taskmgmtinstance_
  • Index Cond: (swimlaneinstance.id_ = taskinstance.swimlaninstance_)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_tskinst_swlane on jbpm.jbpm_pooledactor pooledactor (cost=0.42..0.50 rows=1 width=28) (never executed)

  • Output: pooledactor.id_, pooledactor.version_, pooledactor.actorid_, pooledactor.swimlaneinstance_
  • Index Cond: (pooledactor.swimlaneinstance_ = swimlaneinstance.id_)
21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using jbpm_swimlane_pkey on jbpm.jbpm_swimlane swimlane (cost=0.42..0.44 rows=1 width=8) (never executed)

  • Output: swimlane.id_
  • Index Cond: (swimlane.id_ = swimlaneinstance.swimlane_)
  • Heap Fetches: 0
22. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.75 rows=1 width=32) (never executed)

  • Output: (((contact_1.last_name)::text || ', '::text) || (contact_1.first_name)::text)
  • Inner Unique: true
23. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: patient.id, patient.contact_id, patient.gender, patient.birth_date, patient.client_file_id, patient.parental_relationship, patient.condition, patient.gestational_age, patient.estimated_length_of_stay, patient.ignore, patient.birth_weight, patient.race, patient.apgar_1, patient.apgar_2, patient.apgar_3, patient.apgar_4, patient.patient_id, patient.payer_patient_id
  • Index Cond: (patient.id = xref.patient_id)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact contact_1 (cost=0.42..8.44 rows=1 width=20) (never executed)

  • Output: contact_1.id, contact_1.prefix, contact_1.first_name, contact_1.last_name, contact_1.postfix, contact_1.generic_name, contact_1.password, contact_1.html_mail, contact_1.registration_key, contact_1.note, contact_1.contact_type_id, contact_1.company_id, contact_1.address_id, contact_1.not_allowed_to_login, contact_1.role, contact_1.dont_send_referral_confirmation, contact_1.enable_company_wide_referral_view, contact_1.change_password_next_login, contact_1.last_password_change, contact_1.temporary_password_created, contact_1.last_login, contact_1.clatrackingsheetextendeddatatablestate, contact_1.mytasksextendeddatatablestate, contact_1.referrallistextendeddatatablestate, contact_1.teamtasksextendeddatatablestate, contact_1.unassignedtasksextendeddatatablestate, contact_1.loginfailurecount, contact_1.lastloginfailuredate, contact_1.useragent, contact_1.ipaddress, contact_1.entitytasksextendeddatatablestate, contact_1.lineitemextendeddatatablestate, contact_1.active, contact_1.setinactiveby, contact_1.setinactivedate, contact_1.createdby, contact_1.createddate, contact_1.lastupdatedby, contact_1.updateddate, contact_1.clientportalclaimextendeddatatablestate, contact_1.provider_id, contact_1.closedreferrallistextendeddatatablestate, contact_1.middle_initial
  • Index Cond: (contact_1.id = patient.contact_id)
25. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.00..17.72 rows=1 width=32) (never executed)

  • Output: (((contact_2.last_name)::text || ', '::text) || (contact_2.first_name)::text)
  • Inner Unique: true
26. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: patient_1.contact_id
  • Inner Unique: true
27. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay.id, stay.admitted, stay.discharged, stay.medical_record, stay.facility_id, stay.patient_id, stay.in_network, stay.network, stay.control_number, stay.discount, stay.estimated_resolution_date, stay.closed, stay.close_reason_note, stay.close_reason, stay.status, stay.opened, stay.drg_code, stay.drg_threshold, stay.next_com, stay.drg_outlier_multiplier, stay.drg_cap_addon, stay.retainer, stay.retainer_comment, stay.care_to_clin_conversion_date, stay.drg_client_exceptions, stay.standard_drg, stay.drg_contractual_rate, stay.drg_cost_to_charge_ratio, stay.drg_extra_allowance, stay.drg_special_multiplier, stay.apply_client_exceptions, stay.referral_id, stay.networkstatus
  • Index Cond: (stay.id = xref.stay_id)
28. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_1 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: patient_1.id, patient_1.contact_id, patient_1.gender, patient_1.birth_date, patient_1.client_file_id, patient_1.parental_relationship, patient_1.condition, patient_1.gestational_age, patient_1.estimated_length_of_stay, patient_1.ignore, patient_1.birth_weight, patient_1.race, patient_1.apgar_1, patient_1.apgar_2, patient_1.apgar_3, patient_1.apgar_4, patient_1.patient_id, patient_1.payer_patient_id
  • Index Cond: (patient_1.id = stay.patient_id)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact contact_2 (cost=0.42..1.09 rows=1 width=20) (never executed)

  • Output: contact_2.id, contact_2.prefix, contact_2.first_name, contact_2.last_name, contact_2.postfix, contact_2.generic_name, contact_2.password, contact_2.html_mail, contact_2.registration_key, contact_2.note, contact_2.contact_type_id, contact_2.company_id, contact_2.address_id, contact_2.not_allowed_to_login, contact_2.role, contact_2.dont_send_referral_confirmation, contact_2.enable_company_wide_referral_view, contact_2.change_password_next_login, contact_2.last_password_change, contact_2.temporary_password_created, contact_2.last_login, contact_2.clatrackingsheetextendeddatatablestate, contact_2.mytasksextendeddatatablestate, contact_2.referrallistextendeddatatablestate, contact_2.teamtasksextendeddatatablestate, contact_2.unassignedtasksextendeddatatablestate, contact_2.loginfailurecount, contact_2.lastloginfailuredate, contact_2.useragent, contact_2.ipaddress, contact_2.entitytasksextendeddatatablestate, contact_2.lineitemextendeddatatablestate, contact_2.active, contact_2.setinactiveby, contact_2.setinactivedate, contact_2.createdby, contact_2.createddate, contact_2.lastupdatedby, contact_2.updateddate, contact_2.clientportalclaimextendeddatatablestate, contact_2.provider_id, contact_2.closedreferrallistextendeddatatablestate, contact_2.middle_initial
  • Index Cond: (contact_2.id = patient_1.contact_id)
30. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.29..18.07 rows=1 width=32) (never executed)

  • Output: (((contact_3.last_name)::text || ', '::text) || (contact_3.first_name)::text)
  • Inner Unique: true
31. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.97 rows=1 width=4) (never executed)

  • Output: patient_2.contact_id
  • Inner Unique: true
32. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: stay_1.patient_id
  • Inner Unique: true
33. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim.id, claim.intake, claim.service_start, claim.service_end, claim.total, claim.stay_id, claim.close_reason_note, claim.close_reason, claim.status, claim.claim_type, claim.closed, claim.prescreen_sent, claim.conversion_date, claim.forensic_sent, claim.documentation_received, claim.documentation_required, claim.appeal_received, claim.appeal_response_sent, claim.control_number, claim.hold_start_date, claim.prescreen_due, claim.forensic_due, claim.appeal_due, claim.appeal_response_due, claim.hold_reason_note, claim.hold_reason, claim.prescreen_na, claim.forensic_na, claim.initial_contact, claim.package_create, claim.package_to_facility, claim.fee_percentage, claim.pre_review_claim_payable, claim.payer_patient_id, claim.flexfield1name, claim.flexfield2name, claim.flexfield1value, claim.flexfield2value, claim.medicalrecordsstatus, claim.paymentstatus, claim.claimdatasource, claim.claimpaymenttype_id, claim.dummydatadateofreportgeneration, claim.primarycostdriver, claim.primarycostdriveramount, claim.clientadjustments, claim.adjustedbalancedue, claim.tagbranding, claim.prescreenerrorspreliminarysavingsoverride, claim.prescreeninconsistenciespreliminarysavingsoverride, claim.includesummaryofadjustedrevcodes, claim.estimated_billing_date, claim.isclinlight, claim.med_recs_received, claim.isrush, claim.cvtyapprovedamount, claim.client_contract_date, claim.eop_received_date, claim.trialclaim, claim.timeline_hold_dur, claim.itemized_recvd_date, claim.itemizeddiscrepancy, claim.response_sent, claim.channel, claim.potential_duplicate, claim.internal_rush, claim.corrected, claim.inactive, claim.no_billing
  • Index Cond: (claim.id = xref.claim_id)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_1 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: stay_1.id, stay_1.admitted, stay_1.discharged, stay_1.medical_record, stay_1.facility_id, stay_1.patient_id, stay_1.in_network, stay_1.network, stay_1.control_number, stay_1.discount, stay_1.estimated_resolution_date, stay_1.closed, stay_1.close_reason_note, stay_1.close_reason, stay_1.status, stay_1.opened, stay_1.drg_code, stay_1.drg_threshold, stay_1.next_com, stay_1.drg_outlier_multiplier, stay_1.drg_cap_addon, stay_1.retainer, stay_1.retainer_comment, stay_1.care_to_clin_conversion_date, stay_1.drg_client_exceptions, stay_1.standard_drg, stay_1.drg_contractual_rate, stay_1.drg_cost_to_charge_ratio, stay_1.drg_extra_allowance, stay_1.drg_special_multiplier, stay_1.apply_client_exceptions, stay_1.referral_id, stay_1.networkstatus
  • Index Cond: (stay_1.id = claim.stay_id)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_2 (cost=0.29..0.35 rows=1 width=8) (never executed)

  • Output: patient_2.id, patient_2.contact_id, patient_2.gender, patient_2.birth_date, patient_2.client_file_id, patient_2.parental_relationship, patient_2.condition, patient_2.gestational_age, patient_2.estimated_length_of_stay, patient_2.ignore, patient_2.birth_weight, patient_2.race, patient_2.apgar_1, patient_2.apgar_2, patient_2.apgar_3, patient_2.apgar_4, patient_2.patient_id, patient_2.payer_patient_id
  • Index Cond: (patient_2.id = stay_1.patient_id)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact contact_3 (cost=0.42..1.09 rows=1 width=20) (never executed)

  • Output: contact_3.id, contact_3.prefix, contact_3.first_name, contact_3.last_name, contact_3.postfix, contact_3.generic_name, contact_3.password, contact_3.html_mail, contact_3.registration_key, contact_3.note, contact_3.contact_type_id, contact_3.company_id, contact_3.address_id, contact_3.not_allowed_to_login, contact_3.role, contact_3.dont_send_referral_confirmation, contact_3.enable_company_wide_referral_view, contact_3.change_password_next_login, contact_3.last_password_change, contact_3.temporary_password_created, contact_3.last_login, contact_3.clatrackingsheetextendeddatatablestate, contact_3.mytasksextendeddatatablestate, contact_3.referrallistextendeddatatablestate, contact_3.teamtasksextendeddatatablestate, contact_3.unassignedtasksextendeddatatablestate, contact_3.loginfailurecount, contact_3.lastloginfailuredate, contact_3.useragent, contact_3.ipaddress, contact_3.entitytasksextendeddatatablestate, contact_3.lineitemextendeddatatablestate, contact_3.active, contact_3.setinactiveby, contact_3.setinactivedate, contact_3.createdby, contact_3.createddate, contact_3.lastupdatedby, contact_3.updateddate, contact_3.clientportalclaimextendeddatatablestate, contact_3.provider_id, contact_3.closedreferrallistextendeddatatablestate, contact_3.middle_initial
  • Index Cond: (contact_3.id = patient_2.contact_id)
37. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.29..18.06 rows=1 width=32) (never executed)

  • Output: (((contact_4.last_name)::text || ', '::text) || (contact_4.first_name)::text)
  • Inner Unique: true
38. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.97 rows=1 width=4) (never executed)

  • Output: patient_3.contact_id
  • Inner Unique: true
39. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: pendingpatient.preexistingcontactmatchid
  • Inner Unique: true
40. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral.referraltype, referral.id, referral.version, referral.comments, referral.trial, referral.conditioncategory, referral.createddate, referral.policyholder, referral.gestation, referral.referralcontact_id, referral.pendingpatient_id, referral.pendingclaim_id, referral.provider_id, referral.invoicecompany_id, referral.referringcompany_id, referral.clientfile_id, referral.originator_id, referral.onbehalfofcompany_id, referral.gestationweeks, referral.gestationdays, referral.babieslastname, referral.birthfacilityisdifferentfromprovider, referral.birthfacility_id, referral.invoicecomments, referral.companyiwanttoaffiliatedoesnotexist, referral.nonexistentaffiliatecompanyname, referral.internalsubmitter_id
  • Index Cond: (xref.new_referral_id = referral.id)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using pendingpatient_pkey on public.pendingpatient (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: pendingpatient.id, pendingpatient.version, pendingpatient.firstname, pendingpatient.lastname, pendingpatient.dateofbirth, pendingpatient.gender, pendingpatient.createddate, pendingpatient.payerpatientid, pendingpatient.preexistingcontactmatchfound, pendingpatient.preexistingcontactmatchid, pendingpatient.flexfield1name, pendingpatient.flexfield2name, pendingpatient.flexfield1value, pendingpatient.flexfield2value, pendingpatient.gestationweeks, pendingpatient.gestationdays, pendingpatient.birthweight, pendingpatient.patienttype, pendingpatient.diagnosiscode
  • Index Cond: (pendingpatient.id = referral.pendingpatient_id)
42. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_3 (cost=0.29..0.35 rows=1 width=8) (never executed)

  • Output: patient_3.id, patient_3.contact_id, patient_3.gender, patient_3.birth_date, patient_3.client_file_id, patient_3.parental_relationship, patient_3.condition, patient_3.gestational_age, patient_3.estimated_length_of_stay, patient_3.ignore, patient_3.birth_weight, patient_3.race, patient_3.apgar_1, patient_3.apgar_2, patient_3.apgar_3, patient_3.apgar_4, patient_3.patient_id, patient_3.payer_patient_id
  • Index Cond: (patient_3.id = pendingpatient.preexistingcontactmatchid)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact contact_4 (cost=0.42..1.09 rows=1 width=20) (never executed)

  • Output: contact_4.id, contact_4.prefix, contact_4.first_name, contact_4.last_name, contact_4.postfix, contact_4.generic_name, contact_4.password, contact_4.html_mail, contact_4.registration_key, contact_4.note, contact_4.contact_type_id, contact_4.company_id, contact_4.address_id, contact_4.not_allowed_to_login, contact_4.role, contact_4.dont_send_referral_confirmation, contact_4.enable_company_wide_referral_view, contact_4.change_password_next_login, contact_4.last_password_change, contact_4.temporary_password_created, contact_4.last_login, contact_4.clatrackingsheetextendeddatatablestate, contact_4.mytasksextendeddatatablestate, contact_4.referrallistextendeddatatablestate, contact_4.teamtasksextendeddatatablestate, contact_4.unassignedtasksextendeddatatablestate, contact_4.loginfailurecount, contact_4.lastloginfailuredate, contact_4.useragent, contact_4.ipaddress, contact_4.entitytasksextendeddatatablestate, contact_4.lineitemextendeddatatablestate, contact_4.active, contact_4.setinactiveby, contact_4.setinactivedate, contact_4.createdby, contact_4.createddate, contact_4.lastupdatedby, contact_4.updateddate, contact_4.clientportalclaimextendeddatatablestate, contact_4.provider_id, contact_4.closedreferrallistextendeddatatablestate, contact_4.middle_initial
  • Index Cond: (contact_4.id = patient_3.contact_id)
44. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.63 rows=1 width=32) (never executed)

  • Output: (((pendingpatient_1.lastname)::text || ', '::text) || (pendingpatient_1.firstname)::text)
  • Inner Unique: true
45. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_1 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral_1.referraltype, referral_1.id, referral_1.version, referral_1.comments, referral_1.trial, referral_1.conditioncategory, referral_1.createddate, referral_1.policyholder, referral_1.gestation, referral_1.referralcontact_id, referral_1.pendingpatient_id, referral_1.pendingclaim_id, referral_1.provider_id, referral_1.invoicecompany_id, referral_1.referringcompany_id, referral_1.clientfile_id, referral_1.originator_id, referral_1.onbehalfofcompany_id, referral_1.gestationweeks, referral_1.gestationdays, referral_1.babieslastname, referral_1.birthfacilityisdifferentfromprovider, referral_1.birthfacility_id, referral_1.invoicecomments, referral_1.companyiwanttoaffiliatedoesnotexist, referral_1.nonexistentaffiliatecompanyname, referral_1.internalsubmitter_id
  • Index Cond: (xref.new_referral_id = referral_1.id)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using pendingpatient_pkey on public.pendingpatient pendingpatient_1 (cost=0.29..8.31 rows=1 width=18) (never executed)

  • Output: pendingpatient_1.id, pendingpatient_1.version, pendingpatient_1.firstname, pendingpatient_1.lastname, pendingpatient_1.dateofbirth, pendingpatient_1.gender, pendingpatient_1.createddate, pendingpatient_1.payerpatientid, pendingpatient_1.preexistingcontactmatchfound, pendingpatient_1.preexistingcontactmatchid, pendingpatient_1.flexfield1name, pendingpatient_1.flexfield2name, pendingpatient_1.flexfield1value, pendingpatient_1.flexfield2value, pendingpatient_1.gestationweeks, pendingpatient_1.gestationdays, pendingpatient_1.birthweight, pendingpatient_1.patienttype, pendingpatient_1.diagnosiscode
  • Index Cond: (pendingpatient_1.id = referral_1.pendingpatient_id)
47. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.62 rows=1 width=23) (never executed)

  • Output: company.name
  • Inner Unique: true
48. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_2 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral_2.referraltype, referral_2.id, referral_2.version, referral_2.comments, referral_2.trial, referral_2.conditioncategory, referral_2.createddate, referral_2.policyholder, referral_2.gestation, referral_2.referralcontact_id, referral_2.pendingpatient_id, referral_2.pendingclaim_id, referral_2.provider_id, referral_2.invoicecompany_id, referral_2.referringcompany_id, referral_2.clientfile_id, referral_2.originator_id, referral_2.onbehalfofcompany_id, referral_2.gestationweeks, referral_2.gestationdays, referral_2.babieslastname, referral_2.birthfacilityisdifferentfromprovider, referral_2.birthfacility_id, referral_2.invoicecomments, referral_2.companyiwanttoaffiliatedoesnotexist, referral_2.nonexistentaffiliatecompanyname, referral_2.internalsubmitter_id
  • Index Cond: (referral_2.id = xref.new_referral_id)
49. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company (cost=0.28..8.29 rows=1 width=27) (never executed)

  • Output: company.id, company.name, company.alias, company.email_domain, company.location, company.mail, company.default_referral_id, company.drg_threshold, company.drg_outlier_multiplier, company.ub92_report, company.deferred_company_id, company.clinassist, company.careassist_neonatal, company.careassist_pediatric, company.careassist_maternal, company.comments, company.exclude_clinassist_information_ps, company.include_clinassist_information_fr, company.include_facility_address_ps, company.include_facility_address_fr, company.show_amount_paid_fr, company.prescreen_report, company.exhibit_a_report, company.company_type, company.covered_lives, company.average_book_premium, company.flex_field_one_name, company.flex_field_two_name, company.createddate, company.onshore_data_entry_required, company.company_key, company.tax_id, company.client_submitter_id, company.use_2fa, company.incoming_837_name, company.default_workflow_pod_id, company.iz_required_to_start_workflow, company.report_publish_required_for_referral_channel, company.report_publish_required_for_edi_channel, company.disable_new_claim_processing
  • Index Cond: (company.id = referral_2.onbehalfofcompany_id)
50. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.62 rows=1 width=23) (never executed)

  • Output: company_1.name
  • Inner Unique: true
51. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_3 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral_3.referraltype, referral_3.id, referral_3.version, referral_3.comments, referral_3.trial, referral_3.conditioncategory, referral_3.createddate, referral_3.policyholder, referral_3.gestation, referral_3.referralcontact_id, referral_3.pendingpatient_id, referral_3.pendingclaim_id, referral_3.provider_id, referral_3.invoicecompany_id, referral_3.referringcompany_id, referral_3.clientfile_id, referral_3.originator_id, referral_3.onbehalfofcompany_id, referral_3.gestationweeks, referral_3.gestationdays, referral_3.babieslastname, referral_3.birthfacilityisdifferentfromprovider, referral_3.birthfacility_id, referral_3.invoicecomments, referral_3.companyiwanttoaffiliatedoesnotexist, referral_3.nonexistentaffiliatecompanyname, referral_3.internalsubmitter_id
  • Index Cond: (referral_3.id = xref.new_referral_id)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company company_1 (cost=0.28..8.29 rows=1 width=27) (never executed)

  • Output: company_1.id, company_1.name, company_1.alias, company_1.email_domain, company_1.location, company_1.mail, company_1.default_referral_id, company_1.drg_threshold, company_1.drg_outlier_multiplier, company_1.ub92_report, company_1.deferred_company_id, company_1.clinassist, company_1.careassist_neonatal, company_1.careassist_pediatric, company_1.careassist_maternal, company_1.comments, company_1.exclude_clinassist_information_ps, company_1.include_clinassist_information_fr, company_1.include_facility_address_ps, company_1.include_facility_address_fr, company_1.show_amount_paid_fr, company_1.prescreen_report, company_1.exhibit_a_report, company_1.company_type, company_1.covered_lives, company_1.average_book_premium, company_1.flex_field_one_name, company_1.flex_field_two_name, company_1.createddate, company_1.onshore_data_entry_required, company_1.company_key, company_1.tax_id, company_1.client_submitter_id, company_1.use_2fa, company_1.incoming_837_name, company_1.default_workflow_pod_id, company_1.iz_required_to_start_workflow, company_1.report_publish_required_for_referral_channel, company_1.report_publish_required_for_edi_channel, company_1.disable_new_claim_processing
  • Index Cond: (company_1.id = referral_3.referringcompany_id)
53. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..16.92 rows=1 width=23) (never executed)

  • Output: company_2.name
  • Inner Unique: true
54. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: clientfile.client_id
  • Inner Unique: true
55. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_4 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: patient_4.id, patient_4.contact_id, patient_4.gender, patient_4.birth_date, patient_4.client_file_id, patient_4.parental_relationship, patient_4.condition, patient_4.gestational_age, patient_4.estimated_length_of_stay, patient_4.ignore, patient_4.birth_weight, patient_4.race, patient_4.apgar_1, patient_4.apgar_2, patient_4.apgar_3, patient_4.apgar_4, patient_4.patient_id, patient_4.payer_patient_id
  • Index Cond: (patient_4.id = xref.patient_id)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using client_file_pkey on public.client_file clientfile (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: clientfile.id, clientfile.manage_care, clientfile.audit_claim, clientfile.client_id, clientfile.referral_id, clientfile.insured_employer, clientfile.insured_relationship, clientfile.created, clientfile.payer, clientfile.client_name_override
  • Index Cond: (clientfile.id = patient_4.client_file_id)
57. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company company_2 (cost=0.28..0.30 rows=1 width=27) (never executed)

  • Output: company_2.id, company_2.name, company_2.alias, company_2.email_domain, company_2.location, company_2.mail, company_2.default_referral_id, company_2.drg_threshold, company_2.drg_outlier_multiplier, company_2.ub92_report, company_2.deferred_company_id, company_2.clinassist, company_2.careassist_neonatal, company_2.careassist_pediatric, company_2.careassist_maternal, company_2.comments, company_2.exclude_clinassist_information_ps, company_2.include_clinassist_information_fr, company_2.include_facility_address_ps, company_2.include_facility_address_fr, company_2.show_amount_paid_fr, company_2.prescreen_report, company_2.exhibit_a_report, company_2.company_type, company_2.covered_lives, company_2.average_book_premium, company_2.flex_field_one_name, company_2.flex_field_two_name, company_2.createddate, company_2.onshore_data_entry_required, company_2.company_key, company_2.tax_id, company_2.client_submitter_id, company_2.use_2fa, company_2.incoming_837_name, company_2.default_workflow_pod_id, company_2.iz_required_to_start_workflow, company_2.report_publish_required_for_referral_channel, company_2.report_publish_required_for_edi_channel, company_2.disable_new_claim_processing
  • Index Cond: (company_2.id = clientfile.client_id)
58. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.28 rows=1 width=23) (never executed)

  • Output: company_3.name
  • Inner Unique: true
59. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.98 rows=1 width=4) (never executed)

  • Output: clientfile_1.client_id
  • Inner Unique: true
60. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: patient_5.client_file_id
  • Inner Unique: true
61. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_2 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_2.id, stay_2.admitted, stay_2.discharged, stay_2.medical_record, stay_2.facility_id, stay_2.patient_id, stay_2.in_network, stay_2.network, stay_2.control_number, stay_2.discount, stay_2.estimated_resolution_date, stay_2.closed, stay_2.close_reason_note, stay_2.close_reason, stay_2.status, stay_2.opened, stay_2.drg_code, stay_2.drg_threshold, stay_2.next_com, stay_2.drg_outlier_multiplier, stay_2.drg_cap_addon, stay_2.retainer, stay_2.retainer_comment, stay_2.care_to_clin_conversion_date, stay_2.drg_client_exceptions, stay_2.standard_drg, stay_2.drg_contractual_rate, stay_2.drg_cost_to_charge_ratio, stay_2.drg_extra_allowance, stay_2.drg_special_multiplier, stay_2.apply_client_exceptions, stay_2.referral_id, stay_2.networkstatus
  • Index Cond: (stay_2.id = xref.stay_id)
62. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_5 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: patient_5.id, patient_5.contact_id, patient_5.gender, patient_5.birth_date, patient_5.client_file_id, patient_5.parental_relationship, patient_5.condition, patient_5.gestational_age, patient_5.estimated_length_of_stay, patient_5.ignore, patient_5.birth_weight, patient_5.race, patient_5.apgar_1, patient_5.apgar_2, patient_5.apgar_3, patient_5.apgar_4, patient_5.patient_id, patient_5.payer_patient_id
  • Index Cond: (patient_5.id = stay_2.patient_id)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using client_file_pkey on public.client_file clientfile_1 (cost=0.29..0.36 rows=1 width=8) (never executed)

  • Output: clientfile_1.id, clientfile_1.manage_care, clientfile_1.audit_claim, clientfile_1.client_id, clientfile_1.referral_id, clientfile_1.insured_employer, clientfile_1.insured_relationship, clientfile_1.created, clientfile_1.payer, clientfile_1.client_name_override
  • Index Cond: (clientfile_1.id = patient_5.client_file_id)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company company_3 (cost=0.28..0.30 rows=1 width=27) (never executed)

  • Output: company_3.id, company_3.name, company_3.alias, company_3.email_domain, company_3.location, company_3.mail, company_3.default_referral_id, company_3.drg_threshold, company_3.drg_outlier_multiplier, company_3.ub92_report, company_3.deferred_company_id, company_3.clinassist, company_3.careassist_neonatal, company_3.careassist_pediatric, company_3.careassist_maternal, company_3.comments, company_3.exclude_clinassist_information_ps, company_3.include_clinassist_information_fr, company_3.include_facility_address_ps, company_3.include_facility_address_fr, company_3.show_amount_paid_fr, company_3.prescreen_report, company_3.exhibit_a_report, company_3.company_type, company_3.covered_lives, company_3.average_book_premium, company_3.flex_field_one_name, company_3.flex_field_two_name, company_3.createddate, company_3.onshore_data_entry_required, company_3.company_key, company_3.tax_id, company_3.client_submitter_id, company_3.use_2fa, company_3.incoming_837_name, company_3.default_workflow_pod_id, company_3.iz_required_to_start_workflow, company_3.report_publish_required_for_referral_channel, company_3.report_publish_required_for_edi_channel, company_3.disable_new_claim_processing
  • Index Cond: (company_3.id = clientfile_1.client_id)
65. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.45..17.63 rows=1 width=23) (never executed)

  • Output: company_4.name
  • Inner Unique: true
66. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.17..17.33 rows=1 width=4) (never executed)

  • Output: clientfile_2.client_id
  • Inner Unique: true
67. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.97 rows=1 width=4) (never executed)

  • Output: patient_6.client_file_id
  • Inner Unique: true
68. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: stay_3.patient_id
  • Inner Unique: true
69. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_1 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_1.id, claim_1.intake, claim_1.service_start, claim_1.service_end, claim_1.total, claim_1.stay_id, claim_1.close_reason_note, claim_1.close_reason, claim_1.status, claim_1.claim_type, claim_1.closed, claim_1.prescreen_sent, claim_1.conversion_date, claim_1.forensic_sent, claim_1.documentation_received, claim_1.documentation_required, claim_1.appeal_received, claim_1.appeal_response_sent, claim_1.control_number, claim_1.hold_start_date, claim_1.prescreen_due, claim_1.forensic_due, claim_1.appeal_due, claim_1.appeal_response_due, claim_1.hold_reason_note, claim_1.hold_reason, claim_1.prescreen_na, claim_1.forensic_na, claim_1.initial_contact, claim_1.package_create, claim_1.package_to_facility, claim_1.fee_percentage, claim_1.pre_review_claim_payable, claim_1.payer_patient_id, claim_1.flexfield1name, claim_1.flexfield2name, claim_1.flexfield1value, claim_1.flexfield2value, claim_1.medicalrecordsstatus, claim_1.paymentstatus, claim_1.claimdatasource, claim_1.claimpaymenttype_id, claim_1.dummydatadateofreportgeneration, claim_1.primarycostdriver, claim_1.primarycostdriveramount, claim_1.clientadjustments, claim_1.adjustedbalancedue, claim_1.tagbranding, claim_1.prescreenerrorspreliminarysavingsoverride, claim_1.prescreeninconsistenciespreliminarysavingsoverride, claim_1.includesummaryofadjustedrevcodes, claim_1.estimated_billing_date, claim_1.isclinlight, claim_1.med_recs_received, claim_1.isrush, claim_1.cvtyapprovedamount, claim_1.client_contract_date, claim_1.eop_received_date, claim_1.trialclaim, claim_1.timeline_hold_dur, claim_1.itemized_recvd_date, claim_1.itemizeddiscrepancy, claim_1.response_sent, claim_1.channel, claim_1.potential_duplicate, claim_1.internal_rush, claim_1.corrected, claim_1.inactive, claim_1.no_billing
  • Index Cond: (claim_1.id = xref.claim_id)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_3 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: stay_3.id, stay_3.admitted, stay_3.discharged, stay_3.medical_record, stay_3.facility_id, stay_3.patient_id, stay_3.in_network, stay_3.network, stay_3.control_number, stay_3.discount, stay_3.estimated_resolution_date, stay_3.closed, stay_3.close_reason_note, stay_3.close_reason, stay_3.status, stay_3.opened, stay_3.drg_code, stay_3.drg_threshold, stay_3.next_com, stay_3.drg_outlier_multiplier, stay_3.drg_cap_addon, stay_3.retainer, stay_3.retainer_comment, stay_3.care_to_clin_conversion_date, stay_3.drg_client_exceptions, stay_3.standard_drg, stay_3.drg_contractual_rate, stay_3.drg_cost_to_charge_ratio, stay_3.drg_extra_allowance, stay_3.drg_special_multiplier, stay_3.apply_client_exceptions, stay_3.referral_id, stay_3.networkstatus
  • Index Cond: (stay_3.id = claim_1.stay_id)
71. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_6 (cost=0.29..0.35 rows=1 width=8) (never executed)

  • Output: patient_6.id, patient_6.contact_id, patient_6.gender, patient_6.birth_date, patient_6.client_file_id, patient_6.parental_relationship, patient_6.condition, patient_6.gestational_age, patient_6.estimated_length_of_stay, patient_6.ignore, patient_6.birth_weight, patient_6.race, patient_6.apgar_1, patient_6.apgar_2, patient_6.apgar_3, patient_6.apgar_4, patient_6.patient_id, patient_6.payer_patient_id
  • Index Cond: (patient_6.id = stay_3.patient_id)
72. 0.000 0.000 ↓ 0.0 0

Index Scan using client_file_pkey on public.client_file clientfile_2 (cost=0.29..0.36 rows=1 width=8) (never executed)

  • Output: clientfile_2.id, clientfile_2.manage_care, clientfile_2.audit_claim, clientfile_2.client_id, clientfile_2.referral_id, clientfile_2.insured_employer, clientfile_2.insured_relationship, clientfile_2.created, clientfile_2.payer, clientfile_2.client_name_override
  • Index Cond: (clientfile_2.id = patient_6.client_file_id)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company company_4 (cost=0.28..0.30 rows=1 width=27) (never executed)

  • Output: company_4.id, company_4.name, company_4.alias, company_4.email_domain, company_4.location, company_4.mail, company_4.default_referral_id, company_4.drg_threshold, company_4.drg_outlier_multiplier, company_4.ub92_report, company_4.deferred_company_id, company_4.clinassist, company_4.careassist_neonatal, company_4.careassist_pediatric, company_4.careassist_maternal, company_4.comments, company_4.exclude_clinassist_information_ps, company_4.include_clinassist_information_fr, company_4.include_facility_address_ps, company_4.include_facility_address_fr, company_4.show_amount_paid_fr, company_4.prescreen_report, company_4.exhibit_a_report, company_4.company_type, company_4.covered_lives, company_4.average_book_premium, company_4.flex_field_one_name, company_4.flex_field_two_name, company_4.createddate, company_4.onshore_data_entry_required, company_4.company_key, company_4.tax_id, company_4.client_submitter_id, company_4.use_2fa, company_4.incoming_837_name, company_4.default_workflow_pod_id, company_4.iz_required_to_start_workflow, company_4.report_publish_required_for_referral_channel, company_4.report_publish_required_for_edi_channel, company_4.disable_new_claim_processing
  • Index Cond: (company_4.id = clientfile_2.client_id)
74. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_4 (cost=0.29..8.32 rows=1 width=32) (never executed)

  • Output: CASE WHEN ((referral_4.conditioncategory)::text = 'ADULT'::text) THEN 'Adult'::text WHEN ((referral_4.conditioncategory)::text = 'MATERNAL'::text) THEN 'Maternal'::text WHEN ((referral_4.conditioncategory)::text = 'COMPLEX_NEWBORN'::text) THEN 'Neonatal'::text WHEN ((referral_4.conditioncategory)::text = 'PEDIATRIC'::text) THEN 'Pediatric'::text ELSE NULL::text END
  • Index Cond: (referral_4.id = xref.new_referral_id)
75. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.97 rows=1 width=6) (never executed)

  • Output: patient_7.condition
  • Inner Unique: true
76. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: stay_4.patient_id
  • Inner Unique: true
77. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_2 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_2.id, claim_2.intake, claim_2.service_start, claim_2.service_end, claim_2.total, claim_2.stay_id, claim_2.close_reason_note, claim_2.close_reason, claim_2.status, claim_2.claim_type, claim_2.closed, claim_2.prescreen_sent, claim_2.conversion_date, claim_2.forensic_sent, claim_2.documentation_received, claim_2.documentation_required, claim_2.appeal_received, claim_2.appeal_response_sent, claim_2.control_number, claim_2.hold_start_date, claim_2.prescreen_due, claim_2.forensic_due, claim_2.appeal_due, claim_2.appeal_response_due, claim_2.hold_reason_note, claim_2.hold_reason, claim_2.prescreen_na, claim_2.forensic_na, claim_2.initial_contact, claim_2.package_create, claim_2.package_to_facility, claim_2.fee_percentage, claim_2.pre_review_claim_payable, claim_2.payer_patient_id, claim_2.flexfield1name, claim_2.flexfield2name, claim_2.flexfield1value, claim_2.flexfield2value, claim_2.medicalrecordsstatus, claim_2.paymentstatus, claim_2.claimdatasource, claim_2.claimpaymenttype_id, claim_2.dummydatadateofreportgeneration, claim_2.primarycostdriver, claim_2.primarycostdriveramount, claim_2.clientadjustments, claim_2.adjustedbalancedue, claim_2.tagbranding, claim_2.prescreenerrorspreliminarysavingsoverride, claim_2.prescreeninconsistenciespreliminarysavingsoverride, claim_2.includesummaryofadjustedrevcodes, claim_2.estimated_billing_date, claim_2.isclinlight, claim_2.med_recs_received, claim_2.isrush, claim_2.cvtyapprovedamount, claim_2.client_contract_date, claim_2.eop_received_date, claim_2.trialclaim, claim_2.timeline_hold_dur, claim_2.itemized_recvd_date, claim_2.itemizeddiscrepancy, claim_2.response_sent, claim_2.channel, claim_2.potential_duplicate, claim_2.internal_rush, claim_2.corrected, claim_2.inactive, claim_2.no_billing
  • Index Cond: (claim_2.id = xref.claim_id)
78. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_4 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: stay_4.id, stay_4.admitted, stay_4.discharged, stay_4.medical_record, stay_4.facility_id, stay_4.patient_id, stay_4.in_network, stay_4.network, stay_4.control_number, stay_4.discount, stay_4.estimated_resolution_date, stay_4.closed, stay_4.close_reason_note, stay_4.close_reason, stay_4.status, stay_4.opened, stay_4.drg_code, stay_4.drg_threshold, stay_4.next_com, stay_4.drg_outlier_multiplier, stay_4.drg_cap_addon, stay_4.retainer, stay_4.retainer_comment, stay_4.care_to_clin_conversion_date, stay_4.drg_client_exceptions, stay_4.standard_drg, stay_4.drg_contractual_rate, stay_4.drg_cost_to_charge_ratio, stay_4.drg_extra_allowance, stay_4.drg_special_multiplier, stay_4.apply_client_exceptions, stay_4.referral_id, stay_4.networkstatus
  • Index Cond: (stay_4.id = claim_2.stay_id)
79. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_7 (cost=0.29..0.35 rows=1 width=10) (never executed)

  • Output: patient_7.id, patient_7.contact_id, patient_7.gender, patient_7.birth_date, patient_7.client_file_id, patient_7.parental_relationship, patient_7.condition, patient_7.gestational_age, patient_7.estimated_length_of_stay, patient_7.ignore, patient_7.birth_weight, patient_7.race, patient_7.apgar_1, patient_7.apgar_2, patient_7.apgar_3, patient_7.apgar_4, patient_7.patient_id, patient_7.payer_patient_id
  • Index Cond: (patient_7.id = stay_4.patient_id)
80. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=6) (never executed)

  • Output: patient_8.condition
  • Inner Unique: true
81. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_5 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_5.id, stay_5.admitted, stay_5.discharged, stay_5.medical_record, stay_5.facility_id, stay_5.patient_id, stay_5.in_network, stay_5.network, stay_5.control_number, stay_5.discount, stay_5.estimated_resolution_date, stay_5.closed, stay_5.close_reason_note, stay_5.close_reason, stay_5.status, stay_5.opened, stay_5.drg_code, stay_5.drg_threshold, stay_5.next_com, stay_5.drg_outlier_multiplier, stay_5.drg_cap_addon, stay_5.retainer, stay_5.retainer_comment, stay_5.care_to_clin_conversion_date, stay_5.drg_client_exceptions, stay_5.standard_drg, stay_5.drg_contractual_rate, stay_5.drg_cost_to_charge_ratio, stay_5.drg_extra_allowance, stay_5.drg_special_multiplier, stay_5.apply_client_exceptions, stay_5.referral_id, stay_5.networkstatus
  • Index Cond: (stay_5.id = xref.stay_id)
82. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_8 (cost=0.29..8.31 rows=1 width=10) (never executed)

  • Output: patient_8.id, patient_8.contact_id, patient_8.gender, patient_8.birth_date, patient_8.client_file_id, patient_8.parental_relationship, patient_8.condition, patient_8.gestational_age, patient_8.estimated_length_of_stay, patient_8.ignore, patient_8.birth_weight, patient_8.race, patient_8.apgar_1, patient_8.apgar_2, patient_8.apgar_3, patient_8.apgar_4, patient_8.patient_id, patient_8.payer_patient_id
  • Index Cond: (patient_8.id = stay_5.patient_id)
83. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_9 (cost=0.29..8.31 rows=1 width=6) (never executed)

  • Output: patient_9.condition
  • Index Cond: (patient_9.id = xref.patient_id)
84. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=30) (never executed)

  • Output: pendingcompany.name
  • Inner Unique: true
85. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_5 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral_5.referraltype, referral_5.id, referral_5.version, referral_5.comments, referral_5.trial, referral_5.conditioncategory, referral_5.createddate, referral_5.policyholder, referral_5.gestation, referral_5.referralcontact_id, referral_5.pendingpatient_id, referral_5.pendingclaim_id, referral_5.provider_id, referral_5.invoicecompany_id, referral_5.referringcompany_id, referral_5.clientfile_id, referral_5.originator_id, referral_5.onbehalfofcompany_id, referral_5.gestationweeks, referral_5.gestationdays, referral_5.babieslastname, referral_5.birthfacilityisdifferentfromprovider, referral_5.birthfacility_id, referral_5.invoicecomments, referral_5.companyiwanttoaffiliatedoesnotexist, referral_5.nonexistentaffiliatecompanyname, referral_5.internalsubmitter_id
  • Index Cond: (referral_5.id = xref.new_referral_id)
86. 0.000 0.000 ↓ 0.0 0

Index Scan using pendingcompany_pkey on public.pendingcompany (cost=0.29..8.31 rows=1 width=34) (never executed)

  • Output: pendingcompany.id, pendingcompany.name, pendingcompany.state, pendingcompany.version, pendingcompany.phone, pendingcompany.city, pendingcompany.zipcode, pendingcompany.addressline1, pendingcompany.addressline2, pendingcompany.providertype, pendingcompany.contacttype, pendingcompany.contactphone, pendingcompany.contactemail, pendingcompany.contactfirstname, pendingcompany.contactlastname, pendingcompany.contacttitle, pendingcompany.contactfax, pendingcompany.networkstatus, pendingcompany.networkname, pendingcompany.networkrestrictions, pendingcompany.admissiondate, pendingcompany.preexistingcompanymatchfound, pendingcompany.preexistingcompanymatchid, pendingcompany.npinumber
  • Index Cond: (pendingcompany.id = referral_5.provider_id)
87. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.61 rows=1 width=31) (never executed)

  • Output: provider.name
  • Inner Unique: true
88. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_6 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_6.id, stay_6.admitted, stay_6.discharged, stay_6.medical_record, stay_6.facility_id, stay_6.patient_id, stay_6.in_network, stay_6.network, stay_6.control_number, stay_6.discount, stay_6.estimated_resolution_date, stay_6.closed, stay_6.close_reason_note, stay_6.close_reason, stay_6.status, stay_6.opened, stay_6.drg_code, stay_6.drg_threshold, stay_6.next_com, stay_6.drg_outlier_multiplier, stay_6.drg_cap_addon, stay_6.retainer, stay_6.retainer_comment, stay_6.care_to_clin_conversion_date, stay_6.drg_client_exceptions, stay_6.standard_drg, stay_6.drg_contractual_rate, stay_6.drg_cost_to_charge_ratio, stay_6.drg_extra_allowance, stay_6.drg_special_multiplier, stay_6.apply_client_exceptions, stay_6.referral_id, stay_6.networkstatus
  • Index Cond: (stay_6.id = xref.stay_id)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using provider_pkey on public.provider (cost=0.28..8.30 rows=1 width=35) (never executed)

  • Output: provider.id, provider.npi_number, provider.name, provider.alias, provider.location, provider.mail, provider.comments, provider.createddate, provider.provider_key, provider.tax_id, provider.type_id, provider.valid_npi_number
  • Index Cond: (provider.id = stay_6.facility_id)
90. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..16.93 rows=1 width=31) (never executed)

  • Output: provider_1.name
  • Inner Unique: true
91. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: stay_7.facility_id
  • Inner Unique: true
92. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_3 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_3.id, claim_3.intake, claim_3.service_start, claim_3.service_end, claim_3.total, claim_3.stay_id, claim_3.close_reason_note, claim_3.close_reason, claim_3.status, claim_3.claim_type, claim_3.closed, claim_3.prescreen_sent, claim_3.conversion_date, claim_3.forensic_sent, claim_3.documentation_received, claim_3.documentation_required, claim_3.appeal_received, claim_3.appeal_response_sent, claim_3.control_number, claim_3.hold_start_date, claim_3.prescreen_due, claim_3.forensic_due, claim_3.appeal_due, claim_3.appeal_response_due, claim_3.hold_reason_note, claim_3.hold_reason, claim_3.prescreen_na, claim_3.forensic_na, claim_3.initial_contact, claim_3.package_create, claim_3.package_to_facility, claim_3.fee_percentage, claim_3.pre_review_claim_payable, claim_3.payer_patient_id, claim_3.flexfield1name, claim_3.flexfield2name, claim_3.flexfield1value, claim_3.flexfield2value, claim_3.medicalrecordsstatus, claim_3.paymentstatus, claim_3.claimdatasource, claim_3.claimpaymenttype_id, claim_3.dummydatadateofreportgeneration, claim_3.primarycostdriver, claim_3.primarycostdriveramount, claim_3.clientadjustments, claim_3.adjustedbalancedue, claim_3.tagbranding, claim_3.prescreenerrorspreliminarysavingsoverride, claim_3.prescreeninconsistenciespreliminarysavingsoverride, claim_3.includesummaryofadjustedrevcodes, claim_3.estimated_billing_date, claim_3.isclinlight, claim_3.med_recs_received, claim_3.isrush, claim_3.cvtyapprovedamount, claim_3.client_contract_date, claim_3.eop_received_date, claim_3.trialclaim, claim_3.timeline_hold_dur, claim_3.itemized_recvd_date, claim_3.itemizeddiscrepancy, claim_3.response_sent, claim_3.channel, claim_3.potential_duplicate, claim_3.internal_rush, claim_3.corrected, claim_3.inactive, claim_3.no_billing
  • Index Cond: (claim_3.id = xref.claim_id)
93. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_7 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: stay_7.id, stay_7.admitted, stay_7.discharged, stay_7.medical_record, stay_7.facility_id, stay_7.patient_id, stay_7.in_network, stay_7.network, stay_7.control_number, stay_7.discount, stay_7.estimated_resolution_date, stay_7.closed, stay_7.close_reason_note, stay_7.close_reason, stay_7.status, stay_7.opened, stay_7.drg_code, stay_7.drg_threshold, stay_7.next_com, stay_7.drg_outlier_multiplier, stay_7.drg_cap_addon, stay_7.retainer, stay_7.retainer_comment, stay_7.care_to_clin_conversion_date, stay_7.drg_client_exceptions, stay_7.standard_drg, stay_7.drg_contractual_rate, stay_7.drg_cost_to_charge_ratio, stay_7.drg_extra_allowance, stay_7.drg_special_multiplier, stay_7.apply_client_exceptions, stay_7.referral_id, stay_7.networkstatus
  • Index Cond: (stay_7.id = claim_3.stay_id)
94. 0.000 0.000 ↓ 0.0 0

Index Scan using provider_pkey on public.provider provider_1 (cost=0.28..0.31 rows=1 width=35) (never executed)

  • Output: provider_1.id, provider_1.npi_number, provider_1.name, provider_1.alias, provider_1.location, provider_1.mail, provider_1.comments, provider_1.createddate, provider_1.provider_key, provider_1.tax_id, provider_1.type_id, provider_1.valid_npi_number
  • Index Cond: (provider_1.id = stay_7.facility_id)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_4 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_4.service_start
  • Index Cond: (claim_4.id = xref.claim_id)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_8 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_8.admitted
  • Index Cond: (stay_8.id = xref.stay_id)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_5 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_5.service_end
  • Index Cond: (claim_5.id = xref.claim_id)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_9 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_9.discharged
  • Index Cond: (stay_9.id = xref.stay_id)
99. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..16.88 rows=1 width=32) (never executed)

  • Output: CASE WHEN (process.end_ IS NOT NULL) THEN 'Ended'::text WHEN process.issuspended_ THEN 'Suspended'::text WHEN ((process.start_ IS NULL) AND (process.end_ IS NULL)) THEN 'Not Started'::text WHEN ((process.end_ IS NULL) AND (process.start_ IS NOT NULL)) THEN 'Started'::text ELSE NULL::text END
  • Inner Unique: true
100. 0.000 0.000 ↓ 0.0 0

Index Scan using jbpm_token_pkey on jbpm.jbpm_token token (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Output: token.id_, token.version_, token.name_, token.start_, token.end_, token.nodeenter_, token.nextlogindex_, token.isabletoreactivateparent_, token.isterminationimplicit_, token.issuspended_, token.lock_, token.node_, token.processinstance_, token.parent_, token.subprocessinstance_
  • Index Cond: (task.token_ = token.id_)
101. 0.000 0.000 ↓ 0.0 0

Index Scan using jbpm_processinstance_pkey on jbpm.jbpm_processinstance process (cost=0.42..8.44 rows=1 width=25) (never executed)

  • Output: process.id_, process.version_, process.key_, process.start_, process.end_, process.issuspended_, process.processdefinition_, process.roottoken_, process.superprocesstoken_
  • Index Cond: (process.id_ = token.processinstance_)
102. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_6 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: claim_6.prescreen_due
  • Index Cond: (claim_6.id = xref.claim_id)
103. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_7 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: claim_7.forensic_due
  • Index Cond: (claim_7.id = xref.claim_id)
104. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_8 (cost=0.29..8.31 rows=1 width=1) (never executed)

  • Output: claim_8.isrush
  • Index Cond: (claim_8.id = xref.claim_id)
105. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_9 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: claim_9.total
  • Index Cond: (claim_9.id = xref.claim_id)
106. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_10 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: claim_10.total
  • Index Cond: (claim_10.id = xref.claim_id)
107. 0.001 66.377 ↓ 0.0 0 1

Hash (cost=179,831.88..179,831.88 rows=194 width=8) (actual time=66.377..66.377 rows=0 loops=1)

  • Output: max_id.max_id
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
108. 0.001 66.376 ↓ 0.0 0 1

Subquery Scan on max_id (cost=179,828.97..179,831.88 rows=194 width=8) (actual time=66.376..66.376 rows=0 loops=1)

  • Output: max_id.max_id
109. 0.000 66.375 ↓ 0.0 0 1

Unique (cost=179,828.97..179,829.94 rows=194 width=44) (actual time=66.375..66.375 rows=0 loops=1)

  • Output: (max(taskinstanceview.id) OVER (?)), taskinstanceview.entitykeyvalue, taskinstanceview.entitytype
110. 0.002 66.375 ↓ 0.0 0 1

Sort (cost=179,828.97..179,829.46 rows=194 width=44) (actual time=66.375..66.375 rows=0 loops=1)

  • Output: (max(taskinstanceview.id) OVER (?)), taskinstanceview.entitykeyvalue, taskinstanceview.entitytype
  • Sort Key: (max(taskinstanceview.id) OVER (?))
  • Sort Method: quicksort Memory: 25kB
111. 0.002 66.373 ↓ 0.0 0 1

WindowAgg (cost=179,817.72..179,821.60 rows=194 width=44) (actual time=66.373..66.373 rows=0 loops=1)

  • Output: max(taskinstanceview.id) OVER (?), taskinstanceview.entitykeyvalue, taskinstanceview.entitytype
112. 0.002 66.371 ↓ 0.0 0 1

Sort (cost=179,817.72..179,818.21 rows=194 width=44) (actual time=66.371..66.371 rows=0 loops=1)

  • Output: taskinstanceview.entitykeyvalue, taskinstanceview.entitytype, taskinstanceview.id
  • Sort Key: taskinstanceview.entitykeyvalue
  • Sort Method: quicksort Memory: 25kB
113. 0.000 66.369 ↓ 0.0 0 1

Subquery Scan on taskinstanceview (cost=179,792.40..179,810.35 rows=194 width=44) (actual time=66.369..66.369 rows=0 loops=1)

  • Output: taskinstanceview.entitykeyvalue, taskinstanceview.entitytype, taskinstanceview.id
114. 0.000 66.369 ↓ 0.0 0 1

Unique (cost=179,792.40..179,808.41 rows=194 width=727) (actual time=66.369..66.369 rows=0 loops=1)

  • Output: task_1.id_, task_1.name_, task_1.description_, task_1.actorid_, (CASE WHEN ((task_1.name_)::text = 'manual-task'::text) THEN 'person'::text ELSE 'system'::text END), ((SubPlan 30)), (COALESCE((SubPlan 31), (CASE WHEN (((task_1.name_)::text = 'customerServiceSwimlaneAssignment'::text) OR ((task_1.name_)::text = 'referralHoldTask'::text) OR ((task_1.name_)::text = 'processReferralOnHold'::text)) THEN 'ClinAssistCustomerService'::text WHEN (((task_1.name_)::text = 'processNewReferral'::text) OR ((task_1.name_)::text = 'intakeSwimlaneAssignment'::text)) THEN 'ClinAssistAdmin'::text ELSE NULL::text END)::character varying)), task_1.duedate_, ((task_1.duedate_)::date), (to_char(task_1.duedate_, 'HH12:MI:SS AM'::text)), task_1.start_, task_1.end_, task_1.priority_, (CASE WHEN ((('now'::cstring)::date > task_1.duedate_) AND (task_1.end_ IS NULL)) THEN true ELSE false END), (CASE WHEN task_1.issuspended_ THEN 'Suspended'::text WHEN task_1.iscancelled_ THEN 'Cancelled'::text WHEN (task_1.end_ IS NOT NULL) THEN 'Ended'::text WHEN (task_1.start_ IS NOT NULL) THEN 'Started'::text ELSE 'Not Started'::text END), (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref_1.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref_1.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref_1.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END), (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN 'newReferralId'::text WHEN (xref_1.claim_id IS NOT NULL) THEN 'claimId'::text WHEN (xref_1.stay_id IS NOT NULL) THEN 'stayId'::text WHEN (xref_1.patient_id IS NOT NULL) THEN 'patientId'::text ELSE NULL::text END), (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN xref_1.new_referral_id WHEN (xref_1.claim_id IS NOT NULL) THEN xref_1.claim_id WHEN (xref_1.stay_id IS NOT NULL) THEN xref_1.stay_id WHEN (xref_1.patient_id IS NOT NULL) THEN xref_1.patient_id ELSE NULL::integer END), (COALESCE((SubPlan 32), (SubPlan 33), (SubPlan 34), COALESCE((SubPlan 35), (SubPlan 36)))), (COALESCE((SubPlan 37), (SubPlan 38), (SubPlan 39), (SubPlan 40), (SubPlan 41))), (COALESCE((SubPlan 42), ((SubPlan 43))::text, ((SubPlan 44))::text, ((SubPlan 45))::text)), (COALESCE((SubPlan 46), (SubPlan 47), (SubPlan 48))), (COALESCE((SubPlan 49), (SubPlan 50))), (COALESCE((SubPlan 51), (SubPlan 52))), ((SubPlan 53)), task_1.create_, task_1.procinst_, ((SubPlan 54)), ((SubPlan 55)), (COALESCE((SubPlan 56), false)), ((SubPlan 57)), (((SubPlan 58))::text)
115. 0.019 66.369 ↓ 0.0 0 1

Sort (cost=179,792.40..179,792.89 rows=194 width=727) (actual time=66.369..66.369 rows=0 loops=1)

  • Output: task_1.id_, task_1.name_, task_1.description_, task_1.actorid_, (CASE WHEN ((task_1.name_)::text = 'manual-task'::text) THEN 'person'::text ELSE 'system'::text END), ((SubPlan 30)), (COALESCE((SubPlan 31), (CASE WHEN (((task_1.name_)::text = 'customerServiceSwimlaneAssignment'::text) OR ((task_1.name_)::text = 'referralHoldTask'::text) OR ((task_1.name_)::text = 'processReferralOnHold'::text)) THEN 'ClinAssistCustomerService'::text WHEN (((task_1.name_)::text = 'processNewReferral'::text) OR ((task_1.name_)::text = 'intakeSwimlaneAssignment'::text)) THEN 'ClinAssistAdmin'::text ELSE NULL::text END)::character varying)), task_1.duedate_, ((task_1.duedate_)::date), (to_char(task_1.duedate_, 'HH12:MI:SS AM'::text)), task_1.start_, task_1.end_, task_1.priority_, (CASE WHEN ((('now'::cstring)::date > task_1.duedate_) AND (task_1.end_ IS NULL)) THEN true ELSE false END), (CASE WHEN task_1.issuspended_ THEN 'Suspended'::text WHEN task_1.iscancelled_ THEN 'Cancelled'::text WHEN (task_1.end_ IS NOT NULL) THEN 'Ended'::text WHEN (task_1.start_ IS NOT NULL) THEN 'Started'::text ELSE 'Not Started'::text END), (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref_1.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref_1.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref_1.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END), (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN 'newReferralId'::text WHEN (xref_1.claim_id IS NOT NULL) THEN 'claimId'::text WHEN (xref_1.stay_id IS NOT NULL) THEN 'stayId'::text WHEN (xref_1.patient_id IS NOT NULL) THEN 'patientId'::text ELSE NULL::text END), (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN xref_1.new_referral_id WHEN (xref_1.claim_id IS NOT NULL) THEN xref_1.claim_id WHEN (xref_1.stay_id IS NOT NULL) THEN xref_1.stay_id WHEN (xref_1.patient_id IS NOT NULL) THEN xref_1.patient_id ELSE NULL::integer END), (COALESCE((SubPlan 32), (SubPlan 33), (SubPlan 34), COALESCE((SubPlan 35), (SubPlan 36)))), (COALESCE((SubPlan 37), (SubPlan 38), (SubPlan 39), (SubPlan 40), (SubPlan 41))), (COALESCE((SubPlan 42), ((SubPlan 43))::text, ((SubPlan 44))::text, ((SubPlan 45))::text)), (COALESCE((SubPlan 46), (SubPlan 47), (SubPlan 48))), (COALESCE((SubPlan 49), (SubPlan 50))), (COALESCE((SubPlan 51), (SubPlan 52))), ((SubPlan 53)), task_1.create_, task_1.procinst_, ((SubPlan 54)), ((SubPlan 55)), (COALESCE((SubPlan 56), false)), ((SubPlan 57)), (((SubPlan 58))::text)
  • Sort Key: task_1.create_ DESC, task_1.id_, task_1.name_, task_1.description_, task_1.actorid_, (CASE WHEN ((task_1.name_)::text = 'manual-task'::text) THEN 'person'::text ELSE 'system'::text END), ((SubPlan 30)), (COALESCE((SubPlan 31), (CASE WHEN (((task_1.name_)::text = 'customerServiceSwimlaneAssignment'::text) OR ((task_1.name_)::text = 'referralHoldTask'::text) OR ((task_1.name_)::text = 'processReferralOnHold'::text)) THEN 'ClinAssistCustomerService'::text WHEN (((task_1.name_)::text = 'processNewReferral'::text) OR ((task_1.name_)::text = 'intakeSwimlaneAssignment'::text)) THEN 'ClinAssistAdmin'::text ELSE NULL::text END)::character varying)), task_1.duedate_, ((task_1.duedate_)::date), (to_char(task_1.duedate_, 'HH12:MI:SS AM'::text)), task_1.start_, task_1.end_, task_1.priority_, (CASE WHEN ((('now'::cstring)::date > task_1.duedate_) AND (task_1.end_ IS NULL)) THEN true ELSE false END), (CASE WHEN task_1.issuspended_ THEN 'Suspended'::text WHEN task_1.iscancelled_ THEN 'Cancelled'::text WHEN (task_1.end_ IS NOT NULL) THEN 'Ended'::text WHEN (task_1.start_ IS NOT NULL) THEN 'Started'::text ELSE 'Not Started'::text END), (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref_1.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref_1.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref_1.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END), (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN 'newReferralId'::text WHEN (xref_1.claim_id IS NOT NULL) THEN 'claimId'::text WHEN (xref_1.stay_id IS NOT NULL) THEN 'stayId'::text WHEN (xref_1.patient_id IS NOT NULL) THEN 'patientId'::text ELSE NULL::text END), (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN xref_1.new_referral_id WHEN (xref_1.claim_id IS NOT NULL) THEN xref_1.claim_id WHEN (xref_1.stay_id IS NOT NULL) THEN xref_1.stay_id WHEN (xref_1.patient_id IS NOT NULL) THEN xref_1.patient_id ELSE NULL::integer END), (COALESCE((SubPlan 32), (SubPlan 33), (SubPlan 34), COALESCE((SubPlan 35), (SubPlan 36)))), (COALESCE((SubPlan 37), (SubPlan 38), (SubPlan 39), (SubPlan 40), (SubPlan 41))), (COALESCE((SubPlan 42), ((SubPlan 43))::text, ((SubPlan 44))::text, ((SubPlan 45))::text)), (COALESCE((SubPlan 46), (SubPlan 47), (SubPlan 48))), (COALESCE((SubPlan 49), (SubPlan 50))), (COALESCE((SubPlan 51), (SubPlan 52))), ((SubPlan 53)), task_1.procinst_, ((SubPlan 54)), ((SubPlan 55)), (COALESCE((SubPlan 56), false)), ((SubPlan 57)), (((SubPlan 58))::text)
  • Sort Method: quicksort Memory: 25kB
116. 0.064 66.350 ↓ 0.0 0 1

Hash Right Join (cost=69,706.67..179,785.03 rows=194 width=727) (actual time=66.350..66.350 rows=0 loops=1)

  • Output: task_1.id_, task_1.name_, task_1.description_, task_1.actorid_, CASE WHEN ((task_1.name_)::text = 'manual-task'::text) THEN 'person'::text ELSE 'system'::text END, (SubPlan 30), COALESCE((SubPlan 31), (CASE WHEN (((task_1.name_)::text = 'customerServiceSwimlaneAssignment'::text) OR ((task_1.name_)::text = 'referralHoldTask'::text) OR ((task_1.name_)::text = 'processReferralOnHold'::text)) THEN 'ClinAssistCustomerService'::text WHEN (((task_1.name_)::text = 'processNewReferral'::text) OR ((task_1.name_)::text = 'intakeSwimlaneAssignment'::text)) THEN 'ClinAssistAdmin'::text ELSE NULL::text END)::character varying), task_1.duedate_, (task_1.duedate_)::date, to_char(task_1.duedate_, 'HH12:MI:SS AM'::text), task_1.start_, task_1.end_, task_1.priority_, CASE WHEN ((('now'::cstring)::date > task_1.duedate_) AND (task_1.end_ IS NULL)) THEN true ELSE false END, CASE WHEN task_1.issuspended_ THEN 'Suspended'::text WHEN task_1.iscancelled_ THEN 'Cancelled'::text WHEN (task_1.end_ IS NOT NULL) THEN 'Ended'::text WHEN (task_1.start_ IS NOT NULL) THEN 'Started'::text ELSE 'Not Started'::text END, CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref_1.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref_1.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref_1.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END, CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN 'newReferralId'::text WHEN (xref_1.claim_id IS NOT NULL) THEN 'claimId'::text WHEN (xref_1.stay_id IS NOT NULL) THEN 'stayId'::text WHEN (xref_1.patient_id IS NOT NULL) THEN 'patientId'::text ELSE NULL::text END, CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN xref_1.new_referral_id WHEN (xref_1.claim_id IS NOT NULL) THEN xref_1.claim_id WHEN (xref_1.stay_id IS NOT NULL) THEN xref_1.stay_id WHEN (xref_1.patient_id IS NOT NULL) THEN xref_1.patient_id ELSE NULL::integer END, COALESCE((SubPlan 32), (SubPlan 33), (SubPlan 34), COALESCE((SubPlan 35), (SubPlan 36))), COALESCE((SubPlan 37), (SubPlan 38), (SubPlan 39), (SubPlan 40), (SubPlan 41)), COALESCE((SubPlan 42), ((SubPlan 43))::text, ((SubPlan 44))::text, ((SubPlan 45))::text), COALESCE((SubPlan 46), (SubPlan 47), (SubPlan 48)), COALESCE((SubPlan 49), (SubPlan 50)), COALESCE((SubPlan 51), (SubPlan 52)), (SubPlan 53), task_1.create_, task_1.procinst_, (SubPlan 54), (SubPlan 55), COALESCE((SubPlan 56), false), (SubPlan 57), ((SubPlan 58))::text
  • Inner Unique: true
  • Hash Cond: (xref_1.task_id = task_1.id_)
  • Filter: (CASE WHEN (xref_1.new_referral_id IS NOT NULL) THEN 'NewReferral'::text WHEN (xref_1.claim_id IS NOT NULL) THEN 'Claim'::text WHEN (xref_1.stay_id IS NOT NULL) THEN 'Stay'::text WHEN (xref_1.patient_id IS NOT NULL) THEN 'Patient'::text ELSE NULL::text END = 'Claim'::text)
117. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.task_entity_xref xref_1 (cost=0.00..17,251.96 rows=1,020,196 width=24) (never executed)

  • Output: xref_1.id, xref_1.task_id, xref_1.claim_id, xref_1.patient_id, xref_1.stay_id, xref_1.new_referral_id
118. 0.000 66.286 ↓ 0.0 0 1

Hash (cost=69,222.01..69,222.01 rows=38,773 width=141) (actual time=66.286..66.286 rows=0 loops=1)

  • Output: task_1.id_, task_1.name_, task_1.description_, task_1.actorid_, task_1.duedate_, task_1.start_, task_1.end_, task_1.priority_, task_1.issuspended_, task_1.iscancelled_, task_1.token_, task_1.create_, task_1.procinst_
  • Buckets: 65536 Batches: 1 Memory Usage: 512kB
119. 44.916 66.286 ↓ 0.0 0 1

Bitmap Heap Scan on jbpm.jbpm_taskinstance task_1 (cost=18,461.20..69,222.01 rows=38,773 width=141) (actual time=66.286..66.286 rows=0 loops=1)

  • Output: task_1.id_, task_1.name_, task_1.description_, task_1.actorid_, task_1.duedate_, task_1.start_, task_1.end_, task_1.priority_, task_1.issuspended_, task_1.iscancelled_, task_1.token_, task_1.create_, task_1.procinst_
  • Recheck Cond: ((task_1.end_ >= (now() - '61:00:00'::interval)) OR (task_1.end_ IS NULL))
  • Filter: (((task_1.name_)::text <> 'New Secure Message'::text) AND ((task_1.name_)::text <> 'Process ClinAssist Referral'::text) AND (CASE WHEN task_1.issuspended_ THEN 'Suspended'::text WHEN task_1.iscancelled_ THEN 'Cancelled'::text WHEN (task_1.end_ IS NOT NULL) THEN 'Ended'::text WHEN (task_1.start_ IS NOT NULL) THEN 'Started'::text ELSE 'Not Started'::text END <> 'Suspended'::text) AND ((((task_1.description_)::text = ANY ('{"Data Entry Task","Internal Data Entry Task"}'::text[])) AND (task_1.end_ >= (now() - '61:00:00'::interval))) OR ((task_1.end_ IS NULL) AND ((task_1.description_)::text = 'Data Entry QA'::text) AND (task_1.create_ >= (now() - '61:00:00'::interval)))))
  • Rows Removed by Filter: 7613
  • Heap Blocks: exact=11967
120. 0.001 21.370 ↓ 0.0 0 1

BitmapOr (cost=18,461.20..18,461.20 rows=525,995 width=0) (actual time=21.370..21.370 rows=0 loops=1)

121. 0.200 0.200 ↑ 487.9 1,065 1

Bitmap Index Scan on idx_taskinst_end (cost=0.00..18,217.89 rows=519,661 width=0) (actual time=0.200..0.200 rows=1,065 loops=1)

  • Index Cond: (task_1.end_ >= (now() - '61:00:00'::interval))
122. 21.169 21.169 ↓ 24.3 154,065 1

Bitmap Index Scan on idx_taskinst_end (cost=0.00..223.92 rows=6,333 width=0) (actual time=21.169..21.169 rows=154,065 loops=1)

  • Index Cond: (task_1.end_ IS NULL)
123.          

SubPlan (forHash Right Join)

124. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..16.74 rows=1 width=32) (never executed)

  • Output: (((contact_5.first_name)::text || ' '::text) || (contact_5.last_name)::text)
  • Inner Unique: true
125. 0.000 0.000 ↓ 0.0 0

Index Scan using email_config_email_address_idx on public.email_config email_1 (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Output: email_1.id, email_1.contact_id, email_1.email_address, email_1.send_notifications
  • Index Cond: ((email_1.email_address)::text = (task_1.actorid_)::text)
126. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact contact_5 (cost=0.42..8.44 rows=1 width=20) (never executed)

  • Output: contact_5.id, contact_5.prefix, contact_5.first_name, contact_5.last_name, contact_5.postfix, contact_5.generic_name, contact_5.password, contact_5.html_mail, contact_5.registration_key, contact_5.note, contact_5.contact_type_id, contact_5.company_id, contact_5.address_id, contact_5.not_allowed_to_login, contact_5.role, contact_5.dont_send_referral_confirmation, contact_5.enable_company_wide_referral_view, contact_5.change_password_next_login, contact_5.last_password_change, contact_5.temporary_password_created, contact_5.last_login, contact_5.clatrackingsheetextendeddatatablestate, contact_5.mytasksextendeddatatablestate, contact_5.referrallistextendeddatatablestate, contact_5.teamtasksextendeddatatablestate, contact_5.unassignedtasksextendeddatatablestate, contact_5.loginfailurecount, contact_5.lastloginfailuredate, contact_5.useragent, contact_5.ipaddress, contact_5.entitytasksextendeddatatablestate, contact_5.lineitemextendeddatatablestate, contact_5.active, contact_5.setinactiveby, contact_5.setinactivedate, contact_5.createdby, contact_5.createddate, contact_5.lastupdatedby, contact_5.updateddate, contact_5.clientportalclaimextendeddatatablestate, contact_5.provider_id, contact_5.closedreferrallistextendeddatatablestate, contact_5.middle_initial
  • Index Cond: (contact_5.id = email_1.contact_id)
127. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..17.84 rows=1 width=20) (never executed)

  • Output: pooledactor_1.actorid_
  • Inner Unique: true
128. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..17.40 rows=1 width=28) (never executed)

  • Output: swimlaneinstance_1.swimlane_, pooledactor_1.actorid_
  • Join Filter: (taskinstance_1.swimlaninstance_ = pooledactor_1.swimlaneinstance_)
129. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..16.89 rows=1 width=24) (never executed)

  • Output: taskinstance_1.swimlaninstance_, swimlaneinstance_1.id_, swimlaneinstance_1.swimlane_
  • Inner Unique: true
130. 0.000 0.000 ↓ 0.0 0

Index Scan using jbpm_taskinstance_pkey on jbpm.jbpm_taskinstance taskinstance_1 (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Output: taskinstance_1.id_, taskinstance_1.class_, taskinstance_1.version_, taskinstance_1.name_, taskinstance_1.description_, taskinstance_1.actorid_, taskinstance_1.create_, taskinstance_1.start_, taskinstance_1.end_, taskinstance_1.duedate_, taskinstance_1.priority_, taskinstance_1.iscancelled_, taskinstance_1.issuspended_, taskinstance_1.isopen_, taskinstance_1.issignalling_, taskinstance_1.isblocking_, taskinstance_1.task_, taskinstance_1.token_, taskinstance_1.procinst_, taskinstance_1.swimlaninstance_, taskinstance_1.taskmgmtinstance_
  • Index Cond: (taskinstance_1.id_ = task_1.id_)
131. 0.000 0.000 ↓ 0.0 0

Index Scan using jbpm_swimlaneinstance_pkey on jbpm.jbpm_swimlaneinstance swimlaneinstance_1 (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Output: swimlaneinstance_1.id_, swimlaneinstance_1.version_, swimlaneinstance_1.name_, swimlaneinstance_1.actorid_, swimlaneinstance_1.swimlane_, swimlaneinstance_1.taskmgmtinstance_
  • Index Cond: (swimlaneinstance_1.id_ = taskinstance_1.swimlaninstance_)
132. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_tskinst_swlane on jbpm.jbpm_pooledactor pooledactor_1 (cost=0.42..0.50 rows=1 width=28) (never executed)

  • Output: pooledactor_1.id_, pooledactor_1.version_, pooledactor_1.actorid_, pooledactor_1.swimlaneinstance_
  • Index Cond: (pooledactor_1.swimlaneinstance_ = swimlaneinstance_1.id_)
133. 0.000 0.000 ↓ 0.0 0

Index Only Scan using jbpm_swimlane_pkey on jbpm.jbpm_swimlane swimlane_1 (cost=0.42..0.44 rows=1 width=8) (never executed)

  • Output: swimlane_1.id_
  • Index Cond: (swimlane_1.id_ = swimlaneinstance_1.swimlane_)
  • Heap Fetches: 0
134. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.75 rows=1 width=32) (never executed)

  • Output: (((contact_6.last_name)::text || ', '::text) || (contact_6.first_name)::text)
  • Inner Unique: true
135. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_10 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: patient_10.id, patient_10.contact_id, patient_10.gender, patient_10.birth_date, patient_10.client_file_id, patient_10.parental_relationship, patient_10.condition, patient_10.gestational_age, patient_10.estimated_length_of_stay, patient_10.ignore, patient_10.birth_weight, patient_10.race, patient_10.apgar_1, patient_10.apgar_2, patient_10.apgar_3, patient_10.apgar_4, patient_10.patient_id, patient_10.payer_patient_id
  • Index Cond: (patient_10.id = xref_1.patient_id)
136. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact contact_6 (cost=0.42..8.44 rows=1 width=20) (never executed)

  • Output: contact_6.id, contact_6.prefix, contact_6.first_name, contact_6.last_name, contact_6.postfix, contact_6.generic_name, contact_6.password, contact_6.html_mail, contact_6.registration_key, contact_6.note, contact_6.contact_type_id, contact_6.company_id, contact_6.address_id, contact_6.not_allowed_to_login, contact_6.role, contact_6.dont_send_referral_confirmation, contact_6.enable_company_wide_referral_view, contact_6.change_password_next_login, contact_6.last_password_change, contact_6.temporary_password_created, contact_6.last_login, contact_6.clatrackingsheetextendeddatatablestate, contact_6.mytasksextendeddatatablestate, contact_6.referrallistextendeddatatablestate, contact_6.teamtasksextendeddatatablestate, contact_6.unassignedtasksextendeddatatablestate, contact_6.loginfailurecount, contact_6.lastloginfailuredate, contact_6.useragent, contact_6.ipaddress, contact_6.entitytasksextendeddatatablestate, contact_6.lineitemextendeddatatablestate, contact_6.active, contact_6.setinactiveby, contact_6.setinactivedate, contact_6.createdby, contact_6.createddate, contact_6.lastupdatedby, contact_6.updateddate, contact_6.clientportalclaimextendeddatatablestate, contact_6.provider_id, contact_6.closedreferrallistextendeddatatablestate, contact_6.middle_initial
  • Index Cond: (contact_6.id = patient_10.contact_id)
137. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.00..17.72 rows=1 width=32) (never executed)

  • Output: (((contact_7.last_name)::text || ', '::text) || (contact_7.first_name)::text)
  • Inner Unique: true
138. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: patient_11.contact_id
  • Inner Unique: true
139. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_10 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_10.id, stay_10.admitted, stay_10.discharged, stay_10.medical_record, stay_10.facility_id, stay_10.patient_id, stay_10.in_network, stay_10.network, stay_10.control_number, stay_10.discount, stay_10.estimated_resolution_date, stay_10.closed, stay_10.close_reason_note, stay_10.close_reason, stay_10.status, stay_10.opened, stay_10.drg_code, stay_10.drg_threshold, stay_10.next_com, stay_10.drg_outlier_multiplier, stay_10.drg_cap_addon, stay_10.retainer, stay_10.retainer_comment, stay_10.care_to_clin_conversion_date, stay_10.drg_client_exceptions, stay_10.standard_drg, stay_10.drg_contractual_rate, stay_10.drg_cost_to_charge_ratio, stay_10.drg_extra_allowance, stay_10.drg_special_multiplier, stay_10.apply_client_exceptions, stay_10.referral_id, stay_10.networkstatus
  • Index Cond: (stay_10.id = xref_1.stay_id)
140. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_11 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: patient_11.id, patient_11.contact_id, patient_11.gender, patient_11.birth_date, patient_11.client_file_id, patient_11.parental_relationship, patient_11.condition, patient_11.gestational_age, patient_11.estimated_length_of_stay, patient_11.ignore, patient_11.birth_weight, patient_11.race, patient_11.apgar_1, patient_11.apgar_2, patient_11.apgar_3, patient_11.apgar_4, patient_11.patient_id, patient_11.payer_patient_id
  • Index Cond: (patient_11.id = stay_10.patient_id)
141. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact contact_7 (cost=0.42..1.09 rows=1 width=20) (never executed)

  • Output: contact_7.id, contact_7.prefix, contact_7.first_name, contact_7.last_name, contact_7.postfix, contact_7.generic_name, contact_7.password, contact_7.html_mail, contact_7.registration_key, contact_7.note, contact_7.contact_type_id, contact_7.company_id, contact_7.address_id, contact_7.not_allowed_to_login, contact_7.role, contact_7.dont_send_referral_confirmation, contact_7.enable_company_wide_referral_view, contact_7.change_password_next_login, contact_7.last_password_change, contact_7.temporary_password_created, contact_7.last_login, contact_7.clatrackingsheetextendeddatatablestate, contact_7.mytasksextendeddatatablestate, contact_7.referrallistextendeddatatablestate, contact_7.teamtasksextendeddatatablestate, contact_7.unassignedtasksextendeddatatablestate, contact_7.loginfailurecount, contact_7.lastloginfailuredate, contact_7.useragent, contact_7.ipaddress, contact_7.entitytasksextendeddatatablestate, contact_7.lineitemextendeddatatablestate, contact_7.active, contact_7.setinactiveby, contact_7.setinactivedate, contact_7.createdby, contact_7.createddate, contact_7.lastupdatedby, contact_7.updateddate, contact_7.clientportalclaimextendeddatatablestate, contact_7.provider_id, contact_7.closedreferrallistextendeddatatablestate, contact_7.middle_initial
  • Index Cond: (contact_7.id = patient_11.contact_id)
142. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.29..18.07 rows=1 width=32) (never executed)

  • Output: (((contact_8.last_name)::text || ', '::text) || (contact_8.first_name)::text)
  • Inner Unique: true
143. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.97 rows=1 width=4) (never executed)

  • Output: patient_12.contact_id
  • Inner Unique: true
144. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: stay_11.patient_id
  • Inner Unique: true
145. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_11 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_11.id, claim_11.intake, claim_11.service_start, claim_11.service_end, claim_11.total, claim_11.stay_id, claim_11.close_reason_note, claim_11.close_reason, claim_11.status, claim_11.claim_type, claim_11.closed, claim_11.prescreen_sent, claim_11.conversion_date, claim_11.forensic_sent, claim_11.documentation_received, claim_11.documentation_required, claim_11.appeal_received, claim_11.appeal_response_sent, claim_11.control_number, claim_11.hold_start_date, claim_11.prescreen_due, claim_11.forensic_due, claim_11.appeal_due, claim_11.appeal_response_due, claim_11.hold_reason_note, claim_11.hold_reason, claim_11.prescreen_na, claim_11.forensic_na, claim_11.initial_contact, claim_11.package_create, claim_11.package_to_facility, claim_11.fee_percentage, claim_11.pre_review_claim_payable, claim_11.payer_patient_id, claim_11.flexfield1name, claim_11.flexfield2name, claim_11.flexfield1value, claim_11.flexfield2value, claim_11.medicalrecordsstatus, claim_11.paymentstatus, claim_11.claimdatasource, claim_11.claimpaymenttype_id, claim_11.dummydatadateofreportgeneration, claim_11.primarycostdriver, claim_11.primarycostdriveramount, claim_11.clientadjustments, claim_11.adjustedbalancedue, claim_11.tagbranding, claim_11.prescreenerrorspreliminarysavingsoverride, claim_11.prescreeninconsistenciespreliminarysavingsoverride, claim_11.includesummaryofadjustedrevcodes, claim_11.estimated_billing_date, claim_11.isclinlight, claim_11.med_recs_received, claim_11.isrush, claim_11.cvtyapprovedamount, claim_11.client_contract_date, claim_11.eop_received_date, claim_11.trialclaim, claim_11.timeline_hold_dur, claim_11.itemized_recvd_date, claim_11.itemizeddiscrepancy, claim_11.response_sent, claim_11.channel, claim_11.potential_duplicate, claim_11.internal_rush, claim_11.corrected, claim_11.inactive, claim_11.no_billing
  • Index Cond: (claim_11.id = xref_1.claim_id)
146. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_11 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: stay_11.id, stay_11.admitted, stay_11.discharged, stay_11.medical_record, stay_11.facility_id, stay_11.patient_id, stay_11.in_network, stay_11.network, stay_11.control_number, stay_11.discount, stay_11.estimated_resolution_date, stay_11.closed, stay_11.close_reason_note, stay_11.close_reason, stay_11.status, stay_11.opened, stay_11.drg_code, stay_11.drg_threshold, stay_11.next_com, stay_11.drg_outlier_multiplier, stay_11.drg_cap_addon, stay_11.retainer, stay_11.retainer_comment, stay_11.care_to_clin_conversion_date, stay_11.drg_client_exceptions, stay_11.standard_drg, stay_11.drg_contractual_rate, stay_11.drg_cost_to_charge_ratio, stay_11.drg_extra_allowance, stay_11.drg_special_multiplier, stay_11.apply_client_exceptions, stay_11.referral_id, stay_11.networkstatus
  • Index Cond: (stay_11.id = claim_11.stay_id)
147. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_12 (cost=0.29..0.35 rows=1 width=8) (never executed)

  • Output: patient_12.id, patient_12.contact_id, patient_12.gender, patient_12.birth_date, patient_12.client_file_id, patient_12.parental_relationship, patient_12.condition, patient_12.gestational_age, patient_12.estimated_length_of_stay, patient_12.ignore, patient_12.birth_weight, patient_12.race, patient_12.apgar_1, patient_12.apgar_2, patient_12.apgar_3, patient_12.apgar_4, patient_12.patient_id, patient_12.payer_patient_id
  • Index Cond: (patient_12.id = stay_11.patient_id)
148. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact contact_8 (cost=0.42..1.09 rows=1 width=20) (never executed)

  • Output: contact_8.id, contact_8.prefix, contact_8.first_name, contact_8.last_name, contact_8.postfix, contact_8.generic_name, contact_8.password, contact_8.html_mail, contact_8.registration_key, contact_8.note, contact_8.contact_type_id, contact_8.company_id, contact_8.address_id, contact_8.not_allowed_to_login, contact_8.role, contact_8.dont_send_referral_confirmation, contact_8.enable_company_wide_referral_view, contact_8.change_password_next_login, contact_8.last_password_change, contact_8.temporary_password_created, contact_8.last_login, contact_8.clatrackingsheetextendeddatatablestate, contact_8.mytasksextendeddatatablestate, contact_8.referrallistextendeddatatablestate, contact_8.teamtasksextendeddatatablestate, contact_8.unassignedtasksextendeddatatablestate, contact_8.loginfailurecount, contact_8.lastloginfailuredate, contact_8.useragent, contact_8.ipaddress, contact_8.entitytasksextendeddatatablestate, contact_8.lineitemextendeddatatablestate, contact_8.active, contact_8.setinactiveby, contact_8.setinactivedate, contact_8.createdby, contact_8.createddate, contact_8.lastupdatedby, contact_8.updateddate, contact_8.clientportalclaimextendeddatatablestate, contact_8.provider_id, contact_8.closedreferrallistextendeddatatablestate, contact_8.middle_initial
  • Index Cond: (contact_8.id = patient_12.contact_id)
149. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.29..18.06 rows=1 width=32) (never executed)

  • Output: (((contact_9.last_name)::text || ', '::text) || (contact_9.first_name)::text)
  • Inner Unique: true
150. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.97 rows=1 width=4) (never executed)

  • Output: patient_13.contact_id
  • Inner Unique: true
151. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: pendingpatient_2.preexistingcontactmatchid
  • Inner Unique: true
152. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_6 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral_6.referraltype, referral_6.id, referral_6.version, referral_6.comments, referral_6.trial, referral_6.conditioncategory, referral_6.createddate, referral_6.policyholder, referral_6.gestation, referral_6.referralcontact_id, referral_6.pendingpatient_id, referral_6.pendingclaim_id, referral_6.provider_id, referral_6.invoicecompany_id, referral_6.referringcompany_id, referral_6.clientfile_id, referral_6.originator_id, referral_6.onbehalfofcompany_id, referral_6.gestationweeks, referral_6.gestationdays, referral_6.babieslastname, referral_6.birthfacilityisdifferentfromprovider, referral_6.birthfacility_id, referral_6.invoicecomments, referral_6.companyiwanttoaffiliatedoesnotexist, referral_6.nonexistentaffiliatecompanyname, referral_6.internalsubmitter_id
  • Index Cond: (xref_1.new_referral_id = referral_6.id)
153. 0.000 0.000 ↓ 0.0 0

Index Scan using pendingpatient_pkey on public.pendingpatient pendingpatient_2 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: pendingpatient_2.id, pendingpatient_2.version, pendingpatient_2.firstname, pendingpatient_2.lastname, pendingpatient_2.dateofbirth, pendingpatient_2.gender, pendingpatient_2.createddate, pendingpatient_2.payerpatientid, pendingpatient_2.preexistingcontactmatchfound, pendingpatient_2.preexistingcontactmatchid, pendingpatient_2.flexfield1name, pendingpatient_2.flexfield2name, pendingpatient_2.flexfield1value, pendingpatient_2.flexfield2value, pendingpatient_2.gestationweeks, pendingpatient_2.gestationdays, pendingpatient_2.birthweight, pendingpatient_2.patienttype, pendingpatient_2.diagnosiscode
  • Index Cond: (pendingpatient_2.id = referral_6.pendingpatient_id)
154. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_13 (cost=0.29..0.35 rows=1 width=8) (never executed)

  • Output: patient_13.id, patient_13.contact_id, patient_13.gender, patient_13.birth_date, patient_13.client_file_id, patient_13.parental_relationship, patient_13.condition, patient_13.gestational_age, patient_13.estimated_length_of_stay, patient_13.ignore, patient_13.birth_weight, patient_13.race, patient_13.apgar_1, patient_13.apgar_2, patient_13.apgar_3, patient_13.apgar_4, patient_13.patient_id, patient_13.payer_patient_id
  • Index Cond: (patient_13.id = pendingpatient_2.preexistingcontactmatchid)
155. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_pkey on public.contact contact_9 (cost=0.42..1.09 rows=1 width=20) (never executed)

  • Output: contact_9.id, contact_9.prefix, contact_9.first_name, contact_9.last_name, contact_9.postfix, contact_9.generic_name, contact_9.password, contact_9.html_mail, contact_9.registration_key, contact_9.note, contact_9.contact_type_id, contact_9.company_id, contact_9.address_id, contact_9.not_allowed_to_login, contact_9.role, contact_9.dont_send_referral_confirmation, contact_9.enable_company_wide_referral_view, contact_9.change_password_next_login, contact_9.last_password_change, contact_9.temporary_password_created, contact_9.last_login, contact_9.clatrackingsheetextendeddatatablestate, contact_9.mytasksextendeddatatablestate, contact_9.referrallistextendeddatatablestate, contact_9.teamtasksextendeddatatablestate, contact_9.unassignedtasksextendeddatatablestate, contact_9.loginfailurecount, contact_9.lastloginfailuredate, contact_9.useragent, contact_9.ipaddress, contact_9.entitytasksextendeddatatablestate, contact_9.lineitemextendeddatatablestate, contact_9.active, contact_9.setinactiveby, contact_9.setinactivedate, contact_9.createdby, contact_9.createddate, contact_9.lastupdatedby, contact_9.updateddate, contact_9.clientportalclaimextendeddatatablestate, contact_9.provider_id, contact_9.closedreferrallistextendeddatatablestate, contact_9.middle_initial
  • Index Cond: (contact_9.id = patient_13.contact_id)
156. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.63 rows=1 width=32) (never executed)

  • Output: (((pendingpatient_3.lastname)::text || ', '::text) || (pendingpatient_3.firstname)::text)
  • Inner Unique: true
157. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_7 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral_7.referraltype, referral_7.id, referral_7.version, referral_7.comments, referral_7.trial, referral_7.conditioncategory, referral_7.createddate, referral_7.policyholder, referral_7.gestation, referral_7.referralcontact_id, referral_7.pendingpatient_id, referral_7.pendingclaim_id, referral_7.provider_id, referral_7.invoicecompany_id, referral_7.referringcompany_id, referral_7.clientfile_id, referral_7.originator_id, referral_7.onbehalfofcompany_id, referral_7.gestationweeks, referral_7.gestationdays, referral_7.babieslastname, referral_7.birthfacilityisdifferentfromprovider, referral_7.birthfacility_id, referral_7.invoicecomments, referral_7.companyiwanttoaffiliatedoesnotexist, referral_7.nonexistentaffiliatecompanyname, referral_7.internalsubmitter_id
  • Index Cond: (xref_1.new_referral_id = referral_7.id)
158. 0.000 0.000 ↓ 0.0 0

Index Scan using pendingpatient_pkey on public.pendingpatient pendingpatient_3 (cost=0.29..8.31 rows=1 width=18) (never executed)

  • Output: pendingpatient_3.id, pendingpatient_3.version, pendingpatient_3.firstname, pendingpatient_3.lastname, pendingpatient_3.dateofbirth, pendingpatient_3.gender, pendingpatient_3.createddate, pendingpatient_3.payerpatientid, pendingpatient_3.preexistingcontactmatchfound, pendingpatient_3.preexistingcontactmatchid, pendingpatient_3.flexfield1name, pendingpatient_3.flexfield2name, pendingpatient_3.flexfield1value, pendingpatient_3.flexfield2value, pendingpatient_3.gestationweeks, pendingpatient_3.gestationdays, pendingpatient_3.birthweight, pendingpatient_3.patienttype, pendingpatient_3.diagnosiscode
  • Index Cond: (pendingpatient_3.id = referral_7.pendingpatient_id)
159. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.62 rows=1 width=23) (never executed)

  • Output: company_5.name
  • Inner Unique: true
160. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_8 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral_8.referraltype, referral_8.id, referral_8.version, referral_8.comments, referral_8.trial, referral_8.conditioncategory, referral_8.createddate, referral_8.policyholder, referral_8.gestation, referral_8.referralcontact_id, referral_8.pendingpatient_id, referral_8.pendingclaim_id, referral_8.provider_id, referral_8.invoicecompany_id, referral_8.referringcompany_id, referral_8.clientfile_id, referral_8.originator_id, referral_8.onbehalfofcompany_id, referral_8.gestationweeks, referral_8.gestationdays, referral_8.babieslastname, referral_8.birthfacilityisdifferentfromprovider, referral_8.birthfacility_id, referral_8.invoicecomments, referral_8.companyiwanttoaffiliatedoesnotexist, referral_8.nonexistentaffiliatecompanyname, referral_8.internalsubmitter_id
  • Index Cond: (referral_8.id = xref_1.new_referral_id)
161. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company company_5 (cost=0.28..8.29 rows=1 width=27) (never executed)

  • Output: company_5.id, company_5.name, company_5.alias, company_5.email_domain, company_5.location, company_5.mail, company_5.default_referral_id, company_5.drg_threshold, company_5.drg_outlier_multiplier, company_5.ub92_report, company_5.deferred_company_id, company_5.clinassist, company_5.careassist_neonatal, company_5.careassist_pediatric, company_5.careassist_maternal, company_5.comments, company_5.exclude_clinassist_information_ps, company_5.include_clinassist_information_fr, company_5.include_facility_address_ps, company_5.include_facility_address_fr, company_5.show_amount_paid_fr, company_5.prescreen_report, company_5.exhibit_a_report, company_5.company_type, company_5.covered_lives, company_5.average_book_premium, company_5.flex_field_one_name, company_5.flex_field_two_name, company_5.createddate, company_5.onshore_data_entry_required, company_5.company_key, company_5.tax_id, company_5.client_submitter_id, company_5.use_2fa, company_5.incoming_837_name, company_5.default_workflow_pod_id, company_5.iz_required_to_start_workflow, company_5.report_publish_required_for_referral_channel, company_5.report_publish_required_for_edi_channel, company_5.disable_new_claim_processing
  • Index Cond: (company_5.id = referral_8.onbehalfofcompany_id)
162. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.62 rows=1 width=23) (never executed)

  • Output: company_6.name
  • Inner Unique: true
163. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_9 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral_9.referraltype, referral_9.id, referral_9.version, referral_9.comments, referral_9.trial, referral_9.conditioncategory, referral_9.createddate, referral_9.policyholder, referral_9.gestation, referral_9.referralcontact_id, referral_9.pendingpatient_id, referral_9.pendingclaim_id, referral_9.provider_id, referral_9.invoicecompany_id, referral_9.referringcompany_id, referral_9.clientfile_id, referral_9.originator_id, referral_9.onbehalfofcompany_id, referral_9.gestationweeks, referral_9.gestationdays, referral_9.babieslastname, referral_9.birthfacilityisdifferentfromprovider, referral_9.birthfacility_id, referral_9.invoicecomments, referral_9.companyiwanttoaffiliatedoesnotexist, referral_9.nonexistentaffiliatecompanyname, referral_9.internalsubmitter_id
  • Index Cond: (referral_9.id = xref_1.new_referral_id)
164. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company company_6 (cost=0.28..8.29 rows=1 width=27) (never executed)

  • Output: company_6.id, company_6.name, company_6.alias, company_6.email_domain, company_6.location, company_6.mail, company_6.default_referral_id, company_6.drg_threshold, company_6.drg_outlier_multiplier, company_6.ub92_report, company_6.deferred_company_id, company_6.clinassist, company_6.careassist_neonatal, company_6.careassist_pediatric, company_6.careassist_maternal, company_6.comments, company_6.exclude_clinassist_information_ps, company_6.include_clinassist_information_fr, company_6.include_facility_address_ps, company_6.include_facility_address_fr, company_6.show_amount_paid_fr, company_6.prescreen_report, company_6.exhibit_a_report, company_6.company_type, company_6.covered_lives, company_6.average_book_premium, company_6.flex_field_one_name, company_6.flex_field_two_name, company_6.createddate, company_6.onshore_data_entry_required, company_6.company_key, company_6.tax_id, company_6.client_submitter_id, company_6.use_2fa, company_6.incoming_837_name, company_6.default_workflow_pod_id, company_6.iz_required_to_start_workflow, company_6.report_publish_required_for_referral_channel, company_6.report_publish_required_for_edi_channel, company_6.disable_new_claim_processing
  • Index Cond: (company_6.id = referral_9.referringcompany_id)
165. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..16.92 rows=1 width=23) (never executed)

  • Output: company_7.name
  • Inner Unique: true
166. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: clientfile_3.client_id
  • Inner Unique: true
167. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_14 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: patient_14.id, patient_14.contact_id, patient_14.gender, patient_14.birth_date, patient_14.client_file_id, patient_14.parental_relationship, patient_14.condition, patient_14.gestational_age, patient_14.estimated_length_of_stay, patient_14.ignore, patient_14.birth_weight, patient_14.race, patient_14.apgar_1, patient_14.apgar_2, patient_14.apgar_3, patient_14.apgar_4, patient_14.patient_id, patient_14.payer_patient_id
  • Index Cond: (patient_14.id = xref_1.patient_id)
168. 0.000 0.000 ↓ 0.0 0

Index Scan using client_file_pkey on public.client_file clientfile_3 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: clientfile_3.id, clientfile_3.manage_care, clientfile_3.audit_claim, clientfile_3.client_id, clientfile_3.referral_id, clientfile_3.insured_employer, clientfile_3.insured_relationship, clientfile_3.created, clientfile_3.payer, clientfile_3.client_name_override
  • Index Cond: (clientfile_3.id = patient_14.client_file_id)
169. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company company_7 (cost=0.28..0.30 rows=1 width=27) (never executed)

  • Output: company_7.id, company_7.name, company_7.alias, company_7.email_domain, company_7.location, company_7.mail, company_7.default_referral_id, company_7.drg_threshold, company_7.drg_outlier_multiplier, company_7.ub92_report, company_7.deferred_company_id, company_7.clinassist, company_7.careassist_neonatal, company_7.careassist_pediatric, company_7.careassist_maternal, company_7.comments, company_7.exclude_clinassist_information_ps, company_7.include_clinassist_information_fr, company_7.include_facility_address_ps, company_7.include_facility_address_fr, company_7.show_amount_paid_fr, company_7.prescreen_report, company_7.exhibit_a_report, company_7.company_type, company_7.covered_lives, company_7.average_book_premium, company_7.flex_field_one_name, company_7.flex_field_two_name, company_7.createddate, company_7.onshore_data_entry_required, company_7.company_key, company_7.tax_id, company_7.client_submitter_id, company_7.use_2fa, company_7.incoming_837_name, company_7.default_workflow_pod_id, company_7.iz_required_to_start_workflow, company_7.report_publish_required_for_referral_channel, company_7.report_publish_required_for_edi_channel, company_7.disable_new_claim_processing
  • Index Cond: (company_7.id = clientfile_3.client_id)
170. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.28 rows=1 width=23) (never executed)

  • Output: company_8.name
  • Inner Unique: true
171. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.98 rows=1 width=4) (never executed)

  • Output: clientfile_4.client_id
  • Inner Unique: true
172. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: patient_15.client_file_id
  • Inner Unique: true
173. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_12 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_12.id, stay_12.admitted, stay_12.discharged, stay_12.medical_record, stay_12.facility_id, stay_12.patient_id, stay_12.in_network, stay_12.network, stay_12.control_number, stay_12.discount, stay_12.estimated_resolution_date, stay_12.closed, stay_12.close_reason_note, stay_12.close_reason, stay_12.status, stay_12.opened, stay_12.drg_code, stay_12.drg_threshold, stay_12.next_com, stay_12.drg_outlier_multiplier, stay_12.drg_cap_addon, stay_12.retainer, stay_12.retainer_comment, stay_12.care_to_clin_conversion_date, stay_12.drg_client_exceptions, stay_12.standard_drg, stay_12.drg_contractual_rate, stay_12.drg_cost_to_charge_ratio, stay_12.drg_extra_allowance, stay_12.drg_special_multiplier, stay_12.apply_client_exceptions, stay_12.referral_id, stay_12.networkstatus
  • Index Cond: (stay_12.id = xref_1.stay_id)
174. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_15 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: patient_15.id, patient_15.contact_id, patient_15.gender, patient_15.birth_date, patient_15.client_file_id, patient_15.parental_relationship, patient_15.condition, patient_15.gestational_age, patient_15.estimated_length_of_stay, patient_15.ignore, patient_15.birth_weight, patient_15.race, patient_15.apgar_1, patient_15.apgar_2, patient_15.apgar_3, patient_15.apgar_4, patient_15.patient_id, patient_15.payer_patient_id
  • Index Cond: (patient_15.id = stay_12.patient_id)
175. 0.000 0.000 ↓ 0.0 0

Index Scan using client_file_pkey on public.client_file clientfile_4 (cost=0.29..0.36 rows=1 width=8) (never executed)

  • Output: clientfile_4.id, clientfile_4.manage_care, clientfile_4.audit_claim, clientfile_4.client_id, clientfile_4.referral_id, clientfile_4.insured_employer, clientfile_4.insured_relationship, clientfile_4.created, clientfile_4.payer, clientfile_4.client_name_override
  • Index Cond: (clientfile_4.id = patient_15.client_file_id)
176. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company company_8 (cost=0.28..0.30 rows=1 width=27) (never executed)

  • Output: company_8.id, company_8.name, company_8.alias, company_8.email_domain, company_8.location, company_8.mail, company_8.default_referral_id, company_8.drg_threshold, company_8.drg_outlier_multiplier, company_8.ub92_report, company_8.deferred_company_id, company_8.clinassist, company_8.careassist_neonatal, company_8.careassist_pediatric, company_8.careassist_maternal, company_8.comments, company_8.exclude_clinassist_information_ps, company_8.include_clinassist_information_fr, company_8.include_facility_address_ps, company_8.include_facility_address_fr, company_8.show_amount_paid_fr, company_8.prescreen_report, company_8.exhibit_a_report, company_8.company_type, company_8.covered_lives, company_8.average_book_premium, company_8.flex_field_one_name, company_8.flex_field_two_name, company_8.createddate, company_8.onshore_data_entry_required, company_8.company_key, company_8.tax_id, company_8.client_submitter_id, company_8.use_2fa, company_8.incoming_837_name, company_8.default_workflow_pod_id, company_8.iz_required_to_start_workflow, company_8.report_publish_required_for_referral_channel, company_8.report_publish_required_for_edi_channel, company_8.disable_new_claim_processing
  • Index Cond: (company_8.id = clientfile_4.client_id)
177. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.45..17.63 rows=1 width=23) (never executed)

  • Output: company_9.name
  • Inner Unique: true
178. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.17..17.33 rows=1 width=4) (never executed)

  • Output: clientfile_5.client_id
  • Inner Unique: true
179. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.97 rows=1 width=4) (never executed)

  • Output: patient_16.client_file_id
  • Inner Unique: true
180. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: stay_13.patient_id
  • Inner Unique: true
181. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_12 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_12.id, claim_12.intake, claim_12.service_start, claim_12.service_end, claim_12.total, claim_12.stay_id, claim_12.close_reason_note, claim_12.close_reason, claim_12.status, claim_12.claim_type, claim_12.closed, claim_12.prescreen_sent, claim_12.conversion_date, claim_12.forensic_sent, claim_12.documentation_received, claim_12.documentation_required, claim_12.appeal_received, claim_12.appeal_response_sent, claim_12.control_number, claim_12.hold_start_date, claim_12.prescreen_due, claim_12.forensic_due, claim_12.appeal_due, claim_12.appeal_response_due, claim_12.hold_reason_note, claim_12.hold_reason, claim_12.prescreen_na, claim_12.forensic_na, claim_12.initial_contact, claim_12.package_create, claim_12.package_to_facility, claim_12.fee_percentage, claim_12.pre_review_claim_payable, claim_12.payer_patient_id, claim_12.flexfield1name, claim_12.flexfield2name, claim_12.flexfield1value, claim_12.flexfield2value, claim_12.medicalrecordsstatus, claim_12.paymentstatus, claim_12.claimdatasource, claim_12.claimpaymenttype_id, claim_12.dummydatadateofreportgeneration, claim_12.primarycostdriver, claim_12.primarycostdriveramount, claim_12.clientadjustments, claim_12.adjustedbalancedue, claim_12.tagbranding, claim_12.prescreenerrorspreliminarysavingsoverride, claim_12.prescreeninconsistenciespreliminarysavingsoverride, claim_12.includesummaryofadjustedrevcodes, claim_12.estimated_billing_date, claim_12.isclinlight, claim_12.med_recs_received, claim_12.isrush, claim_12.cvtyapprovedamount, claim_12.client_contract_date, claim_12.eop_received_date, claim_12.trialclaim, claim_12.timeline_hold_dur, claim_12.itemized_recvd_date, claim_12.itemizeddiscrepancy, claim_12.response_sent, claim_12.channel, claim_12.potential_duplicate, claim_12.internal_rush, claim_12.corrected, claim_12.inactive, claim_12.no_billing
  • Index Cond: (claim_12.id = xref_1.claim_id)
182. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_13 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: stay_13.id, stay_13.admitted, stay_13.discharged, stay_13.medical_record, stay_13.facility_id, stay_13.patient_id, stay_13.in_network, stay_13.network, stay_13.control_number, stay_13.discount, stay_13.estimated_resolution_date, stay_13.closed, stay_13.close_reason_note, stay_13.close_reason, stay_13.status, stay_13.opened, stay_13.drg_code, stay_13.drg_threshold, stay_13.next_com, stay_13.drg_outlier_multiplier, stay_13.drg_cap_addon, stay_13.retainer, stay_13.retainer_comment, stay_13.care_to_clin_conversion_date, stay_13.drg_client_exceptions, stay_13.standard_drg, stay_13.drg_contractual_rate, stay_13.drg_cost_to_charge_ratio, stay_13.drg_extra_allowance, stay_13.drg_special_multiplier, stay_13.apply_client_exceptions, stay_13.referral_id, stay_13.networkstatus
  • Index Cond: (stay_13.id = claim_12.stay_id)
183. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_16 (cost=0.29..0.35 rows=1 width=8) (never executed)

  • Output: patient_16.id, patient_16.contact_id, patient_16.gender, patient_16.birth_date, patient_16.client_file_id, patient_16.parental_relationship, patient_16.condition, patient_16.gestational_age, patient_16.estimated_length_of_stay, patient_16.ignore, patient_16.birth_weight, patient_16.race, patient_16.apgar_1, patient_16.apgar_2, patient_16.apgar_3, patient_16.apgar_4, patient_16.patient_id, patient_16.payer_patient_id
  • Index Cond: (patient_16.id = stay_13.patient_id)
184. 0.000 0.000 ↓ 0.0 0

Index Scan using client_file_pkey on public.client_file clientfile_5 (cost=0.29..0.36 rows=1 width=8) (never executed)

  • Output: clientfile_5.id, clientfile_5.manage_care, clientfile_5.audit_claim, clientfile_5.client_id, clientfile_5.referral_id, clientfile_5.insured_employer, clientfile_5.insured_relationship, clientfile_5.created, clientfile_5.payer, clientfile_5.client_name_override
  • Index Cond: (clientfile_5.id = patient_16.client_file_id)
185. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on public.company company_9 (cost=0.28..0.30 rows=1 width=27) (never executed)

  • Output: company_9.id, company_9.name, company_9.alias, company_9.email_domain, company_9.location, company_9.mail, company_9.default_referral_id, company_9.drg_threshold, company_9.drg_outlier_multiplier, company_9.ub92_report, company_9.deferred_company_id, company_9.clinassist, company_9.careassist_neonatal, company_9.careassist_pediatric, company_9.careassist_maternal, company_9.comments, company_9.exclude_clinassist_information_ps, company_9.include_clinassist_information_fr, company_9.include_facility_address_ps, company_9.include_facility_address_fr, company_9.show_amount_paid_fr, company_9.prescreen_report, company_9.exhibit_a_report, company_9.company_type, company_9.covered_lives, company_9.average_book_premium, company_9.flex_field_one_name, company_9.flex_field_two_name, company_9.createddate, company_9.onshore_data_entry_required, company_9.company_key, company_9.tax_id, company_9.client_submitter_id, company_9.use_2fa, company_9.incoming_837_name, company_9.default_workflow_pod_id, company_9.iz_required_to_start_workflow, company_9.report_publish_required_for_referral_channel, company_9.report_publish_required_for_edi_channel, company_9.disable_new_claim_processing
  • Index Cond: (company_9.id = clientfile_5.client_id)
186. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_10 (cost=0.29..8.32 rows=1 width=32) (never executed)

  • Output: CASE WHEN ((referral_10.conditioncategory)::text = 'ADULT'::text) THEN 'Adult'::text WHEN ((referral_10.conditioncategory)::text = 'MATERNAL'::text) THEN 'Maternal'::text WHEN ((referral_10.conditioncategory)::text = 'COMPLEX_NEWBORN'::text) THEN 'Neonatal'::text WHEN ((referral_10.conditioncategory)::text = 'PEDIATRIC'::text) THEN 'Pediatric'::text ELSE NULL::text END
  • Index Cond: (referral_10.id = xref_1.new_referral_id)
187. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.88..16.97 rows=1 width=6) (never executed)

  • Output: patient_17.condition
  • Inner Unique: true
188. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: stay_14.patient_id
  • Inner Unique: true
189. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_13 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_13.id, claim_13.intake, claim_13.service_start, claim_13.service_end, claim_13.total, claim_13.stay_id, claim_13.close_reason_note, claim_13.close_reason, claim_13.status, claim_13.claim_type, claim_13.closed, claim_13.prescreen_sent, claim_13.conversion_date, claim_13.forensic_sent, claim_13.documentation_received, claim_13.documentation_required, claim_13.appeal_received, claim_13.appeal_response_sent, claim_13.control_number, claim_13.hold_start_date, claim_13.prescreen_due, claim_13.forensic_due, claim_13.appeal_due, claim_13.appeal_response_due, claim_13.hold_reason_note, claim_13.hold_reason, claim_13.prescreen_na, claim_13.forensic_na, claim_13.initial_contact, claim_13.package_create, claim_13.package_to_facility, claim_13.fee_percentage, claim_13.pre_review_claim_payable, claim_13.payer_patient_id, claim_13.flexfield1name, claim_13.flexfield2name, claim_13.flexfield1value, claim_13.flexfield2value, claim_13.medicalrecordsstatus, claim_13.paymentstatus, claim_13.claimdatasource, claim_13.claimpaymenttype_id, claim_13.dummydatadateofreportgeneration, claim_13.primarycostdriver, claim_13.primarycostdriveramount, claim_13.clientadjustments, claim_13.adjustedbalancedue, claim_13.tagbranding, claim_13.prescreenerrorspreliminarysavingsoverride, claim_13.prescreeninconsistenciespreliminarysavingsoverride, claim_13.includesummaryofadjustedrevcodes, claim_13.estimated_billing_date, claim_13.isclinlight, claim_13.med_recs_received, claim_13.isrush, claim_13.cvtyapprovedamount, claim_13.client_contract_date, claim_13.eop_received_date, claim_13.trialclaim, claim_13.timeline_hold_dur, claim_13.itemized_recvd_date, claim_13.itemizeddiscrepancy, claim_13.response_sent, claim_13.channel, claim_13.potential_duplicate, claim_13.internal_rush, claim_13.corrected, claim_13.inactive, claim_13.no_billing
  • Index Cond: (claim_13.id = xref_1.claim_id)
190. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_14 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: stay_14.id, stay_14.admitted, stay_14.discharged, stay_14.medical_record, stay_14.facility_id, stay_14.patient_id, stay_14.in_network, stay_14.network, stay_14.control_number, stay_14.discount, stay_14.estimated_resolution_date, stay_14.closed, stay_14.close_reason_note, stay_14.close_reason, stay_14.status, stay_14.opened, stay_14.drg_code, stay_14.drg_threshold, stay_14.next_com, stay_14.drg_outlier_multiplier, stay_14.drg_cap_addon, stay_14.retainer, stay_14.retainer_comment, stay_14.care_to_clin_conversion_date, stay_14.drg_client_exceptions, stay_14.standard_drg, stay_14.drg_contractual_rate, stay_14.drg_cost_to_charge_ratio, stay_14.drg_extra_allowance, stay_14.drg_special_multiplier, stay_14.apply_client_exceptions, stay_14.referral_id, stay_14.networkstatus
  • Index Cond: (stay_14.id = claim_13.stay_id)
191. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_17 (cost=0.29..0.35 rows=1 width=10) (never executed)

  • Output: patient_17.id, patient_17.contact_id, patient_17.gender, patient_17.birth_date, patient_17.client_file_id, patient_17.parental_relationship, patient_17.condition, patient_17.gestational_age, patient_17.estimated_length_of_stay, patient_17.ignore, patient_17.birth_weight, patient_17.race, patient_17.apgar_1, patient_17.apgar_2, patient_17.apgar_3, patient_17.apgar_4, patient_17.patient_id, patient_17.payer_patient_id
  • Index Cond: (patient_17.id = stay_14.patient_id)
192. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=6) (never executed)

  • Output: patient_18.condition
  • Inner Unique: true
193. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_15 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_15.id, stay_15.admitted, stay_15.discharged, stay_15.medical_record, stay_15.facility_id, stay_15.patient_id, stay_15.in_network, stay_15.network, stay_15.control_number, stay_15.discount, stay_15.estimated_resolution_date, stay_15.closed, stay_15.close_reason_note, stay_15.close_reason, stay_15.status, stay_15.opened, stay_15.drg_code, stay_15.drg_threshold, stay_15.next_com, stay_15.drg_outlier_multiplier, stay_15.drg_cap_addon, stay_15.retainer, stay_15.retainer_comment, stay_15.care_to_clin_conversion_date, stay_15.drg_client_exceptions, stay_15.standard_drg, stay_15.drg_contractual_rate, stay_15.drg_cost_to_charge_ratio, stay_15.drg_extra_allowance, stay_15.drg_special_multiplier, stay_15.apply_client_exceptions, stay_15.referral_id, stay_15.networkstatus
  • Index Cond: (stay_15.id = xref_1.stay_id)
194. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_18 (cost=0.29..8.31 rows=1 width=10) (never executed)

  • Output: patient_18.id, patient_18.contact_id, patient_18.gender, patient_18.birth_date, patient_18.client_file_id, patient_18.parental_relationship, patient_18.condition, patient_18.gestational_age, patient_18.estimated_length_of_stay, patient_18.ignore, patient_18.birth_weight, patient_18.race, patient_18.apgar_1, patient_18.apgar_2, patient_18.apgar_3, patient_18.apgar_4, patient_18.patient_id, patient_18.payer_patient_id
  • Index Cond: (patient_18.id = stay_15.patient_id)
195. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_pkey on public.patient patient_19 (cost=0.29..8.31 rows=1 width=6) (never executed)

  • Output: patient_19.condition
  • Index Cond: (patient_19.id = xref_1.patient_id)
196. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=30) (never executed)

  • Output: pendingcompany_1.name
  • Inner Unique: true
197. 0.000 0.000 ↓ 0.0 0

Index Scan using newreferral_pkey on public.newreferral referral_11 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: referral_11.referraltype, referral_11.id, referral_11.version, referral_11.comments, referral_11.trial, referral_11.conditioncategory, referral_11.createddate, referral_11.policyholder, referral_11.gestation, referral_11.referralcontact_id, referral_11.pendingpatient_id, referral_11.pendingclaim_id, referral_11.provider_id, referral_11.invoicecompany_id, referral_11.referringcompany_id, referral_11.clientfile_id, referral_11.originator_id, referral_11.onbehalfofcompany_id, referral_11.gestationweeks, referral_11.gestationdays, referral_11.babieslastname, referral_11.birthfacilityisdifferentfromprovider, referral_11.birthfacility_id, referral_11.invoicecomments, referral_11.companyiwanttoaffiliatedoesnotexist, referral_11.nonexistentaffiliatecompanyname, referral_11.internalsubmitter_id
  • Index Cond: (referral_11.id = xref_1.new_referral_id)
198. 0.000 0.000 ↓ 0.0 0

Index Scan using pendingcompany_pkey on public.pendingcompany pendingcompany_1 (cost=0.29..8.31 rows=1 width=34) (never executed)

  • Output: pendingcompany_1.id, pendingcompany_1.name, pendingcompany_1.state, pendingcompany_1.version, pendingcompany_1.phone, pendingcompany_1.city, pendingcompany_1.zipcode, pendingcompany_1.addressline1, pendingcompany_1.addressline2, pendingcompany_1.providertype, pendingcompany_1.contacttype, pendingcompany_1.contactphone, pendingcompany_1.contactemail, pendingcompany_1.contactfirstname, pendingcompany_1.contactlastname, pendingcompany_1.contacttitle, pendingcompany_1.contactfax, pendingcompany_1.networkstatus, pendingcompany_1.networkname, pendingcompany_1.networkrestrictions, pendingcompany_1.admissiondate, pendingcompany_1.preexistingcompanymatchfound, pendingcompany_1.preexistingcompanymatchid, pendingcompany_1.npinumber
  • Index Cond: (pendingcompany_1.id = referral_11.provider_id)
199. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.61 rows=1 width=31) (never executed)

  • Output: provider_2.name
  • Inner Unique: true
200. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_16 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_16.id, stay_16.admitted, stay_16.discharged, stay_16.medical_record, stay_16.facility_id, stay_16.patient_id, stay_16.in_network, stay_16.network, stay_16.control_number, stay_16.discount, stay_16.estimated_resolution_date, stay_16.closed, stay_16.close_reason_note, stay_16.close_reason, stay_16.status, stay_16.opened, stay_16.drg_code, stay_16.drg_threshold, stay_16.next_com, stay_16.drg_outlier_multiplier, stay_16.drg_cap_addon, stay_16.retainer, stay_16.retainer_comment, stay_16.care_to_clin_conversion_date, stay_16.drg_client_exceptions, stay_16.standard_drg, stay_16.drg_contractual_rate, stay_16.drg_cost_to_charge_ratio, stay_16.drg_extra_allowance, stay_16.drg_special_multiplier, stay_16.apply_client_exceptions, stay_16.referral_id, stay_16.networkstatus
  • Index Cond: (stay_16.id = xref_1.stay_id)
201. 0.000 0.000 ↓ 0.0 0

Index Scan using provider_pkey on public.provider provider_2 (cost=0.28..8.30 rows=1 width=35) (never executed)

  • Output: provider_2.id, provider_2.npi_number, provider_2.name, provider_2.alias, provider_2.location, provider_2.mail, provider_2.comments, provider_2.createddate, provider_2.provider_key, provider_2.tax_id, provider_2.type_id, provider_2.valid_npi_number
  • Index Cond: (provider_2.id = stay_16.facility_id)
202. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..16.93 rows=1 width=31) (never executed)

  • Output: provider_3.name
  • Inner Unique: true
203. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=4) (never executed)

  • Output: stay_17.facility_id
  • Inner Unique: true
204. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_14 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_14.id, claim_14.intake, claim_14.service_start, claim_14.service_end, claim_14.total, claim_14.stay_id, claim_14.close_reason_note, claim_14.close_reason, claim_14.status, claim_14.claim_type, claim_14.closed, claim_14.prescreen_sent, claim_14.conversion_date, claim_14.forensic_sent, claim_14.documentation_received, claim_14.documentation_required, claim_14.appeal_received, claim_14.appeal_response_sent, claim_14.control_number, claim_14.hold_start_date, claim_14.prescreen_due, claim_14.forensic_due, claim_14.appeal_due, claim_14.appeal_response_due, claim_14.hold_reason_note, claim_14.hold_reason, claim_14.prescreen_na, claim_14.forensic_na, claim_14.initial_contact, claim_14.package_create, claim_14.package_to_facility, claim_14.fee_percentage, claim_14.pre_review_claim_payable, claim_14.payer_patient_id, claim_14.flexfield1name, claim_14.flexfield2name, claim_14.flexfield1value, claim_14.flexfield2value, claim_14.medicalrecordsstatus, claim_14.paymentstatus, claim_14.claimdatasource, claim_14.claimpaymenttype_id, claim_14.dummydatadateofreportgeneration, claim_14.primarycostdriver, claim_14.primarycostdriveramount, claim_14.clientadjustments, claim_14.adjustedbalancedue, claim_14.tagbranding, claim_14.prescreenerrorspreliminarysavingsoverride, claim_14.prescreeninconsistenciespreliminarysavingsoverride, claim_14.includesummaryofadjustedrevcodes, claim_14.estimated_billing_date, claim_14.isclinlight, claim_14.med_recs_received, claim_14.isrush, claim_14.cvtyapprovedamount, claim_14.client_contract_date, claim_14.eop_received_date, claim_14.trialclaim, claim_14.timeline_hold_dur, claim_14.itemized_recvd_date, claim_14.itemizeddiscrepancy, claim_14.response_sent, claim_14.channel, claim_14.potential_duplicate, claim_14.internal_rush, claim_14.corrected, claim_14.inactive, claim_14.no_billing
  • Index Cond: (claim_14.id = xref_1.claim_id)
205. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_17 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: stay_17.id, stay_17.admitted, stay_17.discharged, stay_17.medical_record, stay_17.facility_id, stay_17.patient_id, stay_17.in_network, stay_17.network, stay_17.control_number, stay_17.discount, stay_17.estimated_resolution_date, stay_17.closed, stay_17.close_reason_note, stay_17.close_reason, stay_17.status, stay_17.opened, stay_17.drg_code, stay_17.drg_threshold, stay_17.next_com, stay_17.drg_outlier_multiplier, stay_17.drg_cap_addon, stay_17.retainer, stay_17.retainer_comment, stay_17.care_to_clin_conversion_date, stay_17.drg_client_exceptions, stay_17.standard_drg, stay_17.drg_contractual_rate, stay_17.drg_cost_to_charge_ratio, stay_17.drg_extra_allowance, stay_17.drg_special_multiplier, stay_17.apply_client_exceptions, stay_17.referral_id, stay_17.networkstatus
  • Index Cond: (stay_17.id = claim_14.stay_id)
206. 0.000 0.000 ↓ 0.0 0

Index Scan using provider_pkey on public.provider provider_3 (cost=0.28..0.31 rows=1 width=35) (never executed)

  • Output: provider_3.id, provider_3.npi_number, provider_3.name, provider_3.alias, provider_3.location, provider_3.mail, provider_3.comments, provider_3.createddate, provider_3.provider_key, provider_3.tax_id, provider_3.type_id, provider_3.valid_npi_number
  • Index Cond: (provider_3.id = stay_17.facility_id)
207. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_15 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_15.service_start
  • Index Cond: (claim_15.id = xref_1.claim_id)
208. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_18 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_18.admitted
  • Index Cond: (stay_18.id = xref_1.stay_id)
209. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_16 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: claim_16.service_end
  • Index Cond: (claim_16.id = xref_1.claim_id)
210. 0.000 0.000 ↓ 0.0 0

Index Scan using stay_pkey on public.stay stay_19 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: stay_19.discharged
  • Index Cond: (stay_19.id = xref_1.stay_id)
211. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..16.88 rows=1 width=32) (never executed)

  • Output: CASE WHEN (process_1.end_ IS NOT NULL) THEN 'Ended'::text WHEN process_1.issuspended_ THEN 'Suspended'::text WHEN ((process_1.start_ IS NULL) AND (process_1.end_ IS NULL)) THEN 'Not Started'::text WHEN ((process_1.end_ IS NULL) AND (process_1.start_ IS NOT NULL)) THEN 'Started'::text ELSE NULL::text END
  • Inner Unique: true
212. 0.000 0.000 ↓ 0.0 0

Index Scan using jbpm_token_pkey on jbpm.jbpm_token token_1 (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Output: token_1.id_, token_1.version_, token_1.name_, token_1.start_, token_1.end_, token_1.nodeenter_, token_1.nextlogindex_, token_1.isabletoreactivateparent_, token_1.isterminationimplicit_, token_1.issuspended_, token_1.lock_, token_1.node_, token_1.processinstance_, token_1.parent_, token_1.subprocessinstance_
  • Index Cond: (task_1.token_ = token_1.id_)
213. 0.000 0.000 ↓ 0.0 0

Index Scan using jbpm_processinstance_pkey on jbpm.jbpm_processinstance process_1 (cost=0.42..8.44 rows=1 width=25) (never executed)

  • Output: process_1.id_, process_1.version_, process_1.key_, process_1.start_, process_1.end_, process_1.issuspended_, process_1.processdefinition_, process_1.roottoken_, process_1.superprocesstoken_
  • Index Cond: (process_1.id_ = token_1.processinstance_)
214. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_17 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: claim_17.prescreen_due
  • Index Cond: (claim_17.id = xref_1.claim_id)
215. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_18 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: claim_18.forensic_due
  • Index Cond: (claim_18.id = xref_1.claim_id)
216. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_19 (cost=0.29..8.31 rows=1 width=1) (never executed)

  • Output: claim_19.isrush
  • Index Cond: (claim_19.id = xref_1.claim_id)
217. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_20 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: claim_20.total
  • Index Cond: (claim_20.id = xref_1.claim_id)
218. 0.000 0.000 ↓ 0.0 0

Index Scan using claim_pkey on public.claim claim_21 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: claim_21.total
  • Index Cond: (claim_21.id = xref_1.claim_id)
Planning time : 38.706 ms
Execution time : 67.574 ms