explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8BwN

Settings
# exclusive inclusive rows x rows loops node
1. 2.879 3,444.609 ↑ 51.5 159 1

Hash Left Join (cost=35,489.38..207,969.94 rows=8,194 width=3,846) (actual time=1,015.110..3,444.609 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, CASE WHEN (t2_0.ssn_unmasked IS NOT NULL) THEN concat('xxx-xx-', "right"(t2_0.ssn_unmasked, 4)) ELSE ''::text END, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason, t14_0.shift_desc, t15_0.reference, t16_0.ada_sensitive, t16_0.eeo_class_code, t16_0.eeo_group_code, t16_0.exempt, t16_0.flsa_type, t16_0.job_title, t18_0.address, t18_0.cert_peo, t18_0.city, t18_0.ein, t18_0.employer_name, t18_0.employer_print_name, t18_0.obsolete, t18_0.state, t18_0.zip_code, t18_0.zip_suffix, t17_0.addr_one, t17_0.addr_two, t17_0.business, t17_0.cafeteria_plan, t17_0.category_cd, t17_0.city, t17_0.client_name, t17_0.company_mods, t17_0.consultant, t17_0.contract_date, t17_0.contractors_allowed, t17_0.control_client, t17_0.convert_date, t17_0.corp_type, t17_0.cost_center, t17_0.do_not_svc, t17_0.employer_id, t17_0.entity_id, t17_0.esac_q1, t17_0.fed_id_num, t17_0.gl_template_code, t17_0.group_code, t17_0.hab_id, t17_0.hsa_plan, t17_0.legal_name, t17_0.main_tel_ext, t17_0.naics_code, t17_0.payroll_date, t17_0.payroll_rep, t17_0.railroad_er, t17_0.reg_locn_code, t17_0.risk_mgr, t17_0.salesperson, t17_0.service_type, t17_0.sic_code, t17_0.state_code, t17_0.status, t17_0.status_date, t17_0.sub_cost_ctr, t17_0.telephone, t17_0.wc_bill_based_on, t17_0.wc_eff_date, t17_0.wc_expiration_date, t17_0.wc_policy, t17_0.wc_policy_subid, t17_0.wc_loc_based, t17_0.zip_code, t17_0.zip_suffix, t19_0.entity_name, t19_0.ein, t19_0.address, t19_0.city, t19_0.state, t19_0.zip_code, t20_0.location, t20_0.addr_one, t20_0.addr_two, t20_0.city, t20_0.construct_type, t20_0.county, t20_0.entity_id, t20_0.geo_code, t20_0.highest_floor_occ, t20_0.latitude, t20_0.location_code, t20_0.longitude, t20_0.max_ees_on_site, t20_0.obsolete_date, t20_0.obsolete_loc, t20_0.or_transit, t20_0.ruleset_id, t20_0.sales_tax_code, t20_0.sb_tax_pcnt, t20_0.sprinklers, t20_0.state_code, t20_0.story_cnt, t20_0.subject_to_oh_sers, t20_0.union_location, t20_0.worksite_id, t20_0.year_built, t20_0.zip_code, t20_0.zip_suffix, t20_0.work_comp_state, (SubPlan 1), (SubPlan 2), t5_0.status_class, t2_0.form_i9, t21_0.drug_result, t21_0.last_audio, t21_0.last_drug_test, t21_0.last_physical, t21_0.next_audio, t21_0.next_drug_test, t21_0.next_physical, t21_0.phys_result, CASE WHEN (t2_0.i9_ssn IS NOT NULL) THEN concat('xxx-xx-', "right"(t2_0.i9_ssn, 4)) ELSE ''::text END, t2_0.tax_credit, (SubPlan 3), t2_0.i9_ssn, t2_0.ssn_unmasked, t22_0.user_id
  • Hash Cond: ((t1_0.employee_id = t22_0.employee_id) AND (t1_0.peo_id = t22_0.peo_id))
  • Buffers: shared hit=1,162,557, temp read=12,126 written=12,580
2. 0.828 3,393.616 ↑ 51.5 159 1

Nested Loop Left Join (cost=29,417.02..145,944.46 rows=8,194 width=4,019) (actual time=969.469..3,393.616 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason, t14_0.shift_desc, t15_0.reference, t16_0.ada_sensitive, t16_0.eeo_class_code, t16_0.eeo_group_code, t16_0.exempt, t16_0.flsa_type, t16_0.job_title, t16_0.record, t17_0.addr_one, t17_0.addr_two, t17_0.business, t17_0.cafeteria_plan, t17_0.category_cd, t17_0.city, t17_0.client_name, t17_0.company_mods, t17_0.consultant, t17_0.contract_date, t17_0.contractors_allowed, t17_0.control_client, t17_0.convert_date, t17_0.corp_type, t17_0.cost_center, t17_0.do_not_svc, t17_0.employer_id, t17_0.entity_id, t17_0.esac_q1, t17_0.fed_id_num, t17_0.gl_template_code, t17_0.group_code, t17_0.hab_id, t17_0.hsa_plan, t17_0.legal_name, t17_0.main_tel_ext, t17_0.naics_code, t17_0.payroll_date, t17_0.payroll_rep, t17_0.railroad_er, t17_0.reg_locn_code, t17_0.risk_mgr, t17_0.salesperson, t17_0.service_type, t17_0.sic_code, t17_0.state_code, t17_0.status, t17_0.status_date, t17_0.sub_cost_ctr, t17_0.telephone, t17_0.wc_bill_based_on, t17_0.wc_eff_date, t17_0.wc_expiration_date, t17_0.wc_policy, t17_0.wc_policy_subid, t17_0.wc_loc_based, t17_0.zip_code, t17_0.zip_suffix, t18_0.address, t18_0.cert_peo, t18_0.city, t18_0.ein, t18_0.employer_name, t18_0.employer_print_name, t18_0.obsolete, t18_0.state, t18_0.zip_code, t18_0.zip_suffix, t19_0.entity_name, t19_0.ein, t19_0.address, t19_0.city, t19_0.state, t19_0.zip_code, t20_0.location, t20_0.addr_one, t20_0.addr_two, t20_0.city, t20_0.construct_type, t20_0.county, t20_0.entity_id, t20_0.geo_code, t20_0.highest_floor_occ, t20_0.latitude, t20_0.location_code, t20_0.longitude, t20_0.max_ees_on_site, t20_0.obsolete_date, t20_0.obsolete_loc, t20_0.or_transit, t20_0.ruleset_id, t20_0.sales_tax_code, t20_0.sb_tax_pcnt, t20_0.sprinklers, t20_0.state_code, t20_0.story_cnt, t20_0.subject_to_oh_sers, t20_0.union_location, t20_0.worksite_id, t20_0.year_built, t20_0.zip_code, t20_0.zip_suffix, t20_0.work_comp_state, t20_0.record, t21_0.drug_result, t21_0.last_audio, t21_0.last_drug_test, t21_0.last_physical, t21_0.next_audio, t21_0.next_drug_test, t21_0.next_physical, t21_0.phys_result
  • Inner Unique: true
  • Buffers: shared hit=1,157,836, temp read=12,126 written=12,580
3. 0.409 3,391.516 ↑ 13.3 159 1

Hash Left Join (cost=29,416.74..145,286.83 rows=2,111 width=3,688) (actual time=969.432..3,391.516 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason, t14_0.shift_desc, t15_0.reference, t16_0.ada_sensitive, t16_0.eeo_class_code, t16_0.eeo_group_code, t16_0.exempt, t16_0.flsa_type, t16_0.job_title, t16_0.record, t17_0.addr_one, t17_0.addr_two, t17_0.business, t17_0.cafeteria_plan, t17_0.category_cd, t17_0.city, t17_0.client_name, t17_0.company_mods, t17_0.consultant, t17_0.contract_date, t17_0.contractors_allowed, t17_0.control_client, t17_0.convert_date, t17_0.corp_type, t17_0.cost_center, t17_0.do_not_svc, t17_0.employer_id, t17_0.entity_id, t17_0.esac_q1, t17_0.fed_id_num, t17_0.gl_template_code, t17_0.group_code, t17_0.hab_id, t17_0.hsa_plan, t17_0.legal_name, t17_0.main_tel_ext, t17_0.naics_code, t17_0.payroll_date, t17_0.payroll_rep, t17_0.railroad_er, t17_0.reg_locn_code, t17_0.risk_mgr, t17_0.salesperson, t17_0.service_type, t17_0.sic_code, t17_0.state_code, t17_0.status, t17_0.status_date, t17_0.sub_cost_ctr, t17_0.telephone, t17_0.wc_bill_based_on, t17_0.wc_eff_date, t17_0.wc_expiration_date, t17_0.wc_policy, t17_0.wc_policy_subid, t17_0.wc_loc_based, t17_0.zip_code, t17_0.zip_suffix, t18_0.address, t18_0.cert_peo, t18_0.city, t18_0.ein, t18_0.employer_name, t18_0.employer_print_name, t18_0.obsolete, t18_0.state, t18_0.zip_code, t18_0.zip_suffix, t19_0.entity_name, t19_0.ein, t19_0.address, t19_0.city, t19_0.state, t19_0.zip_code, t21_0.drug_result, t21_0.last_audio, t21_0.last_drug_test, t21_0.last_physical, t21_0.next_audio, t21_0.next_drug_test, t21_0.next_physical, t21_0.phys_result
  • Inner Unique: true
  • Hash Cond: ((t17_0.entity_id = t19_0.entity_id) AND (t17_0.peo_id = t19_0.peo_id))
  • Buffers: shared hit=1,157,369, temp read=12,126 written=12,580
4. 5.215 3,391.097 ↑ 13.3 159 1

Hash Left Join (cost=29,415.64..145,274.65 rows=2,111 width=3,628) (actual time=969.400..3,391.097 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason, t14_0.shift_desc, t15_0.reference, t16_0.ada_sensitive, t16_0.eeo_class_code, t16_0.eeo_group_code, t16_0.exempt, t16_0.flsa_type, t16_0.job_title, t16_0.record, t17_0.addr_one, t17_0.addr_two, t17_0.business, t17_0.cafeteria_plan, t17_0.category_cd, t17_0.city, t17_0.client_name, t17_0.company_mods, t17_0.consultant, t17_0.contract_date, t17_0.contractors_allowed, t17_0.control_client, t17_0.convert_date, t17_0.corp_type, t17_0.cost_center, t17_0.do_not_svc, t17_0.employer_id, t17_0.entity_id, t17_0.esac_q1, t17_0.fed_id_num, t17_0.gl_template_code, t17_0.group_code, t17_0.hab_id, t17_0.hsa_plan, t17_0.legal_name, t17_0.main_tel_ext, t17_0.naics_code, t17_0.payroll_date, t17_0.payroll_rep, t17_0.railroad_er, t17_0.reg_locn_code, t17_0.risk_mgr, t17_0.salesperson, t17_0.service_type, t17_0.sic_code, t17_0.state_code, t17_0.status, t17_0.status_date, t17_0.sub_cost_ctr, t17_0.telephone, t17_0.wc_bill_based_on, t17_0.wc_eff_date, t17_0.wc_expiration_date, t17_0.wc_policy, t17_0.wc_policy_subid, t17_0.wc_loc_based, t17_0.zip_code, t17_0.zip_suffix, t17_0.peo_id, t18_0.address, t18_0.cert_peo, t18_0.city, t18_0.ein, t18_0.employer_name, t18_0.employer_print_name, t18_0.obsolete, t18_0.state, t18_0.zip_code, t18_0.zip_suffix, t21_0.drug_result, t21_0.last_audio, t21_0.last_drug_test, t21_0.last_physical, t21_0.next_audio, t21_0.next_drug_test, t21_0.next_physical, t21_0.phys_result
  • Inner Unique: true
  • Hash Cond: ((t17_0.employer_id = t18_0.employer_id) AND (t17_0.peo_id = t18_0.peo_id))
  • Buffers: shared hit=1,157,368, temp read=12,126 written=12,580
5. 1.389 3,385.746 ↑ 13.3 159 1

Nested Loop Left Join (cost=29,403.46..145,251.34 rows=2,111 width=3,520) (actual time=969.239..3,385.746 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason, t14_0.shift_desc, t15_0.reference, t16_0.ada_sensitive, t16_0.eeo_class_code, t16_0.eeo_group_code, t16_0.exempt, t16_0.flsa_type, t16_0.job_title, t16_0.record, t17_0.addr_one, t17_0.addr_two, t17_0.business, t17_0.cafeteria_plan, t17_0.category_cd, t17_0.city, t17_0.client_name, t17_0.company_mods, t17_0.consultant, t17_0.contract_date, t17_0.contractors_allowed, t17_0.control_client, t17_0.convert_date, t17_0.corp_type, t17_0.cost_center, t17_0.do_not_svc, t17_0.employer_id, t17_0.entity_id, t17_0.esac_q1, t17_0.fed_id_num, t17_0.gl_template_code, t17_0.group_code, t17_0.hab_id, t17_0.hsa_plan, t17_0.legal_name, t17_0.main_tel_ext, t17_0.naics_code, t17_0.payroll_date, t17_0.payroll_rep, t17_0.railroad_er, t17_0.reg_locn_code, t17_0.risk_mgr, t17_0.salesperson, t17_0.service_type, t17_0.sic_code, t17_0.state_code, t17_0.status, t17_0.status_date, t17_0.sub_cost_ctr, t17_0.telephone, t17_0.wc_bill_based_on, t17_0.wc_eff_date, t17_0.wc_expiration_date, t17_0.wc_policy, t17_0.wc_policy_subid, t17_0.wc_loc_based, t17_0.zip_code, t17_0.zip_suffix, t17_0.peo_id, t21_0.drug_result, t21_0.last_audio, t21_0.last_drug_test, t21_0.last_physical, t21_0.next_audio, t21_0.next_drug_test, t21_0.next_physical, t21_0.phys_result
  • Inner Unique: true
  • Buffers: shared hit=1,157,358, temp read=12,126 written=12,580
6. 0.525 3,383.403 ↑ 13.3 159 1

Hash Left Join (cost=29,403.18..144,612.82 rows=2,111 width=3,122) (actual time=969.196..3,383.403 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason, t14_0.shift_desc, t15_0.reference, t16_0.ada_sensitive, t16_0.eeo_class_code, t16_0.eeo_group_code, t16_0.exempt, t16_0.flsa_type, t16_0.job_title, t16_0.record, t21_0.drug_result, t21_0.last_audio, t21_0.last_drug_test, t21_0.last_physical, t21_0.next_audio, t21_0.next_drug_test, t21_0.next_physical, t21_0.phys_result
  • Inner Unique: true
  • Hash Cond: ((t8_0.peo_id = t16_0.peo_id) AND (t8_0.job_class = t16_0.pos_class))
  • Buffers: shared hit=1,156,891, temp read=12,126 written=12,580
7. 0.500 3,380.905 ↑ 13.3 159 1

Hash Left Join (cost=29,249.83..144,448.37 rows=2,111 width=2,754) (actual time=967.199..3,380.905 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t8_0.peo_id, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason, t14_0.shift_desc, t15_0.reference, t21_0.drug_result, t21_0.last_audio, t21_0.last_drug_test, t21_0.last_physical, t21_0.next_audio, t21_0.next_drug_test, t21_0.next_physical, t21_0.phys_result
  • Inner Unique: true
  • Hash Cond: ((t2_0.peo_id = t15_0.peo_id) AND (t2_0.client_id = t15_0.client_id) AND (t2_0.pay_group = t15_0.pay_group))
  • Buffers: shared hit=1,156,788, temp read=12,126 written=12,580
8. 0.781 3,378.692 ↑ 13.3 159 1

Nested Loop Left Join (cost=28,995.91..144,177.83 rows=2,111 width=2,740) (actual time=965.462..3,378.692 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t8_0.peo_id, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason, t14_0.shift_desc, t21_0.drug_result, t21_0.last_audio, t21_0.last_drug_test, t21_0.last_physical, t21_0.next_audio, t21_0.next_drug_test, t21_0.next_physical, t21_0.phys_result
  • Inner Unique: true
  • Buffers: shared hit=1,156,586, temp read=12,126 written=12,580
9. 0.575 3,374.413 ↑ 13.3 159 1

Nested Loop Left Join (cost=28,995.49..143,170.28 rows=2,111 width=2,690) (actual time=965.429..3,374.413 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t8_0.peo_id, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason, t14_0.shift_desc
  • Inner Unique: true
  • Buffers: shared hit=1,155,960, temp read=12,126 written=12,580
10. 0.656 3,373.679 ↑ 1.6 159 1

Nested Loop Left Join (cost=28,995.22..143,093.10 rows=257 width=2,683) (actual time=965.413..3,373.679 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t8_0.peo_id, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name, t13_0.reason
  • Inner Unique: true
  • Buffers: shared hit=1,155,942, temp read=12,126 written=12,580
11. 0.691 3,372.864 ↑ 1.6 159 1

Nested Loop Left Join (cost=28,995.07..143,050.05 rows=257 width=2,665) (actual time=965.392..3,372.864 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t8_0.peo_id, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity, t12_0.user_name
  • Inner Unique: true
  • Buffers: shared hit=1,155,890, temp read=12,126 written=12,580
12. 0.709 3,372.173 ↑ 1.6 159 1

Nested Loop Left Join (cost=28,994.65..142,919.89 rows=257 width=2,653) (actual time=965.374..3,372.173 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t8_0.peo_id, t9_0.union_desc, t10_0.group_name, t11_0.ethnicity
  • Inner Unique: true
  • Buffers: shared hit=1,155,887, temp read=12,126 written=12,580
13. 0.666 3,370.987 ↑ 1.6 159 1

Nested Loop Left Join (cost=28,994.52..142,879.54 rows=257 width=2,634) (actual time=965.350..3,370.987 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t8_0.peo_id, t9_0.union_desc, t10_0.group_name
  • Inner Unique: true
  • Buffers: shared hit=1,155,589, temp read=12,126 written=12,580
14. 0.749 3,369.208 ↑ 1.6 159 1

Nested Loop Left Join (cost=28,994.24..142,802.22 rows=257 width=2,626) (actual time=965.320..3,369.208 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t8_0.peo_id, t9_0.union_desc
  • Inner Unique: true
  • Buffers: shared hit=1,155,121, temp read=12,126 written=12,580
15. 0.794 3,368.459 ↑ 1.6 159 1

Nested Loop Left Join (cost=28,993.97..142,727.01 rows=257 width=2,608) (actual time=965.299..3,368.459 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description, t8_0.alaska_job_code, t8_0.dot_flag, t8_0.hierarchy_tier, t8_0.indirect_tip, t8_0.job_class, t8_0.job_title, t8_0.obsolete, t8_0.per_diem_pcnt, t8_0.pr_chauffeur, t8_0.prev_wage, t8_0.price_code, t8_0.probation_days, t8_0.salary_grade, t8_0.sales_position, t8_0.soc_code, t8_0.supervisory, t8_0.suppress_work_state_tax, t8_0.tipped_position, t8_0.union_code_override, t8_0.wc_loc_based, t8_0.peo_id
  • Inner Unique: true
  • Buffers: shared hit=1,155,121, temp read=12,126 written=12,580
16. 0.671 3,366.234 ↑ 1.6 159 1

Nested Loop Left Join (cost=28,993.68..142,645.85 rows=257 width=2,341) (actual time=965.266..3,366.234 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t3_0.department, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description
  • Inner Unique: true
  • Buffers: shared hit=1,154,654, temp read=12,126 written=12,580
17. 0.358 3,365.245 ↑ 1.6 159 1

Hash Left Join (cost=28,993.40..142,565.92 rows=257 width=2,329) (actual time=965.245..3,365.245 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc, t7_0.description
  • Inner Unique: true
  • Hash Cond: ((t0_0.client_id = t7_0.client_id) AND (t0_0.peo_id = t7_0.peo_id) AND (t0_0.work_group_code = t7_0.work_group))
  • Buffers: shared hit=1,154,572, temp read=12,126 written=12,580
18. 0.402 3,364.839 ↑ 1.6 159 1

Hash Left Join (cost=28,990.66..142,561.16 rows=257 width=2,316) (actual time=965.178..3,364.839 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t6_0.type_desc, t6_0.abbrev_desc
  • Inner Unique: true
  • Hash Cond: ((t0_0.type_code = t6_0.type_code) AND (t0_0.peo_id = t6_0.peo_id))
  • Buffers: shared hit=1,154,571, temp read=12,126 written=12,580
19. 0.436 3,364.409 ↑ 1.6 159 1

Hash Left Join (cost=28,977.41..142,546.56 rows=257 width=2,252) (actual time=965.132..3,364.409 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t4_0.division_name, t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class
  • Inner Unique: true
  • Hash Cond: ((t0_0.status_code = t5_0.status_code) AND (t0_0.peo_id = t5_0.peo_id))
  • Buffers: shared hit=1,154,570, temp read=12,126 written=12,580
20. 0.000 3,363.955 ↑ 1.6 159 1

Hash Left Join (cost=28,963.66..142,531.46 rows=257 width=2,156) (actual time=965.094..3,363.955 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t4_0.division_name
  • Inner Unique: true
  • Hash Cond: ((t0_0.division_code = t4_0.division_code) AND (t0_0.peo_id = t4_0.peo_id) AND (t0_0.client_id = t4_0.client_id))
  • Buffers: shared hit=1,154,569, temp read=12,126 written=12,580
21. 0.000 3,386.506 ↑ 1.6 159 1

Gather (cost=28,939.70..142,505.47 rows=257 width=2,141) (actual time=964.701..3,386.506 rows=159 loops=1)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1,154,562, temp read=12,126 written=12,580
22. 156.110 3,394.945 ↑ 2.0 53 3 / 3

Nested Loop Left Join (cost=27,939.70..141,479.77 rows=107 width=2,141) (actual time=845.852..3,394.945 rows=53 loops=3)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id
  • Inner Unique: true
  • Filter: ((t0_0.modified > '2020-05-01 17:48:04.885'::timestamp without time zone) OR (t2_0.modified > '2020-05-01 17:48:04.885'::timestamp without time zone) OR (t1_0.modified > '2020-05-01 17:48:04.885'::timestamp without time zone))
  • Rows Removed by Filter: 94,052
  • Buffers: shared hit=1,154,562, temp read=12,126 written=12,580
  • Worker 0: actual time=821.838..3416.395 rows=52 loops=1
  • Buffers: shared hit=381,617, temp read=4,028 written=4,344
  • Worker 1: actual time=754.307..3413.955 rows=56 loops=1
  • Buffers: shared hit=379,524, temp read=3,900 written=3,900
23. 588.115 1,168.525 ↑ 1.2 94,105 3 / 3

Parallel Hash Left Join (cost=27,939.27..63,877.15 rows=117,631 width=1,232) (actual time=766.522..1,168.525 rows=94,105 loops=3)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t0_0.modified, t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t1_0.modified
  • Inner Unique: true
  • Hash Cond: ((t0_0.peo_id = t1_0.peo_id) AND (t0_0.employee_id = t1_0.employee_id))
  • Buffers: shared hit=22,807, temp read=12,126 written=12,580
  • Worker 0: actual time=765.600..1129.343 rows=93,162 loops=1
  • Buffers: shared hit=8,151, temp read=4,028 written=4,344
  • Worker 1: actual time=753.447..1162.862 rows=92,952 loops=1
  • Buffers: shared hit=6,960, temp read=3,900 written=3,900
24. 187.866 187.866 ↑ 1.2 94,105 3 / 3

Parallel Seq Scan on public.employee_com t0_0 (cost=0.00..7,659.31 rows=117,631 width=628) (actual time=0.012..187.866 rows=94,105 loops=3)

  • Output: t0_0.applicant_id, t0_0.ben_email_address, t0_0.ben_email_opt_in_date, t0_0.ben_email_opt_out_date, t0_0.benefit_group, t0_0.business_owner, t0_0.client_id, t0_0.clock_no, t0_0.contact_email, t0_0.court_order_med, t0_0.cs_in_arrears, t0_0.dept_code, t0_0.division_code, t0_0.elec_onboard, t0_0.elec_onboard_date, t0_0.employee_id, t0_0.employee_no, t0_0.enroll_suspend_type, t0_0.evs_date, t0_0.hierarchy_tier, t0_0.hire_date, t0_0.hndbk_mailed, t0_0.hndbk_recvd, t0_0.job_code, t0_0.job_start_date, t0_0.last_conf_date, t0_0.last_conf_id, t0_0.last_hire, t0_0.last_job_change_date, t0_0.last_status_change_date, t0_0.location_code, t0_0.mail_addr_one, t0_0.mail_addr_two, t0_0.mail_city, t0_0.mail_state, t0_0.mail_suffix, t0_0.mail_zip, t0_0.nh_rpt_date, t0_0.ob_ready, t0_0.officer, t0_0.onboard_inprogress, t0_0.onhrp_ben_enr_susp_until, t0_0.peo_id, t0_0.probation_date, t0_0.proj_workord, t0_0.rehire_okay, t0_0.reports_to, t0_0.return_date, t0_0.scorp_owner, t0_0.self_id_disability, t0_0.seniority_date, t0_0.status_code, t0_0.status_date, t0_0.supports_other, t0_0.ten99_flag, t0_0.term_reason_code, t0_0.type_code, t0_0.type_date, t0_0.union_code, t0_0.wc_exempt, t0_0.wc_officer, t0_0.work_email_address, t0_0.work_ext, t0_0.work_group_code, t0_0.work_phone, t0_0.wotc_status, t0_0.modified
  • Buffers: shared hit=6,483
  • Worker 0: actual time=0.011..167.653 rows=91,362 loops=1
  • Buffers: shared hit=2,115
  • Worker 1: actual time=0.012..223.038 rows=89,217 loops=1
  • Buffers: shared hit=2,056
25. 205.199 392.544 ↑ 1.2 91,465 3 / 3

Parallel Hash (cost=17,403.31..17,403.31 rows=114,331 width=604) (actual time=392.543..392.544 rows=91,465 loops=3)

  • Output: t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t1_0.modified
  • Buckets: 8,192 Batches: 64 Memory Usage: 992kB
  • Buffers: shared hit=16,260, temp written=6,920
  • Worker 0: actual time=386.089..386.090 rows=101,200 loops=1
  • Buffers: shared hit=6,004, temp written=2,528
  • Worker 1: actual time=383.319..383.319 rows=82,339 loops=1
  • Buffers: shared hit=4,872, temp written=2,104
26. 187.345 187.345 ↑ 1.2 91,465 3 / 3

Parallel Seq Scan on public.employee_per t1_0 (cost=0.00..17,403.31 rows=114,331 width=604) (actual time=0.009..187.345 rows=91,465 loops=3)

  • Output: t1_0.address_one, t1_0.address_two, t1_0.agri_worker, t1_0.bh_candidate_id, t1_0.birth_date, t1_0.blind, t1_0.carrier_reported, t1_0.citizen, t1_0.city, t1_0.cobra_only, t1_0.county, t1_0.date_married, t1_0.death_date, t1_0.deceased, t1_0.disabled_vet, t1_0.driv_lic_class, t1_0.driver_state, t1_0.driv_lic_no, t1_0.e_w2_elect_date, t1_0.elec_w2_form, t1_0.email_address, t1_0.ethnic_code, t1_0.first_name, t1_0.form_c112, t1_0.gender, t1_0.geo_code, t1_0.handicapped, t1_0.high_comp, t1_0.hispanic_yn, t1_0.last_name, t1_0.key_employee, t1_0.legacy_empid, t1_0.lic_exp_date, t1_0.marital_status, t1_0.middle_init, t1_0.nickname, t1_0.oth_prot_vet, t1_0.over_geocode, t1_0.over_geo_thru_date, t1_0.peo_start_dt, t1_0.probation_date, t1_0.psd_code, t1_0.rec_sep_vet, t1_0.school_district, t1_0.ser_med_vet, t1_0.smoker, t1_0.sort_name, t1_0.state, t1_0.telephone, t1_0.unincorporated, t1_0.v2_latitude, t1_0.v2_longitude, t1_0.veteran, t1_0.w2_addr_one, t1_0.w2_addr_two, t1_0.w2_city, t1_0.w2_postal, t1_0.w2_state, t1_0.zip_code, t1_0.zip_suffix, t1_0.peo_id, t1_0.employee_id, t1_0.modified
  • Buffers: shared hit=16,260
  • Worker 0: actual time=0.007..182.880 rows=101,200 loops=1
  • Buffers: shared hit=6,004
  • Worker 1: actual time=0.008..198.678 rows=82,339 loops=1
  • Buffers: shared hit=4,872
27. 2,070.310 2,070.310 ↑ 1.0 1 282,315 / 3

Index Scan using pk_employee_pay on public.employee_pay t2_0 (cost=0.42..0.64 rows=1 width=940) (actual time=0.022..0.022 rows=1 loops=282,315)

  • Output: t2_0.alien_reg_no, t2_0.alien_reg_exp, t2_0.alloc_template_id, t2_0.annual_pay, t2_0.auto_hours, t2_0.auto_sheet, t2_0.benefit_salary, t2_0.bene_per_hr, t2_0.biweekly_pay, t2_0.bonus_accrued, t2_0.check_home, t2_0.comparatio, t2_0.conv_date, t2_0.daily_time_sheet, t2_0.dflt_hours, t2_0.elec_pay_stub, t2_0.elig_docmnt, t2_0.evs_date, t2_0.evs_deadline, t2_0.evs_fail_code, t2_0.evs_verify_by, t2_0.evs_verify_code, t2_0.family_member, t2_0.fed_w4_file, t2_0.fed_w4_year, t2_0.fica_exempt, t2_0.first_pay_period_hours, t2_0.foreign_passport_country, t2_0.foreign_passport_no, t2_0.form_4029_filed, t2_0.fs_fed, t2_0.hourly_rate, t2_0.i9_dob, t2_0.i9_elig_auth_name, t2_0.i9_elig_doc_exp, t2_0.i9_elig_docmnt, t2_0.i9_elig_docno, t2_0.i9_elig2_auth_name, t2_0.i9_elig2_doc_exp, t2_0.i9_elig2_docmnt, t2_0.i9_elig2_docno, t2_0.i9_elig3_auth_name, t2_0.i9_elig3_doc_exp, t2_0.i9_elig3_docmnt, t2_0.i9_elig3_docno, t2_0.i9_first_name, t2_0.i9_from_ob, t2_0.i9_id_auth_name, t2_0.i9_id_doc_exp, t2_0.i9_id_docno, t2_0.i9_last_name, t2_0.i9_middle_name, t2_0.i9_other_name_used, t2_0.i9_renew_date, t2_0.i9_start_date, t2_0.i9_version, t2_0.id_document, t2_0.i94_admission_no, t2_0.irs_lockin_date, t2_0.last_change_date, t2_0.last_day_worked, t2_0.last_pay_amt, t2_0.last_pay_date, t2_0.last_pay_pcnt, t2_0.last_period_end_date, t2_0.last_rating, t2_0.last_review, t2_0.monthly_pay, t2_0.next_pay_review, t2_0.next_review, t2_0.nonres_alien, t2_0.oa_fed, t2_0.ot_fed, t2_0.override_work_geocode, t2_0.paid_thru, t2_0.pay_group, t2_0.pay_method, t2_0.pay_method_custom, t2_0.pay_period, t2_0.pcnt_midpoint, t2_0.per_day_diem, t2_0.perf_agrmnt, t2_0.period_rate, t2_0.position_minimum_wage, t2_0.pricing_code, t2_0.probation_code, t2_0.provider_notified, t2_0.quartile, t2_0.railroad_ee, t2_0.retro_hire1_date, t2_0.retro_hire2_date, t2_0.sales_draw_start, t2_0.semi_pay, t2_0.tax_calc_fed, t2_0.title_last_performance_review, t2_0.vt_health_ins_indicator, t2_0.wa_fed, t2_0.weekly_pay, t2_0.work_auth_expire_date, t2_0.work_shift, t2_0.ssn_unmasked, t2_0.form_i9, t2_0.i9_ssn, t2_0.tax_credit, t2_0.peo_id, t2_0.client_id, t2_0.employee_id, t2_0.modified
  • Index Cond: ((t0_0.peo_id = t2_0.peo_id) AND (t0_0.client_id = t2_0.client_id) AND (t0_0.employee_id = t2_0.employee_id))
  • Buffers: shared hit=1,131,755
  • Worker 0: actual time=0.022..0.022 rows=1 loops=93,162
  • Buffers: shared hit=373,466
  • Worker 1: actual time=0.022..0.022 rows=1 loops=92,952
  • Buffers: shared hit=372,564
28. 0.218 0.361 ↑ 1.2 533 1

Hash (cost=13.17..13.17 rows=617 width=34) (actual time=0.360..0.361 rows=533 loops=1)

  • Output: t4_0.division_name, t4_0.division_code, t4_0.peo_id, t4_0.client_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
  • Buffers: shared hit=7
29. 0.143 0.143 ↑ 1.2 533 1

Seq Scan on public.division_codes t4_0 (cost=0.00..13.17 rows=617 width=34) (actual time=0.008..0.143 rows=533 loops=1)

  • Output: t4_0.division_name, t4_0.division_code, t4_0.peo_id, t4_0.client_id
  • Buffers: shared hit=7
30. 0.009 0.018 ↑ 8.8 17 1

Hash (cost=11.50..11.50 rows=150 width=160) (actual time=0.018..0.018 rows=17 loops=1)

  • Output: t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t5_0.status_code, t5_0.peo_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
31. 0.009 0.009 ↑ 8.8 17 1

Seq Scan on public.employee_status_codes t5_0 (cost=0.00..11.50 rows=150 width=160) (actual time=0.004..0.009 rows=17 loops=1)

  • Output: t5_0.status_desc, t5_0.abbrev_desc, t5_0.status_class, t5_0.status_code, t5_0.peo_id
  • Buffers: shared hit=1
32. 0.016 0.028 ↑ 3.4 38 1

Hash (cost=11.30..11.30 rows=130 width=128) (actual time=0.028..0.028 rows=38 loops=1)

  • Output: t6_0.type_desc, t6_0.abbrev_desc, t6_0.type_code, t6_0.peo_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
33. 0.012 0.012 ↑ 3.4 38 1

Seq Scan on public.employee_type_codes t6_0 (cost=0.00..11.30 rows=130 width=128) (actual time=0.004..0.012 rows=38 loops=1)

  • Output: t6_0.type_desc, t6_0.abbrev_desc, t6_0.type_code, t6_0.peo_id
  • Buffers: shared hit=1
34. 0.029 0.048 ↑ 1.0 63 1

Hash (cost=1.63..1.63 rows=63 width=32) (actual time=0.048..0.048 rows=63 loops=1)

  • Output: t7_0.description, t7_0.client_id, t7_0.peo_id, t7_0.work_group
  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=1
35. 0.019 0.019 ↑ 1.0 63 1

Seq Scan on public.work_groups t7_0 (cost=0.00..1.63 rows=63 width=32) (actual time=0.006..0.019 rows=63 loops=1)

  • Output: t7_0.description, t7_0.client_id, t7_0.peo_id, t7_0.work_group
  • Buffers: shared hit=1
36. 0.318 0.318 ↓ 0.0 0 159

Index Scan using pk_dept_codes on public.dept_codes t3_0 (cost=0.29..0.31 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=159)

  • Output: t3_0.peo_id, t3_0.client_id, t3_0.dept_code, t3_0.department, t3_0.gl_code, t3_0.gl_segment2, t3_0.per_diem_pcnt, t3_0.hours_type1, t3_0.hours_type2, t3_0.hours_type3, t3_0.hours_type4, t3_0.hours_type5, t3_0.flat_type7, t3_0.flat_type8, t3_0.extra_hdg1, t3_0.extra_hdg2, t3_0.std_deduct1, t3_0.std_deduct2, t3_0.std_deduct3, t3_0.note_col_hdg, t3_0.obsolete, t3_0.change_date, t3_0.change_time, t3_0.supervisor, t3_0.union_eligible_days, t3_0.record, t3_0.modified_by, t3_0.modified_ip, t3_0.modified
  • Index Cond: ((t0_0.peo_id = t3_0.peo_id) AND (t0_0.client_id = t3_0.client_id) AND (t0_0.dept_code = t3_0.dept_code))
  • Buffers: shared hit=82
37. 1.431 1.431 ↑ 1.0 1 159

Index Scan using pk_job_codes on public.job_codes t8_0 (cost=0.29..0.32 rows=1 width=286) (actual time=0.009..0.009 rows=1 loops=159)

  • Output: t8_0.peo_id, t8_0.client_id, t8_0.job_code, t8_0.job_title, t8_0.ada_sensitive, t8_0.gl_code, t8_0.job_class, t8_0.pay_rate1, t8_0.last_desc_upd, t8_0.ada_review_date, t8_0.ada_reviewer, t8_0.salary_grade, t8_0.supervisory, t8_0.pay_rate3, t8_0.pay_rate4, t8_0.probation_days, t8_0.per_diem_pcnt, t8_0.sales_position, t8_0.pos_count, t8_0.pos_budget, t8_0.dot_flag, t8_0.tipped_position, t8_0.union_code_override, t8_0.obsolete, t8_0.indirect_tip, t8_0.alaska_job_code, t8_0.pr_chauffeur, t8_0.change_date, t8_0.change_time, t8_0.prev_wage, t8_0.price_code, t8_0.wc_loc_based, t8_0.pay_rate2, t8_0.active_vacancy, t8_0.num_vacancies, t8_0.vacancy_name, t8_0.hiring_manager, t8_0.location_type_cd, t8_0.hierarchy_tier, t8_0.ben_group_dflt, t8_0.gl_code3, t8_0.suppress_work_state_tax, t8_0.gl_code2, t8_0.soc_code, t8_0.otr_driver_flag, t8_0.position_minimum_wage, t8_0.in_season_ee_code, t8_0.record, t8_0.modified_by, t8_0.modified_ip, t8_0.modified
  • Index Cond: ((t0_0.peo_id = t8_0.peo_id) AND (t0_0.client_id = t8_0.client_id) AND (t0_0.job_code = t8_0.job_code))
  • Buffers: shared hit=467
38. 0.000 0.000 ↓ 0.0 0 159

Index Scan using pk_union_codes on public.union_codes t9_0 (cost=0.27..0.29 rows=1 width=42) (actual time=0.000..0.000 rows=0 loops=159)

  • Output: t9_0.peo_id, t9_0.client_id, t9_0.union_code, t9_0.union_desc, t9_0.accept_ts_over, t9_0.union_addr1, t9_0.value_code, t9_0.custom_option, t9_0.union_addr2, t9_0.union_city, t9_0.biwkly_max_dues, t9_0.biwkly_min_dues, t9_0.wkly_max_dues, t9_0.wkly_min_dues, t9_0.union_state, t9_0.union_zip, t9_0.union_phone, t9_0.union_contact, t9_0.union_bill_template, t9_0.record, t9_0.modified_by, t9_0.modified_ip, t9_0.modified
  • Index Cond: ((t0_0.peo_id = t9_0.peo_id) AND (t0_0.client_id = t9_0.client_id) AND (t0_0.union_code = t9_0.union_code))
39. 1.113 1.113 ↑ 1.0 1 159

Index Scan using pk_benefit_groups on public.benefit_groups t10_0 (cost=0.28..0.30 rows=1 width=22) (actual time=0.007..0.007 rows=1 loops=159)

  • Output: t10_0.peo_id, t10_0.client_id, t10_0.group_id, t10_0.group_name, t10_0.stop_new_use_on, t10_0.stop_all_use_on, t10_0.flex_med_match, t10_0.flex_dep_match, t10_0.ret_ben_only, t10_0.record, t10_0.modified_by, t10_0.modified_ip, t10_0.modified
  • Index Cond: ((t0_0.peo_id = t10_0.peo_id) AND (t0_0.client_id = t10_0.client_id) AND (t0_0.benefit_group = t10_0.group_id))
  • Buffers: shared hit=468
40. 0.477 0.477 ↑ 1.0 1 159

Index Scan using pk_eeo_ethnic_codes on public.eeo_ethnic_codes t11_0 (cost=0.14..0.16 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=159)

  • Output: t11_0.peo_id, t11_0.eeo_ethnic_code, t11_0.ethnicity, t11_0.eeo_rpt_code, t11_0.modified_by, t11_0.modified_ip, t11_0.modified, t11_0.record
  • Index Cond: ((t1_0.peo_id = t11_0.peo_id) AND (t1_0.ethnic_code = t11_0.eeo_ethnic_code))
  • Buffers: shared hit=298
41. 0.000 0.000 ↓ 0.0 0 159

Index Scan using pk_hrp_users on public.hrp_users t12_0 (cost=0.41..0.51 rows=1 width=30) (actual time=0.000..0.000 rows=0 loops=159)

  • Output: t12_0.user_name, t12_0.peo_id, t12_0.user_id
  • Index Cond: ((t0_0.peo_id = t12_0.peo_id) AND (t0_0.reports_to = t12_0.user_id))
  • Buffers: shared hit=3
42. 0.159 0.159 ↓ 0.0 0 159

Index Scan using pk_reason_codes on public.reason_codes t13_0 (cost=0.15..0.17 rows=1 width=31) (actual time=0.001..0.001 rows=0 loops=159)

  • Output: t13_0.peo_id, t13_0.reason_code, t13_0.reason, t13_0.valid_actions, t13_0.tpa_seperation_code, t13_0.show_on_web, t13_0.obsolete_on, t13_0.term_type, t13_0.record, t13_0.modified_by, t13_0.modified_ip, t13_0.modified
  • Index Cond: ((t0_0.peo_id = t13_0.peo_id) AND (t0_0.term_reason_code = t13_0.reason_code))
  • Buffers: shared hit=52
43. 0.159 0.159 ↓ 0.0 0 159

Index Scan using pk_shift_codes on public.shift_codes t14_0 (cost=0.28..0.30 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=159)

  • Output: t14_0.peo_id, t14_0.client_id, t14_0.shift_code, t14_0.shift_desc, t14_0.method, t14_0.amount, t14_0.rate_include, t14_0.reg_pay_code, t14_0.ot_pay_code, t14_0.ot_factor, t14_0.per_diem_rate, t14_0.ot_diff_straight, t14_0.mileage_rate, t14_0.change_date, t14_0.change_time, t14_0.per_diem_pcnt, t14_0.record, t14_0.modified_by, t14_0.modified_ip, t14_0.modified
  • Index Cond: ((t2_0.peo_id = t14_0.peo_id) AND (t2_0.client_id = t14_0.client_id) AND (t2_0.work_shift = t14_0.shift_code))
  • Buffers: shared hit=18
44. 3.498 3.498 ↑ 1.0 1 159

Index Scan using pk_employee_hlh on public.employee_hlh t21_0 (cost=0.42..0.48 rows=1 width=70) (actual time=0.022..0.022 rows=1 loops=159)

  • Output: t21_0.peo_id, t21_0.client_id, t21_0.employee_id, t21_0.height, t21_0.weight, t21_0.next_physical, t21_0.last_physical, t21_0.phys_result, t21_0.next_drug_test, t21_0.last_drug_test, t21_0.drug_result, t21_0.blood_type, t21_0.blood_rh, t21_0.donation_date, t21_0.next_donation, t21_0.eligible_donor, t21_0.last_audio, t21_0.next_audio, t21_0.audio_result, t21_0.modified_by, t21_0.modified_ip, t21_0.modified, t21_0.record
  • Index Cond: ((t0_0.peo_id = t21_0.peo_id) AND (t0_0.client_id = t21_0.client_id) AND (t0_0.employee_id = t21_0.employee_id))
  • Buffers: shared hit=626
45. 0.928 1.713 ↑ 1.0 1,868 1

Hash (cost=220.88..220.88 rows=1,888 width=47) (actual time=1.712..1.713 rows=1,868 loops=1)

  • Output: t15_0.reference, t15_0.peo_id, t15_0.client_id, t15_0.pay_group
  • Buckets: 2,048 Batches: 1 Memory Usage: 164kB
  • Buffers: shared hit=202
46. 0.785 0.785 ↑ 1.0 1,868 1

Seq Scan on public.pay_groups t15_0 (cost=0.00..220.88 rows=1,888 width=47) (actual time=0.003..0.785 rows=1,868 loops=1)

  • Output: t15_0.reference, t15_0.peo_id, t15_0.client_id, t15_0.pay_group
  • Buffers: shared hit=202
47. 1.109 1.973 ↑ 1.0 2,000 1

Hash (cost=123.14..123.14 rows=2,014 width=390) (actual time=1.973..1.973 rows=2,000 loops=1)

  • Output: t16_0.ada_sensitive, t16_0.eeo_class_code, t16_0.eeo_group_code, t16_0.exempt, t16_0.flsa_type, t16_0.job_title, t16_0.record, t16_0.peo_id, t16_0.pos_class
  • Buckets: 2,048 Batches: 1 Memory Usage: 800kB
  • Buffers: shared hit=103
48. 0.864 0.864 ↑ 1.0 2,000 1

Seq Scan on public.job_code_master t16_0 (cost=0.00..123.14 rows=2,014 width=390) (actual time=0.005..0.864 rows=2,000 loops=1)

  • Output: t16_0.ada_sensitive, t16_0.eeo_class_code, t16_0.eeo_group_code, t16_0.exempt, t16_0.flsa_type, t16_0.job_title, t16_0.record, t16_0.peo_id, t16_0.pos_class
  • Buffers: shared hit=103
49. 0.954 0.954 ↑ 1.0 1 159

Index Scan using pk_client_master on public.client_master t17_0 (cost=0.28..0.30 rows=1 width=403) (actual time=0.006..0.006 rows=1 loops=159)

  • Output: t17_0.peo_id, t17_0.client_id, t17_0.client_name, t17_0.status, t17_0.ach_bank_name, t17_0.aba_spec_info, t17_0.bank_phone, t17_0.bank_city, t17_0.bank_state, t17_0.bank_zip, t17_0.aba_number, t17_0.bank_acno, t17_0.check_save, t17_0.ach_status, t17_0.status_date, t17_0.abbrev_name, t17_0.annual_hours, t17_0.data_entry_by, t17_0.bill_by_sort, t17_0.bill_inv_break, t17_0.consultant, t17_0.salesperson, t17_0.payroll_rep, t17_0.check_acct, t17_0.check_style, t17_0.def_comp_sup, t17_0.reason_code, t17_0.check_acct_garn, t17_0.recalc_ot, t17_0.pp_subscrib, t17_0.client_agrmnt_recd, t17_0.inv_recpt_acct, t17_0.adj_ach_days, t17_0.pin_number, t17_0.nes_offset, t17_0.job_rates, t17_0.rate_markup, t17_0.ts_entry_type, t17_0.daily_cc_req, t17_0.batch_reg_opts, t17_0.bill_addr1, t17_0.bill_addr2, t17_0.bill_zip_code, t17_0.bill_city, t17_0.bill_state_code, t17_0.bill_zip_suffix, t17_0.worksite_tse, t17_0.process_schedule_id, t17_0.edi_allstate_agent_type, t17_0.edi_allstate_agent_id, t17_0.elig_ben_det, t17_0.bill_redir_code, t17_0.employer_id, t17_0.alloc_primary_client_name, t17_0.pcnt_diem_rate_src, t17_0.use_client_accounting, t17_0.std_cl_accting, t17_0.new_invoice_on_break, t17_0.tip_action, t17_0.suppress_ben_adj, t17_0.show_pay_rates, t17_0.mileage_shift, t17_0.bill_client_addr, t17_0.ts_note_heading, t17_0.suppress_ach, t17_0.supp_consol_batch, t17_0.printer_name, t17_0.check_path, t17_0.sep_garn_chk, t17_0.garn_ck_path, t17_0.ach_check_acct, t17_0.tips_to_min, t17_0.suppress_addr, t17_0.bbsi_paycard_option, t17_0.related_code, t17_0.convert_date, t17_0.user_210, t17_0.wc_contract_dt_bbsi, t17_0.alt_retire_plan, t17_0.user_240, t17_0.cafeteria_plan, t17_0.tlc_time_mode, t17_0.user_250, t17_0.tlc_pay_mthd, t17_0.lpi_lp_region, t17_0.tlc_no_drivers, t17_0.tlc_no_mech, t17_0.tlc_no_cler, t17_0.tlc_no_other, t17_0.tlc_sdep_req, t17_0.tlc_sdep_amt, t17_0.hsa_plan, t17_0.tlc_ddep_ok, t17_0.user_260, t17_0.tlc_liab_exp_date, t17_0.bill_unit_based_rate, t17_0.web_approval, t17_0.everify, t17_0.gl_cono, t17_0.bill_template, t17_0.web_emp_menu_template, t17_0.suppr_arrear, t17_0.w_web_pwd_update_type, t17_0.w_web_auto_id, t17_0.w_web_auto_pwd, t17_0.category_cd, t17_0.wc_policy, t17_0.fmla_basis, t17_0.fmla_fiscal_month, t17_0.fmla_fiscal_day, t17_0.rehire_sen_date, t17_0.recalc_ot_pay_code, t17_0.override_work_geocode, t17_0.non_std_rnding, t17_0.tax_limit_basis, t17_0.gl_over_on_job, t17_0.wc_eff_date, t17_0.web_show_peo_contrib, t17_0.web_show_employer_contrib, t17_0.cachet_trans_type, t17_0.do_not_svc, t17_0.qual_transp, t17_0.gl_template_code, t17_0.check_stock_name, t17_0.web_link_template, t17_0.web_comp_logo, t17_0.wc_loc_based, t17_0.mvq_chk_printer, t17_0.naics_code, t17_0.bill_format, t17_0.company_mods, t17_0.mvq_rpt_printer, t17_0.pdf_password, t17_0.ben_rep, t17_0.risk_mgr, t17_0.group_code, t17_0.deposit_type2, t17_0.deposit_date, t17_0.deposit_amt, t17_0.handbook_id, t17_0.manual_batch_call_in, t17_0.transfer_type, t17_0.aftpost_premail_hold, t17_0.aftpost_premail_threshold, t17_0.ach_hold_threshold, t17_0.alloc_tip_calc_perc, t17_0.reg_locn_code, t17_0.client_hdhp, t17_0.tax_options, t17_0.ssn_option, t17_0.cl_coor, t17_0.invoice_name, t17_0.suppr_dedns_faxbk, t17_0.check_acct_cseft, t17_0.use_wc_rate_template, t17_0.calc_wc_on_1099_ees, t17_0.suppr_garn_checks, t17_0.suppr_ach_pay_reg, t17_0.suppress_fsa_hsa, t17_0.use_fed_min_rate_wv, t17_0.elec_w2_form, t17_0.tpa_dld_opts, t17_0.calc_er_nysdi, t17_0.er_nysdi_rate, t17_0.ach_balance_acct, t17_0.reserved_398, t17_0.reserved_399, t17_0.state_code, t17_0.esac_q1, t17_0.show_memo, t17_0.hire_act_not_elig, t17_0.hire_act_no_credit, t17_0.wc_policy_subid, t17_0.wc_bill_based_on, t17_0.definition_id, t17_0.eeo_gov_contract, t17_0.check_acct_cb, t17_0.broker, t17_0.phantom_init, t17_0.contractors_allowed, t17_0.onboard_status, t17_0.nymct_rate, t17_0.is_a_fin_inst, t17_0.use_onhrp, t17_0.nh_ben_enroll, t17_0.cancel_term_date, t17_0.ach_client_name_in_break, t17_0.ach_break_name, t17_0.onhrp_benefits_good_through, t17_0.auto_enroll_suspend, t17_0.self_service, t17_0.paperless, t17_0.max_inv_amt, t17_0.hab_id, t17_0.self_svc_restrict, t17_0.website_url, t17_0.railroad_er, t17_0.leave_system, t17_0.location_type_reqd, t17_0.min_add_on_days, t17_0.dflt_hrs_col, t17_0.man_check_bank_acct, t17_0.w_include_employer_cost, t17_0.w_employee_calculation_based_on, t17_0.entity_id, t17_0.inv_addr_employer_id, t17_0.smfa_client_enabled, t17_0.smfa_ta_pwd_reset, t17_0.enable_ess_2_0, t17_0.config_template, t17_0.config_template_override, t17_0.config_template_override_enabled, t17_0.display_option_temp, t17_0.i92_approver, t17_0.zip_code, t17_0.flsa_ruleset, t17_0.payroll_finalization_list, t17_0.payroll_finalization_notify, t17_0.ts_id_display, t17_0.allow_first_period_hours, t17_0.pay_card_account_cb, t17_0.wc_expiration_date, t17_0.week_ends, t17_0.smfa_client_ep_enabled, t17_0.suppress_wells_fargo_pm, t17_0.force_a_balance_account, t17_0.first_per_start_date, t17_0.first_per_end_date, t17_0.ma_pfml_1099, t17_0.corp_type, t17_0.legal_name, t17_0.bill_reimb_rate, t17_0.bill_reimb_spec_rate, t17_0.control_client, t17_0.ar_cust_no, t17_0.delivery_mthd, t17_0.del_checks, t17_0.wc_accr_pcnt, t17_0.main_tel_ext, t17_0.addr_one, t17_0.change_date, t17_0.addr_two, t17_0.city, t17_0.zip_suffix, t17_0.telephone, t17_0.fax, t17_0.modem, t17_0.modem_extn, t17_0.email, t17_0.contract_date, t17_0.change_time, t17_0.payroll_date, t17_0.business, t17_0.sic_code, t17_0.fed_id_num, t17_0.bill_reimb_spec_to, t17_0.std_deduct3, t17_0.depts_used, t17_0.auto_create_oe, t17_0.bill_admin_emp_spec_max, t17_0.extra_fax_back_lines_per_ee, t17_0.project_flag, t17_0.pdf_output_type, t17_0.bill_admin_emp_max, t17_0.auto_post_oe, t17_0.work_group_flag, t17_0.bill_admin_inv_min, t17_0.bill_admin_supp_spec_min, t17_0.bill_admin_inv_spec_max, t17_0.cost_center, t17_0.extra_fax_back_lines_per_break, t17_0.bill_admin_check_rate, t17_0.bill_admin_supp_min, t17_0.pd_sun_bef_aft, t17_0.remit_copies, t17_0.mvq_chk_rpt_name, t17_0.signature_path, t17_0.web_aso_emp_file, t17_0.check_sort_1, t17_0.company_dir, t17_0.bill_admin_hours_spec_rate, t17_0.division_flag, t17_0.mvq_garn_chk_rpt_name, t17_0.chk_inc_memo_pay_codes, t17_0.prnt_fa_only_on_check_stub, t17_0.mvq_advice_printer, t17_0.max_check, t17_0.check_sort_2, t17_0.pdf_rpt_password, t17_0.bill_admin_supp_spec_max, t17_0.check_sort_3, t17_0.bill_admin_inv_max, t17_0.chk_stub_hdr_format, t17_0.pd_on_sat, t17_0.service_type, t17_0.bill_admin_supp_max, t17_0.bill_reimb_spec_from, t17_0.empnos_used, t17_0.sub_cost_ctr, t17_0.auto_empno, t17_0.rpt_logo_path, t17_0.invoice_copies, t17_0.bill_admin_check_spec_rate, t17_0.use_bplan_deduct_desc, t17_0.pd_sat_bef_aft, t17_0.bill_admin_wages_spec_rate, t17_0.check_logo_path, t17_0.bill_admin_emp_spec_min, t17_0.pd_on_sun, t17_0.mvq_check_printer, t17_0.shifts_used, t17_0.bill_admin_hours_rate, t17_0.bill_admin_emp_min, t17_0.bill_admin_spec_from, t17_0.bill_admin_spec_to, t17_0.bill_admin_inv_spec_min, t17_0.std_deduct1, t17_0.web_aso_file, t17_0.bill_admin_wages_rate, t17_0.std_deduct2, t17_0.min_check, t17_0.ach_report_name, t17_0.chk_void_days, t17_0.ee_web_rpt_flg_bbsi, t17_0.use_wc_ovr_undr_bbsi, t17_0.wc_ou_act_date_bbsi, t17_0.record, t17_0.modified_by, t17_0.modified_ip, t17_0.modified, t17_0.dash_field_1, t17_0.dash_field_2, t17_0.dash_field_3, t17_0.dash_field_4, t17_0.billwc
  • Index Cond: ((t0_0.peo_id = t17_0.peo_id) AND (t0_0.client_id = t17_0.client_id))
  • Buffers: shared hit=467
50. 0.060 0.136 ↓ 1.1 96 1

Hash (cost=10.87..10.87 rows=87 width=121) (actual time=0.136..0.136 rows=96 loops=1)

  • Output: t18_0.address, t18_0.cert_peo, t18_0.city, t18_0.ein, t18_0.employer_name, t18_0.employer_print_name, t18_0.obsolete, t18_0.state, t18_0.zip_code, t18_0.zip_suffix, t18_0.employer_id, t18_0.peo_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared hit=10
51. 0.076 0.076 ↓ 1.1 96 1

Seq Scan on public.employer_master t18_0 (cost=0.00..10.87 rows=87 width=121) (actual time=0.005..0.076 rows=96 loops=1)

  • Output: t18_0.address, t18_0.cert_peo, t18_0.city, t18_0.ein, t18_0.employer_name, t18_0.employer_print_name, t18_0.obsolete, t18_0.state, t18_0.zip_code, t18_0.zip_suffix, t18_0.employer_id, t18_0.peo_id
  • Buffers: shared hit=10
52. 0.004 0.010 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=81) (actual time=0.010..0.010 rows=4 loops=1)

  • Output: t19_0.entity_name, t19_0.ein, t19_0.address, t19_0.city, t19_0.state, t19_0.zip_code, t19_0.entity_id, t19_0.peo_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
53. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on public.client_federal_entities t19_0 (cost=0.00..1.04 rows=4 width=81) (actual time=0.004..0.006 rows=4 loops=1)

  • Output: t19_0.entity_name, t19_0.ein, t19_0.address, t19_0.city, t19_0.state, t19_0.zip_code, t19_0.entity_id, t19_0.peo_id
  • Buffers: shared hit=1
54. 1.272 1.272 ↑ 1.0 1 159

Index Scan using pk_location_codes on public.location_codes t20_0 (cost=0.29..0.31 rows=1 width=344) (actual time=0.008..0.008 rows=1 loops=159)

  • Output: t20_0.peo_id, t20_0.client_id, t20_0.location_code, t20_0.location, t20_0.pay_method, t20_0.v2_address1, t20_0.v2_address2, t20_0.v2_city, t20_0.v2_county, t20_0.v2_state, t20_0.v2_zip, t20_0.v2_zip_suffix, t20_0.fax_number, t20_0.latitude, t20_0.longitude, t20_0.subject_to_oh_sers, t20_0.fingerprint_required, t20_0.zip_code, t20_0.city, t20_0.state_code, t20_0.county, t20_0.auto_flag, t20_0.sales_tax_code, t20_0.gl_code, t20_0.geo_code, t20_0.sb_tax_pcnt, t20_0.or_transit, t20_0.override_client_accting, t20_0.wc_policy_id, t20_0.add_date, t20_0.aba_number, t20_0.bank_acno, t20_0.check_save, t20_0.loc_ach_status, t20_0.addr_one, t20_0.gl_code_2, t20_0.gl_code_3, t20_0.obsolete_loc, t20_0.eeo_unit_nbr, t20_0.ruleset_id, t20_0.entity_id, t20_0.addr_two, t20_0.flsa_ruleset, t20_0.tip_flsa_ruleset, t20_0.zip_suffix, t20_0.worksite_id, t20_0.zone_code, t20_0.check_acct, t20_0.ach_acct, t20_0.garn_chk_acct, t20_0.obsolete_date, t20_0.garn_eft_chk_acct, t20_0.f56, t20_0.work_comp_state, t20_0.story_cnt, t20_0.highest_floor_occ, t20_0.construct_type, t20_0.year_built, t20_0.sprinklers, t20_0.max_ees_on_site, t20_0.alt_sui_state, t20_0.union_location, t20_0.eeo_override_locn, t20_0.v2_geocode, t20_0.v2_school_district, t20_0.v2_psd, t20_0.v2_metro_id, t20_0.v2_transit_id, t20_0.talx_code, t20_0.clsuta_fein, t20_0.division_code, t20_0.dept_code, t20_0.project_code, t20_0.work_shift, t20_0.school_district, t20_0.locn_type, t20_0.adult_age, t20_0.dflt_override_work_geocode, t20_0.pay_group, t20_0.eeo_question_d2, t20_0.record, t20_0.modified_by, t20_0.modified_ip, t20_0.modified, t20_0.takeon_facility
  • Index Cond: ((t0_0.peo_id = t20_0.peo_id) AND (t0_0.client_id = t20_0.client_id) AND (t0_0.location_code = t20_0.location_code))
  • Buffers: shared hit=467
55. 20.711 45.252 ↑ 1.0 47,888 1

Hash (cost=5,353.51..5,353.51 rows=47,923 width=25) (actual time=45.252..45.252 rows=47,888 loops=1)

  • Output: t22_0.user_id, t22_0.employee_id, t22_0.peo_id
  • Buckets: 65,536 Batches: 1 Memory Usage: 3,235kB
  • Buffers: shared hit=4,721
56. 24.541 24.541 ↓ 1.0 47,924 1

Seq Scan on public.hrp_users t22_0 (cost=0.00..5,353.51 rows=47,923 width=25) (actual time=0.005..24.541 rows=47,924 loops=1)

  • Output: t22_0.user_id, t22_0.employee_id, t22_0.peo_id
  • Filter: (t22_0.user_type = 'E'::text)
  • Rows Removed by Filter: 2,688
  • Buffers: shared hit=4,721
57.          

SubPlan (for Hash Left Join)

58. 0.636 1.590 ↑ 20.0 5 159

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.006..0.010 rows=5 loops=159)

  • Output: jsonb_extract_path((jsonb_array_elements((t16_0.record -> 'wcclass'::text))), VARIADIC '{wcState}'::text[])
59. 0.954 0.954 ↑ 20.0 5 159

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.005..0.006 rows=5 loops=159)

  • Output: jsonb_array_elements((t16_0.record -> 'wcclass'::text))
60. 0.000 0.000 ↑ 1.0 1 159

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=159)

61. 0.477 1.113 ↑ 20.0 5 159

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.004..0.007 rows=5 loops=159)

  • Output: jsonb_extract_path((jsonb_array_elements((t16_0.record -> 'wcclass'::text))), VARIADIC '{wcClass}'::text[])
62. 0.636 0.636 ↑ 20.0 5 159

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.002..0.004 rows=5 loops=159)

  • Output: jsonb_array_elements((t16_0.record -> 'wcclass'::text))
63. 0.000 0.000 ↑ 1.0 1 159

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=159)

64. 0.000 0.159 ↓ 0.0 0 159

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=159)

  • Output: jsonb_extract_path((jsonb_array_elements((t20_0.record -> 'cdcontact'::text))), VARIADIC '{telephone}'::text[])
65. 0.159 0.159 ↓ 0.0 0 159

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=159)

  • Output: jsonb_array_elements((t20_0.record -> 'cdcontact'::text))
66. 0.000 0.000 ↑ 1.0 1 159

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=159)