Duplicate Indexes

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

rails generate migration remove_unneeded_indexes

And paste

remove_index :barcode_registry, name: "idx_barcode_registry_barcode", column: :barcode
remove_index :code_symbol, name: "idx_code_symbol_repo", column: :repo
remove_index :connexx_shipment_packages, name: "idx_tracking_code_trgm", column: :"tracking_code gin_trgm_ops"
remove_index :connexx_shipments, name: "idx_shipments_not_cancelled_error", column: [:"id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text", :"'ERROR'::text])"]
remove_index :connexx_shipments, name: "connexx_shipments_sales_account_id_created_date_idx", column: [:sales_account_id, :created_date]
remove_index :consignment_imports, name: "ci_sales_account_id_idx", column: :sales_account_id
remove_index :currency, name: "idx_currency_id", column: :id
remove_index :currency, name: "idx_currency", column: :id
remove_index :file_imports, name: "idx_file_imports_hash", column: :file_hash
remove_index :financial_company, name: "idx_financial_company_id", column: :id
remove_index :flattened_shipments, name: "idx_flattened_created_day", column: :created_date_day
remove_index :flattened_shipments, name: "idx_flattened_created_month", column: :created_date_month
remove_index :flattened_shipments, name: "idx_flattened_created_week", column: :created_date_week
remove_index :flattened_shipments, name: "flattened_shipments_shipment_package_id_idx", column: :shipment_package_id
remove_index :flattened_shipments_scurri, name: "flattened_shipments_scurri_shipment_package_id_idx", column: :shipment_package_id
remove_index :intake_account_supplier_mapping, name: "idx_acct_supplier_config", column: :config_id
remove_index :intake_config_supplier, name: "idx_intake_config_supplier_config", column: :config_id
remove_index :intl_consignments_surcharges_transactions, name: "intl_consignments_surcharges_transactions_consignment_id_idx", column: :consignment_id
remove_index :intl_consignments_surcharges_transactions, name: "intl_consignments_surcharges_trans_consignment_surcharge_id_idx", column: :consignment_surcharge_id
remove_index :intl_consignments_surcharges_transactions, name: "intl_consignments_surcharges_transa_consignment_vat_duty_id_idx", column: :consignment_vat_duty_id
remove_index :intl_consignments_surcharges_transactions, name: "intl_consignments_surcharges_tra_supplier_linked_invoice_id_idx", column: :supplier_linked_invoice_id
remove_index :intl_consignments_surcharges_transactions, name: "idx_pl_icst_supplier_invoice", column: :supplier_linked_invoice_id
remove_index :intl_consignments_surcharges_transactions, name: "icst_supplier_linked_invoice_id_index", column: :supplier_linked_invoice_id
remove_index :margin_details, name: "idx_margin_details_sales_account", column: :sales_account_id
remove_index :mb_shipments_rollup_mv, name: "mb_shipments_rollup_mv_day_customer", column: [:day, :customer_name]
remove_index :pipeline_events, name: "idx_pipeline_events_pair_group", column: [:pair_group_id, :sequence]
remove_index :processing_lab_exceptions, name: "idx_plab_exceptions_run", column: :run_id
remove_index :processing_lab_output, name: "idx_plab_output_run", column: :run_id
remove_index :processing_run_steps, name: "idx_processing_run_steps_run_id", column: :run_id
remove_index :purchase_account_transactions, name: "index_pth_transaction_date", column: :transaction_date
remove_index :sales_account, name: "idx_sa_manager_structure", column: :account_manager_structure_id
remove_index :sales_account_shipping_whitelist, name: "sales_account_shipping_whitelist_sales_account_id_index", column: :sales_account_id
remove_index :sales_account_transactions, name: "slt_sales_acc_ind", column: :sales_account_id
remove_index :session_queries, name: "idx_session_queries_session_id", column: :session_id
remove_index :shipments, name: "idx_shipments_barcode", column: :barcode
remove_index :surcharge_types, name: "idx_surcharge_types_code", column: :code
remove_index :system_user, name: "idx_system_user_id", column: :id
remove_index :tariff_credential, name: "idx_rates_tariff_credential_tariff", column: :tariff_id
remove_index :tariff_user_default, name: "idx_rates_tud_user_carrier", column: [:user_id, :carrier_id]
remove_index :tariff_user_default, name: "idx_rates_tud_user_carrier", column: [:user_id, :carrier_id]
remove_index :tariffs, name: "idx_tariffs_code", column: :code
remove_index :uk_ecommerce_consignment_surcharges, name: "ukecs_supplier_invoice_id_index", column: :supplier_linked_invoice_id
remove_index :uk_ecommerce_consignments, name: "dom_con_sa_id_idx", column: :sales_account_id
remove_index :uk_ecommerce_consignments, name: "dom_con_supplier_invoice_id_idx", column: :supplier_linked_invoice_id
remove_index :uk_ecommerce_supplier_invoice, name: "idx_ukesi_supplier_account_id", column: :supplier_account_id
remove_index :uk_ecommerce_user_default_tariff, name: "idx_user_default_tariff_user_carrier", column: [:user_id, :carrier_id]
remove_index :uk_postcodes_april_2025, name: "idx_postcodes_latlng_group", column: [:lat_group, :lng_group]
remove_index :upload_column_mappings, name: "idx_column_mapping_config", column: :configuration_id
remove_index :upload_transform_run, name: "upload_transform_run_created_at_idx1", column: :"created_at DESC"
remove_index :upload_transform_run, name: "upload_transform_run_status_created_at_idx1", column: [:status, :"created_at DESC"]
remove_index :upload_transform_run, name: "upload_transform_run_supplier_account_id_created_at_idx1", column: [:supplier_account_id, :"created_at DESC"]
remove_index :upload_transform_run_column, name: "idx_transform_run_column_run_id", column: :run_id
remove_index :upload_transform_run_column, name: "idx_upload_transform_run_column_run_order", column: [:run_id, :column_order]
remove_index :upload_transform_run_row, name: "idx_transform_run_row_run_id", column: :run_id
remove_index :upload_transform_run_row, name: "idx_upload_transform_run_row_run_rownum", column: [:run_id, :row_number]

