Column	Sequence
ai_prompt_history.id upload_metadata	ai_prompt_history_id_seq upload_metadata
ai_prompts.id upload_metadata	ai_prompts_id_seq upload_metadata
analysis.id ai_codebrain	analysis_id_seq ai_codebrain
audit_log.id rate_engine	audit_log_id_seq rate_engine
barcode_registry.id logistics_v2	barcode_registry_id_seq logistics_v2
billing_data_files.id	billing_data_files_id_seq
billing_pdfs.id	billing_pdfs_id_seq
carrier.id rates	carrier_id_seq rates
carrier.id rate_engine	carrier_id_seq rate_engine
carrier.id	carrier_id_seq
carrier_sales_link.id	carrier_sales_link_id_seq
carrier_sales_link.id rates	carrier_sales_link_id_seq rates
carriers.id logistics_v2	carriers_id_seq logistics_v2
customer_shipments.id	customer_shipments_id_seq
customer_tariffs.id logistics_v2	customer_tariffs_id_seq logistics_v2
customers.id logistics_v2	customers_id_seq logistics_v2
depot.id rate_engine	depot_id_seq rate_engine
ecommerce_supplier_link.id	ecommerce_supplier_link_id_seq
ecommerce_tariff_link.id	ecommerce_tariff_link_id_seq
fedex_missng.id	fedex_missng_id_seq
file_formats.id logistics_v2	file_formats_id_seq logistics_v2
file_imports.id logistics_v2	file_imports_id_seq logistics_v2
ftp_files.id	ftp_files_seq
fuel_surcharge_bespoke_history.id rates	fuel_surcharge_bespoke_history_id_seq rates
fuel_surcharge_bespoke.id rates	fuel_surcharge_bespoke_id_seq rates
fuel_surcharge_rate.id rates	fuel_surcharge_rate_id_seq rates
fuel_surcharge_version.id rates	fuel_surcharge_version_id_seq rates
general_lookup.id	general_lookup_id_seq
gri_sales_account.id	gri_sa_seq
icst_2026_01_14t15_35_24z.id temp	icst_2026_01_14t15_35_24z_id_seq temp
icst_2026_01_14t17_40_55z.id temp	icst_2026_01_14t17_40_55z_id_seq temp
intake_account_supplier_mapping.id uploaded_data	intake_account_supplier_mapping_id_seq uploaded_data
intake_carrier_config.id uploaded_data	intake_carrier_config_id_seq uploaded_data
intake_config_supplier.id uploaded_data	intake_config_supplier_id_seq uploaded_data
intake_dispatch.id uploaded_data	intake_dispatch_id_seq uploaded_data
intake_ftp_poll_run.id uploaded_data	intake_ftp_poll_run_id_seq uploaded_data
intake_pair_group.id uploaded_data	intake_pair_group_id_seq uploaded_data
intake_pair_pdf_enrichment.id uploaded_data	intake_pair_pdf_enrichment_id_seq uploaded_data
intake_staged_file.id uploaded_data	intake_staged_file_id_seq uploaded_data
inter_company_customer.id	inter_company_customer_id_seq
intl_consignments_2025_08_08t13_30_43_01_00_288_19673.id temp	intl_consignments_2025_08_08t13_30_43_01_00_288_19673_id_seq temp
invoice_analysis.id sales	invoice_analysis_id_seq sales
invoice_analysis_line.id sales	invoice_analysis_line_id_seq sales
invoice_copy_audit.id uploaded_data	invoice_copy_audit_id_seq uploaded_data
invoice_copy_id_map.id uploaded_data	invoice_copy_id_map_id_seq uploaded_data
intl_consignment_surcharges.id processing_lab	lab_consignment_surcharges_seq processing_lab
intl_consignments.id processing_lab	lab_consignments_seq processing_lab
intl_consignments_surcharges_transactions.id processing_lab	lab_cst_seq processing_lab
intl_consignment_vat_duty.id processing_lab	lab_cvd_seq processing_lab
intl_supplier_invoice.id processing_lab	lab_supplier_invoice_seq processing_lab
leads.id scanning_app	leads_id_seq scanning_app
margin_details.id	margin_details_id_seq
override_rate.id rate_engine	override_rate_id_seq rate_engine
pipeline_events.id uploaded_data	pipeline_events_id_seq uploaded_data
pricing_profile.id rate_engine	pricing_profile_id_seq rate_engine
processing_events.id logistics_v2	processing_events_id_seq logistics_v2
processing_lab_exceptions.id uploaded_data	processing_lab_exceptions_id_seq uploaded_data
processing_lab_output.id uploaded_data	processing_lab_output_id_seq uploaded_data
processing_lab_run_exceptions.id uploaded_data	processing_lab_run_exceptions_id_seq uploaded_data
processing_lab_run.id uploaded_data	processing_lab_run_id_seq uploaded_data
processing_manual_overrides.id uploaded_data	processing_manual_overrides_id_seq uploaded_data
processing_run_steps.id uploaded_data	processing_run_steps_id_seq uploaded_data
processing_runs.id uploaded_data	processing_runs_id_seq uploaded_data
query_log.id ai_codebrain	query_log_id_seq ai_codebrain
quote_comparison.id uploaded_data	quote_comparison_id_seq uploaded_data
quote.id sales	quote_id_seq sales
rate_card.id rate_engine	rate_card_id_seq rate_engine
rate_card_line.id rate_engine	rate_card_line_id_seq rate_engine
rate_cards.id logistics_v2	rate_cards_id_seq logistics_v2
refactor_project.id ai_codebrain	refactor_project_id_seq ai_codebrain
sales_account_pricing.id logistics_v2	sales_account_pricing_id_seq logistics_v2
service.id rate_engine	service_id_seq rate_engine
service.id	service_id_seq
service.id rates	service_id_seq rates
service_zones.id logistics_v2	service_zones_id_seq logistics_v2
services.id logistics_v2	services_id_seq logistics_v2
session_queries.id ai_codebrain	session_queries_id_seq ai_codebrain
sessions.id ai_codebrain	sessions_id_seq ai_codebrain
shipments.id logistics_v2	shipments_id_seq logistics_v2
supplier.id rates	supplier_id_seq rates
supplier.id	supplier_id_seq
supplier_sales_link.id	supplier_sales_link_id_seq
supplier_sales_link.id rates	supplier_sales_link_id_seq rates
supplier_service_zones.id	supplier_service_zones_id_seq
supplier_service_zones.id rates	supplier_service_zones_id_seq rates
suppliers.id logistics_v2	suppliers_id_seq logistics_v2
surcharge.id	surcharge_id_seq
surcharge.id rates	surcharge_id_seq rates
surcharge_rules.id	surcharge_rules_id_seq
surcharge_types.id	surcharge_types_id_seq
surcharges.id logistics_v2	surcharges_id_seq logistics_v2
tariff_child_account.id rates	tariff_child_account_id_seq rates
tariff_child_account.id	tariff_child_account_id_seq
tariff_credential.id rates	tariff_credential_id_seq rates
tariff_credential.id	tariff_credential_id_seq
tariff.id	tariff_id_seq
tariff.id rates	tariff_id_seq rates
tariff_rate.id rates	tariff_rate_id_seq rates
tariff_rate.id	tariff_rate_id_seq
tariff_sales_fuel_link.id rates	tariff_sales_fuel_link_id_seq rates
tariff_sales_fuel_link.id	tariff_sales_fuel_link_id_seq
tariff_user_default.id	tariff_user_default_id_seq
tariff_user_default.id rates	tariff_user_default_id_seq rates
tariffs.id logistics_v2	tariffs_id_seq logistics_v2
temp_connexx_marketplace_tracking_callbacks.id	temp_connexx_marketplace_tracking_callbacks_id_seq
uk_ecommerce_user_default_tariff.id	uk_ecommerce_user_default_tariff_id_seq
upload_column_mappings.id upload_metadata	upload_column_mappings_id_seq upload_metadata
upload_configuration_audit.id upload_metadata	upload_configuration_audit_id_seq upload_metadata
upload_configurations.id upload_metadata	upload_configurations_id_seq upload_metadata
upload_date_formats.id upload_metadata	upload_date_formats_id_seq upload_metadata
upload_derived_fields.id upload_metadata	upload_derived_fields_id_seq upload_metadata
upload_dynamic_surcharges.id upload_metadata	upload_dynamic_surcharges_id_seq upload_metadata
upload_field_transformations.id upload_metadata	upload_field_transformations_id_seq upload_metadata
upload_package_type_mappings.id upload_metadata	upload_package_type_mappings_id_seq upload_metadata
upload_service_mappings.id upload_metadata	upload_service_mappings_id_seq upload_metadata
upload_surcharge_mappings.id upload_metadata	upload_surcharge_mappings_id_seq upload_metadata
upload_template_supplier_link.id upload_metadata	upload_template_supplier_link_id_seq upload_metadata
upload_transform_run_column.id uploaded_data	upload_transform_run_column_id_seq uploaded_data
upload_transform_run.id uploaded_data	upload_transform_run_id_seq uploaded_data
upload_transform_run_row.id uploaded_data	upload_transform_run_row_id_seq uploaded_data
upload_validation_rules.id upload_metadata	upload_validation_rules_id_seq upload_metadata
upload_version_detection.id upload_metadata	upload_version_detection_id_seq upload_metadata
validation_rule.id rate_engine	validation_rule_id_seq rate_engine
yodel_pan_files.id	yodel_pan_files_id_seq
zone_postcodes.id logistics_v2	zone_postcodes_id_seq logistics_v2
zones.id logistics_v2	zones_id_seq logistics_v2

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)