explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EaIo2

Settings
# exclusive inclusive rows x rows loops node
1. 52,692.884 52,692.884 ↓ 0.0 3,255,493 1

Remote Fast Query Execution (cost=0.00..0.00 rows=0 width=0) (actual time=3.917..52,692.884 rows=3,255,493 loops=1)

  • Output: f.fact_labor_line_id, f.vfi_key, f.dim_client_id, f.dim_repair_order_id, f.dim_labor_line_id, f.dim_date_id_open, f.dim_date_id_close, f.dim_date_id_estimated_completion, f.dim_date_id_invoice, f.dim_date_id_ledger_post, f.dim_date_id_original_close, f.dim_date_id_promise, f.dim_date_id_void, f.dim_date_id_warranty_post, f.dim_date_id_vehicle_sold, f.dim_date_id_vehicle_in_service, f.dim_date_id_vehicle_warranty_expiration, f.dim_date_id_vehicle_delivery, f.dim_date_id_vehicle_first_ro, f.dim_customer_id, f.dim_vehicle_id, f.dim_employee_id_service_consultant, f.dim_employee_id_technician, f.dim_op_code_id, f.days_open, f.misc_sales, f.misc_cost, f.labor_hours_billed, f.labor_hours_actual, f.labor_sales, f.labor_cost, f.parts_sales, f.parts_cost, f.expected_labor_sales, f.vehicle_age_months, f.fixed_labor_hours_billed, f.fixed_labor_hours_actual, f.lc_labor_hours_billed, f.lm_labor_hours_billed, f.lr_labor_hours_billed, f.lx_labor_hours_billed, f.total_cmr_labor_hours_billed, f.total_all_labor_hours_billed, f.lc_labor_hours_actual, f.lm_labor_hours_actual, f.lr_labor_hours_actual, f.lx_labor_hours_actual, f.total_cmr_labor_hours_actual, f.total_all_labor_hours_actual, f.lc_labor_sales, f.lm_labor_sales, f.lr_labor_sales, f.lx_labor_sales, f.total_cmr_labor_sales, f.total_all_labor_sales, f.lc_labor_cost, f.lm_labor_cost, f.lr_labor_cost, f.lx_labor_cost, f.total_cmr_labor_cost, f.total_all_labor_cost, f.lc_parts_sales, f.lm_parts_sales, f.lr_parts_sales, f.lx_parts_sales, f.total_cmr_parts_sales, f.total_all_parts_sales, f.lc_parts_cost, f.lm_parts_cost, f.lr_parts_cost, f.lx_parts_cost, f.total_cmr_parts_cost, f.total_all_parts_cost, f.lc_expected_labor_sales, f.lm_expected_labor_sales, f.lr_expected_labor_sales, f.total_cmr_expected_labor_sales, f.is_repair_opp, f.vehicle_mileage_in, f.pay_type_short, f.is_ssp, f.is_repair_done, f.is_one_item_ro, f.is_off_grid_line, f.is_email_captured, f.is_cp_ro, f.is_wp_ro, f.is_ip_ro, f.cp_labor_hours_billed, f.wp_labor_hours_billed, f.ip_labor_hours_billed, f.cp_labor_hours_actual, f.wp_labor_hours_actual, f.ip_labor_hours_actual, f.cp_labor_sales, f.wp_labor_sales, f.ip_labor_sales, f.cp_labor_cost, f.wp_labor_cost, f.ip_labor_cost, f.cp_parts_sales, f.wp_parts_sales, f.ip_parts_sales, f.cp_parts_cost, f.wp_parts_cost, f.ip_parts_cost, f.menu_def_sale_price, f.menu_def_sale_labor_hours, f.menu_def_sale_item_count, f.menu_sale_labor_hours_billed, f.menu_sale_labor_hours_actual, f.menu_sale_labor_sales, f.menu_sale_labor_cost, f.menu_sale_parts_sales, f.menu_sale_parts_cost, f.menu_def_opp_labor_hours, f.menu_def_opp_item_count, f.menu_def_opp_price, f.fpm_menu_def_sale_price, f.fpm_menu_def_sale_labor_hours, f.fpm_menu_sale_labor_hours_billed, f.fpm_menu_sale_labor_hours_actual, f.fpm_menu_sale_labor_sales, f.fpm_menu_sale_labor_cost, f.fpm_menu_sale_parts_sales, f.fpm_menu_sale_parts_cost, f.fpm_menu_def_opp_labor_hours, f.fpm_menu_def_opp_item_count, f.fpm_menu_def_opp_price, f.is_ala_carte_menu_sale, f.menu_ala_carte_labor_hours_billed, f.menu_ala_carte_labor_hours_actual, f.menu_ala_carte_labor_sales, f.menu_ala_carte_labor_cost, f.menu_ala_carte_parts_sales, f.menu_ala_carte_parts_cost, f.mpi_labor_hours_billed, f.mpi_labor_hours_actual, f.mpi_labor_sales, f.mpi_parts_sales, f.fpm_menu_def_sale_item_count, f.grease_oil_gas_cost, f.grease_oil_gas_sales, f.is_declined_service, f.is_menu_disclaimer, f.is_mpi_disclaimer, f.is_vip_reinspection, f.is_cp_menu_opp, f.is_cp_mpi_opp, f.is_fpm_menu_opp, f.is_fpm_menu_sale, f.is_menu_opp, f.is_menu_opp_incl_fpm, f.is_menu_sale, f.is_menu_sale_incl_fpm, f.is_mpi_sale, f.is_mpi_opp, f.is_wp_menu_opp, f.is_wp_mpi_opp, f.menu_lott, f.menu_def_opp_mileage, f.menu_def_opp_price_incl_fpm, f.menu_potential_labor_hours, f.menu_sale_labor_hours_billed_incl_ala_carte, f.menu_sale_labor_hours_billed_incl_fpm, f.menu_sale_labor_hours_billed_incl_fpm_and_ala_carte, f.menu_def_sale_labor_hours_incl_fpm, f.menu_sale_labor_sales_incl_ala_carte, f.menu_sale_labor_sales_incl_fpm, f.menu_sale_labor_sales_incl_fpm_and_ala_carte, f.menu_def_sale_mileage, f.menu_sale_parts_sales_incl_ala_carte, f.menu_sale_parts_sales_incl_fpm, f.menu_sale_parts_sales_incl_fpm_and_ala_carte, f.menu_def_sale_price_incl_fpm, f.mpi_potential_labor_sales, f.mpi_potential_parts_sales, f.multi_item_labor_sales, f.multi_item_parts_sales, f.multi_item_total_sales, f.one_item_labor_sales, f.one_item_parts_sales, f.one_item_total_sales, f.vehicle_mileage_out, f.fpm_menu_def_opp_mileage, f.fpm_menu_def_sale_mileage, f.is_roams_line, f.menu_def_sale_item_count_incl_fpm, f.menu_sale_labor_hours_actual_incl_ala_carte, f.menu_sale_labor_hours_actual_incl_fpm, f.menu_sale_labor_hours_actual_incl_fpm_and_ala_carte, f.expected_package_price, f.expected_parts_sales, f.expected_parts_cost, f.expected_labor_cost, f.expected_labor_hours
  • Node/s: pr_era_pgxl2_data, pr_era_pgxl3_data
  • Remote query: SELECT fact_labor_line_id, vfi_key, dim_client_id, dim_repair_order_id, dim_labor_line_id, dim_date_id_open, dim_date_id_close, dim_date_id_estimated_completion, dim_date_id_invoice, dim_date_id_ledger_post, dim_date_id_original_close, dim_date_id_promise, dim_date_id_void, dim_date_id_warranty_post, dim_date_id_vehicle_sold, dim_date_id_vehicle_in_service, dim_date_id_vehicle_warranty_expiration, dim_date_id_vehicle_delivery, dim_date_id_vehicle_first_ro, dim_customer_id, dim_vehicle_id, dim_employee_id_service_consultant, dim_employee_id_technician, dim_op_code_id, days_open, misc_sales, misc_cost, labor_hours_billed, labor_hours_actual, labor_sales, labor_cost, parts_sales, parts_cost, expected_labor_sales, vehicle_age_months, fixed_labor_hours_billed, fixed_labor_hours_actual, lc_labor_hours_billed, lm_labor_hours_billed, lr_labor_hours_billed, lx_labor_hours_billed, total_cmr_labor_hours_billed, total_all_labor_hours_billed, lc_labor_hours_actual, lm_labor_hours_actual, lr_labor_hours_actual, lx_labor_hours_actual, total_cmr_labor_hours_actual, total_all_labor_hours_actual, lc_labor_sales, lm_labor_sales, lr_labor_sales, lx_labor_sales, total_cmr_labor_sales, total_all_labor_sales, lc_labor_cost, lm_labor_cost, lr_labor_cost, lx_labor_cost, total_cmr_labor_cost, total_all_labor_cost, lc_parts_sales, lm_parts_sales, lr_parts_sales, lx_parts_sales, total_cmr_parts_sales, total_all_parts_sales, lc_parts_cost, lm_parts_cost, lr_parts_cost, lx_parts_cost, total_cmr_parts_cost, total_all_parts_cost, lc_expected_labor_sales, lm_expected_labor_sales, lr_expected_labor_sales, total_cmr_expected_labor_sales, is_repair_opp, vehicle_mileage_in, pay_type_short, is_ssp, is_repair_done, is_one_item_ro, is_off_grid_line, is_email_captured, is_cp_ro, is_wp_ro, is_ip_ro, cp_labor_hours_billed, wp_labor_hours_billed, ip_labor_hours_billed, cp_labor_hours_actual, wp_labor_hours_actual, ip_labor_hours_actual, cp_labor_sales, wp_labor_sales, ip_labor_sales, cp_labor_cost, wp_labor_cost, ip_labor_cost, cp_parts_sales, wp_parts_sales, ip_parts_sales, cp_parts_cost, wp_parts_cost, ip_parts_cost, menu_def_sale_price, menu_def_sale_labor_hours, menu_def_sale_item_count, menu_sale_labor_hours_billed, menu_sale_labor_hours_actual, menu_sale_labor_sales, menu_sale_labor_cost, menu_sale_parts_sales, menu_sale_parts_cost, menu_def_opp_labor_hours, menu_def_opp_item_count, menu_def_opp_price, fpm_menu_def_sale_price, fpm_menu_def_sale_labor_hours, fpm_menu_sale_labor_hours_billed, fpm_menu_sale_labor_hours_actual, fpm_menu_sale_labor_sales, fpm_menu_sale_labor_cost, fpm_menu_sale_parts_sales, fpm_menu_sale_parts_cost, fpm_menu_def_opp_labor_hours, fpm_menu_def_opp_item_count, fpm_menu_def_opp_price, is_ala_carte_menu_sale, menu_ala_carte_labor_hours_billed, menu_ala_carte_labor_hours_actual, menu_ala_carte_labor_sales, menu_ala_carte_labor_cost, menu_ala_carte_parts_sales, menu_ala_carte_parts_cost, mpi_labor_hours_billed, mpi_labor_hours_actual, mpi_labor_sales, mpi_parts_sales, fpm_menu_def_sale_item_count, grease_oil_gas_cost, grease_oil_gas_sales, is_declined_service, is_menu_disclaimer, is_mpi_disclaimer, is_vip_reinspection, is_cp_menu_opp, is_cp_mpi_opp, is_fpm_menu_opp, is_fpm_menu_sale, is_menu_opp, is_menu_opp_incl_fpm, is_menu_sale, is_menu_sale_incl_fpm, is_mpi_sale, is_mpi_opp, is_wp_menu_opp, is_wp_mpi_opp, menu_lott, menu_def_opp_mileage, menu_def_opp_price_incl_fpm, menu_potential_labor_hours, menu_sale_labor_hours_billed_incl_ala_carte, menu_sale_labor_hours_billed_incl_fpm, menu_sale_labor_hours_billed_incl_fpm_and_ala_carte, menu_def_sale_labor_hours_incl_fpm, menu_sale_labor_sales_incl_ala_carte, menu_sale_labor_sales_incl_fpm, menu_sale_labor_sales_incl_fpm_and_ala_carte, menu_def_sale_mileage, menu_sale_parts_sales_incl_ala_carte, menu_sale_parts_sales_incl_fpm, menu_sale_parts_sales_incl_fpm_and_ala_carte, menu_def_sale_price_incl_fpm, mpi_potential_labor_sales, mpi_potential_parts_sales, multi_item_labor_sales, multi_item_parts_sales, multi_item_total_sales, one_item_labor_sales, one_item_parts_sales, one_item_total_sales, vehicle_mileage_out, fpm_menu_def_opp_mileage, fpm_menu_def_sale_mileage, is_roams_line, menu_def_sale_item_count_incl_fpm, menu_sale_labor_hours_actual_incl_ala_carte, menu_sale_labor_hours_actual_incl_fpm, menu_sale_labor_hours_actual_incl_fpm_and_ala_carte, expected_package_price, expected_parts_sales, expected_parts_cost, expected_labor_cost, expected_labor_hours FROM fact_labor_line f