Details
On barcode_registry idx_barcode_registry_barcode (barcode) is covered by uq_barcode_registry_barcode_customer (barcode, customer_id, label_created_at)
On code_symbol idx_code_symbol_repo (repo) is covered by idx_code_symbol_repo_type (repo, symbol_type)
On connexx_shipment_packages idx_tracking_code_trgm (tracking_code gin_trgm_ops) is covered by idx_tracking_code_partial (tracking_code gin_trgm_ops)
On connexx_shipments idx_shipments_not_cancelled_error (id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text])) is covered by idx_shipments_id_status (id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]))
On connexx_shipments connexx_shipments_sales_account_id_created_date_idx (sales_account_id, created_date) is covered by idx_connexx_shipments_filter (sales_account_id, created_date, shipment_type, status)
On consignment_imports ci_sales_account_id_idx (sales_account_id) is covered by idx_ci_sa_created_date (sales_account_id, created_date_date)
On currency idx_currency_id (id) is covered by idx_currency (id)
On currency idx_currency (id) is covered by currency_pk (id)
On file_imports idx_file_imports_hash (file_hash) is covered by uq_file_imports_hash_carrier (file_hash, carrier_id)
On financial_company idx_financial_company_id (id) is covered by fin_comp_pk (id)
On flattened_shipments idx_flattened_created_day (created_date_day) is covered by idx_flattened_day_account_status (created_date_day, sales_account_id, status)
On flattened_shipments idx_flattened_created_month (created_date_month) is covered by idx_created_month_status_customer (created_date_month, status, customer_name)
On flattened_shipments idx_flattened_created_week (created_date_week) is covered by idx_created_week_status_customer (created_date_week, status, customer_name)
On flattened_shipments flattened_shipments_shipment_package_id_idx (shipment_package_id) is covered by flattened_shipments_shipment_package_id_uk (shipment_package_id)
On flattened_shipments_scurri flattened_shipments_scurri_shipment_package_id_idx (shipment_package_id) is covered by flattened_shipments_scurri_shipment_package_id_uk (shipment_package_id)
On intake_account_supplier_mapping idx_acct_supplier_config (config_id) is covered by intake_account_supplier_mapping_config_id_account_pattern_key (config_id, account_pattern)
On intake_config_supplier idx_intake_config_supplier_config (config_id) is covered by intake_config_supplier_config_id_supplier_id_key (config_id, supplier_id)
On intl_consignments_surcharges_transactions intl_consignments_surcharges_transactions_consignment_id_idx (consignment_id) is covered by idx_pl_icst_consignment (consignment_id)
On intl_consignments_surcharges_transactions intl_consignments_surcharges_trans_consignment_surcharge_id_idx (consignment_surcharge_id) is covered by idx_pl_icst_consignment_surcharge (consignment_surcharge_id)
On intl_consignments_surcharges_transactions intl_consignments_surcharges_transa_consignment_vat_duty_id_idx (consignment_vat_duty_id) is covered by idx_pl_icst_consignment_vat_duty (consignment_vat_duty_id)
On intl_consignments_surcharges_transactions intl_consignments_surcharges_tra_supplier_linked_invoice_id_idx (supplier_linked_invoice_id) is covered by idx_pl_icst_supplier_invoice (supplier_linked_invoice_id)
On intl_consignments_surcharges_transactions idx_pl_icst_supplier_invoice (supplier_linked_invoice_id) is covered by intl_consignments_surcharges__supplier_linked_invoice_id_co_idx (supplier_linked_invoice_id, consignment_id, consignment_surcharge_id)
On intl_consignments_surcharges_transactions icst_supplier_linked_invoice_id_index (supplier_linked_invoice_id) is covered by idx_icst_siid_cons_surch (supplier_linked_invoice_id, consignment_id, consignment_surcharge_id)
On margin_details idx_margin_details_sales_account (sales_account_id) is covered by idx_margin_details_lookup (sales_account_id, tariff_id, service_id, margin_type, effective_start_date)
On mb_shipments_rollup_mv mb_shipments_rollup_mv_day_customer (day, customer_name) is covered by mb_shipments_rollup_mv_uk (day, customer_name, day_order, week_start_sat)
On pipeline_events idx_pipeline_events_pair_group (pair_group_id, sequence) is covered by pipeline_events_pair_group_id_sequence_key (pair_group_id, sequence)
On processing_lab_exceptions idx_plab_exceptions_run (run_id) is covered by processing_lab_exceptions_run_id_line_index_target_table_key (run_id, line_index, target_table)
On processing_lab_output idx_plab_output_run (run_id) is covered by processing_lab_output_run_id_target_table_key (run_id, target_table)
On processing_run_steps idx_processing_run_steps_run_id (run_id) is covered by processing_run_steps_unique (run_id, step_name)
On purchase_account_transactions index_pth_transaction_date (transaction_date) is covered by idx_pat_txdate_flags (transaction_date, reversal_user, status, financial_company)
On sales_account idx_sa_manager_structure (account_manager_structure_id) is covered by idx_sales_account_structure (account_manager_structure_id, sales_person_structure_id)
On sales_account_shipping_whitelist sales_account_shipping_whitelist_sales_account_id_index (sales_account_id) is covered by idx_sales_account_whitelist_multi (sales_account_id, status, from_weight, to_weight, carrier_id, supplier_id, tariff_id, service_id)
On sales_account_transactions slt_sales_acc_ind (sales_account_id) is covered by active_sat_index (sales_account_id, financial_company, status, reversal_user, reversed_by, original_id, transaction_category)
On session_queries idx_session_queries_session_id (session_id) is covered by idx_session_queries_session (session_id)
On shipments idx_shipments_barcode (barcode) is covered by uq_shipments_barcode_date_carrier (barcode, invoice_date, carrier_id)
On surcharge_types idx_surcharge_types_code (code) is covered by surcharge_types_code_key (code)
On system_user idx_system_user_id (id) is covered by system_users_pk (id)
On tariff_credential idx_rates_tariff_credential_tariff (tariff_id) is covered by uq_tariff_credential_natural_key (tariff_id, credential_type)
On tariff_user_default idx_rates_tud_user_carrier (user_id, carrier_id) is covered by tariff_user_default_user_id_carrier_id_tariff_id_key (user_id, carrier_id, tariff_id)
On tariff_user_default idx_rates_tud_user_carrier (user_id, carrier_id) is covered by tariff_user_default_user_id_carrier_id_tariff_id_key (user_id, carrier_id, tariff_id)
On tariffs idx_tariffs_code (code) is covered by tariffs_code_key (code)
On uk_ecommerce_consignment_surcharges ukecs_supplier_invoice_id_index (supplier_linked_invoice_id) is covered by idx_ukecs_siid_charge_client_tariff (supplier_linked_invoice_id, charge_type, client, tariff_id)
On uk_ecommerce_consignments dom_con_sa_id_idx (sales_account_id) is covered by idx_ukec_sa_svc_created_desc (sales_account_id, service_id, created_date DESC) INCLUDE (sales_price)
On uk_ecommerce_consignments dom_con_supplier_invoice_id_idx (supplier_linked_invoice_id) is covered by idx_ukec_siid_client (supplier_linked_invoice_id, client)
On uk_ecommerce_supplier_invoice idx_ukesi_supplier_account_id (supplier_account_id) is covered by idx_ukesi_supplier_account_purchase_tx (supplier_account_id, purchase_transaction_id)
On uk_ecommerce_user_default_tariff idx_user_default_tariff_user_carrier (user_id, carrier_id) is covered by uk_ecommerce_user_default_tari_user_id_carrier_id_tariff_id_key (user_id, carrier_id, tariff_id)
On uk_postcodes_april_2025 idx_postcodes_latlng_group (lat_group, lng_group) is covered by idx_uk_postcodes_grouping (lat_group, lng_group, postcode_prefix)
On upload_column_mappings idx_column_mapping_config (configuration_id) is covered by upload_column_mappings_configuration_id_target_field_key (configuration_id, target_field)
On upload_transform_run upload_transform_run_created_at_idx1 (created_at DESC) is covered by upload_transform_run_created_at_idx (created_at DESC)
On upload_transform_run upload_transform_run_status_created_at_idx1 (status, created_at DESC) is covered by upload_transform_run_status_created_at_idx (status, created_at DESC)
On upload_transform_run upload_transform_run_supplier_account_id_created_at_idx1 (supplier_account_id, created_at DESC) is covered by upload_transform_run_supplier_account_id_created_at_idx (supplier_account_id, created_at DESC)
On upload_transform_run_column idx_transform_run_column_run_id (run_id) is covered by upload_transform_run_column_run_id_field_path_key (run_id, field_path)
On upload_transform_run_column idx_upload_transform_run_column_run_order (run_id, column_order) is covered by upload_transform_run_column_run_id_column_order_key (run_id, column_order)
On upload_transform_run_row idx_transform_run_row_run_id (run_id) is covered by idx_upload_transform_run_row_run_rownum (run_id, row_number)
On upload_transform_run_row idx_upload_transform_run_row_run_rownum (run_id, row_number) is covered by upload_transform_run_row_run_id_row_number_key (run_id, row_number)

