explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yccW

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

Remote Fast Query Execution (cost=0.00..0.00 rows=0 width=0) (actual time=7,363.828..143,950.421 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 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 FROM (((fact_labor_line f LEFT JOIN dim_repair_order dro ON (((f.dim_repair_order_id = dro.dim_repair_order_id) AND (1 = 1)))) LEFT JOIN dim_labor_line dll ON (((f.dim_labor_line_id = dll.dim_labor_line_id) AND (1 = 1)))) LEFT JOIN dim_vehicle dv ON (((f.dim_vehicle_id = dv.dim_vehicle_id) AND (1 = 1))))
  • Buffers: shared hit=20