Queries

Total Time	Average Time	Calls
878 min 21%	557 ms	94,594 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" LEFT JOIN "public"."portal_user" AS "j3" ON ("j3"."id") = ("public"."connexx_shipments"."created_by") LEFT JOIN "public"."connexx_shipment_bulk_uploads" AS "j4" ON ("j4"."id") = ("public"."connexx_shipments"."shipment_bulk_upload_id") LEFT JOIN "public"."sales_account_shipping_whitelist" AS "j5" ON ("j5"."id") = ("public"."connexx_shipments"."shipping_whitelist_id") WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND ("public"."connexx_shipments"."customer_reference" ILIKE $3 OR "public"."connexx_shipments"."customer_reference_2" ILIKE $4 OR "public"."connexx_shipments"."order_number" ILIKE $5 OR "public"."connexx_shipments"."from_address_company" ILIKE $6 OR "public"."connexx_shipments"."from_address_first_name" ILIKE $7 OR "public"."connexx_shipments"."from_address_last_name" ILIKE $8 OR "public"."connexx_shipments"."from_address_street_1" ILIKE $9 OR "public"."connexx_shipments"."from_address_zip" ILIKE $10 OR "public"."connexx_shipments"."to_address_company" ILIKE $11 OR "public"."connexx_shipments"."to_address_first_name" ILIKE $12 OR "public"."connexx_shipments"."to_address_last_name" ILIKE $13 OR "public"."connexx_shipments"."to_address_street_1" ILIKE $14 OR "public"."connexx_shipments"."to_address_zip" ILIKE $15 OR "public"."connexx_shipments"."estimated_delivery_date" ILIKE $16 OR ("public"."connexx_shipments"."id") IN (SELECT "t1"."shipment_id" FROM "public"."connexx_shipment_packages" AS "t1" WHERE ("t1"."tracking_code" ILIKE $17 AND "t1"."shipment_id" IS NOT NULL)) OR ("public"."connexx_shipments"."id") IN (SELECT "t2"."shipment_id" FROM "public"."connexx_shipment_item_descriptions" AS "t2" WHERE (("t2"."sku" ILIKE $18 OR "t2"."description" ILIKE $19) AND "t2"."shipment_id" IS NOT NULL)) OR ("j3"."email" ILIKE $20 AND ("j3"."id" IS NOT NULL)) OR ("j4"."filename" ILIKE $21 AND ("j4"."id" IS NOT NULL)) OR (("j5"."carrier_name" ILIKE $22 OR "j5"."service_name" ILIKE $23) AND ("j5"."id" IS NOT NULL))) AND "public"."connexx_shipments"."created_date" >= $24 AND "public"."connexx_shipments"."created_date" <= $25 AND "public"."connexx_shipments"."deleted_date" IS NULL AND "public"."connexx_shipments"."status" IN ($26)) ORDER BY "public"."connexx_shipments"."created_date" DESC LIMIT $27 OFFSET $28
730 min 18%	435 ms	100,761 upadmin
SELECT COUNT(*), "public"."connexx_shipments"."status" FROM "public"."connexx_shipments" LEFT JOIN "public"."portal_user" AS "j3" ON ("j3"."id") = ("public"."connexx_shipments"."created_by") LEFT JOIN "public"."connexx_shipment_bulk_uploads" AS "j4" ON ("j4"."id") = ("public"."connexx_shipments"."shipment_bulk_upload_id") LEFT JOIN "public"."sales_account_shipping_whitelist" AS "j5" ON ("j5"."id") = ("public"."connexx_shipments"."shipping_whitelist_id") WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND ("public"."connexx_shipments"."customer_reference" ILIKE $3 OR "public"."connexx_shipments"."customer_reference_2" ILIKE $4 OR "public"."connexx_shipments"."order_number" ILIKE $5 OR "public"."connexx_shipments"."from_address_company" ILIKE $6 OR "public"."connexx_shipments"."from_address_first_name" ILIKE $7 OR "public"."connexx_shipments"."from_address_last_name" ILIKE $8 OR "public"."connexx_shipments"."from_address_street_1" ILIKE $9 OR "public"."connexx_shipments"."from_address_zip" ILIKE $10 OR "public"."connexx_shipments"."to_address_company" ILIKE $11 OR "public"."connexx_shipments"."to_address_first_name" ILIKE $12 OR "public"."connexx_shipments"."to_address_last_name" ILIKE $13 OR "public"."connexx_shipments"."to_address_street_1" ILIKE $14 OR "public"."connexx_shipments"."to_address_zip" ILIKE $15 OR "public"."connexx_shipments"."estimated_delivery_date" ILIKE $16 OR ("public"."connexx_shipments"."id") IN (SELECT "t1"."shipment_id" FROM "public"."connexx_shipment_packages" AS "t1" WHERE ("t1"."tracking_code" ILIKE $17 AND "t1"."shipment_id" IS NOT NULL)) OR ("public"."connexx_shipments"."id") IN (SELECT "t2"."shipment_id" FROM "public"."connexx_shipment_item_descriptions" AS "t2" WHERE (("t2"."sku" ILIKE $18 OR "t2"."description" ILIKE $19) AND "t2"."shipment_id" IS NOT NULL)) OR ("j3"."email" ILIKE $20 AND ("j3"."id" IS NOT NULL)) OR ("j4"."filename" ILIKE $21 AND ("j4"."id" IS NOT NULL)) OR (("j5"."carrier_name" ILIKE $22 OR "j5"."service_name" ILIKE $23) AND ("j5"."id" IS NOT NULL))) AND "public"."connexx_shipments"."created_date" >= $24 AND "public"."connexx_shipments"."created_date" <= $25) GROUP BY "public"."connexx_shipments"."status" OFFSET $26
459 min 11%	291 ms	94,595 upadmin
SELECT "public"."connexx_shipments"."id" FROM "public"."connexx_shipments" LEFT JOIN "public"."portal_user" AS "j3" ON ("j3"."id") = ("public"."connexx_shipments"."created_by") LEFT JOIN "public"."connexx_shipment_bulk_uploads" AS "j4" ON ("j4"."id") = ("public"."connexx_shipments"."shipment_bulk_upload_id") LEFT JOIN "public"."sales_account_shipping_whitelist" AS "j5" ON ("j5"."id") = ("public"."connexx_shipments"."shipping_whitelist_id") WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND ("public"."connexx_shipments"."customer_reference" ILIKE $3 OR "public"."connexx_shipments"."customer_reference_2" ILIKE $4 OR "public"."connexx_shipments"."order_number" ILIKE $5 OR "public"."connexx_shipments"."from_address_company" ILIKE $6 OR "public"."connexx_shipments"."from_address_first_name" ILIKE $7 OR "public"."connexx_shipments"."from_address_last_name" ILIKE $8 OR "public"."connexx_shipments"."from_address_street_1" ILIKE $9 OR "public"."connexx_shipments"."from_address_zip" ILIKE $10 OR "public"."connexx_shipments"."to_address_company" ILIKE $11 OR "public"."connexx_shipments"."to_address_first_name" ILIKE $12 OR "public"."connexx_shipments"."to_address_last_name" ILIKE $13 OR "public"."connexx_shipments"."to_address_street_1" ILIKE $14 OR "public"."connexx_shipments"."to_address_zip" ILIKE $15 OR "public"."connexx_shipments"."estimated_delivery_date" ILIKE $16 OR ("public"."connexx_shipments"."id") IN (SELECT "t1"."shipment_id" FROM "public"."connexx_shipment_packages" AS "t1" WHERE ("t1"."tracking_code" ILIKE $17 AND "t1"."shipment_id" IS NOT NULL)) OR ("public"."connexx_shipments"."id") IN (SELECT "t2"."shipment_id" FROM "public"."connexx_shipment_item_descriptions" AS "t2" WHERE (("t2"."sku" ILIKE $18 OR "t2"."description" ILIKE $19) AND "t2"."shipment_id" IS NOT NULL)) OR ("j3"."email" ILIKE $20 AND ("j3"."id" IS NOT NULL)) OR ("j4"."filename" ILIKE $21 AND ("j4"."id" IS NOT NULL)) OR (("j5"."carrier_name" ILIKE $22 OR "j5"."service_name" ILIKE $23) AND ("j5"."id" IS NOT NULL))) AND "public"."connexx_shipments"."created_date" >= $24 AND "public"."connexx_shipments"."created_date" <= $25 AND "public"."connexx_shipments"."deleted_date" IS NULL AND "public"."connexx_shipments"."status" IN ($26)) ORDER BY "public"."connexx_shipments"."created_date" DESC OFFSET $27
239 min 6%	86 ms	166,291 upadmin
`SELECT COUNT(*), "public"."connexx_label_jobs"."downloaded" FROM "public"."connexx_label_jobs" WHERE "public"."connexx_label_jobs"."sales_account_id" = $1 GROUP BY "public"."connexx_label_jobs"."downloaded" OFFSET $2` `Covered by index on (sales_account_id, created_date) Rows: 12958780 Row progression: 12958780, 25509 Row estimates - sales_account_id (=): 25509 Existing indexes - id PRIMARY - deprecated_shipment_ids - sales_account_id, created_date - uuid UNIQUE`
210 min 5%	76 ms	166,291 upadmin
`SELECT COUNT(*) FROM (SELECT "public"."connexx_label_jobs"."id" FROM "public"."connexx_label_jobs" WHERE ("public"."connexx_label_jobs"."sales_account_id" = $1 AND "public"."connexx_label_jobs"."status" <> $2) OFFSET $3) AS "sub"`
183 min 4%	70 ms	157,358 upadmin
`SELECT * FROM get_quotes_v5(current_date, cast($1 as int), cast($2 as int), cast($3 as int), $4, $5, $6, $7, cast($8 as int), cast($9 as int) ) WHERE id IS NOT NULL ORDER BY carrier_name, supplier_name, service_name`
177 min 4%	1 ms	16,903,590 upadmin
`SELECT "public"."intl_service"."id", "public"."intl_service"."name" FROM "public"."intl_service" WHERE $2=$3 OFFSET $1`
146 min 4%	1 ms	16,903,877 upadmin
`SELECT "public"."uk_ecommerce_tariff_child_account"."id", "public"."uk_ecommerce_tariff_child_account"."alias", "public"."uk_ecommerce_tariff_child_account"."child_account_name" FROM "public"."uk_ecommerce_tariff_child_account" WHERE $2=$3 OFFSET $1`
128 min 3%	7 ms	1,155,881 upadmin
SELECT "public"."consignment_unified_statuses"."id", "public"."consignment_unified_statuses"."created_at", "public"."consignment_unified_statuses"."tracking_code", "public"."consignment_unified_statuses"."client_description", "public"."consignment_unified_statuses"."unified_status", "public"."consignment_unified_statuses"."carrier_id", "public"."consignment_unified_statuses"."carrier", "public"."consignment_unified_statuses"."ghost_scan", "public"."consignment_unified_statuses"."exception_type" FROM "public"."consignment_unified_statuses" WHERE $2=$3 OFFSET $1
87 min 2%	65 ms	80,578 upadmin
SELECT "public"."connexx_shipment_packages"."id", "public"."connexx_shipment_packages"."created_by", "public"."connexx_shipment_packages"."created_date", "public"."connexx_shipment_packages"."last_modified_by", "public"."connexx_shipment_packages"."last_modified_date", "public"."connexx_shipment_packages"."shipment_id", "public"."connexx_shipment_packages"."weight", "public"."connexx_shipment_packages"."length", "public"."connexx_shipment_packages"."height", "public"."connexx_shipment_packages"."type", "public"."connexx_shipment_packages"."quantity", "public"."connexx_shipment_packages"."width", "public"."connexx_shipment_packages"."tracking_code", "public"."connexx_shipment_packages"."label_created_date", "public"."connexx_shipment_packages"."label_url", "public"."connexx_shipment_packages"."label_format", "public"."connexx_shipment_packages"."errors", "public"."connexx_shipment_packages"."index", "public"."connexx_shipment_packages"."sales_account_id", "public"."connexx_shipment_packages"."base64_pdf", "public"."connexx_shipment_packages"."shipping_price", "public"."connexx_shipment_packages"."base64_zpl", "public"."connexx_shipment_packages"."original_ui_index", "public"."connexx_shipment_packages"."created_date_date", "public"."connexx_shipment_packages"."year", "public"."connexx_shipment_packages"."month", "public"."connexx_shipment_packages"."class", "public"."connexx_shipment_packages"."dg_net_weight", "public"."connexx_shipment_packages"."dgun_number", "public"."connexx_shipment_packages"."dry_ice_weight", "public"."connexx_shipment_packages"."lithium_category", "public"."connexx_shipment_packages"."packing_group", "public"."connexx_shipment_packages"."dg_package", "public"."connexx_shipment_packages"."carrier_shipment_package_id", "public"."connexx_shipment_packages"."dg_volume_ml_100" FROM "public"."connexx_shipment_packages" LEFT JOIN "public"."connexx_shipments" AS "j1" ON ("j1"."id") = ("public"."connexx_shipment_packages"."shipment_id") WHERE ("public"."connexx_shipment_packages"."tracking_code" IN ($1 /, ... /) AND "public"."connexx_shipment_packages"."sales_account_id" IN ($2 /, ... /) AND ("j1"."shipping_whitelist_id" IS NOT NULL AND ("j1"."id" IS NOT NULL))) OFFSET $3
61 min 1%	0 ms	16,903,590 upadmin
`SELECT "public"."intl_supplier"."id", "public"."intl_supplier"."name", "public"."intl_supplier"."alias", "public"."intl_supplier"."carrier_depot_id", "public"."intl_supplier"."api_path", "public"."intl_supplier"."supports_importer_of_the_records", "public"."intl_supplier"."allow_supplier_pickup" FROM "public"."intl_supplier" WHERE $2=$3 OFFSET $1`
51 min 1%	574 ms	5,327 upadmin
INSERT INTO shipment_data.flattened_shipments ( shipment_package_id, shipment_id, sales_account_id, sales_account_reference, company_id, customer_name, tracking_code, status, created_date, shipment_source_name, supplier_name, shipping_whitelist_id, iso_country_origin, iso_country_destination, zip_origin, zip_destination ) SELECT csp.id, cs.id, sa.id, sa.sales_account_reference, co.id, UPPER(co.name), csp.tracking_code, UPPER(cs.status), cs.created_date, UPPER(cs.shipment_source_name), UPPER(combined_suppliers.supplier_name), cs.shipping_whitelist_id, cs.from_address_country_iso, cs.to_address_country_iso, cs.from_address_zip, cs.to_address_zip FROM public.connexx_shipment_packages csp LEFT JOIN public.connexx_shipments cs ON cs.id = csp.shipment_id LEFT JOIN public.sales_account sa ON sa.id = cs.sales_account_id LEFT JOIN public.company co ON co.id = sa.company_id LEFT JOIN public.sales_account_shipping_whitelist sasw ON sasw.id = cs.shipping_whitelist_id LEFT JOIN public.combined_suppliers ON combined_suppliers.id = sasw.supplier_id LEFT JOIN shipment_data.flattened_shipments fs ON fs.shipment_package_id = csp.id WHERE csp.tracking_code IS NOT NULL AND upper(cs.status) <> $1 AND csp.created_date >= date_trunc($2, current_date) - INTERVAL $3 AND csp.sales_account_id NOT IN ($4 /, ... /) AND fs.shipment_package_id IS NULL
33 min 0.8%	2,501 ms	781 postgresitd
WITH returned_data AS (SELECT rc.awb AS outgoing_barcode, rc.source_table AS parent_table, rc.source_table_id AS parent_table_id, $1 AS return_match, $2 AS customer_name, $3 AS trading_name, $4 AS sales_account_id, $5 AS sales_account_reference, $6 AS ship_to_postcode, $7 AS carrier, $8 AS dom_intl, $9 AS carrier_id, $10 AS depot, $11 AS return_method, $12 AS shipper_reference, $13 AS returns_address, COALESCE(rc.created_date, $14) AS return_received_date, COALESCE(rc.created_by, $15) AS return_received_by FROM returns_consignment rc WHERE rc.awb = $16), uk_billed AS (SELECT DISTINCT ukec.barcode AS outgoing_barcode, $17 AS parent_table, ukec.id::bigint AS parent_table_id, $18 AS return_match, COALESCE(RTRIM(company.name), $19) AS customer_name, COALESCE(sa.trade_name, $20) AS trading_name, COALESCE(ukec.sales_account_id, $21) AS sales_account_id, COALESCE(ukec.sales_account_reference, $22) AS sales_account_reference, COALESCE(ship_to_postcode, $23) AS ship_to_postcode, COALESCE(ukcar.name, $24) AS carrier, $25 AS dom_intl, COALESCE(ukcar.id, $26) AS carrier_id, CASE WHEN carrier_cd.name IS NOT NULL AND carrier_cd.name <> $27 THEN carrier_cd.name ELSE COALESCE(general_cd.name, $28) END AS depot, COALESCE(sa.return_method, $29) AS return_method, COALESCE(shipper_reference_1, $30) AS shipper_reference, regexp_replace(COALESCE(aan.address_line_1, $31) \|\| chr($32) \|\| COALESCE(aan.address_line_2, $33) \|\| chr($34) \|\| COALESCE(aan.address_line_3, $35) \|\| chr($36) \|\| COALESCE(aan.city, $37) \|\| chr($38) \|\| COALESCE(aan.county_state, $39) \|\| chr($40) \|\| COALESCE(aan.postcode, $41) \|\| chr($42) \|\| COALESCE(aan.country, $43), $44, $45, $46) AS returns_address, COALESCE(return_received_date, $47) AS return_received_date, COALESCE(return_received_by, $48) AS return_received_by FROM uk_ecommerce_consignments ukec LEFT JOIN uk_ecommerce_service ukes ON ukec.service_id = ukes.id LEFT JOIN uk_ecommerce_carrier ukcar ON ukes.carrier_id = ukcar.id LEFT JOIN nominal_transaction_lines ntl ON ntl.referring_id = ukec.id LEFT JOIN sales_account_transactions sat ON sat.id = ntl.sales_transaction_id LEFT JOIN sales_account sa ON sa.id = ukec.sales_account_id LEFT JOIN company ON company.id = sa.company_id LEFT JOIN account_address_new aan ON aan.company_id = company.id AND aan.returns_address = $49 AND aan.status = $50 LEFT JOIN sales_account_collection_types carrier_sact ON sa.id = carrier_sact.sales_account_id AND carrier_sact.domestic_international = $51 AND carrier_sact.carrier_id = ukcar.id AND carrier_sact.collected_by = $52 AND carrier_sact.status = $53 LEFT JOIN sales_account_collection_types general_sact ON sa.id = general_sact.sales_account_id AND general_sact.collected_by = $54 AND general_sact.status = $55 LEFT JOIN carrier_depots carrier_cd ON carrier_sact.depot_id = carrier_cd.id LEFT JOIN carrier_depots general_cd ON general_sact.depot_id = general_cd.id WHERE ukec.barcode = $56), intl_billed AS (SELECT DISTINCT ON (ic.consignment_number) COALESCE(ic.barcode, ic.consignment_number) AS outgoing_barcode, $57 AS parent_table, ukec.id::bigint AS parent_table_id, $58 AS return_match, COALESCE(RTRIM(company.name), $59) AS customer_name, COALESCE(sa.trade_name, $60) AS trading_name, COALESCE(sa.id, $61) AS sales_account_id, COALESCE(sa.sales_account_reference, $62) AS sales_account_reference, COALESCE(ic.ship_to_postcode, $63) AS ship_to_postcode, COALESCE(i_carrier.name, $64) AS carrier, $65 AS dom_intl, COALESCE(i_carrier.id, $66) AS carrier_id, CASE WHEN carrier_cd.name IS NOT NULL AND carrier_cd.name <> $67 THEN carrier_cd.name ELSE COALESCE(general_cd.name, $68) END AS depot, COALESCE(sa.return_method, $69) AS return_method, COALESCE(CASE WHEN ic.shipper_reference_1 IS NOT NULL AND ic.shipper_reference_1 <> $70 THEN ic.shipper_reference_1 ELSE ic.order_number END, $71) AS shipper_reference, regexp_replace(COALESCE(aan.address_line_1, $72) \|\| chr($73) \|\| COALESCE(aan.address_line_2, $74) \|\| chr($75) \|\| COALESCE(aan.address_line_3, $76) \|\| chr($77) \|\| COALESCE(aan.city, $78) \|\| chr($79) \|\| COALESCE(aan.county_state, $80) \|\| chr($81) \|\| COALESCE(aan.postcode, $82) \|\| chr($83) \|\| COALESCE(aan.country, $84), $85, $86, $87) AS returns_address, COALESCE(ic.return_received_date, $88) AS return_received_date, COALESCE(ic.return_received_by, $89) AS return_received_by FROM intl_consignments_surcharges_transactions ukec LEFT JOIN intl_consignments ic ON ic.id = ukec.consignment_id LEFT JOIN intl_service i_service ON i_service.id = ic.service_id LEFT JOIN intl_carrier i_carrier ON i_carrier.id = i_service.carrier_id LEFT JOIN sales_account sa ON sa.id = ukec.sales_account_id LEFT JOIN company ON company.id = sa.company_id LEFT JOIN account_address_new aan ON aan.company_id = sa.company_id AND aan.returns_address = $90 AND aan.status = $91 LEFT JOIN sales_account_collection_types carrier_sact ON sa.id = carrier_sact.sales_account_id AND carrier_sact.domestic_international = $92 AND carrier_sact.carrier_id = i_carrier.id AND carrier_sact.collected_by = $93 AND carrier_sact.status = $94 LEFT JOIN sales_account_collection_types general_sact ON sa.id = general_sact.sales_account_id AND general_sact.collected_by = $95 AND general_sact.status = $96 LEFT JOIN carrier_depots carrier_cd ON carrier_sact.depot_id = carrier_cd.id LEFT JOIN carrier_depots general_cd ON general_sact.depot_id = general_cd.id WHERE (ic.barcode = $97 OR ic.consignment_number = $98)), imports AS (SELECT DISTINCT ukec.barcode AS outgoing_barcode, $99 AS parent_table, ukec.id::bigint AS parent_table_id, $100 AS return_match, COALESCE(RTRIM(company.name), $101) AS customer_name, COALESCE(sa.trade_name, $102) AS trading_name, COALESCE(ukec.sales_account_id, $103) AS sales_account_id, COALESCE(ukec.sales_account_reference, $104) AS sales_account_reference, COALESCE(ship_to_postcode, $105) AS ship_to_postcode, COALESCE(carrier, $106) AS carrier, CASE WHEN carrier = $107 AND service = $108 THEN $109 WHEN carrier = $110 AND service <> $111 THEN $112 WHEN carrier = $113 THEN $114 ELSE $115 END AS dom_intl, CASE WHEN carrier ilike $116 THEN $117 WHEN carrier ilike $118 THEN $119 WHEN carrier ilike $120 THEN $121 WHEN (carrier ilike $122 OR carrier ilike $123) THEN $124 WHEN carrier ilike $125 THEN $126 WHEN carrier ilike $127 THEN $128 WHEN carrier ilike $129 THEN $130 WHEN (carrier ilike $131 OR carrier ilike $132) THEN $133 WHEN carrier ilike $134 THEN $135 WHEN carrier ilike $136 THEN $137 WHEN carrier ilike $138 THEN $139 WHEN carrier ilike $140 THEN $141 ELSE COALESCE((SELECT id FROM intl_carrier WHERE (name = carrier OR similarity(name, carrier) > $142) AND financial_company = $143), $144) END AS carrier_id, (SELECT COALESCE(COALESCE(CASE WHEN carrier = $145 AND service = $146 THEN (SELECT cd.name FROM sales_account_collection_types sact LEFT JOIN carrier_depots cd ON sact.depot_id = cd.id WHERE sact.sales_account_id = ukec.sales_account_id AND sact.domestic_international = $147 AND sact.carrier_id = $148 AND sact.collected_by = $149) WHEN carrier = $150 AND service <> $151 THEN (SELECT cd.name FROM sales_account_collection_types sact LEFT JOIN carrier_depots cd ON sact.depot_id = cd.id WHERE sact.status = $152 AND sact.sales_account_id = ukec.sales_account_id AND sact.domestic_international = $153 AND sact.carrier_id = $154 AND sact.collected_by = $155) WHEN carrier = $156 THEN (SELECT cd.name FROM sales_account_collection_types sact LEFT JOIN carrier_depots cd ON sact.depot_id = cd.id WHERE sact.status = $157 AND sact.sales_account_id = ukec.sales_account_id AND sact.domestic_international = $158 AND sact.carrier_id = $159 AND sact.collected_by = $160) WHEN carrier ilike $161 THEN (SELECT cd.name FROM sales_account_collection_types sact LEFT JOIN carrier_depots cd ON sact.depot_id = cd.id WHERE sact.status = $162 AND sact.sales_account_id = ukec.sales_account_id AND sact.domestic_international = $163 AND sact.carrier_id = $164 AND sact.collected_by = $165) WHEN (carrier ilike $166 OR carrier ilike $167) THEN (SELECT cd.name FROM sales_account_collection_types sact LEFT JOIN carrier_depots cd ON sact.depot_id = cd.id WHERE sact.status = $168 AND sact.sales_account_id = ukec.sales_account_id AND sact.domestic_international = $169 AND sact.carrier_id = $170 AND sact.collected_by = $171) WHEN carrier ilike $172 THEN (SELECT cd.name FROM sales_account_collection_types sact LEFT JOIN carrier_depots
30 min 0.7%	10 ms	174,036 upadmin
`SELECT COUNT(*) FROM (SELECT "public"."connexx_shipments"."id" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND "public"."connexx_shipments"."deleted_date" IS NULL) OFFSET $3) AS "sub"`
27 min 0.6%	0 ms	16,903,580 upadmin
`SELECT "public"."intl_tariff"."id", "public"."intl_tariff"."name", "public"."intl_tariff"."carrier_id", "public"."intl_tariff"."direction_type" FROM "public"."intl_tariff" WHERE $2=$3 OFFSET $1`
26 min 0.6%	2,584 ms	613 postgresitd
SELECT $4, ukesi.id, ukesi.status, ukesi.created_date, ukea.name, ukes.name, ukesi.supplier_invoice_number, ukesi.description, $5 as invoice_type, COALESCE((SUM(COALESCE(ukec.supplier_cost_price, $6)) FILTER (WHERE ukec.exception_code != $7)), $8) + COALESCE((SELECT SUM(COALESCE(ukecs.supplier_cost_price, $9)) FROM uk_ecommerce_consignment_surcharges ukecs WHERE ukecs.supplier_linked_invoice_id = ukesi.id AND ukecs.exception_code != $10), $11) AS supplier_freight_exceptions, $12, COALESCE((SUM(COALESCE(ukec.sales_price, $13)) FILTER (WHERE ukec.exception_code <> $14)), $15) + COALESCE((SUM(COALESCE(ukec.surcharge_sales_price, $16)) FILTER (WHERE ukec.exception_code <> $17)), $18) + COALESCE((SELECT SUM(COALESCE(ukecs.sales_price, $19)) FROM uk_ecommerce_consignment_surcharges ukecs WHERE ukecs.supplier_linked_invoice_id = ukesi.id AND ukecs.exception_code != $20), $21) + COALESCE((SELECT SUM(t1.sales_fuel) ::bigint FROM (SELECT (SUM(COALESCE(sales_price, $22))::bigint + SUM(COALESCE(surcharge_sales_price, $23))::bigint) * COALESCE(sales_fuel_surcharge_percent, $24) / $25::bigint AS sales_fuel FROM uk_ecommerce_consignments WHERE supplier_linked_invoice_id = ukec.supplier_linked_invoice_id AND uk_ecommerce_consignments.exception_code != $26 GROUP BY sales_fuel_surcharge_percent ORDER BY sales_fuel_surcharge_percent) t1), $27) AS sales_freight_exceptions, COALESCE((SUM(COALESCE(ukec.supplier_cost_price, $28)) FILTER (WHERE ukec.exception_code = $29)), $30) + COALESCE((SELECT SUM(COALESCE(ukecs.supplier_cost_price, $31)) FROM uk_ecommerce_consignment_surcharges ukecs WHERE ukecs.supplier_linked_invoice_id = ukesi.id AND ukecs.exception_code = $32), $33) AS supplier_freight, $34, COALESCE((SUM(COALESCE(ukec.sales_price, $35)) FILTER (WHERE ukec.exception_code = $36)), $37) + COALESCE((SUM(COALESCE(ukec.surcharge_sales_price, $38)) FILTER (WHERE ukec.exception_code = $39)), $40) + COALESCE((SELECT SUM(COALESCE(ukecs.sales_price, $41)) FROM uk_ecommerce_consignment_surcharges ukecs WHERE ukecs.supplier_linked_invoice_id = ukesi.id AND ukecs.exception_code = $42), $43) + COALESCE((SELECT SUM(t1.sales_fuel) ::bigint FROM (SELECT (SUM(COALESCE(sales_price, $44))::bigint + SUM(COALESCE(surcharge_sales_price, $45))::bigint) * COALESCE(sales_fuel_surcharge_percent, $46) / $47::bigint AS sales_fuel FROM uk_ecommerce_consignments WHERE supplier_linked_invoice_id = ukec.supplier_linked_invoice_id AND uk_ecommerce_consignments.exception_code = $48 GROUP BY sales_fuel_surcharge_percent ORDER BY sales_fuel_surcharge_percent) t1), $49) AS sales_freight, COALESCE(ukesi.purchase_transaction_id, 0) AS purchase_transaction_id, COALESCE(ukes.purchase_account_id, $50) AS purchase_account_id, COALESCE(CONCAT(pa.purchase_account_reference, $51, RTRIM(company.name)), $52) AS purchase_account_name, COALESCE(confirmed_for_invoicing, $53) AS confirmed_for_invoicing FROM uk_ecommerce_supplier_invoice ukesi LEFT JOIN uk_ecommerce_supplier ukes ON ukes.id = ukesi.supplier_account_id LEFT JOIN uk_ecommerce_carrier ukea ON ukea.id = ukes.carrier_id LEFT JOIN uk_ecommerce_consignments ukec ON ukec.supplier_linked_invoice_id = ukesi.id LEFT JOIN purchase_account pa ON pa.id = ukes.purchase_account_id LEFT JOIN company ON company.id = pa.company_id WHERE ukesi.created_date::date BETWEEN $1 AND $2 AND ukesi.status <> $54 AND ukesi.financial_company = $3 GROUP BY 4, 5, 6, 7, 8, 2, 16, ukec.supplier_linked_invoice_id, ukesi.status, ukes.purchase_account_id, pa.purchase_account_reference, company.name, confirmed_for_invoicing ORDER BY 4 DESC, 2 DESC
25 min 0.6%	2 ms	613,965 upadmin
INSERT INTO "public"."connexx_shipment_bulk_uploads" ("created_by","created_date","last_modified_date","sales_account_id","shipment_import_profile_id","filename","method","api_key_id","sales_account_integration_id") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "public"."connexx_shipment_bulk_uploads"."id", "public"."connexx_shipment_bulk_uploads"."uuid", "public"."connexx_shipment_bulk_uploads"."created_by", "public"."connexx_shipment_bulk_uploads"."created_date", "public"."connexx_shipment_bulk_uploads"."last_modified_by", "public"."connexx_shipment_bulk_uploads"."last_modified_date", "public"."connexx_shipment_bulk_uploads"."sales_account_id", "public"."connexx_shipment_bulk_uploads"."shipment_import_profile_id", "public"."connexx_shipment_bulk_uploads"."courier_api_bulk_label_job_id", "public"."connexx_shipment_bulk_uploads"."filename", "public"."connexx_shipment_bulk_uploads"."method", "public"."connexx_shipment_bulk_uploads"."api_key_id", "public"."connexx_shipment_bulk_uploads"."sales_account_integration_id"
23 min 0.5%	19 ms	71,766 upadmin
`SELECT * FROM get_whitelist_id(cast($1 as int), cast($2 as bigint), cast($3 as int), $4, $5, $6, $7, cast($8 as int)) WHERE actual_zone IS NOT NULL`
21 min 0.5%	67 ms	19,226 postgresitd
`SELECT EXISTS ( SELECT $3 FROM connexx_shipments WHERE customer_reference = $1 AND shipment_integration_id = $2) AS exists`
21 min 0.5%	2 ms	622,904 upadmin
INSERT INTO "public"."connexx_label_jobs" ("status","created_by","created_date","sales_account_id","downloaded","label_size","deprecated_shipment_ids","print_png_labels") VALUES ($1,$2,$3,$4,$5,CAST($6::text AS "public"."label_sizes"),$7,$8) RETURNING "public"."connexx_label_jobs"."id", "public"."connexx_label_jobs"."uuid", "public"."connexx_label_jobs"."status", "public"."connexx_label_jobs"."created_by", "public"."connexx_label_jobs"."created_date", "public"."connexx_label_jobs"."sales_account_id", "public"."connexx_label_jobs"."label_url", "public"."connexx_label_jobs"."downloaded", "public"."connexx_label_jobs"."downloaded_date", "public"."connexx_label_jobs"."downloaded_by", "public"."connexx_label_jobs"."label_size"::text, "public"."connexx_label_jobs"."errors", "public"."connexx_label_jobs"."deprecated_shipment_ids", "public"."connexx_label_jobs"."print_png_labels"
19 min 0.5%	16 ms	72,468 upadmin
`select * FROM get_whitelist_v2(cast($1 as int), --customer id cast($2 as bigint), -- service id cast($3 as int), -- weight in grams $4, -- origin country iso $7, -- origin postcode $5, -- destination country iso $8, -- destination poscode cast($6 as int))`
18 min 0.4%	2 ms	641,786 upadmin
INSERT INTO "public"."connexx_quoted_rates" ("shipment_id","sales_account_id","created_by","created_date","net_price","vat_code","fuel_surcharge_percent","shipping_whitelist_id","deliver_to_residential") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "public"."connexx_quoted_rates"."id", "public"."connexx_quoted_rates"."uuid", "public"."connexx_quoted_rates"."shipment_id", "public"."connexx_quoted_rates"."sales_account_id", "public"."connexx_quoted_rates"."created_by", "public"."connexx_quoted_rates"."created_date", "public"."connexx_quoted_rates"."last_modified_by", "public"."connexx_quoted_rates"."last_modified_date", "public"."connexx_quoted_rates"."net_price", "public"."connexx_quoted_rates"."vat_code", "public"."connexx_quoted_rates"."fuel_surcharge_percent", "public"."connexx_quoted_rates"."sent_to_customer", "public"."connexx_quoted_rates"."shipping_whitelist_id", "public"."connexx_quoted_rates"."is_selected", "public"."connexx_quoted_rates"."external_rates", "public"."connexx_quoted_rates"."deliver_to_residential"
17 min 0.4%	8 ms	124,588 upadmin
`SELECT "public"."connexx_shipments"."id" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND "public"."connexx_shipments"."created_date" >= $3 AND "public"."connexx_shipments"."created_date" <= $4 AND "public"."connexx_shipments"."deleted_date" IS NULL AND "public"."connexx_shipments"."status" IN ($5)) ORDER BY "public"."connexx_shipments"."created_date" DESC OFFSET $6` Covered by index on (sales_account_id, created_date) Rows: 16915082 Row progression: 16915082, 30098, 3010 Row estimates - sales_account_id (=): 30098 - created_date (>=): 1691509 - created_date (<=): 1691509 - status (=): 3383016 - shipment_type (=): 8457541 - deleted_date (null): 15882134 - created_date (sort): 9 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
16 min 0.4%	0 ms	2,792,876 postgresitd
`SELECT EXISTS( SELECT $4 FROM connexx_shipments WHERE customer_reference = $1 AND shipment_integration_id = $2 AND sales_account_id = $3 )`
16 min 0.4%	8 ms	127,818 upadmin
`SELECT COUNT(*), "public"."connexx_shipments"."status" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND "public"."connexx_shipments"."created_date" >= $3 AND "public"."connexx_shipments"."created_date" <= $4) GROUP BY "public"."connexx_shipments"."status" OFFSET $5` Covered by index on (sales_account_id, created_date) Rows: 16915082 Row progression: 16915082, 30098, 3010 Row estimates - sales_account_id (=): 30098 - created_date (>=): 1691509 - created_date (<=): 1691509 - shipment_type (=): 8457541 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
16 min 0.4%	0 ms	16,903,596 upadmin
`SELECT "public"."uk_ecommerce_service"."id", "public"."uk_ecommerce_service"."name" FROM "public"."uk_ecommerce_service" WHERE $2=$3 OFFSET $1`
16 min 0.4%	6 ms	166,273 upadmin
`UPDATE "public"."connexx_shipment_packages" SET "label_url" = $1, "tracking_code" = $2, "base64_pdf" = $3, "carrier_shipment_package_id" = $4 WHERE ("public"."connexx_shipment_packages"."id" = $5 AND $6=$7) RETURNING "public"."connexx_shipment_packages"."id", "public"."connexx_shipment_packages"."shipment_id", "public"."connexx_shipment_packages"."tracking_code", "public"."connexx_shipment_packages"."label_url", "public"."connexx_shipment_packages"."base64_pdf"`
13 min 0.3%	0 ms	2,398,668 postgresitd
`INSERT INTO public.consignment_tracking(status, created_by, created_date, barcode, carrier_id, type, tracking_information) VALUES ($5,$6, CURRENT_TIMESTAMP, $1, $2, $3, $4::jsonb) ON CONFLICT (barcode) DO UPDATE SET tracking_information = consignment_tracking.tracking_information \|\| $4::jsonb`
13 min 0.3%	6 ms	126,405 upadmin
SELECT "public"."consignment_tracking"."id", "public"."consignment_tracking"."status", "public"."consignment_tracking"."created_by", "public"."consignment_tracking"."created_date", "public"."consignment_tracking"."barcode", "public"."consignment_tracking"."carrier_id", "public"."consignment_tracking"."type", "public"."consignment_tracking"."tracking_information", "public"."consignment_tracking"."consignment_number" FROM "public"."consignment_tracking" WHERE "public"."consignment_tracking"."barcode" IN ($1 /, ... /) OFFSET $2 `Covered by index on (barcode) Rows: 32431452 Row progression: 32431452, 1 Row estimates - barcode (=): 1 Existing indexes - id PRIMARY - (((tracking_information -> '-1'::integer) -> 'trackingEvent'::text)) GIN - (((tracking_information -> 'statusCode'::text))::text) - ((created_date)::date) - barcode UNIQUE - barcode UNIQUE - carrier_id - consignment_number`
13 min 0.3%	1 ms	679,374 upadmin
SELECT "public"."connexx_shipment_packages"."id", "public"."connexx_shipment_packages"."created_by", "public"."connexx_shipment_packages"."created_date", "public"."connexx_shipment_packages"."last_modified_by", "public"."connexx_shipment_packages"."last_modified_date", "public"."connexx_shipment_packages"."shipment_id", "public"."connexx_shipment_packages"."weight", "public"."connexx_shipment_packages"."length", "public"."connexx_shipment_packages"."height", "public"."connexx_shipment_packages"."type", "public"."connexx_shipment_packages"."quantity", "public"."connexx_shipment_packages"."width", "public"."connexx_shipment_packages"."tracking_code", "public"."connexx_shipment_packages"."label_created_date", "public"."connexx_shipment_packages"."label_url", "public"."connexx_shipment_packages"."label_format", "public"."connexx_shipment_packages"."errors", "public"."connexx_shipment_packages"."index", "public"."connexx_shipment_packages"."sales_account_id", "public"."connexx_shipment_packages"."base64_pdf", "public"."connexx_shipment_packages"."shipping_price", "public"."connexx_shipment_packages"."base64_zpl", "public"."connexx_shipment_packages"."original_ui_index", "public"."connexx_shipment_packages"."created_date_date", "public"."connexx_shipment_packages"."year", "public"."connexx_shipment_packages"."month", "public"."connexx_shipment_packages"."class", "public"."connexx_shipment_packages"."dg_net_weight", "public"."connexx_shipment_packages"."dgun_number", "public"."connexx_shipment_packages"."dry_ice_weight", "public"."connexx_shipment_packages"."lithium_category", "public"."connexx_shipment_packages"."packing_group", "public"."connexx_shipment_packages"."dg_package", "public"."connexx_shipment_packages"."carrier_shipment_package_id", "public"."connexx_shipment_packages"."dg_volume_ml_100" FROM "public"."connexx_shipment_packages" LEFT JOIN "public"."connexx_shipments" AS "j1" ON ("j1"."id") = ("public"."connexx_shipment_packages"."shipment_id") WHERE ("public"."connexx_shipment_packages"."tracking_code" IN ($1) AND "public"."connexx_shipment_packages"."sales_account_id" IN ($2) AND ("j1"."shipping_whitelist_id" IS NOT NULL AND ("j1"."id" IS NOT NULL))) OFFSET $3
13 min 0.3%	0 ms	16,903,592 upadmin
`SELECT "public"."uk_ecommerce_tariff"."id", "public"."uk_ecommerce_tariff"."name", "public"."uk_ecommerce_tariff"."alias", "public"."uk_ecommerce_tariff"."carrier_id" FROM "public"."uk_ecommerce_tariff" WHERE $2=$3 OFFSET $1`
13 min 0.3%	6 ms	133,377 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" WHERE "public"."connexx_shipments"."id" IN ($1 /, ... /) OFFSET $2 Covered by index on (id) Rows: 16915082 Row progression: 16915082, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
12 min 0.3%	4 ms	183,486 upadmin
UPDATE "public"."connexx_shipments" SET "packing_slip_base64" = $1 WHERE ("public"."connexx_shipments"."id" = $2 AND $3=$4) RETURNING "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails"
12 min 0.3%	1 ms	1,391,472 upadmin
INSERT INTO "public"."connexx_api_requests" ("connexx_api_key_id","ip","method","original_url","response_status_code","request_body","request_headers","response_body","created_date","request_id","company_name","sales_account_id") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12) RETURNING "public"."connexx_api_requests"."id", "public"."connexx_api_requests"."connexx_api_key_id", "public"."connexx_api_requests"."ip", "public"."connexx_api_requests"."method", "public"."connexx_api_requests"."original_url", "public"."connexx_api_requests"."response_status_code", "public"."connexx_api_requests"."request_body", "public"."connexx_api_requests"."request_headers", "public"."connexx_api_requests"."response_body", "public"."connexx_api_requests"."created_date", "public"."connexx_api_requests"."request_id", "public"."connexx_api_requests"."company_name", "public"."connexx_api_requests"."sales_account_id"
11 min 0.3%	4 ms	174,034 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND "public"."connexx_shipments"."deleted_date" IS NULL) ORDER BY "public"."connexx_shipments"."created_date" DESC LIMIT $3 OFFSET $4 Covered by index on (sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text)) Rows: 16915082 Row progression: 16915082, 30098, 15049 Row estimates - sales_account_id (=): 30098 - shipment_type (=): 8457541 - deleted_date (null): 15882134 - created_date (sort): 9 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
11 min 0.3%	124 ms	5,327 upadmin
INSERT INTO shipment_data.flattened_shipments_scurri ( shipment_package_id, sales_account_id, sales_account_reference, company_id, customer_name, tracking_code, created_date, supplier_name, iso_country_destination, zip_destination ) SELECT ci.id, sa.id, sa.sales_account_reference, co.id, UPPER(co.name), ci.barcode, ci.created_date, UPPER(ci.carrier), ci.ship_to_country, ci.ship_to_postcode FROM public.consignment_imports ci LEFT JOIN public.sales_account sa ON sa.id = ci.sales_account_id LEFT JOIN public.company co ON co.id = sa.company_id LEFT JOIN shipment_data.flattened_shipments_scurri fs ON fs.shipment_package_id = ci.id WHERE ci.barcode IS NOT NULL AND ci.source = $1 AND ci.created_date_date >= current_date - $2 AND ci.created_date_date <= current_date AND ci.sales_account_id NOT IN ($3 /, ... /) AND fs.shipment_package_id IS NULL
11 min 0.3%	122 ms	5,327 upadmin
`UPDATE shipment_data.flattened_shipments fs SET status = UPPER(cs.status) FROM public.connexx_shipments cs WHERE fs.shipment_id = cs.id AND fs.created_date::date = current_date AND fs.status <> UPPER(cs.status)`
11 min 0.3%	21 ms	30,442 upadmin
`SELECT COUNT(*), "public"."connexx_shipments"."status" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND "public"."connexx_shipments"."integration_store_id" = $3 AND "public"."connexx_shipments"."created_date" >= $4 AND "public"."connexx_shipments"."created_date" <= $5) GROUP BY "public"."connexx_shipments"."status" OFFSET $6` Covered by index on (integration_store_id, sales_account_id) Rows: 16915082 Row progression: 16915082, 7041, 13 Row estimates - integration_store_id (=): 7041 - sales_account_id (=): 30098 - created_date (<=): 1691509 - created_date (>=): 1691509 - shipment_type (=): 8457541 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
10 min 0.2%	40 ms	15,299 upadmin
SELECT "public"."connexx_shipment_packages"."id", "public"."connexx_shipment_packages"."created_by", "public"."connexx_shipment_packages"."created_date", "public"."connexx_shipment_packages"."last_modified_by", "public"."connexx_shipment_packages"."last_modified_date", "public"."connexx_shipment_packages"."shipment_id", "public"."connexx_shipment_packages"."weight", "public"."connexx_shipment_packages"."length", "public"."connexx_shipment_packages"."height", "public"."connexx_shipment_packages"."type", "public"."connexx_shipment_packages"."quantity", "public"."connexx_shipment_packages"."width", "public"."connexx_shipment_packages"."tracking_code", "public"."connexx_shipment_packages"."label_created_date", "public"."connexx_shipment_packages"."label_url", "public"."connexx_shipment_packages"."label_format", "public"."connexx_shipment_packages"."errors", "public"."connexx_shipment_packages"."index", "public"."connexx_shipment_packages"."sales_account_id", "public"."connexx_shipment_packages"."base64_pdf", "public"."connexx_shipment_packages"."shipping_price", "public"."connexx_shipment_packages"."base64_zpl", "public"."connexx_shipment_packages"."original_ui_index", "public"."connexx_shipment_packages"."created_date_date", "public"."connexx_shipment_packages"."year", "public"."connexx_shipment_packages"."month", "public"."connexx_shipment_packages"."class", "public"."connexx_shipment_packages"."dg_net_weight", "public"."connexx_shipment_packages"."dgun_number", "public"."connexx_shipment_packages"."dry_ice_weight", "public"."connexx_shipment_packages"."lithium_category", "public"."connexx_shipment_packages"."packing_group", "public"."connexx_shipment_packages"."dg_package", "public"."connexx_shipment_packages"."carrier_shipment_package_id", "public"."connexx_shipment_packages"."dg_volume_ml_100" FROM "public"."connexx_shipment_packages" LEFT JOIN "public"."connexx_shipments" AS "j1" ON ("j1"."id") = ("public"."connexx_shipment_packages"."shipment_id") WHERE ("public"."connexx_shipment_packages"."tracking_code" IN ($1 /, ... /) AND "public"."connexx_shipment_packages"."shipment_id" IN ($2 /, ... /) AND "public"."connexx_shipment_packages"."sales_account_id" IN ($3) AND ("j1"."shipping_whitelist_id" IS NOT NULL AND ("j1"."id" IS NOT NULL))) OFFSET $4
10 min 0.2%	2 ms	330,446 upadmin
`SELECT "public"."consignment_unified_statuses"."id", "public"."consignment_unified_statuses"."unified_status" FROM "public"."consignment_unified_statuses" WHERE $2=$3 OFFSET $1`
10 min 0.2%	1 ms	450,421 upadmin
UPDATE "public"."connexx_shipments" SET "status" = $1 WHERE ("public"."connexx_shipments"."id" = $2 AND $3=$4) RETURNING "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails"
10 min 0.2%	0 ms	1,264,912 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" WHERE "public"."connexx_shipments"."id" IN ($1) OFFSET $2 Covered by index on (id) Rows: 16915082 Row progression: 16915082, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
9 min 0.2%	0 ms	16,903,590 upadmin
SELECT "public"."carrier_depots"."id", "public"."carrier_depots"."name", "public"."carrier_depots"."address_line_1", "public"."carrier_depots"."address_line_2", "public"."carrier_depots"."city", "public"."carrier_depots"."postcode", "public"."carrier_depots"."for_amazon", "public"."carrier_depots"."for_dpd", "public"."carrier_depots"."sales_account_id", "public"."carrier_depots"."state", "public"."carrier_depots"."country_code", "public"."carrier_depots"."dsv_id", "public"."carrier_depots"."rm_location_id" FROM "public"."carrier_depots" WHERE "public"."carrier_depots"."id" IN ($1 /, ... /) OFFSET $2
9 min 0.2%	1 ms	511,270 postgresitd
`INSERT INTO sessions (created_date, modified_date, token, data, expiry, token_id, username) VALUES ($1, $2, $3, $4, $5, $6, $7) ON CONFLICT (username) DO UPDATE SET modified_date = EXCLUDED.modified_date, data = EXCLUDED.data, expiry = EXCLUDED.expiry, token = EXCLUDED.token, token_id = EXCLUDED.token_id`
9 min 0.2%	2 ms	231,627 postgresitd
`UPDATE connexx_shipments SET carrier_api_request_json = $1 WHERE id = $2` Covered by index on (id) Rows: 16915082 Row progression: 16915082, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
8 min 0.2%	4 ms	124,588 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND "public"."connexx_shipments"."created_date" >= $3 AND "public"."connexx_shipments"."created_date" <= $4 AND "public"."connexx_shipments"."deleted_date" IS NULL AND "public"."connexx_shipments"."status" IN ($5)) ORDER BY "public"."connexx_shipments"."created_date" DESC LIMIT $6 OFFSET $7 Covered by index on (sales_account_id, created_date) Rows: 16915082 Row progression: 16915082, 30098, 3010 Row estimates - sales_account_id (=): 30098 - created_date (>=): 1691509 - created_date (<=): 1691509 - status (=): 3383016 - shipment_type (=): 8457541 - deleted_date (null): 15882134 - created_date (sort): 9 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
8 min 0.2%	0 ms	16,903,592 upadmin
`SELECT "public"."intl_carrier"."id", "public"."intl_carrier"."name", "public"."intl_carrier"."alias" FROM "public"."intl_carrier" WHERE $2=$3 OFFSET $1`
8 min 0.2%	1 ms	334,168 upadmin
`UPDATE "public"."connexx_shipment_packages" SET "label_url" = $1, "tracking_code" = $2, "base64_pdf" = $3, "base64_zpl" = $4 WHERE ("public"."connexx_shipment_packages"."id" = $5 AND $6=$7) RETURNING "public"."connexx_shipment_packages"."id", "public"."connexx_shipment_packages"."shipment_id", "public"."connexx_shipment_packages"."tracking_code", "public"."connexx_shipment_packages"."label_url", "public"."connexx_shipment_packages"."base64_pdf", "public"."connexx_shipment_packages"."base64_zpl"`
7 min 0.2%	586 ms	743 postgresitd
WITH docs AS ( SELECT docs.linked_id as id, jsonb_agg(docs.) AS d_json FROM (SELECT id, filename, CAST((links ->> $3) AS integer) as linked_id FROM documents WHERE (links ->> $4)::text = $5 AND status = $6 AND (links ->> $7) <> $8) docs GROUP BY docs.linked_id), claims_cte AS (SELECT c.id, COALESCE(c.is_resolved, $9), c.created_date, c.created_by, c.barcode, COALESCE(c.evri_claim_ref, $10), c.claim_status, COALESCE(sat.transaction_reference, $11), COALESCE(c.cost_net_credit, $12), COALESCE(c.cost_total_credit, $13), COALESCE(c.sales_net_credit, $14), COALESCE(c.sales_total_credit, $15), COALESCE(c.order_ref, $16), COALESCE(c.order_type, $17) as order_type, COALESCE(c.claim_reference, $18), COALESCE(c.recipient_name, $19), COALESCE(c.recipient_postcode, $20), COALESCE(c.lost_or_damaged, $21), COALESCE(c.dor_date, $22), COALESCE(c.cust_cont_name, $23), COALESCE(c.cust_cont_number, $24), COALESCE(c.cust_cont_email, $25), COALESCE(c.internal_ticket_number, $26), COALESCE(c.quantity_being_claimed, $27), COALESCE(c.product_category, $28), COALESCE(c.product_description, $29), COALESCE(c.cost_value, $30), COALESCE(c.retail_value, $31), COALESCE(c.supplier_claim_code, $32), COALESCE(c.appeal_comment, $33), COALESCE(ce.evri_file_ref, $34), COALESCE(c.carrier_id, $35) as carrier_id, COALESCE(c.service_id, $36) as service_id, COALESCE(c.sales_account_id, $37) as sales_account_id, CASE WHEN COALESCE(appeal, $38) = $39 THEN $40 ELSE $41 END, COALESCE(CASE WHEN COALESCE(appeal, $42) = $43 AND c.sales_credit_note IS NOT NULL THEN array_agg(COALESCE(e_pat.transaction_reference, $44)) ELSE array_agg(COALESCE(a_pat.transaction_reference, $45)) END, $46), COALESCE(CASE WHEN COALESCE(appeal, $47) = $48 AND c.sales_credit_note IS NOT NULL THEN array_agg(COALESCE(e_pat.supplier_invoice_reference, $49)) ELSE array_agg(COALESCE(a_pat.supplier_invoice_reference, $50)) END, $51) FROM claims c LEFT JOIN sales_account_transactions sat ON sat.transaction_reference = c.sales_credit_note LEFT JOIN claim_exports ce on c.export = ce.id LEFT JOIN claim_exports ca on c.appeal = ca.id LEFT JOIN purchase_account_transactions e_pat ON e_pat.id = ANY (ARRAY[ce.purchase_credit_notes]) LEFT JOIN purchase_account_transactions a_pat ON a_pat.id = ANY (ARRAY[ca.purchase_credit_notes]) WHERE c.status = $52 AND c.created_date::date BETWEEN $1 AND $2 group by c.id, sat.transaction_reference, ce.evri_file_ref) SELECT c., COALESCE(co.name, $53), COALESCE(sa.sales_account_reference, $54), COALESCE(inc.name, $55), COALESCE(ins.name, $56), $57, $58, COALESCE(d.d_json, $59) FROM claims_cte c LEFT JOIN intl_carrier inc ON c.carrier_id = inc.id LEFT JOIN intl_service ins ON c.service_id = ins.id LEFT JOIN sales_account sa ON c.sales_account_id = sa.id LEFT JOIN company co ON sa.company_id = co.id LEFT JOIN docs d ON d.id = c.id WHERE c.order_type = $60 UNION ALL SELECT c., COALESCE(co.name, $61), COALESCE(sa.sales_account_reference, $62), COALESCE(ukec.name, $63), COALESCE(ukes.name, $64), $65, $66, COALESCE(d.d_json, $67) FROM claims_cte c LEFT JOIN uk_ecommerce_carrier ukec ON c.carrier_id = ukec.id LEFT JOIN uk_ecommerce_service ukes ON c.service_id = ukes.id LEFT JOIN sales_account sa ON c.sales_account_id = sa.id LEFT JOIN company co ON sa.company_id = co.id LEFT JOIN docs d ON d.id = c.id WHERE c.order_type = $68 AND ukec.financial_company = $69 UNION ALL SELECT c., COALESCE(co.name, $70), COALESCE(sa.sales_account_reference, $71), COALESCE(ukc.name, $72), COALESCE(uks.name, $73), COALESCE(ukes.name, $74), COALESCE(sat.transaction_reference, $75), COALESCE(d.d_json, $76) FROM nominal_transaction_lines ntl LEFT JOIN uk_ecommerce_consignments ukec ON ukec.sales_nominal_transaction_id = ntl.id LEFT JOIN claims_cte c ON ukec.barcode = c.barcode LEFT JOIN sales_account_transactions sat ON ntl.sales_transaction_id = sat.id LEFT JOIN uk_ecommerce_supplier ukes ON ukec.supplier_account_id = ukes.id LEFT JOIN uk_ecommerce_carrier ukc ON c.carrier_id = ukc.id LEFT JOIN uk_ecommerce_service uks ON c.service_id = uks.id LEFT JOIN sales_account sa ON c.sales_account_id = sa.id LEFT JOIN company co ON sa.company_id = co.id LEFT JOIN docs d ON d.id = c.id WHERE c.order_type = $77 AND ntl.referring_table = $78 AND COALESCE(ukec.sales_nominal_transaction_id, $79) <> $80 AND ukc.financial_company = $81 UNION ALL SELECT c., COALESCE(co.name, $82), COALESCE(sa.sales_account_reference, $83), COALESCE(ukc.name, $84), COALESCE(uks.name, $85), COALESCE(ukes.name, $86), $87, COALESCE(d.d_json, $88) FROM claims_cte c LEFT JOIN uk_ecommerce_consignments ukec ON ukec.barcode = c.barcode LEFT JOIN uk_ecommerce_supplier ukes ON ukec.supplier_account_id = ukes.id LEFT JOIN uk_ecommerce_carrier ukc ON c.carrier_id = ukc.id LEFT JOIN uk_ecommerce_service uks ON c.service_id = uks.id LEFT JOIN sales_account sa ON c.sales_account_id = sa.id LEFT JOIN company co ON sa.company_id = co.id LEFT JOIN docs d ON d.id = c.id WHERE c.order_type = $89 AND COALESCE(ukec.sales_nominal_transaction_id, $90) = $91 AND ukc.financial_company = $92 UNION ALL SELECT c., COALESCE(co.name, $93), COALESCE(sa.sales_account_reference, $94), COALESCE(inc.name, $95), COALESCE(ins.name, $96), COALESCE(ints.name, $97), COALESCE(ntl.reference, $98), COALESCE(d.d_json, $99) FROM claims_cte c LEFT JOIN intl_consignments ic ON ic.barcode = c.barcode LEFT JOIN intl_consignments_surcharges_transactions icst ON ic.id = icst.consignment_id LEFT JOIN nominal_transaction_lines ntl ON icst.sales_nominal_transaction_id = ntl.id LEFT JOIN sales_account sa ON c.sales_account_id = sa.id LEFT JOIN company co ON sa.company_id = co.id LEFT JOIN intl_supplier ints ON ic.supplier_id = ints.id LEFT JOIN intl_carrier inc ON c.carrier_id = inc.id LEFT JOIN intl_service ins ON c.service_id = ins.id LEFT JOIN docs d ON d.id = c.id WHERE order_type = $100 AND ntl.referring_table = $101 AND COALESCE(icst.consignment_id, $102) <> $103 UNION ALL SELECT c., COALESCE(co.name, $104), COALESCE(sa.sales_account_reference, $105), COALESCE(inc.name, $106), COALESCE(ins.name, $107), $108, $109, COALESCE(d.d_json, $110) FROM claims_cte c LEFT JOIN intl_consignments ic ON ic.barcode = c.barcode LEFT JOIN intl_consignments_surcharges_transactions icst ON ic.id = icst.consignment_id LEFT JOIN intl_carrier inc ON c.carrier_id = inc.id LEFT JOIN intl_service ins ON c.service_id = ins.id LEFT JOIN sales_account sa ON c.sales_account_id = sa.id LEFT JOIN company co ON sa.company_id = co.id LEFT JOIN docs d ON d.id = c.id WHERE NOT EXISTS(SELECT c2.id FROM claims c2 LEFT JOIN intl_consignments ic ON ic.barcode = c2.barcode LEFT JOIN intl_consignments_surcharges_transactions icst ON ic.id = icst.consignment_id WHERE c.order_type = $111 AND COALESCE(icst.sales_nominal_transaction_id, $112) <> $113 AND c2.id = c.id) AND c.order_type = $114 UNION ALL SELECT c., COALESCE(co.name, $115), COALESCE(sa.sales_account_reference, $116), COALESCE(inc.name, $117), COALESCE(ins.name, $118), $119, $120, COALESCE(d.d_json, $121) FROM claims_cte c LEFT JOIN intl_consignments ic ON ic.barcode = c.barcode LEFT JOIN intl_consignments_surcharges_transactions icst ON ic.id = icst.consignment_id LEFT JOIN intl_carrier inc ON c.carrier_id = inc.id LEFT JOIN intl_service ins ON c.service_id = ins.id LEFT JOIN sales_account sa ON c.sales_account_id = sa.id LEFT JOIN company co ON sa.company_id = co.id LEFT JOIN docs d ON d.id = c.id WHERE NOT EXISTS(SELECT id FROM intl_consignments_surcharges_transactions inst WHERE inst.consignment_id = ic.id) AND c.order_type = $122 UNION ALL SELECT c., COALESCE(co.name, $123), COALESCE(sa.sales_account_reference, $124), COALESCE(ukec.name, $125), COALESCE(ukes.name, $126), $127, $128, COALESCE(d.d_json, $129) FROM claims_cte c LEFT JOIN consignment_imports ci ON ci.barcode = c.barcode LEFT JOIN uk_ecommerce_carrier ukec ON c.carrier_id = ukec.id LEFT JOIN uk_ecommerce_service ukes ON c.service_id = ukes.id LEFT JOIN sales_account sa ON c.sales_account_id = sa.id LEFT JOIN company co ON sa.company_id = co.id LEFT JOIN docs d ON d.id = c.id WHERE c.order_type = $130 AND ukec.financial_company = $131 UNION ALL SELECT c., COALESCE(co.name, $132), COALESCE(sa.sales_account_reference, $133), COALESCE(inc.name, $134), COALESCE(ins.name, $135), $136, $137, COALESCE(d.d_json, $138) FROM claims_cte c LEFT JOIN consignment_imports ci ON ci.barcode = c.barcode LEFT JOIN intl_carrier inc ON c.carrier_id = inc.id LEFT JOIN intl_service ins ON c.service_id = ins.id LEFT JOIN sales_account sa ON c.sales_account_id = sa.id LEFT JOIN company co ON sa.company_id = co.id LEFT JOIN docs d ON d.id = c.id WHERE c.order_type = $139 ORDER BY 1 DESC
7 min 0.2%	1 ms	717,034 upadmin
SELECT "public"."consignment_tracking"."id", "public"."consignment_tracking"."status", "public"."consignment_tracking"."created_by", "public"."consignment_tracking"."created_date", "public"."consignment_tracking"."barcode", "public"."consignment_tracking"."carrier_id", "public"."consignment_tracking"."type", "public"."consignment_tracking"."tracking_information", "public"."consignment_tracking"."consignment_number" FROM "public"."consignment_tracking" WHERE "public"."consignment_tracking"."barcode" IN ($1) OFFSET $2 `Covered by index on (barcode) Rows: 32431452 Row progression: 32431452, 1 Row estimates - barcode (=): 1 Existing indexes - id PRIMARY - (((tracking_information -> '-1'::integer) -> 'trackingEvent'::text)) GIN - (((tracking_information -> 'statusCode'::text))::text) - ((created_date)::date) - barcode UNIQUE - barcode UNIQUE - carrier_id - consignment_number`
7 min 0.2%	6 ms	73,436 postgresitd
INSERT INTO freight_boxtop_charges (old_id, invoice_number, job_number, description, cost_currency, charge_currency, charge_code, tax_code, taxable, charge_exchange, show, supplier_invoice, remarks, supplier_name, cost_tax_code, chapter, collect_charge, supplier_invoice_id, line_order, bill_to_account_number, mod_sales_roe, mod_purchase_roe, tax_rate, tstamp, estimate_cost, actual_cost, base_estimated_cost, base_actual_cost, charge, base_charge, cost_exchange, tax, cost_tax, accrued_date, paid_date, date_created, cost_id) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, (SELECT freight_cost.id from freight_cost WHERE charge_id = $37)) ON CONFLICT (old_id) DO UPDATE SET invoice_number = EXCLUDED.invoice_number, job_number = EXCLUDED.job_number, description = EXCLUDED.description, cost_currency = EXCLUDED.cost_currency, charge_currency = EXCLUDED.charge_currency, charge_code = EXCLUDED.charge_code, tax_code = EXCLUDED.tax_code, taxable = EXCLUDED.taxable, charge_exchange = EXCLUDED.charge_exchange, show = EXCLUDED.show, supplier_invoice = EXCLUDED.supplier_invoice, remarks = EXCLUDED.remarks, supplier_name = EXCLUDED.supplier_name, cost_tax_code = EXCLUDED.cost_tax_code, chapter = EXCLUDED.chapter, collect_charge = EXCLUDED.collect_charge, supplier_invoice_id = EXCLUDED.supplier_invoice_id, line_order = EXCLUDED.line_order, bill_to_account_number = EXCLUDED.bill_to_account_number, mod_sales_roe = EXCLUDED.mod_sales_roe, mod_purchase_roe = EXCLUDED.mod_purchase_roe, tax_rate = EXCLUDED.tax_rate, tstamp = EXCLUDED.tstamp, estimate_cost = EXCLUDED.estimate_cost, actual_cost = EXCLUDED.actual_cost, base_estimated_cost = EXCLUDED.base_estimated_cost, base_actual_cost = EXCLUDED.base_actual_cost, charge = EXCLUDED.charge, base_charge = EXCLUDED.base_charge, cost_exchange = EXCLUDED.cost_exchange, tax = EXCLUDED.tax, cost_tax = EXCLUDED.cost_tax, accrued_date = EXCLUDED.accrued_date, paid_date = EXCLUDED.paid_date, date_created = EXCLUDED.date_created, cost_type = EXCLUDED.cost_type, cost_id = EXCLUDED.cost_id RETURNING (old_id)
6 min 0.2%	0 ms	16,903,592 upadmin
`SELECT "public"."uk_ecommerce_supplier"."id", "public"."uk_ecommerce_supplier"."name" FROM "public"."uk_ecommerce_supplier" WHERE $2=$3 OFFSET $1`
6 min 0.2%	181 ms	2,081 postgresitd
`UPDATE consignment_imports ec SET sales_account_id = sa.id FROM sales_account sa WHERE ec.sales_account_reference = sa.sales_account_reference AND sa.status = $1 AND ec.sales_account_id = $2` Covered by index on (sales_account_reference, sales_account_id) Rows: 72646008 Row progression: 72646008, 69798, 68 Row estimates - sales_account_reference (=): 69798 - sales_account_id (=): 70660 - status (=): 36319372 Existing indexes - id PRIMARY - ((created_date)::date) - barcode - barcode_postcode_key UNIQUE - carrier - consignment_number - consignment_number_postcode_key - created_date_date, id WHERE ((source)::text = 'scurri'::text) AND (barcode IS NOT NULL) AND (sales_account_id <> ALL (ARRAY[225578, 1605, 0])) - month, source - order_number, ship_to_postcode - sales_account_id - sales_account_id, ((created_date)::date) - sales_account_id, created_date_date - sales_account_reference, sales_account_id - source - year, source
6 min 0.2%	1 ms	351,533 postgresitd
`UPDATE connexx_shipments SET carrier_api_request = $1 WHERE id = $2` Covered by index on (id) Rows: 16915082 Row progression: 16915082, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
6 min 0.1%	0 ms	1,243,255 upadmin
SELECT "public"."connexx_rules"."id", "public"."connexx_rules"."name", "public"."connexx_rules"."priority", "public"."connexx_rules"."virtual_warehouse_id", "public"."connexx_rules"."shipping_whitelist_id", "public"."connexx_rules"."conditions", "public"."connexx_rules"."block_shipment_creation", "public"."connexx_rules"."put_into_to_fix", "public"."connexx_rules"."use_importer_of_record" FROM "public"."connexx_rules" WHERE ("public"."connexx_rules"."sales_account_id" = $1 AND "public"."connexx_rules"."deleted_date" IS NULL AND "public"."connexx_rules"."enabled" = $2) ORDER BY "public"."connexx_rules"."priority" ASC OFFSET $3 Details `CREATE INDEX CONCURRENTLY ON connexx_rules (sales_account_id)` `Rows: 1029 Row progression: 1029, 3 Row estimates - sales_account_id (=): 3 - enabled (=): 515 - deleted_date (null): 800 - priority (sort): 18 Existing indexes - id PRIMARY - uuid UNIQUE`
6 min 0.1%	0 ms	16,903,832 upadmin
`SELECT "public"."uk_ecommerce_carrier"."id", "public"."uk_ecommerce_carrier"."name", "public"."uk_ecommerce_carrier"."alias" FROM "public"."uk_ecommerce_carrier" WHERE $2=$3 OFFSET $1`
6 min 0.1%	6 ms	64,604 upadmin
SELECT "public"."connexx_shipment_packages"."id", "public"."connexx_shipment_packages"."created_by", "public"."connexx_shipment_packages"."created_date", "public"."connexx_shipment_packages"."last_modified_by", "public"."connexx_shipment_packages"."last_modified_date", "public"."connexx_shipment_packages"."shipment_id", "public"."connexx_shipment_packages"."weight", "public"."connexx_shipment_packages"."length", "public"."connexx_shipment_packages"."height", "public"."connexx_shipment_packages"."type", "public"."connexx_shipment_packages"."quantity", "public"."connexx_shipment_packages"."width", "public"."connexx_shipment_packages"."tracking_code", "public"."connexx_shipment_packages"."label_created_date", "public"."connexx_shipment_packages"."label_url", "public"."connexx_shipment_packages"."label_format", "public"."connexx_shipment_packages"."errors", "public"."connexx_shipment_packages"."index", "public"."connexx_shipment_packages"."sales_account_id", "public"."connexx_shipment_packages"."base64_pdf", "public"."connexx_shipment_packages"."shipping_price", "public"."connexx_shipment_packages"."base64_zpl", "public"."connexx_shipment_packages"."original_ui_index", "public"."connexx_shipment_packages"."created_date_date", "public"."connexx_shipment_packages"."year", "public"."connexx_shipment_packages"."month", "public"."connexx_shipment_packages"."class", "public"."connexx_shipment_packages"."dg_net_weight", "public"."connexx_shipment_packages"."dgun_number", "public"."connexx_shipment_packages"."dry_ice_weight", "public"."connexx_shipment_packages"."lithium_category", "public"."connexx_shipment_packages"."packing_group", "public"."connexx_shipment_packages"."dg_package", "public"."connexx_shipment_packages"."carrier_shipment_package_id", "public"."connexx_shipment_packages"."dg_volume_ml_100" FROM "public"."connexx_shipment_packages" LEFT JOIN "public"."connexx_shipments" AS "j1" ON ("j1"."id") = ("public"."connexx_shipment_packages"."shipment_id") WHERE ("public"."connexx_shipment_packages"."tracking_code" IN ($1 /, ... /) AND "public"."connexx_shipment_packages"."sales_account_id" IN ($2) AND ("j1"."shipping_whitelist_id" IS NOT NULL AND ("j1"."id" IS NOT NULL))) OFFSET $3
5 min 0.1%	1 ms	227,331 postgresitd
WITH address AS( SELECT name, aan.address_line_1, aan.address_line_2, aan.address_line_3, aan.city, aan.county_state, aan.postcode, aan.country_iso, aan.telephone_number FROM account_address_new aan INNER JOIN company c ON c.id = aan.company_id INNER JOIN sales_account sa ON sa.company_id = c.id WHERE sa.id = $1 AND aan.status = $2 ) SELECT json_build_object($3, address.name, $4, address.address_line_1, $5, address.address_line_2, $6, address.address_line_3, $7, address.city, $8, address.county_state, $9, address.postcode, $10, address.country_iso, $11, address.telephone_number) FROM address
5 min 0.1%	861 ms	357 upadmin
`SELECT MAX("effective_date") FROM (SELECT "public"."exchange_rates"."effective_date" FROM "public"."exchange_rates" WHERE 1=1 OFFSET $1) AS "sub"`
5 min 0.1%	28 ms	10,657 postgresitd
SELECT COALESCE(json_agg(query.*), $1) FROM (SELECT DISTINCT ON (csaic.id) COALESCE(jsonb_build_object( $2, COALESCE(c.name, $3), $4, COALESCE(aan.address_line_1, $5), $6, COALESCE(aan.address_line_2, $7), $8, COALESCE(aan.address_line_3, $9), $10, COALESCE(aan.city, $11), $12, COALESCE(aan.county_state, $13), $14, COALESCE(aan.postcode, $15), $16, COALESCE(aan.country_iso, $17), $18, COALESCE(RTRIM(ac.name), $19), $20, COALESCE(aan.telephone_number, $21)), $22) AS default_address, COALESCE(cvw.phone_number, $23) AS telephone_number, COALESCE(jsonb_build_object($24, COALESCE(csaic.api_key, $25), $26, COALESCE(csaic.token, $27), $28, csaic.details->>$29), $30) AS tokens, csaic.id, csaic.sales_account_id AS SalesAccountID, COALESCE(cap.token, $31) AS connexx_token, COALESCE(cvw.name, $32) AS warehouse_name, COALESCE(csaic.identifier, $33) AS StoreName, COALESCE(csaic.email, $34) AS UserEmail FROM connexx_sales_account_integration_credentials csaic LEFT JOIN sales_account sa ON sa.id = csaic.sales_account_id LEFT JOIN company c ON sa.company_id = c.id LEFT JOIN connexx_virtual_warehouses cvw ON sa.id = cvw.sales_account_id AND cvw.is_default IS TRUE AND cvw.deleted_date IS NULL LEFT JOIN account_address_new aan ON cvw.address_id = aan.id LEFT JOIN connexx_api_keys cap ON cap.sales_account_id = sa.id LEFT JOIN account_contact ac ON ac.sales_account_id = sa.id WHERE COALESCE(csaic.api_key , $35) <> $36 AND csaic.integration_type = $37 AND csaic.status = $38 ORDER BY csaic.id DESC) query
4 min 0.1%	2 ms	169,829 upadmin
UPDATE "public"."connexx_shipments" SET "status" = $1, "carrier_label_errors" = $2 WHERE ("public"."connexx_shipments"."id" = $3 AND $4=$5) RETURNING "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails"
4 min 0.1%	1 ms	238,379 postgresitd
`INSERT INTO public.consignment_tracking(id, status, created_by, created_date, barcode, carrier_id, type, tracking_information) VALUES (DEFAULT, $5, $6, CURRENT_TIMESTAMP, $1, $2, $3, $4) on conflict (barcode) do update SET tracking_information = consignment_tracking.tracking_information \|\| $4::jsonb`
4 min 0.1%	1 ms	175,969 upadmin
`SELECT "public"."connexx_label_jobs_shipments"."label_job_id", "public"."connexx_label_jobs_shipments"."shipment_id" FROM "public"."connexx_label_jobs_shipments" WHERE "public"."connexx_label_jobs_shipments"."label_job_id" IN ($1 /, ... /) OFFSET $2` `Covered by index on (label_job_id, shipment_id) Rows: 16972462 Row progression: 16972462, 38 Row estimates - label_job_id (=): 38 Existing indexes - label_job_id, shipment_id UNIQUE - shipment_id`
4 min < 0.1%	8 ms	30,238 upadmin
SELECT "public"."connexx_shipments"."id" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND "public"."connexx_shipments"."integration_store_id" = $3 AND "public"."connexx_shipments"."created_date" >= $4 AND "public"."connexx_shipments"."created_date" <= $5 AND "public"."connexx_shipments"."deleted_date" IS NULL AND "public"."connexx_shipments"."status" IN ($6)) ORDER BY "public"."connexx_shipments"."created_date" DESC OFFSET $7 Covered by index on (integration_store_id, sales_account_id) Rows: 16915082 Row progression: 16915082, 7041, 13 Row estimates - integration_store_id (=): 7041 - sales_account_id (=): 30098 - created_date (<=): 1691509 - created_date (>=): 1691509 - status (=): 3383016 - shipment_type (=): 8457541 - deleted_date (null): 15882134 - created_date (sort): 9 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
4 min < 0.1%	161 ms	1,517 postgresitd
WITH consignments as (SELECT isi.id AS isi_id, isi.status AS status, isi.created_date AS created_date, icarrier.name AS carrier_name, isupplier.name AS supplier_name, isi.supplier_invoice_number AS supplier_invoice_number, COALESCE(description, $5) AS description, isi.invoice_type as invoice_type, COALESCE(SUM(COALESCE(icst.supplier_freight_amount, $6) + COALESCE(icst.government_duty, $7) + COALESCE(icst.government_vat, $8)) FILTER (WHERE icst.sales_exception_code != $9), $10) + COALESCE(SUM(COALESCE(icst.supplier_fuel_surcharge_amount, $11)) FILTER (WHERE icst.sales_exception_code != $12), $13) AS supplier_cost_price_exceptions, $14 AS supplier_vat_exceptions, COALESCE(SUM(COALESCE(icst.sales_freight_amount, $15) + COALESCE(icst.government_duty, $16) + COALESCE(icst.government_vat, $17)) FILTER (WHERE icst.sales_exception_code != $18), $19) + COALESCE(SUM(COALESCE(icst.sales_fuel_surcharge_amount, $20)) FILTER (WHERE icst.sales_exception_code != $21), $22) AS sales_cost_price_exceptions, COALESCE(SUM(COALESCE(icst.supplier_freight_amount, $23) + COALESCE(icst.government_duty, $24) + COALESCE(icst.government_vat, $25)) FILTER (WHERE icst.sales_exception_code = $26), $27) + COALESCE(SUM(COALESCE(icst.supplier_fuel_surcharge_amount, $28)) FILTER (WHERE icst.sales_exception_code = $29), $30) AS supplier_cost_price, COALESCE(SUM(COALESCE(icst.sales_freight_amount, $31) + COALESCE(icst.government_duty, $32) + COALESCE(icst.government_vat, $33)) FILTER (WHERE icst.sales_exception_code = $34), $35) + COALESCE(SUM(COALESCE(icst.sales_fuel_surcharge_amount, $36)) FILTER (WHERE icst.sales_exception_code = $37), $38) AS sales_cost_price, $39 AS supplier_vat, COALESCE(isi.purchase_transaction_id, $40) AS nominal_transaction_id, COALESCE(pa.id, $41) AS pa_id, COALESCE(CONCAT(pa.purchase_account_reference, $42, RTRIM(company.name)), $43) AS purchase_account_name, COALESCE(confirmed_for_invoicing, $44) AS confirmed_for_invoicing FROM intl_supplier_invoice isi LEFT JOIN intl_supplier isupplier ON isupplier.id = isi.supplier_account_id LEFT JOIN intl_carrier icarrier ON icarrier.id = isupplier.carrier_id LEFT JOIN intl_consignments_surcharges_transactions icst ON icst.supplier_linked_invoice_id = isi.id LEFT JOIN purchase_account pa ON pa.id = isupplier.purchase_account_id LEFT JOIN company ON company.id = pa.company_id WHERE isi.status <> $45 AND isi.created_date :: date BETWEEN $2 AND $3 AND isi.invoice_type = $1 AND isi.financial_company = $4 AND icst.consignment_id <> $46 GROUP BY icarrier.name, isi.status, isupplier.name, isi.supplier_invoice_number, isi.id, isi.description, isi.invoice_type, isi.created_date, isi.purchase_transaction_id, pa.id, pa.purchase_account_reference, company.name, confirmed_for_invoicing, icst.government_duty, icst.government_vat UNION ALL SELECT isi.id AS isi_id, isi.status AS status, isi.created_date AS created_date, icarrier.name AS carrier_name, isupplier.name AS supplier_name, isi.supplier_invoice_number AS supplier_invoice_number, COALESCE(description, $47) AS description, isi.invoice_type as invoice_type, COALESCE(SUM(COALESCE(icst.supplier_freight_amount, $48) + COALESCE(icst.government_duty, $49) + COALESCE(icst.government_vat, $50)) FILTER (WHERE icst.sales_exception_code != $51), $52) + COALESCE(SUM(COALESCE(icst.supplier_fuel_surcharge_amount, $53)) FILTER (WHERE icst.sales_exception_code != $54), $55) AS supplier_cost_price_exceptions, $56 AS supplier_vat_exceptions, COALESCE(SUM(COALESCE(icst.sales_freight_amount, $57) + COALESCE(icst.government_duty, $58) + COALESCE(icst.government_vat, $59)) FILTER (WHERE icst.sales_exception_code != $60), $61) + COALESCE(SUM(COALESCE(icst.sales_fuel_surcharge_amount, $62)) FILTER (WHERE icst.sales_exception_code != $63), $64) AS sales_cost_price_exceptions, COALESCE(SUM(COALESCE(icst.supplier_freight_amount, $65) + COALESCE(icst.government_duty, $66) + COALESCE(icst.government_vat, $67)) FILTER (WHERE icst.sales_exception_code = $68), $69) + COALESCE(SUM(COALESCE(icst.supplier_fuel_surcharge_amount, $70)) FILTER (WHERE icst.sales_exception_code = $71), $72) AS supplier_cost_price, COALESCE(SUM(COALESCE(icst.sales_freight_amount, $73) + COALESCE(icst.government_duty, $74) + COALESCE(icst.government_vat, $75)) FILTER (WHERE icst.sales_exception_code = $76), $77) + COALESCE(SUM(COALESCE(icst.sales_fuel_surcharge_amount, $78)) FILTER (WHERE icst.sales_exception_code = $79), $80) AS sales_cost_price, $81 AS supplier_vat, COALESCE(isi.purchase_transaction_id, $82) AS nominal_transaction_id, COALESCE(pa.id, $83) AS pa_id, COALESCE(CONCAT(pa.purchase_account_reference, $84, RTRIM(company.name)), $85) AS purchase_account_name, COALESCE(confirmed_for_invoicing, $86) AS confirmed_for_invoicing FROM intl_supplier_invoice isi LEFT JOIN intl_supplier isupplier ON isupplier.id = isi.supplier_account_id LEFT JOIN intl_carrier icarrier ON icarrier.id = isupplier.carrier_id LEFT JOIN intl_consignments_surcharges_transactions icst ON icst.supplier_linked_invoice_id = isi.id LEFT JOIN purchase_account pa ON pa.id = isupplier.purchase_account_id LEFT JOIN company ON company.id = pa.company_id WHERE isi.status <> $87 AND isi.created_date ::date BETWEEN $2 AND $3 AND isi.invoice_type = $1 AND icst.financial_company = $4 AND isi.financial_company = $4 AND icst.consignment_id = $88 GROUP BY icarrier.name, isi.status, isupplier.name, isi.supplier_invoice_number, isi.id, isi.description, isi.invoice_type, isi.created_date, isi.purchase_transaction_id, pa.id, pa.purchase_account_reference, company.name, confirmed_for_invoicing) SELECT $89, isi_id, status, created_date, carrier_name, supplier_name, supplier_invoice_number, description, invoice_type, SUM(supplier_cost_price_exceptions), SUM(supplier_vat_exceptions) AS vat_exceptions, SUM(sales_cost_price_exceptions), SUM(supplier_cost_price), SUM(supplier_vat) AS vat, SUM(sales_cost_price), nominal_transaction_id, pa_id, purchase_account_name, confirmed_for_invoicing FROM consignments GROUP BY isi_id, status, supplier_invoice_number, pa_id, purchase_account_name, description, invoice_type, nominal_transaction_id, created_date, carrier_name, supplier_name, confirmed_for_invoicing ORDER BY created_date DESC, carrier_name DESC, supplier_name, supplier_invoice_number, description
4 min < 0.1%	4 ms	65,066 upadmin
INSERT INTO "public"."connexx_shipments" ("created_by","created_date","last_modified_date","from_address_country_iso","from_address_zip","to_address_country_iso","to_address_zip","sales_account_id","job_number","generated_by_admin","shipment_type","status","rates_sql_query_output","rates_sql_query_input","errors","virtual_warehouse_id","service_options","should_split_duty_and_vat","importer_address_country_iso","importer_address_zip","requires_signature","requires_adult_signature","requires_direct_delivery","deliver_to_residential","notification_emails") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25) RETURNING "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails"
4 min < 0.1%	403 ms	552 upadmin
SELECT "public"."connexx_shipment_bulk_uploads"."id", "public"."connexx_shipment_bulk_uploads"."uuid", "public"."connexx_shipment_bulk_uploads"."created_by", "public"."connexx_shipment_bulk_uploads"."created_date", "public"."connexx_shipment_bulk_uploads"."last_modified_by", "public"."connexx_shipment_bulk_uploads"."last_modified_date", "public"."connexx_shipment_bulk_uploads"."sales_account_id", "public"."connexx_shipment_bulk_uploads"."shipment_import_profile_id", "public"."connexx_shipment_bulk_uploads"."courier_api_bulk_label_job_id", "public"."connexx_shipment_bulk_uploads"."filename", "public"."connexx_shipment_bulk_uploads"."method", "public"."connexx_shipment_bulk_uploads"."api_key_id", "public"."connexx_shipment_bulk_uploads"."sales_account_integration_id" FROM "public"."connexx_shipment_bulk_uploads" WHERE ("public"."connexx_shipment_bulk_uploads"."sales_account_id" = $1 AND "public"."connexx_shipment_bulk_uploads"."filename" ILIKE $2) ORDER BY "public"."connexx_shipment_bulk_uploads"."created_date" DESC OFFSET $3 Details `CREATE INDEX CONCURRENTLY ON connexx_shipment_bulk_uploads (sales_account_id, created_date)` `Rows: 12843840 Row progression: 12843840, 30009, 0 Row estimates - sales_account_id (=): 30009 - filename (~~*): 1296734 - created_date (sort): 1 Existing indexes - id PRIMARY - sales_account_id - uuid UNIQUE`
4 min < 0.1%	1 ms	179,934 postgresitd
WITH ranked_services AS (SELECT service_id, package_type, standard_sales_price, effective_start_date, ROW_NUMBER() OVER ( PARTITION BY service_id, package_type, standard_sales_price ORDER BY effective_start_date DESC ) AS row_num FROM uk_ecommerce_carrier_service_link ukcsl WHERE ukcsl.effective_start_date::date <= current_date AND carrier_id = $1 AND status = $2), ranked_standard_prices AS (SELECT service_id, package_type, standard_sales_price, effective_start_date, ROW_NUMBER() OVER ( PARTITION BY service_id, package_type ORDER BY effective_start_date DESC ) AS row_num FROM ranked_services WHERE row_num = $3 ORDER BY service_id, package_type, effective_start_date DESC) SELECT service_id, package_type, standard_sales_price, effective_start_date, ROW_NUMBER() OVER ( PARTITION BY service_id, package_type ORDER BY effective_start_date DESC ) AS row_num FROM ranked_standard_prices WHERE row_num <= $4 ORDER BY service_id, package_type, effective_start_date DESC
3 min < 0.1%	1 ms	166,291 upadmin
SELECT "public"."connexx_label_jobs"."id", "public"."connexx_label_jobs"."uuid", "public"."connexx_label_jobs"."status", "public"."connexx_label_jobs"."created_date", "public"."connexx_label_jobs"."created_by", "public"."connexx_label_jobs"."downloaded_date", "public"."connexx_label_jobs"."label_url" FROM "public"."connexx_label_jobs" WHERE ("public"."connexx_label_jobs"."sales_account_id" = $1 AND "public"."connexx_label_jobs"."status" <> $2) ORDER BY "public"."connexx_label_jobs"."created_date" DESC LIMIT $3 OFFSET $4 `Covered by index on (sales_account_id, created_date) Rows: 12958780 Row progression: 12958780, 25509, 17006 Row estimates - sales_account_id (=): 25509 - status (<>): 8639187 - created_date (sort): 1 Existing indexes - id PRIMARY - deprecated_shipment_ids - sales_account_id, created_date - uuid UNIQUE`
3 min < 0.1%	472 ms	407 postgresitd
WITH lat AS (SELECT lat.sales_account_id, COALESCE(sum(lat.outstanding), $2) AS outstanding, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $3 AND CURRENT_DATE - interval $4), $5) AS period_1, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $6 AND CURRENT_DATE - interval $7), $8) AS period_2, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $9 AND CURRENT_DATE - interval $10), $11) AS period_3, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $12 AND CURRENT_DATE - interval $13), $14) AS period_4, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $15 AND CURRENT_DATE - interval $16), $17) AS period_5, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $18 AND CURRENT_DATE - interval $19), $20) AS period_6, lat.transaction_category, make_date($21, $22, $23) as transaction_date, $24 as transaction_reference FROM sales_account_transactions lat WHERE lat.status = $25 AND lat.reversal_user = $26 AND lat.reversed_by = $27 AND lat.original_id = $28 AND lat.financial_company = $1 GROUP BY lat.sales_account_id, lat.status, lat.reversal_user, lat.reversed_by, lat.original_id, lat.financial_company, lat.transaction_category), addresses AS (SELECT sa.id AS sales_account_id, array_agg(TRIM(COALESCE(INITCAP(aan.address_line_1), $29) \|\| $30 \|\| COALESCE(INITCAP(aan.address_line_2), $31) \|\| $32 \|\| COALESCE(INITCAP(aan.address_line_3), $33) \|\| $34 \|\| COALESCE(INITCAP(aan.city), $35) \|\| $36 \|\| COALESCE(INITCAP(aan.county_state), $37) \|\| $38 \|\| COALESCE(UPPER(aan.postcode), $39) \|\| $40 \|\| COALESCE(aan.country, $41))) AS addresses FROM sales_account sa LEFT JOIN account_address_new aan ON sa.company_id = aan.company_id WHERE sa.financial_company = $1 AND aan.status = $42 GROUP BY 1), contacts AS (SELECT sa.id AS sales_account_id, array_agg(TRIM(COALESCE(INITCAP(ac.name), $43) \|\| $44 \|\| COALESCE(LOWER(ac.email_address), $45))) AS contacts FROM sales_account sa LEFT JOIN account_contact ac ON sa.company_id = ac.company_id WHERE sa.financial_company = $1 AND ac.status = $46 GROUP BY 1), sales_accounts AS (SELECT sa.id, COALESCE(sa.old_id, $47) AS old_id, sa.company_id, sa.status, COALESCE(sa.salesperson, $48) AS salesperson, COALESCE(su.department, $49) AS department, coalesce(sa.sales_account_reference, $50) AS ledgerName_reference, coalesce(sa.old_sales_account_reference, $51) AS old_ledgerName_reference, COALESCE(sa.company_number, $52) AS company_number, COALESCE(RTRIM(INITCAP(CONCAT(su.first_name, $53, su.surname))), $54) AS sales_person_name, last_statement_date, CASE WHEN (c_terms ->> $55)::int = $56 THEN $57 WHEN (c_terms ->> $58)::int = $59 THEN $60 WHEN (c_terms ->> $61)::int = $62 THEN $63 WHEN (c_terms ->> $64)::int = $65 THEN $66 WHEN (c_terms ->> $67)::int = $68 THEN $69 WHEN (c_terms ->> $70)::int = $71 THEN $72 ELSE $73 END AS payment_type, COALESCE((c_terms ->> $74)::int, $75) AS credit_terms_period, COALESCE((c_terms ->> $76)::int, $77) AS following_month, COALESCE(sa.status_plus, $78) as status_plus, sa.internal_credit_limit, sa.agent_limit, sa.alert_type, CASE WHEN sa.account_type = $79 THEN $80 WHEN sa.account_type = $81 THEN $82 WHEN sa.account_type = $83 THEN $84 ELSE $85 END AS account_type, CASE WHEN sa.base_currency IS NOT null AND sa.base_currency != $86 THEN currency.currency_code ELSE $87 END AS base_currency, CASE WHEN spsu.id <> $88 THEN CONCAT(spsu.first_name, $89, spsu.surname) ELSE $90 END AS cs_salesperson, CASE WHEN amsu.id <> $91 THEN CONCAT(amsu.first_name, $92, amsu.surname) ELSE $93 END AS cs_account_manager, CASE WHEN succ.id <> $94 THEN CONCAT(succ.first_name, $95, succ.surname) ELSE $96 END AS credit_controller, COALESCE(sa.collection_method, $97) AS collection_method, COALESCE(evri_premium, $98) AS evri_premium FROM sales_account sa LEFT JOIN jsonb_array_elements(sa.credit_terms_json -> $99) AS c_terms ON ($100 AND (c_terms -> $101)::text::int = $102) LEFT JOIN public.system_user su ON su.id = sa.salesperson LEFT JOIN currency ON sa.base_currency = currency.id LEFT JOIN system_user_structure_margins spsm ON sa.sales_person_structure_id = spsm.id LEFT JOIN public.system_user spsu ON spsm.system_user_id = spsu.id LEFT JOIN system_user_structure_margins amsm ON sa.account_manager_structure_id = amsm.id LEFT JOIN public.system_user amsu ON amsm.system_user_id = amsu.id LEFT JOIN public.system_user succ ON sa.credit_controller_id = succ.id WHERE sa.status <> $103 AND sa.financial_company = $1) SELECT sa.id, sa.old_id, COALESCE(sa.internal_credit_limit, $104), COALESCE(sa.agent_limit, $105), sa.ledgerName_reference, sa.old_ledgerName_reference, COALESCE(lat.transaction_date, $106), $107::date, COALESCE(lat.transaction_reference, $108), RTRIM(COALESCE(company.name, $109)), sa.sales_person_name AS sales_person_name, sa.credit_controller AS credit_controller, RTRIM(COALESCE(COALESCE(NULLIF(company.trading_name, $110), company.name), $111)), COALESCE(sa.company_number, $112), SUM(COALESCE(lat.outstanding, $113)), SUM(COALESCE(lat.period_1, $114)), SUM(COALESCE(lat.period_2, $115)), SUM(COALESCE(lat.period_3, $116)), SUM(COALESCE(lat.period_4, $117)), SUM(COALESCE(lat.period_5, $118)), SUM(COALESCE(lat.period_6, $119)), sa.status, CASE WHEN sa.status_plus = $120 AND sa.alert_type = $121 THEN $122 WHEN sa.status_plus = $123 AND sa.alert_type = $124 THEN $125 WHEN sa.status_plus = $126 AND sa.alert_type = $127 THEN $128 WHEN sa.status_plus = $129 AND sa.alert_type = $130 THEN $131 WHEN sa.status_plus = $132 AND sa.alert_type = $133 THEN $134 WHEN sa.status_plus = $135 AND sa.alert_type = $136 THEN $137 ELSE sa.status_plus END, COALESCE(sa.payment_type, $138), COALESCE(sa.credit_terms_period, $139), CASE WHEN COALESCE(sa.status_plus, $140) = $141 THEN SUM(COALESCE(lat.outstanding, $142)) ELSE $143 END, COALESCE(sa.last_statement_date, $144), COALESCE(sa.following_month, $145) AS following_month, sa.account_type, sa.base_currency, CASE WHEN sa.cs_account_manager <> $146 AND sa.cs_salesperson <> $147 THEN CONCAT(sa.cs_salesperson, $148, sa.cs_account_manager) ELSE CONCAT(sa.cs_salesperson, sa.cs_account_manager) END AS cs_sp_am, COALESCE(sa.collection_method, $149) AS collection_method, sa.evri_premium, addresses.addresses \|\| contacts.contacts AS contacts_addresses FROM sales_accounts sa LEFT JOIN company ON company.id = sa.company_id LEFT JOIN lat ON lat.sales_account_id = sa.id LEFT JOIN public.system_user su ON su.id = sa.salesperson LEFT JOIN addresses ON sa.id = addresses.sales_account_id LEFT JOIN contacts ON sa.id = contacts.sales_account_id WHERE sa.status_plus = $150 AND (sa.alert_type = $151 OR sa.alert_type = $152 OR sa.alert_type is null OR sa.alert_type = $153) GROUP BY sa.id, sa.old_id, sa.internal_credit_limit, sa.agent_limit, sa.ledgerName_reference, sa.old_ledgerName_reference, lat.transaction_date, lat.transaction_reference, company.name, sa.sales_person_name, sa.credit_controller, company.trading_name, sa.company_number, sa.status, sa.status_plus, sa.alert_type, sa.payment_type, sa.credit_terms_period, sa.last_statement_date, sa.following_month, sa.account_type, sa.base_currency, sa.cs_salesperson, sa.cs_account_manager, sa.collection_method, sa.evri_premium, addresses.addresses, contacts.contacts
3 min < 0.1%	0 ms	461,017 postgresitd
INSERT INTO consignment_imports (status, source, created_by, created_date, order_number, order_date, order_value, consignment_number, consignment_identifier, barcode_postcode_key, barcode, package_weight, currency, shipment_method, shipper_warehouse, recipient_first_name, recipient_last_name, recipient_phone, ship_to_company_name, ship_to_address_line_1, ship_to_address_line_2, ship_to_address_line_3, ship_to_city, ship_to_state, ship_to_postcode, ship_to_country, email, carrier, service, applied_shipment_rule, external_tracking_url, package_type, import_date, print_date, manifest_date, company_name, sales_account_id, shipper_reference_1, shipper_reference_2, parent, client, brand, origin_of_parcel, invoice_date, evri_year_week, client_year_period, sales_account_reference, destination_area, p_shop_delivery, next_day, sunday, signature, household_signature, pin, volume, carrier_invoice_description, surcharge_description, carrier_invoice_number, client_id, account_number, product_number, product_description, consignment_number_postcode_key, package_length, package_width, package_height) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66) ON CONFLICT (barcode_postcode_key) DO UPDATE SET status = EXCLUDED.status, source = EXCLUDED.source, order_number = EXCLUDED.order_number, order_date = EXCLUDED.order_date, order_value = EXCLUDED.order_value, consignment_number = EXCLUDED.consignment_number, barcode_postcode_key = EXCLUDED.barcode_postcode_key, barcode = EXCLUDED.barcode, package_weight = EXCLUDED.package_weight, currency = EXCLUDED.currency, shipment_method = EXCLUDED.shipment_method, shipper_warehouse = EXCLUDED.shipper_warehouse, recipient_first_name = EXCLUDED.recipient_first_name, recipient_last_name = EXCLUDED.recipient_last_name, recipient_phone = EXCLUDED.recipient_phone, ship_to_company_name = EXCLUDED.ship_to_company_name, ship_to_address_line_1 = EXCLUDED.ship_to_address_line_1, ship_to_address_line_2 = EXCLUDED.ship_to_address_line_2, ship_to_address_line_3 = EXCLUDED.ship_to_address_line_3, ship_to_city = EXCLUDED.ship_to_city, ship_to_state = EXCLUDED.ship_to_state, ship_to_postcode = EXCLUDED.ship_to_postcode, ship_to_country = EXCLUDED.ship_to_country, email = EXCLUDED.email, carrier = EXCLUDED.carrier, service = EXCLUDED.service, applied_shipment_rule = EXCLUDED.applied_shipment_rule, external_tracking_url = EXCLUDED.external_tracking_url, package_type = EXCLUDED.package_type, import_date = EXCLUDED.import_date, print_date = EXCLUDED.print_date, manifest_date = EXCLUDED.manifest_date, company_name = EXCLUDED.company_name, sales_account_id = EXCLUDED.sales_account_id, shipper_reference_1 = EXCLUDED.shipper_reference_1, shipper_reference_2 = EXCLUDED.shipper_reference_2, parent = EXCLUDED.parent, client = EXCLUDED.client, brand = EXCLUDED.brand, origin_of_parcel = EXCLUDED.origin_of_parcel, invoice_date = EXCLUDED.invoice_date, evri_year_week = EXCLUDED.evri_year_week, client_year_period = EXCLUDED.client_year_period, sales_account_reference = EXCLUDED.sales_account_reference, destination_area = EXCLUDED.destination_area, p_shop_delivery = EXCLUDED.p_shop_delivery, next_day = EXCLUDED.next_day, sunday = EXCLUDED.sunday, signature = EXCLUDED.signature, household_signature = EXCLUDED.household_signature, pin = EXCLUDED.pin, volume = EXCLUDED.volume, carrier_invoice_description = EXCLUDED.carrier_invoice_description, surcharge_description = EXCLUDED.surcharge_description, carrier_invoice_number = EXCLUDED.carrier_invoice_number, client_id = EXCLUDED.client_id, account_number = EXCLUDED.account_number, product_number = EXCLUDED.product_number, product_description = EXCLUDED.product_description, consignment_number_postcode_key = EXCLUDED.consignment_number_postcode_key, package_length = EXCLUDED.package_length, package_width = EXCLUDED.package_width, package_height = EXCLUDED.package_height
3 min < 0.1%	0 ms	4,498,757 postgresitd
`SELECT CASE WHEN COUNT(*) > $3 THEN $4 ELSE $5 END FROM connexx_shipments WHERE order_number = $1 AND shipment_source_name = $6 AND sales_account_id = $2 AND status <> $7` Covered by index on (order_number) Rows: 16915082 Row progression: 16915082, 3 Row estimates - order_number (=): 3 - sales_account_id (=): 30098 - shipment_source_name (=): 961772 - status (<>): 13532066 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
3 min < 0.1%	2 ms	76,895 upadmin
UPDATE "public"."connexx_shipments" SET "deleted_date" = $1, "deleted_by" = $2, "status" = $3 WHERE ("public"."connexx_shipments"."id" = $4 AND $5=$6) RETURNING "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails"
3 min < 0.1%	113 ms	1,459 postgresitd
`SELECT note.id, note.created_date, COALESCE(note.created_by, $4), note, COALESCE(internal_type, $5) FROM note LEFT JOIN note_link ON note_link.note_id = note.id WHERE (note_link.old_table_id = $1 OR note_link.table_name = $3) AND note_link.record_id = $2 AND note_link.status = $6 ORDER BY note.created_date DESC LIMIT $7`
3 min < 0.1%	0 ms	1,243,257 upadmin
SELECT "public"."sales_account_shipping_whitelist"."id", "public"."sales_account_shipping_whitelist"."status", "public"."sales_account_shipping_whitelist"."created_date", "public"."sales_account_shipping_whitelist"."created_by", "public"."sales_account_shipping_whitelist"."last_modified_by", "public"."sales_account_shipping_whitelist"."sales_account_id", "public"."sales_account_shipping_whitelist"."carrier_id", "public"."sales_account_shipping_whitelist"."supplier_id", "public"."sales_account_shipping_whitelist"."service_id", "public"."sales_account_shipping_whitelist"."tariff_id", "public"."sales_account_shipping_whitelist"."package_id", "public"."sales_account_shipping_whitelist"."bespoke_margin_discount", "public"."sales_account_shipping_whitelist"."metaphor_login", "public"."sales_account_shipping_whitelist"."scurri_login", "public"."sales_account_shipping_whitelist"."customers_own_login", "public"."sales_account_shipping_whitelist"."notes", "public"."sales_account_shipping_whitelist"."domestic_international", "public"."sales_account_shipping_whitelist"."from_weight", "public"."sales_account_shipping_whitelist"."to_weight", "public"."sales_account_shipping_whitelist"."is_custom", "public"."sales_account_shipping_whitelist"."is_supplier_override_zone", "public"."sales_account_shipping_whitelist"."zone_name", "public"."sales_account_shipping_whitelist"."package_types", "public"."sales_account_shipping_whitelist"."child_account_id", "public"."sales_account_shipping_whitelist"."uuid", "public"."sales_account_shipping_whitelist"."allow_quotes", "public"."sales_account_shipping_whitelist"."allow_labels", "public"."sales_account_shipping_whitelist"."carrier_name", "public"."sales_account_shipping_whitelist"."service_name", "public"."sales_account_shipping_whitelist"."direction_type", "public"."sales_account_shipping_whitelist"."connexx_login", "public"."sales_account_shipping_whitelist"."previous_id", "public"."sales_account_shipping_whitelist"."should_use_new_popal_api", "public"."sales_account_shipping_whitelist"."allow_pickup", "public"."sales_account_shipping_whitelist"."should_use_direct_popal_api", "public"."sales_account_shipping_whitelist"."allow_email", "public"."sales_account_shipping_whitelist"."allow_signature", "public"."sales_account_shipping_whitelist"."allow_adult_signature", "public"."sales_account_shipping_whitelist"."allow_direct_delivery" FROM "public"."sales_account_shipping_whitelist" WHERE ("public"."sales_account_shipping_whitelist"."sales_account_id" = $1 AND "public"."sales_account_shipping_whitelist"."status" = $2) OFFSET $3 `Covered by index on (sales_account_id) Rows: 63681 Row progression: 63681, 20 Row estimates - sales_account_id (=): 20 - status (=): 21227 Existing indexes - id PRIMARY - carrier_id, domestic_international - domestic_international - sales_account_id - sales_account_id, status, from_weight, to_weight, carrier_id, supplier_id, tariff_id, service_id - uuid - zone_name jsonb_path_ops GIN`
3 min < 0.1%	5 ms	30,238 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."sales_account_id" = $1 AND "public"."connexx_shipments"."shipment_type" = $2 AND "public"."connexx_shipments"."integration_store_id" = $3 AND "public"."connexx_shipments"."created_date" >= $4 AND "public"."connexx_shipments"."created_date" <= $5 AND "public"."connexx_shipments"."deleted_date" IS NULL AND "public"."connexx_shipments"."status" IN ($6)) ORDER BY "public"."connexx_shipments"."created_date" DESC LIMIT $7 OFFSET $8 Covered by index on (integration_store_id, sales_account_id) Rows: 16915082 Row progression: 16915082, 7041, 13 Row estimates - integration_store_id (=): 7041 - sales_account_id (=): 30098 - created_date (<=): 1691509 - created_date (>=): 1691509 - status (=): 3383016 - shipment_type (=): 8457541 - deleted_date (null): 15882134 - created_date (sort): 9 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
3 min < 0.1%	0 ms	501,694 upadmin
SELECT "public"."connexx_shipment_packages"."id", "public"."connexx_shipment_packages"."index", "public"."connexx_shipment_packages"."shipment_id", "public"."connexx_shipment_packages"."weight", "public"."connexx_shipment_packages"."width", "public"."connexx_shipment_packages"."height", "public"."connexx_shipment_packages"."length", "public"."connexx_shipment_packages"."tracking_code", "public"."connexx_shipment_packages"."label_url", "public"."connexx_shipment_packages"."errors", "public"."connexx_shipment_packages"."base64_pdf", "public"."connexx_shipment_packages"."base64_zpl", "public"."connexx_shipment_packages"."type" FROM "public"."connexx_shipment_packages" WHERE "public"."connexx_shipment_packages"."shipment_id" IN ($1) OFFSET $2 `Covered by index on (shipment_id) Rows: 16760993 Row progression: 16760993, 2 Row estimates - shipment_id (=): 2 Existing indexes - id PRIMARY - ((created_date)::date), tracking_code, carrier_shipment_package_id - created_date, id - created_date_date - sales_account_id, created_date - shipment_id - tracking_code, created_date - tracking_code, created_date WHERE tracking_code IS NOT NULL - tracking_code gin_trgm_ops GIN - tracking_code gin_trgm_ops GIN`
2 min < 0.1%	1 ms	110,225 upadmin
UPDATE "public"."connexx_shipment_packages" SET "label_url" = $1, "tracking_code" = $2, "base64_pdf" = $3 WHERE ("public"."connexx_shipment_packages"."id" = $4 AND $5=$6) RETURNING "public"."connexx_shipment_packages"."id", "public"."connexx_shipment_packages"."created_by", "public"."connexx_shipment_packages"."created_date", "public"."connexx_shipment_packages"."last_modified_by", "public"."connexx_shipment_packages"."last_modified_date", "public"."connexx_shipment_packages"."shipment_id", "public"."connexx_shipment_packages"."weight", "public"."connexx_shipment_packages"."length", "public"."connexx_shipment_packages"."height", "public"."connexx_shipment_packages"."type", "public"."connexx_shipment_packages"."quantity", "public"."connexx_shipment_packages"."width", "public"."connexx_shipment_packages"."tracking_code", "public"."connexx_shipment_packages"."label_created_date", "public"."connexx_shipment_packages"."label_url", "public"."connexx_shipment_packages"."label_format", "public"."connexx_shipment_packages"."errors", "public"."connexx_shipment_packages"."index", "public"."connexx_shipment_packages"."sales_account_id", "public"."connexx_shipment_packages"."base64_pdf", "public"."connexx_shipment_packages"."shipping_price", "public"."connexx_shipment_packages"."base64_zpl", "public"."connexx_shipment_packages"."original_ui_index", "public"."connexx_shipment_packages"."created_date_date", "public"."connexx_shipment_packages"."year", "public"."connexx_shipment_packages"."month", "public"."connexx_shipment_packages"."class", "public"."connexx_shipment_packages"."dg_net_weight", "public"."connexx_shipment_packages"."dgun_number", "public"."connexx_shipment_packages"."dry_ice_weight", "public"."connexx_shipment_packages"."lithium_category", "public"."connexx_shipment_packages"."packing_group", "public"."connexx_shipment_packages"."dg_package", "public"."connexx_shipment_packages"."carrier_shipment_package_id", "public"."connexx_shipment_packages"."dg_volume_ml_100"
2 min < 0.1%	0 ms	432,712 postgresitd
`INSERT INTO linnworks_api_history (id, created_date, sales_account_id, linnworks_request, connexx_request, connexx_response, linnworks_response, endpoint, errors) VALUES ($9, $1, $2, $3, $4, $5, $6, $7, $8) ON CONFLICT (id) DO UPDATE SET sales_account_id = EXCLUDED.sales_account_id, connexx_request = EXCLUDED.connexx_request, connexx_response = EXCLUDED.connexx_response, linnworks_response = EXCLUDED.linnworks_response, errors = EXCLUDED.errors RETURNING id`
2 min < 0.1%	0 ms	1,250,686 upadmin
SELECT "public"."connexx_virtual_warehouses"."id", "public"."connexx_virtual_warehouses"."is_default", "public"."connexx_virtual_warehouses"."name", "public"."connexx_virtual_warehouses"."address_id", "public"."connexx_virtual_warehouses"."vat_number", "public"."connexx_virtual_warehouses"."email", "public"."connexx_virtual_warehouses"."phone_number", "public"."connexx_virtual_warehouses"."company_name", "public"."connexx_virtual_warehouses"."eori_number", "public"."connexx_virtual_warehouses"."sales_account_id" FROM "public"."connexx_virtual_warehouses" WHERE ("public"."connexx_virtual_warehouses"."sales_account_id" = $1 AND "public"."connexx_virtual_warehouses"."deleted_date" IS NULL) OFFSET $2 Details `CREATE INDEX CONCURRENTLY ON connexx_virtual_warehouses (sales_account_id)` `Rows: 994 Row progression: 994, 1 Row estimates - sales_account_id (=): 1 - deleted_date (null): 974 Existing indexes - id PRIMARY - name, sales_account_id UNIQUE`
2 min < 0.1%	1 ms	260,739 postgresitd
`INSERT INTO consignment_tracking( status, created_by, created_date, barcode, carrier_id, type, tracking_information) VALUES ( $5, $6, CURRENT_TIMESTAMP, $1, $2, $3, $4 ) ON CONFLICT (barcode) DO UPDATE SET tracking_information = CASE WHEN consignment_tracking.tracking_information IS NULL OR consignment_tracking.tracking_information->$7->>$8 != $4->$9->>$10 THEN consignment_tracking.tracking_information \|\| $4 ::jsonb ELSE consignment_tracking.tracking_information END`
2 min < 0.1%	0 ms	1,119,038 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."id") IN (SELECT "t1"."shipment_id" FROM "public"."connexx_label_jobs_shipments" AS "t1" WHERE ("t1"."label_job_id" = $1 AND "t1"."shipment_id" IS NOT NULL)) OFFSET $2
2 min < 0.1%	0 ms	3,639,611 upadmin
SELECT "public"."connexx_shipment_packages"."id", "public"."connexx_shipment_packages"."created_by", "public"."connexx_shipment_packages"."created_date", "public"."connexx_shipment_packages"."last_modified_by", "public"."connexx_shipment_packages"."last_modified_date", "public"."connexx_shipment_packages"."shipment_id", "public"."connexx_shipment_packages"."weight", "public"."connexx_shipment_packages"."length", "public"."connexx_shipment_packages"."height", "public"."connexx_shipment_packages"."type", "public"."connexx_shipment_packages"."quantity", "public"."connexx_shipment_packages"."width", "public"."connexx_shipment_packages"."tracking_code", "public"."connexx_shipment_packages"."label_created_date", "public"."connexx_shipment_packages"."label_url", "public"."connexx_shipment_packages"."label_format", "public"."connexx_shipment_packages"."errors", "public"."connexx_shipment_packages"."index", "public"."connexx_shipment_packages"."sales_account_id", "public"."connexx_shipment_packages"."base64_pdf", "public"."connexx_shipment_packages"."shipping_price", "public"."connexx_shipment_packages"."base64_zpl", "public"."connexx_shipment_packages"."original_ui_index", "public"."connexx_shipment_packages"."created_date_date", "public"."connexx_shipment_packages"."year", "public"."connexx_shipment_packages"."month", "public"."connexx_shipment_packages"."class", "public"."connexx_shipment_packages"."dg_net_weight", "public"."connexx_shipment_packages"."dgun_number", "public"."connexx_shipment_packages"."dry_ice_weight", "public"."connexx_shipment_packages"."lithium_category", "public"."connexx_shipment_packages"."packing_group", "public"."connexx_shipment_packages"."dg_package", "public"."connexx_shipment_packages"."carrier_shipment_package_id", "public"."connexx_shipment_packages"."dg_volume_ml_100" FROM "public"."connexx_shipment_packages" WHERE "public"."connexx_shipment_packages"."shipment_id" = $1 OFFSET $2 `Covered by index on (shipment_id) Rows: 16760993 Row progression: 16760993, 2 Row estimates - shipment_id (=): 2 Existing indexes - id PRIMARY - ((created_date)::date), tracking_code, carrier_shipment_package_id - created_date, id - created_date_date - sales_account_id, created_date - shipment_id - tracking_code, created_date - tracking_code, created_date WHERE tracking_code IS NOT NULL - tracking_code gin_trgm_ops GIN - tracking_code gin_trgm_ops GIN`
2 min < 0.1%	1 ms	80,542 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" WHERE "public"."connexx_shipments"."job_number" = $1 LIMIT $2 OFFSET $3 Covered by index on (job_number) Rows: 16915082 Row progression: 16915082, 1 Row estimates - job_number (=): 1 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
2 min < 0.1%	0 ms	384,596 upadmin
`UPDATE "public"."connexx_shipments" SET "status" = $1 WHERE "public"."connexx_shipments"."id" IN ($2)` Covered by index on (id) Rows: 16915082 Row progression: 16915082, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
2 min < 0.1%	3,577 ms	31 postgresitd
`UPDATE uk_ecommerce_consignments AS update_table SET supplier_nominal_transaction_id = ntl.id FROM nominal_transaction_lines ntl WHERE (update_table.supplier_nominal_transaction_id = $1 OR update_table.supplier_nominal_transaction_id IS NULL) AND ntl.referring_table = $2 AND ntl.referring_field = $3 AND update_table.id = ntl.referring_id AND ntl.status = $4 AND ntl.original_id = $5 AND ntl.reversed_by = $6 AND ntl.reversal_user = $7`
2 min < 0.1%	498 ms	218 postgresitd
WITH lat AS (SELECT lat.sales_account_id, COALESCE(sum(lat.outstanding), $2) AS outstanding, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $3 AND CURRENT_DATE - interval $4), $5) AS period_1, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $6 AND CURRENT_DATE - interval $7), $8) AS period_2, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $9 AND CURRENT_DATE - interval $10), $11) AS period_3, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $12 AND CURRENT_DATE - interval $13), $14) AS period_4, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $15 AND CURRENT_DATE - interval $16), $17) AS period_5, COALESCE(sum(lat.outstanding) FILTER (WHERE lat.date_due BETWEEN CURRENT_DATE - interval $18 AND CURRENT_DATE - interval $19), $20) AS period_6, lat.transaction_category, make_date($21, $22, $23) as transaction_date, $24 as transaction_reference FROM sales_account_transactions lat WHERE lat.status = $25 AND lat.reversal_user = $26 AND lat.reversed_by = $27 AND lat.original_id = $28 AND lat.financial_company = $1 GROUP BY lat.sales_account_id, lat.status, lat.reversal_user, lat.reversed_by, lat.original_id, lat.financial_company, lat.transaction_category), addresses AS (SELECT sa.id AS sales_account_id, array_agg(TRIM(COALESCE(INITCAP(aan.address_line_1), $29) \|\| $30 \|\| COALESCE(INITCAP(aan.address_line_2), $31) \|\| $32 \|\| COALESCE(INITCAP(aan.address_line_3), $33) \|\| $34 \|\| COALESCE(INITCAP(aan.city), $35) \|\| $36 \|\| COALESCE(INITCAP(aan.county_state), $37) \|\| $38 \|\| COALESCE(UPPER(aan.postcode), $39) \|\| $40 \|\| COALESCE(aan.country, $41))) AS addresses FROM sales_account sa LEFT JOIN account_address_new aan ON sa.company_id = aan.company_id WHERE sa.financial_company = $1 AND aan.status = $42 GROUP BY 1), contacts AS (SELECT sa.id AS sales_account_id, array_agg(TRIM(COALESCE(INITCAP(ac.name), $43) \|\| $44 \|\| COALESCE(LOWER(ac.email_address), $45))) AS contacts FROM sales_account sa LEFT JOIN account_contact ac ON sa.company_id = ac.company_id WHERE sa.financial_company = $1 AND ac.status = $46 GROUP BY 1), sales_accounts AS (SELECT sa.id, COALESCE(sa.old_id, $47) AS old_id, sa.company_id, sa.status, COALESCE(sa.salesperson, $48) AS salesperson, COALESCE(su.department, $49) AS department, coalesce(sa.sales_account_reference, $50) AS ledgerName_reference, coalesce(sa.old_sales_account_reference, $51) AS old_ledgerName_reference, COALESCE(sa.company_number, $52) AS company_number, COALESCE(RTRIM(INITCAP(CONCAT(su.first_name, $53, su.surname))), $54) AS sales_person_name, last_statement_date, CASE WHEN (c_terms ->> $55)::int = $56 THEN $57 WHEN (c_terms ->> $58)::int = $59 THEN $60 WHEN (c_terms ->> $61)::int = $62 THEN $63 WHEN (c_terms ->> $64)::int = $65 THEN $66 WHEN (c_terms ->> $67)::int = $68 THEN $69 WHEN (c_terms ->> $70)::int = $71 THEN $72 ELSE $73 END AS payment_type, COALESCE((c_terms ->> $74)::int, $75) AS credit_terms_period, COALESCE((c_terms ->> $76)::int, $77) AS following_month, COALESCE(sa.status_plus, $78) as status_plus, sa.internal_credit_limit, sa.agent_limit, sa.alert_type, CASE WHEN sa.account_type = $79 THEN $80 WHEN sa.account_type = $81 THEN $82 WHEN sa.account_type = $83 THEN $84 ELSE $85 END AS account_type, CASE WHEN sa.base_currency IS NOT null AND sa.base_currency != $86 THEN currency.currency_code ELSE $87 END AS base_currency, CASE WHEN spsu.id <> $88 THEN CONCAT(spsu.first_name, $89, spsu.surname) ELSE $90 END AS cs_salesperson, CASE WHEN amsu.id <> $91 THEN CONCAT(amsu.first_name, $92, amsu.surname) ELSE $93 END AS cs_account_manager, CASE WHEN succ.id <> $94 THEN CONCAT(succ.first_name, $95, succ.surname) ELSE $96 END AS credit_controller, COALESCE(sa.collection_method, $97) AS collection_method, COALESCE(evri_premium, $98) AS evri_premium FROM sales_account sa LEFT JOIN jsonb_array_elements(sa.credit_terms_json -> $99) AS c_terms ON ($100 AND (c_terms -> $101)::text::int = $102) LEFT JOIN public.system_user su ON su.id = sa.salesperson LEFT JOIN currency ON sa.base_currency = currency.id LEFT JOIN system_user_structure_margins spsm ON sa.sales_person_structure_id = spsm.id LEFT JOIN public.system_user spsu ON spsm.system_user_id = spsu.id LEFT JOIN system_user_structure_margins amsm ON sa.account_manager_structure_id = amsm.id LEFT JOIN public.system_user amsu ON amsm.system_user_id = amsu.id LEFT JOIN public.system_user succ ON sa.credit_controller_id = succ.id WHERE sa.status <> $103 AND sa.financial_company = $1) SELECT sa.id, sa.old_id, COALESCE(sa.internal_credit_limit, $104), COALESCE(sa.agent_limit, $105), sa.ledgerName_reference, sa.old_ledgerName_reference, COALESCE(lat.transaction_date, $106), $107::date, COALESCE(lat.transaction_reference, $108), RTRIM(COALESCE(company.name, $109)), sa.sales_person_name AS sales_person_name, sa.credit_controller AS credit_controller, RTRIM(COALESCE(COALESCE(NULLIF(company.trading_name, $110), company.name), $111)), COALESCE(sa.company_number, $112), SUM(COALESCE(lat.outstanding, $113)), SUM(COALESCE(lat.period_1, $114)), SUM(COALESCE(lat.period_2, $115)), SUM(COALESCE(lat.period_3, $116)), SUM(COALESCE(lat.period_4, $117)), SUM(COALESCE(lat.period_5, $118)), SUM(COALESCE(lat.period_6, $119)), sa.status, CASE WHEN sa.status_plus = $120 AND sa.alert_type = $121 THEN $122 WHEN sa.status_plus = $123 AND sa.alert_type = $124 THEN $125 WHEN sa.status_plus = $126 AND sa.alert_type = $127 THEN $128 WHEN sa.status_plus = $129 AND sa.alert_type = $130 THEN $131 WHEN sa.status_plus = $132 AND sa.alert_type = $133 THEN $134 WHEN sa.status_plus = $135 AND sa.alert_type = $136 THEN $137 ELSE sa.status_plus END, COALESCE(sa.payment_type, $138), COALESCE(sa.credit_terms_period, $139), CASE WHEN COALESCE(sa.status_plus, $140) = $141 THEN SUM(COALESCE(lat.outstanding, $142)) ELSE $143 END, COALESCE(sa.last_statement_date, $144), COALESCE(sa.following_month, $145) AS following_month, sa.account_type, sa.base_currency, CASE WHEN sa.cs_account_manager <> $146 AND sa.cs_salesperson <> $147 THEN CONCAT(sa.cs_salesperson, $148, sa.cs_account_manager) ELSE CONCAT(sa.cs_salesperson, sa.cs_account_manager) END AS cs_sp_am, COALESCE(sa.collection_method, $149) AS collection_method, sa.evri_premium, addresses.addresses \|\| contacts.contacts AS contacts_addresses FROM sales_accounts sa LEFT JOIN company ON company.id = sa.company_id LEFT JOIN lat ON lat.sales_account_id = sa.id LEFT JOIN public.system_user su ON su.id = sa.salesperson LEFT JOIN addresses ON sa.id = addresses.sales_account_id LEFT JOIN contacts ON sa.id = contacts.sales_account_id WHERE (sa.status_plus = $150 OR sa.status_plus = $151) OR sa.alert_type = $152 GROUP BY sa.id, sa.old_id, sa.internal_credit_limit, sa.agent_limit, sa.ledgerName_reference, sa.old_ledgerName_reference, lat.transaction_date, lat.transaction_reference, company.name, sa.sales_person_name, sa.credit_controller, company.trading_name, sa.company_number, sa.status, sa.status_plus, sa.alert_type, sa.payment_type, sa.credit_terms_period, sa.last_statement_date, sa.following_month, sa.account_type, sa.base_currency, sa.cs_salesperson, sa.cs_account_manager, sa.collection_method, sa.evri_premium, addresses.addresses, contacts.contacts
2 min < 0.1%	3 ms	33,934 upadmin
UPDATE "public"."connexx_shipments" SET "status" = $1, "combined_label_url" = $2, "consignment_number" = $3, "base64_eltron" = $4, "base64_citizen" = $5, "carrier_label_errors" = $6, "carrier_shipment_id" = $7 WHERE ("public"."connexx_shipments"."id" = $8 AND $9=$10) RETURNING "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails"
2 min < 0.1%	0 ms	3,068,032 upadmin
`SELECT "public"."sales_account"."id", "public"."sales_account"."default_settings" FROM "public"."sales_account" WHERE ("public"."sales_account"."id" = $1 AND $4=$5) LIMIT $2 OFFSET $3`
2 min < 0.1%	0 ms	514,892 upadmin
UPDATE "public"."connexx_label_jobs" SET "label_url" = $1, "status" = $2 WHERE ("public"."connexx_label_jobs"."id" = $3 AND $4=$5) RETURNING "public"."connexx_label_jobs"."id", "public"."connexx_label_jobs"."uuid", "public"."connexx_label_jobs"."status", "public"."connexx_label_jobs"."created_by", "public"."connexx_label_jobs"."created_date", "public"."connexx_label_jobs"."sales_account_id", "public"."connexx_label_jobs"."label_url", "public"."connexx_label_jobs"."downloaded", "public"."connexx_label_jobs"."downloaded_date", "public"."connexx_label_jobs"."downloaded_by", "public"."connexx_label_jobs"."label_size"::text, "public"."connexx_label_jobs"."errors", "public"."connexx_label_jobs"."deprecated_shipment_ids", "public"."connexx_label_jobs"."print_png_labels"
2 min < 0.1%	0 ms	1,839,417 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" WHERE "public"."connexx_shipments"."shipment_bulk_upload_id" = $1 OFFSET $2 Covered by index on (shipment_bulk_upload_id) Rows: 16915082 Row progression: 16915082, 25 Row estimates - shipment_bulk_upload_id (=): 25 Existing indexes - id PRIMARY - api_id, sales_account_id - carrier_shipment_id - created_by - created_date_date - customer_reference gin_trgm_ops GIN - customer_reference_2 gin_trgm_ops GIN - from_address_company gin_trgm_ops GIN - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - id WHERE upper((status)::text) <> ALL (ARRAY['CANCELLED'::text, 'ERROR'::text]) - integration_store_id, sales_account_id - job_number - lower((customer_reference)::text) - lower((estimated_delivery_date)::text) - lower((from_address_first_name)::text) - lower((from_address_last_name)::text) - lower((from_address_street_1)::text) - lower((from_address_zip)::text) - lower((order_number)::text), shipment_source_name, sales_account_id, status - lower((to_address_company)::text) - lower((to_address_first_name)::text) - lower((to_address_last_name)::text) - lower((to_address_street_1)::text) - lower((to_address_zip)::text) - order_number - order_number gin_trgm_ops GIN - sales_account_id, created_date - sales_account_id, created_date, shipment_type, status - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'cancelled'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'error'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'label_created'::text) - sales_account_id, created_date WHERE ((shipment_type)::text = 'SHIPMENT'::text) AND ((status)::text = 'ready_to_print'::text) - sales_account_id, customer_reference - shipment_bulk_upload_id - shipment_integration_id, lower((customer_reference)::text) - shipment_type - status, carrier_api_request_json - to_address_company gin_trgm_ops GIN - ups_pickup_prn_number - uuid UNIQUE
2 min < 0.1%	1 ms	134,772 upadmin
SELECT "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."uuid" = $1 AND $4=$5) LIMIT $2 OFFSET $3
1 min < 0.1%	0 ms	749,288 postgresitd
`INSERT INTO consignment_tracking (status, created_by, created_date, barcode, carrier_id, type, tracking_information) VALUES ($3, $4, current_timestamp, $1, $5, $6, $2::jsonb) ON CONFLICT (barcode) DO UPDATE SET tracking_information = EXCLUDED.tracking_information::jsonb`
1 min < 0.1%	2 ms	43,399 upadmin
UPDATE "public"."connexx_shipments" SET "shipment_type" = $1, "status" = $2, "customer_reference" = $3, "customer_reference_2" = $4, "ddp" = $5, "invoice_number" = $6, "dangerous_goods" = $7, "reason_for_export" = $8, "duty_or_tax_paid_by" = $9, "date_converted_to_shipment" = $10, "from_address_first_name" = $11, "from_address_last_name" = $12, "from_address_email" = $13, "from_address_phone" = $14, "from_address_company" = $15, "from_address_street_1" = $16, "from_address_street_2" = $17, "from_address_city" = $18, "from_address_county_state" = $19, "from_address_vat_number" = $20, "from_address_eori_number" = $21, "to_address_first_name" = $22, "to_address_last_name" = $23, "to_address_email" = $24, "to_address_phone" = $25, "to_address_company" = $26, "to_address_street_1" = $27, "to_address_street_2" = $28, "to_address_city" = $29, "to_address_county_state" = $30, "to_address_vat_number" = $31, "to_address_eori_number" = $32, "importer_address_first_name" = $33, "importer_address_last_name" = $34, "importer_address_email" = $35, "importer_address_phone" = $36, "importer_address_company" = $37, "importer_address_street_1" = $38, "importer_address_street_2" = $39, "importer_address_city" = $40, "importer_address_county_state" = $41, "importer_address_country_iso" = $42, "importer_address_eori_number" = $43, "importer_address_vat_number" = $44, "should_use_importer_of_record" = $45, "shipping_whitelist_id" = $46, "pick_up_from_date_local_time" = $47, "pick_up_instructions" = $48, "pick_up_to_date_local_time" = $49, "should_pick_up" = $50, "insurance_amount" = $51, "insurance_amount_currency_code" = $52, "requires_direct_delivery" = $53, "requires_adult_signature" = $54, "requires_signature" = $55, "use_insurance" = $56, "uploaded_proforma_invoice_base64" = $57, "uploaded_commercial_invoice_base64" = $58, "uploaded_customs_declaration_base64" = $59, "uploaded_certificate_of_origin_base64" = $60, "uploaded_packing_listadr_base64" = $61, "uploaded_bank_documents_base64" = $62, "uploaded_dg_goods_declaration_base64" = $63, "uploaded_other_documents_base64" = $64, "uploaded_pickup_order_base64" = $65, "uploaded_export_declaration_base64" = $66, "uploaded_export_attachment_base64" = $67, "shipment_source_name" = $68, "dropoff_info" = $69, "should_split_duty_and_vat" = $70, "integration_store_id" = $71, "shipment_integration_id" = $72, "order_number" = $73, "ukims_number" = $74, "integration_created_date" = $75, "delivery_instructions" = $76, "service_options" = $77 WHERE ("public"."connexx_shipments"."id" = $78 AND $79=$80) RETURNING "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."co
1 min < 0.1%	1 ms	84,287 upadmin
UPDATE "public"."connexx_shipments" SET "commercial_invoice_base64" = $1 WHERE ("public"."connexx_shipments"."id" = $2 AND $3=$4) RETURNING "public"."connexx_shipments"."id", "public"."connexx_shipments"."uuid", "public"."connexx_shipments"."created_by", "public"."connexx_shipments"."created_date", "public"."connexx_shipments"."last_modified_by", "public"."connexx_shipments"."last_modified_date", "public"."connexx_shipments"."duty_or_tax_paid_by", "public"."connexx_shipments"."customer_reference", "public"."connexx_shipments"."shipment_bulk_upload_id", "public"."connexx_shipments"."applied_rule_id", "public"."connexx_shipments"."from_address_first_name", "public"."connexx_shipments"."from_address_last_name", "public"."connexx_shipments"."from_address_company", "public"."connexx_shipments"."from_address_email", "public"."connexx_shipments"."from_address_phone", "public"."connexx_shipments"."from_address_street_1", "public"."connexx_shipments"."from_address_street_2", "public"."connexx_shipments"."from_address_street_3", "public"."connexx_shipments"."from_address_city", "public"."connexx_shipments"."from_address_county_state", "public"."connexx_shipments"."from_address_country_iso", "public"."connexx_shipments"."from_address_zip", "public"."connexx_shipments"."to_address_first_name", "public"."connexx_shipments"."to_address_last_name", "public"."connexx_shipments"."to_address_company", "public"."connexx_shipments"."to_address_email", "public"."connexx_shipments"."to_address_phone", "public"."connexx_shipments"."to_address_street_1", "public"."connexx_shipments"."to_address_street_2", "public"."connexx_shipments"."to_address_street_3", "public"."connexx_shipments"."to_address_city", "public"."connexx_shipments"."to_address_county_state", "public"."connexx_shipments"."to_address_country_iso", "public"."connexx_shipments"."to_address_zip", "public"."connexx_shipments"."sales_account_id", "public"."connexx_shipments"."job_number", "public"."connexx_shipments"."generated_by_admin", "public"."connexx_shipments"."date_converted_to_shipment", "public"."connexx_shipments"."shipment_type", "public"."connexx_shipments"."deleted_date", "public"."connexx_shipments"."deleted_by", "public"."connexx_shipments"."status", "public"."connexx_shipments"."rates_sql_query_output", "public"."connexx_shipments"."rates_sql_query_input", "public"."connexx_shipments"."errors", "public"."connexx_shipments"."reason_for_export", "public"."connexx_shipments"."combined_label_url", "public"."connexx_shipments"."bulk_upload_row_id", "public"."connexx_shipments"."original_shipment_id", "public"."connexx_shipments"."_remove_selected_quote_id", "public"."connexx_shipments"."shipping_whitelist_id", "public"."connexx_shipments"."from_address_vat_number", "public"."connexx_shipments"."from_address_eori_number", "public"."connexx_shipments"."to_address_vat_number", "public"."connexx_shipments"."to_address_eori_number", "public"."connexx_shipments"."virtual_warehouse_id", "public"."connexx_shipments"."service_options", "public"."connexx_shipments"."consignment_number", "public"."connexx_shipments"."commercial_invoice_pdf_url", "public"."connexx_shipments"."external_customer_id", "public"."connexx_shipments"."carrier_depot_id", "public"."connexx_shipments"."base64_eltron", "public"."connexx_shipments"."base64_citizen", "public"."connexx_shipments"."label_type"::text, "public"."connexx_shipments"."carrier_shipment_id", "public"."connexx_shipments"."invoice_date", "public"."connexx_shipments"."invoice_number", "public"."connexx_shipments"."order_number", "public"."connexx_shipments"."carrier_label_errors", "public"."connexx_shipments"."commercial_invoice_base64", "public"."connexx_shipments"."should_generate_commercial_invoice", "public"."connexx_shipments"."use_insurance", "public"."connexx_shipments"."insurance_amount", "public"."connexx_shipments"."insurance_amount_currency_code", "public"."connexx_shipments"."fedex_pickup_request_form_base64", "public"."connexx_shipments"."ddp", "public"."connexx_shipments"."should_pick_up", "public"."connexx_shipments"."pick_up_from_date_local_time", "public"."connexx_shipments"."pick_up_to_date_local_time", "public"."connexx_shipments"."pick_up_instructions", "public"."connexx_shipments"."carrier_api_request_json", "public"."connexx_shipments"."carrier_api_request", "public"."connexx_shipments"."original_shipping_whitelist_id", "public"."connexx_shipments"."uploaded_commercial_invoice_base64", "public"."connexx_shipments"."ioss_number", "public"."connexx_shipments"."future_label_date", "public"."connexx_shipments"."uploaded_proforma_invoice_base64", "public"."connexx_shipments"."uploaded_customs_declaration_base64", "public"."connexx_shipments"."uploaded_certificate_of_origin_base64", "public"."connexx_shipments"."uploaded_packing_listadr_base64", "public"."connexx_shipments"."uploaded_bank_documents_base64", "public"."connexx_shipments"."uploaded_dg_goods_declaration_base64", "public"."connexx_shipments"."uploaded_other_documents_base64", "public"."connexx_shipments"."uploaded_pickup_order_base64", "public"."connexx_shipments"."uploaded_export_declaration_base64", "public"."connexx_shipments"."uploaded_export_attachment_base64", "public"."connexx_shipments"."display_address_line_3", "public"."connexx_shipments"."discount_amount_multiplied", "public"."connexx_shipments"."shipment_source_name", "public"."connexx_shipments"."shipment_integration_id", "public"."connexx_shipments"."api_id", "public"."connexx_shipments"."ups_pickup_prn_number", "public"."connexx_shipments"."created_date_date", "public"."connexx_shipments"."dangerous_goods", "public"."connexx_shipments"."estimated_delivery_date", "public"."connexx_shipments"."packing_slip_base64", "public"."connexx_shipments"."should_split_duty_and_vat", "public"."connexx_shipments"."fedex_pickup_prn_number", "public"."connexx_shipments"."shipment_info", "public"."connexx_shipments"."integration_store_id", "public"."connexx_shipments"."store_integration_id", "public"."connexx_shipments"."dropoff_info", "public"."connexx_shipments"."ups_pickup_request_body", "public"."connexx_shipments"."fedex_pickup_location", "public"."connexx_shipments"."historic_prns", "public"."connexx_shipments"."cn22_base64", "public"."connexx_shipments"."customer_reference_2", "public"."connexx_shipments"."custom_shipment_data", "public"."connexx_shipments"."ukims_number", "public"."connexx_shipments"."delivery_instructions", "public"."connexx_shipments"."integration_created_date", "public"."connexx_shipments"."importer_address_first_name", "public"."connexx_shipments"."importer_address_last_name", "public"."connexx_shipments"."importer_address_company", "public"."connexx_shipments"."importer_address_email", "public"."connexx_shipments"."importer_address_phone", "public"."connexx_shipments"."importer_address_street_1", "public"."connexx_shipments"."importer_address_street_2", "public"."connexx_shipments"."importer_address_street_3", "public"."connexx_shipments"."importer_address_city", "public"."connexx_shipments"."importer_address_county_state", "public"."connexx_shipments"."importer_address_country_iso", "public"."connexx_shipments"."importer_address_zip", "public"."connexx_shipments"."importer_address_eori_number", "public"."connexx_shipments"."importer_address_vat_number", "public"."connexx_shipments"."should_use_importer_of_record", "public"."connexx_shipments"."requires_signature", "public"."connexx_shipments"."requires_adult_signature", "public"."connexx_shipments"."requires_direct_delivery", "public"."connexx_shipments"."deliver_to_residential", "public"."connexx_shipments"."notification_emails"
1 min < 0.1%	0 ms	2,072,698 upadmin
`SELECT "public"."sales_account"."id", "public"."sales_account"."default_settings" FROM "public"."sales_account" WHERE "public"."sales_account"."id" = $1 LIMIT $2 OFFSET $3` Covered by index on (id, COALESCE(old_id, 0), COALESCE(sales_account_reference, ''::character varying), COALESCE(old_sales_account_reference, ''::character varying), company_id) Rows: 8410 Row progression: 8410, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - account_manager_structure_id - account_manager_structure_id, sales_person_structure_id - alert_type - company_id - financial_company, status WHERE (status)::text = 'A'::text - id, COALESCE(old_id, 0), COALESCE(sales_account_reference, ''::character varying), COALESCE(old_sales_account_reference, ''::character varying), company_id - parent_id - parent_id WHERE parent_id > 0 - sales_account_reference UNIQUE - sales_person_structure_id - status_plus, financial_company, status - uuid