Details

On barcode_registry

idx_barcode_registry_barcode (barcode)

is covered by

uq_barcode_registry_barcode_customer (barcode, customer_id, label_created_at)

On code_symbol

idx_code_symbol_repo (repo)

is covered by

idx_code_symbol_repo_type (repo, symbol_type)

On connexx_shipment_packages

idx_tracking_code_trgm (tracking_code gin_trgm_ops)

is covered by

idx_tracking_code_partial (tracking_code gin_trgm_ops)

On connexx_shipments

idx_shipments_not_cancelled_error (id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]))

is covered by

idx_shipments_id_status (id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]))

On connexx_shipments

connexx_shipments_sales_account_id_created_date_idx (sales_account_id, created_date)

is covered by

idx_connexx_shipments_filter (sales_account_id, created_date, shipment_type, status)

On consignment_imports

ci_sales_account_id_idx (sales_account_id)

is covered by

idx_ci_sa_created_date (sales_account_id, created_date_date)

On currency

idx_currency_id (id)

is covered by

idx_currency (id)

On currency

idx_currency (id)

is covered by

currency_pk (id)

On file_imports

idx_file_imports_hash (file_hash)

is covered by

uq_file_imports_hash_carrier (file_hash, carrier_id)

On financial_company

idx_financial_company_id (id)

is covered by

fin_comp_pk (id)

On flattened_shipments

idx_flattened_created_day (created_date_day)

is covered by

idx_flattened_day_account_status (created_date_day, sales_account_id, status)

On flattened_shipments

idx_flattened_created_month (created_date_month)

is covered by

idx_created_month_status_customer (created_date_month, status, customer_name)

On flattened_shipments

idx_flattened_created_week (created_date_week)

is covered by

idx_created_week_status_customer (created_date_week, status, customer_name)

On flattened_shipments

flattened_shipments_shipment_package_id_idx (shipment_package_id)

is covered by

flattened_shipments_shipment_package_id_uk (shipment_package_id)

On flattened_shipments_scurri

flattened_shipments_scurri_shipment_package_id_idx (shipment_package_id)

is covered by

flattened_shipments_scurri_shipment_package_id_uk (shipment_package_id)

On intake_account_supplier_mapping

idx_acct_supplier_config (config_id)

is covered by

intake_account_supplier_mapping_config_id_account_pattern_key (config_id, account_pattern)

On intake_config_supplier

idx_intake_config_supplier_config (config_id)

is covered by

intake_config_supplier_config_id_supplier_id_key (config_id, supplier_id)