Queries

Total Time	Average Time	Calls
1,384 min 19%	457 ms	181,640 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
1,077 min 15%	409 ms	157,924 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", "public"."connexx_shipments"."customer_order_source" 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
786 min 11%	298 ms	157,927 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
444 min 6%	103 ms	259,743 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: 15442166 Row progression: 15442166, 28282 Row estimates - sales_account_id (=): 28282 Existing indexes - id PRIMARY - deprecated_shipment_ids - sales_account_id, created_date - uuid UNIQUE`
400 min 6%	1 ms	24,928,752 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`
379 min 5%	14 ms	1,607,354 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
331 min 5%	78 ms	254,122 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"`
319 min 4%	1,311 ms	14,616 upadmin
SELECT "public"."connexx_shipment_item_descriptions"."id", "public"."connexx_shipment_item_descriptions"."description", "public"."connexx_shipment_item_descriptions"."commodity_code", "public"."connexx_shipment_item_descriptions"."sku", "public"."connexx_shipment_item_descriptions"."item_value", "public"."connexx_shipment_item_descriptions"."weight", "public"."connexx_shipment_item_descriptions"."country_of_origin", "public"."connexx_shipment_item_descriptions"."manufacturer_details", "public"."connexx_shipment_item_descriptions"."currency" FROM "public"."connexx_shipment_item_descriptions" WHERE ("public"."connexx_shipment_item_descriptions"."sales_account_id" = $1 AND "public"."connexx_shipment_item_descriptions"."description" IS NOT NULL AND "public"."connexx_shipment_item_descriptions"."description" ILIKE $2) ORDER BY "public"."connexx_shipment_item_descriptions"."created_date" DESC LIMIT $3 OFFSET $4 Details `CREATE INDEX CONCURRENTLY ON connexx_shipment_item_descriptions (sales_account_id)` Rows: 24877030 Row progression: 24877030, 46412, 45333 Row estimates - sales_account_id (=): 46412 - description (~~*): 2429946 - description (not_null): 24298224 - created_date (sort): 65 Existing indexes - id PRIMARY - lower((description)::text) - lower((sku)::text) - shipment_id - shipment_id, lower((sku)::text), lower((description)::text) WHERE shipment_id IS NOT NULL - shipment_id WHERE shipment_id IS NOT NULL - sku - sku gin_trgm_ops, description gin_trgm_ops GIN - sku gin_trgm_ops WHERE shipment_id IS NOT NULL GIN
227 min 3%	52 ms	259,742 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"`
181 min 3%	55 ms	199,328 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`
173 min 2%	0 ms	21,387,615 upadmin
`SELECT "public"."intl_service"."id", "public"."intl_service"."name" FROM "public"."intl_service" WHERE $2=$3 OFFSET $1`
150 min 2%	0 ms	21,387,683 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`
87 min 1%	1,415 ms	3,685 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", "public"."connexx_shipments"."customer_order_source" 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"."customer_reference" ASC LIMIT $27 OFFSET $28
75 min 1%	1 ms	4,025,160 postgresitd
`SELECT EXISTS( SELECT $4 FROM connexx_shipments WHERE customer_reference = $1 AND shipment_integration_id = $2 AND sales_account_id = $3 )`
66 min 0.9%	66 ms	60,787 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", "public"."connexx_shipment_packages"."randomized_reference" 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
62 min 0.9%	0 ms	21,387,615 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`
61 min 0.9%	541 ms	6,792 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
44 min 0.6%	5 ms	506,814 upadmin
`SELECT "public"."consignment_unified_statuses"."id", "public"."consignment_unified_statuses"."unified_status" FROM "public"."consignment_unified_statuses" WHERE $2=$3 OFFSET $1`
43 min 0.6%	14 ms	185,072 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: 19930812 Row progression: 19930812, 34363, 3436 Row estimates - sales_account_id (=): 34363 - created_date (>=): 1993082 - created_date (<=): 1993082 - status (=): 3321802 - shipment_type (=): 9965406 - deleted_date (null): 18711711 - created_date (sort): 10 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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
34 min 0.5%	21 ms	96,334 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`
33 min 0.5%	14 ms	145,536 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: 34687828 Row progression: 34687828, 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`
30 min 0.4%	19 ms	96,418 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))`
28 min 0.4%	78 ms	21,587 postgresitd
`SELECT EXISTS ( SELECT $3 FROM connexx_shipments WHERE customer_reference = $1 AND shipment_integration_id = $2) AS exists`
28 min 0.4%	2 ms	801,150 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"
27 min 0.4%	0 ms	21,387,615 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`
27 min 0.4%	2 ms	806,785 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"
24 min 0.3%	393 ms	3,685 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"."customer_reference" ASC OFFSET $27
22 min 0.3%	7 ms	194,460 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: 19930812 Row progression: 19930812, 34363, 3436 Row estimates - sales_account_id (=): 34363 - created_date (>=): 1993082 - created_date (<=): 1993082 - shipment_type (=): 9965406 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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
19 min 0.3%	395 ms	2,879 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: 80512064 Row progression: 80512064, 76949, 75 Row estimates - sales_account_reference (=): 76949 - sales_account_id (=): 78191 - status (=): 40230537 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
18 min 0.3%	4 ms	254,110 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", "public"."connexx_shipments"."customer_order_source" 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 = 'cancelled'::text)) Rows: 19930812 Row progression: 19930812, 34363, 17182 Row estimates - sales_account_id (=): 34363 - shipment_type (=): 9965406 - deleted_date (null): 18711711 - created_date (sort): 10 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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
17 min 0.2%	1 ms	1,701,063 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", "public"."connexx_shipments"."customer_order_source" FROM "public"."connexx_shipments" WHERE "public"."connexx_shipments"."id" IN ($1) OFFSET $2 Covered by index on (id) Rows: 19930812 Row progression: 19930812, 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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.2%	1 ms	1,821,329 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"
16 min 0.2%	0 ms	3,144,254 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`
16 min 0.2%	99 ms	9,827 upadmin
SELECT "public"."connexx_shipment_item_descriptions"."id", "public"."connexx_shipment_item_descriptions"."sku", "public"."connexx_shipment_item_descriptions"."description", "public"."connexx_shipment_item_descriptions"."commodity_code", "public"."connexx_shipment_item_descriptions"."item_value", "public"."connexx_shipment_item_descriptions"."weight", "public"."connexx_shipment_item_descriptions"."country_of_origin", "public"."connexx_shipment_item_descriptions"."manufacturer_details", "public"."connexx_shipment_item_descriptions"."currency" FROM "public"."connexx_shipment_item_descriptions" WHERE ("public"."connexx_shipment_item_descriptions"."sales_account_id" = $1 AND "public"."connexx_shipment_item_descriptions"."sku" IS NOT NULL AND "public"."connexx_shipment_item_descriptions"."sku" ILIKE $2) ORDER BY "public"."connexx_shipment_item_descriptions"."created_date" DESC LIMIT $3 OFFSET $4 Details `CREATE INDEX CONCURRENTLY ON connexx_shipment_item_descriptions (sales_account_id)` Rows: 24877030 Row progression: 24877030, 46412, 38839 Row estimates - sales_account_id (=): 46412 - sku (~~*): 2081908 - sku (not_null): 20817928 - created_date (sort): 65 Existing indexes - id PRIMARY - lower((description)::text) - lower((sku)::text) - shipment_id - shipment_id, lower((sku)::text), lower((description)::text) WHERE shipment_id IS NOT NULL - shipment_id WHERE shipment_id IS NOT NULL - sku - sku gin_trgm_ops, description gin_trgm_ops GIN - sku gin_trgm_ops WHERE shipment_id IS NOT NULL GIN
16 min 0.2%	2 ms	615,460 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", "public"."connexx_shipments"."customer_order_source"
16 min 0.2%	0 ms	21,387,617 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.2%	138 ms	6,792 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
15 min 0.2%	1 ms	1,016,067 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: 34687828 Row progression: 34687828, 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`
15 min 0.2%	33,680 ms	26 postgresitd
WITH p_rows AS (SELECT p.id, p.d_scanned_by AS scanned_by, COALESCE(p.d_scan, $3) AS time_scanned, COALESCE(vr.depot, u.depot) AS depot, $4 AS source, u.user_type AS user_type FROM scanning_app.parcels p LEFT JOIN van_routes vr ON UPPER(vr.driver_name) = p.d_scanned_by LEFT JOIN scanning_app.users u ON u.username = p.d_scanned_by WHERE COALESCE(p.d_scan, $5) <> $6 UNION ALL SELECT p.id, p.w_scanned_by AS scanned_by, COALESCE(p.w_scan, $7) AS time_scanned, CASE WHEN COALESCE(u.sales_account_id, $8) <> $9 THEN c.name ELSE u.depot END AS depot, $10 AS source, u.user_type AS user_type FROM scanning_app.parcels p LEFT JOIN scanning_app.users u ON UPPER(u.username) = p.w_scanned_by LEFT JOIN sales_account sa ON sa.id = u.sales_account_id LEFT JOIN company c ON c.id = sa.company_id WHERE COALESCE(p.w_scan, $11) <> $12 union all select p.id, p.r_scanned_by AS scanned_by, COALESCE(p.r_scan_timestamp, $13) AS time_scanned, CASE WHEN COALESCE(u.sales_account_id, $14) <> $15 THEN c.name ELSE u.depot END AS depot, $16 AS source, $17 AS user_type from scanning_app.parcels p LEFT join scanning_app.users u ON UPPER(u.username) = p.r_scanned_by LEFT JOIN sales_account sa ON sa.id = u.sales_account_id LEFT JOIN company c ON c.id = sa.company_id), parcel AS (SELECT p.id, p.status, COALESCE(trailer_number, $18), p.barcode, CASE WHEN parcel_type = $19 THEN COALESCE(ukec.name, $20) ELSE COALESCE(ic.name, $21) END, COALESCE(container, $22), COALESCE(container_quantity, $23) FROM scanning_app.parcels p LEFT JOIN intl_carrier ic ON ic.id = p.carrier_id LEFT JOIN uk_ecommerce_carrier ukec ON ukec.id = p.carrier_id), customer AS (SELECT DISTINCT ON (j_rows.id) j_rows.id AS j_id, j_rows.name AS name FROM (SELECT p.id AS id, c.name AS name FROM scanning_app.parcels p LEFT JOIN scanning_app.users u ON u.username = p.created_by LEFT JOIN sales_account sa ON sa.id = u.sales_account_id LEFT JOIN company c ON c.id = sa.company_id WHERE COALESCE(u.sales_account_id, $24) <> $25 UNION ALL SELECT p.id, c.name AS name FROM scanning_app.parcels p LEFT JOIN uk_ecommerce_consignments ukec ON ukec.barcode = p.barcode LEFT JOIN sales_account sa on ukec.sales_account_id = sa.id LEFT JOIN company c ON sa.company_id = c.id UNION ALL SELECT p.id, c.name AS name FROM scanning_app.parcels p LEFT JOIN intl_consignments ic ON ic.barcode = p.barcode LEFT JOIN sales_account sa ON ic.sales_account_reference = sa.sales_account_reference LEFT JOIN company c ON sa.company_id = c.id UNION ALL SELECT p.id, c.name AS name FROM scanning_app.parcels p LEFT JOIN consignment_imports ci ON ci.barcode = p.barcode LEFT JOIN sales_account sa ON ci.sales_account_reference = sa.sales_account_reference LEFT JOIN company c ON sa.company_id = c.id LEFT JOIN scanning_app.users u ON u.username = p.created_by WHERE COALESCE(u.sales_account_id, $26) = $27) j_rows ORDER BY j_rows.id, j_rows.name) SELECT p.*, p_rows.scanned_by AS scanned_by, p_rows.time_scanned AS time_scanned, p_rows.source AS source, COALESCE(UPPER(p_rows.depot), $28) AS depot, COALESCE(c.name, $29) AS name, p_rows.user_type AS user_type FROM customer c LEFT JOIN parcel p ON c.j_id = p.id LEFT JOIN p_rows ON c.j_id = p_rows.id WHERE p_rows.time_scanned::date >= $1 AND p_rows.time_scanned::date <= $2 ORDER BY p_rows.time_scanned DESC
14 min 0.2%	63 ms	13,593 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
14 min 0.2%	2 ms	341,581 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", "public"."connexx_shipment_bulk_uploads"."csv_url"
13 min 0.2%	4 ms	186,833 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", "public"."connexx_shipments"."customer_order_source" FROM "public"."connexx_shipments" WHERE "public"."connexx_shipments"."id" IN ($1 /, ... /) OFFSET $2 Covered by index on (id) Rows: 19930812 Row progression: 19930812, 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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
13 min 0.2%	0 ms	21,387,616 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`
12 min 0.2%	4 ms	185,072 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", "public"."connexx_shipments"."customer_order_source" 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: 19930812 Row progression: 19930812, 34363, 3436 Row estimates - sales_account_id (=): 34363 - created_date (>=): 1993082 - created_date (<=): 1993082 - status (=): 3321802 - shipment_type (=): 9965406 - deleted_date (null): 18711711 - created_date (sort): 10 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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.2%	20 ms	34,235 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: 19930812 Row progression: 19930812, 7885, 14 Row estimates - integration_store_id (=): 7885 - sales_account_id (=): 34363 - created_date (<=): 1993082 - created_date (>=): 1993082 - shipment_type (=): 9965406 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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.1%	0 ms	21,387,615 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.1%	5 ms	111,400 upadmin
`UPDATE "public"."connexx_shipment_packages" SET "label_url" = $1, "tracking_code" = $2, "base64_pdf" = $3, "carrier_shipment_package_id" = $4, "label_created_date" = $5 WHERE ("public"."connexx_shipment_packages"."id" = $6 AND $7=$8) 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"`
9 min 0.1%	0 ms	21,387,615 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.1%	75 ms	6,792 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)`
8 min 0.1%	2 ms	326,549 upadmin
UPDATE "public"."connexx_shipment_packages" SET "label_url" = $1, "tracking_code" = $2, "base64_pdf" = $3, "base64_zpl" = $4, "label_created_date" = $5 WHERE ("public"."connexx_shipment_packages"."id" = $6 AND $7=$8) 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"
8 min 0.1%	2 ms	235,852 postgresitd
`UPDATE connexx_shipments SET carrier_api_request_json = $1 WHERE id = $2` Covered by index on (id) Rows: 19930812 Row progression: 19930812, 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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
7 min 0.1%	0 ms	1,603,676 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: 1121 Row progression: 1121, 3 Row estimates - sales_account_id (=): 3 - enabled (=): 561 - deleted_date (null): 877 - priority (sort): 19 Existing indexes - id PRIMARY - uuid UNIQUE`
7 min < 0.1%	0 ms	21,387,616 upadmin
`SELECT "public"."uk_ecommerce_supplier"."id", "public"."uk_ecommerce_supplier"."name" FROM "public"."uk_ecommerce_supplier" WHERE $2=$3 OFFSET $1`
7 min < 0.1%	6 ms	74,410 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)
7 min < 0.1%	637 ms	642 upadmin
SELECT * FROM ( SELECT DISTINCT ON (csp.tracking_code) csp.tracking_code, cs.id AS shipment_id, cs.created_date AS shipment_created_date, csp.randomized_reference, sasw.carrier_id, ct.id AS consignment_tracking_id, ct.created_date AS consignment_tracking_created_date, COALESCE(ct.tracking_information, $5::jsonb) AS existing_tracking_information FROM connexx_shipments cs JOIN connexx_shipment_packages csp ON csp.shipment_id = cs.id JOIN sales_account_shipping_whitelist sasw ON sasw.id = cs.shipping_whitelist_id LEFT JOIN consignment_tracking ct ON ct.barcode = csp.tracking_code WHERE sasw.supplier_id = $1 AND COALESCE(csp.tracking_code, $6) <> $7 AND COALESCE(csp.randomized_reference, $8) <> $9 AND cs.created_date >= NOW() - $2::interval ORDER BY csp.tracking_code, cs.created_date DESC ) candidates ORDER BY shipment_created_date ASC, tracking_code ASC OFFSET $3 LIMIT $4
7 min < 0.1%	0 ms	21,387,619 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%	1 ms	293,957 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", "public"."connexx_shipment_packages"."randomized_reference" 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
6 min < 0.1%	27 ms	13,144 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", "public"."connexx_shipment_packages"."randomized_reference" 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
6 min < 0.1%	1 ms	284,522 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`
6 min < 0.1%	3,068 ms	110 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, $50) AS purchase_transaction_id, COALESCE(ukes.purchase_account_id, $51) AS purchase_account_id, COALESCE(CONCAT(pa.purchase_account_reference, $52, RTRIM(company.name)), $53) AS purchase_account_name, COALESCE(confirmed_for_invoicing, $54) 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 <> $55 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
6 min < 0.1%	0 ms	6,598,153 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: 19930812 Row progression: 19930812, 5 Row estimates - order_number (=): 5 - sales_account_id (=): 34363 - shipment_source_name (=): 1075267 - status (<>): 16609010 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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
5 min < 0.1%	326,703 ms	1 upadmin
`UPDATE consignment_imports SET year = EXTRACT(YEAR FROM created_date), month = EXTRACT(MONTH FROM created_date) WHERE year is null and source = 'scurri' and id > 120658891` Details `CREATE INDEX CONCURRENTLY ON consignment_imports (source, id)` Rows: 80512064 Row progression: 80512064, 5030494, 503049 Row estimates - source (=): 5030494 - id (>): 8051207 - year (null): 55609683 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
5 min < 0.1%	2 ms	154,984 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", "public"."connexx_shipments"."customer_order_source"
5 min < 0.1%	1 ms	298,068 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%	1 ms	212,058 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", "public"."connexx_shipments"."customer_order_source"
4 min < 0.1%	3 ms	78,674 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", "public"."connexx_shipments"."customer_order_source"
4 min < 0.1%	0 ms	643,161 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
4 min < 0.1%	1 ms	259,743 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: 15442166 Row progression: 15442166, 28282, 21212 Row estimates - sales_account_id (=): 28282 - status (<>): 11581625 - created_date (sort): 1 Existing indexes - id PRIMARY - deprecated_shipment_ids - sales_account_id, created_date - uuid UNIQUE`
4 min < 0.1%	1 ms	418,645 postgresitd
`UPDATE connexx_shipments SET carrier_api_request = $1 WHERE id = $2` Covered by index on (id) Rows: 19930812 Row progression: 19930812, 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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%	0 ms	634,417 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: 20251836 Row progression: 20251836, 3 Row estimates - shipment_id (=): 3 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 WHERE (tracking_code IS NOT NULL) AND ((tracking_code)::text <> ''::text) - tracking_code gin_trgm_ops GIN - tracking_code gin_trgm_ops GIN
4 min < 0.1%	2 ms	108,797 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", "public"."connexx_shipments"."customer_order_source"
4 min < 0.1%	1 ms	225,511 upadmin
`select b.oid, b.typarray from pg_catalog.pg_type a left join pg_catalog.pg_type b on b.oid = a.typelem where a.typcategory = $1 group by b.oid, b.typarray order by b.oid`
4 min < 0.1%	0 ms	1,603,676 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`
4 min < 0.1%	7 ms	31,893 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: 19930812 Row progression: 19930812, 7885, 14 Row estimates - integration_store_id (=): 7885 - sales_account_id (=): 34363 - created_date (<=): 1993082 - created_date (>=): 1993082 - status (=): 3321802 - shipment_type (=): 9965406 - deleted_date (null): 18711711 - created_date (sort): 10 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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%	2,195 ms	108 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", "public"."connexx_shipments"."customer_order_source" 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"."estimated_delivery_date" ASC LIMIT $27 OFFSET $28
3 min < 0.1%	0 ms	557,811 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`
3 min < 0.1%	0 ms	2,776,045 upadmin
SELECT "public"."sales_account"."id", "public"."sales_account"."status", "public"."sales_account"."created_date", "public"."sales_account"."created_by", "public"."sales_account"."financial_company", "public"."sales_account"."status_plus", "public"."sales_account"."company_id", "public"."sales_account"."sales_account_reference", "public"."sales_account"."trade_name", "public"."sales_account"."company_number", "public"."sales_account"."nature_of_business", "public"."sales_account"."base_currency", "public"."sales_account"."standard_price_level", "public"."sales_account"."standard_tax_code", "public"."sales_account"."ec_customer", "public"."sales_account"."ec_country", "public"."sales_account"."vat_reg_no", "public"."sales_account"."pdf_invoice", "public"."sales_account"."email_reports", "public"."sales_account"."excel_invoice", "public"."sales_account"."invoice_address_different", "public"."sales_account"."invoice_address", "public"."sales_account"."invoice_postcode", "public"."sales_account"."address_inc_postcode", "public"."sales_account"."invoice_email_address", "public"."sales_account"."invoice_layout", "public"."sales_account"."invoice_method", "public"."sales_account"."last_statement_date", "public"."sales_account"."no_vat", "public"."sales_account"."payment_type", "public"."sales_account"."settlement_days", "public"."sales_account"."statement_email_address", "public"."sales_account"."bank_account_number", "public"."sales_account"."bank_account_name", "public"."sales_account"."bank_sort_code", "public"."sales_account"."credit_terms_period", "public"."sales_account"."at_risk", "public"."sales_account"."bad_debt", "public"."sales_account"."bad_debt_reason", "public"."sales_account"."on_stop", "public"."sales_account"."on_stop_date", "public"."sales_account"."on_stop_reason", "public"."sales_account"."on_stop_user_id", "public"."sales_account"."no_credit_limit", "public"."sales_account"."pre_payment", "public"."sales_account"."priority_risk", "public"."sales_account"."dd_email", "public"."sales_account"."dd_reference", "public"."sales_account"."dd_transaction_type", "public"."sales_account"."dd_cancel", "public"."sales_account"."old_id", "public"."sales_account"."old_company_id", "public"."sales_account"."authorised_by", "public"."sales_account"."authorised_date", "public"."sales_account"."single_shipment_invoices", "public"."sales_account"."internal_credit_limit", "public"."sales_account"."line_discount_amount", "public"."sales_account"."settlement_discount_amount", "public"."sales_account"."credit_terms", "public"."sales_account"."bond", "public"."sales_account"."salesperson", "public"."sales_account"."old_internal_id", "public"."sales_account"."accounts_contact", "public"."sales_account"."accounts_phone", "public"."sales_account"."on_stop_reason_id", "public"."sales_account"."important_reminder", "public"."sales_account"."bad_debt_reason_id", "public"."sales_account"."amber_alert", "public"."sales_account"."amber_alert_amount", "public"."sales_account"."bad_debt_date", "public"."sales_account"."bad_debt_user_id", "public"."sales_account"."amber_alert_date", "public"."sales_account"."amber_alert_user_id", "public"."sales_account"."expected_monthly_sales", "public"."sales_account"."deferment_number", "public"."sales_account"."key_account", "public"."sales_account"."shipment_notification", "public"."sales_account"."shipment_authorisation", "public"."sales_account"."cost_centre", "public"."sales_account"."standard_margin", "public"."sales_account"."depot", "public"."sales_account"."last_modified_by", "public"."sales_account"."old_salesperson", "public"."sales_account"."account_ids", "public"."sales_account"."made_live_date", "public"."sales_account"."made_live_by", "public"."sales_account"."agent_limit", "public"."sales_account"."monthly_or_invoice_date", "public"."sales_account"."month_after", "public"."sales_account"."days", "public"."sales_account"."important_note", "public"."sales_account"."bank_account_sort_code", "public"."sales_account"."bond_amount", "public"."sales_account"."alert_type", "public"."sales_account"."alert_reason_id", "public"."sales_account"."alert_user_id", "public"."sales_account"."alert_date", "public"."sales_account"."alert_amount", "public"."sales_account"."credit_safe_id", "public"."sales_account"."credit_terms_json", "public"."sales_account"."duty_vat_bond_amount", "public"."sales_account"."activation_stage", "public"."sales_account"."account_manager_id", "public"."sales_account"."account_type", "public"."sales_account"."duty_vat_agreement", "public"."sales_account"."cc_email", "public"."sales_account"."sales_person_structure_id", "public"."sales_account"."account_manager_structure_id", "public"."sales_account"."logins", "public"."sales_account"."csv_invoice", "public"."sales_account"."old_sales_account_reference", "public"."sales_account"."iso_country", "public"."sales_account"."account_activation_date", "public"."sales_account"."industry_sector", "public"."sales_account"."default_settings", "public"."sales_account"."eori_number", "public"."sales_account"."uuid", "public"."sales_account"."return_method", "public"."sales_account"."evri_premium", "public"."sales_account"."collection_method", "public"."sales_account"."rejected_date", "public"."sales_account"."rejected_by", "public"."sales_account"."depot_v2", "public"."sales_account"."account_activation_by", "public"."sales_account"."zoho_id", "public"."sales_account"."credit_controller_id", "public"."sales_account"."margin_improvement_type", "public"."sales_account"."parent_id", "public"."sales_account"."first_transaction_date", "public"."sales_account"."last_transaction_date", "public"."sales_account"."use_parent_rates", "public"."sales_account"."dom_intl_posting_group", "public"."sales_account"."is_bc_ready", "public"."sales_account"."is_auditel_referral", "public"."sales_account"."july_gri", "public"."sales_account"."terms_are_bc_ready", "public"."sales_account"."bill_child_accounts_separately", "public"."sales_account"."zoho_crm_account_id", "public"."sales_account"."zoho_crm_account_id_updated_at" FROM "public"."sales_account" WHERE "public"."sales_account"."uuid" = $1 LIMIT $2 OFFSET $3 Covered by index on (uuid) Rows: 6084 Row progression: 6084, 1 Row estimates - uuid (=): 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
3 min < 0.1%	3 ms	68,460 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", "public"."connexx_shipments"."customer_order_source"
3 min < 0.1%	2 ms	102,193 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", "public"."connexx_shipments"."customer_order_source" FROM "public"."connexx_shipments" WHERE "public"."connexx_shipments"."job_number" = $1 LIMIT $2 OFFSET $3 Covered by index on (job_number) Rows: 19930812 Row progression: 19930812, 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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%	1 ms	208,606 upadmin
`UPDATE consignment_tracking SET tracking_information = $1, type = $3, status = $4 WHERE id = $2` `Covered by index on (id) Rows: 34687828 Row progression: 34687828, 1 Row estimates - id (=): 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`
3 min < 0.1%	1 ms	204,059 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", "public"."connexx_shipments"."customer_order_source" FROM "public"."connexx_shipments" WHERE ("public"."connexx_shipments"."uuid" = $1 AND $4=$5) LIMIT $2 OFFSET $3
3 min < 0.1%	0 ms	1,620,559 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: 1029 Row progression: 1029, 1 Row estimates - sales_account_id (=): 1 - deleted_date (null): 1008 Existing indexes - id PRIMARY - name, sales_account_id UNIQUE`
3 min < 0.1%	0 ms	442,517 upadmin
`UPDATE "public"."connexx_shipments" SET "status" = $1 WHERE "public"."connexx_shipments"."id" IN ($2)` Covered by index on (id) Rows: 19930812 Row progression: 19930812, 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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%	9 ms	16,745 upadmin
UPDATE "public"."connexx_shipments" SET "status" = $1, "carrier_label_errors" = $2, "carrier_shipment_id" = $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", "public"."connexx_shipments"."customer_order_source"
2 min < 0.1%	0 ms	1,409,091 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", "public"."connexx_shipments"."customer_order_source" 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,790,251 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%	878 ms	154 upadmin
`SELECT MAX("effective_date") FROM (SELECT "public"."exchange_rates"."effective_date" FROM "public"."exchange_rates" WHERE $2=$3 OFFSET $1) AS "sub"`
2 min < 0.1%	0 ms	3,512,253 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: 6084 Row progression: 6084, 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
2 min < 0.1%	1,259 ms	100 postgresitd
WITH returned_to_itd AS (SELECT COALESCE((SELECT created_date FROM returns_consignment WHERE awb = $1), $2) AS date) SELECT ic.id, $3 as shipment_type, CASE WHEN i_carrier.eu = $4 THEN $5 ELSE $6 END AS transaction_type, CASE WHEN icst.sales_nominal_transaction_id > $7 THEN $8 WHEN icst.supplier_nominal_transaction_id <> $9 THEN $10 ELSE $11 END AS status, ic.consignment_number, COALESCE(ic.shipped_date, ic.invoice_date) AS transaction_date, COALESCE(CONCAT(RTRIM(company.name), $12, sa.sales_account_reference), $13) AS customer_name, i_carrier.name AS carrier_name, i_supplier.name AS supplier_name, i_service.name AS service_name, isi.supplier_invoice_number as supplier_invoice_number, CASE WHEN ic.tracking_postcode_financial_company ~* $14 THEN CONCAT($15, $16, icst.sales_exception_code) ELSE icst.sales_exception_code END as exception_code, ic.zone_name, ic.charged_weight, icst.sales_freight_amount, COALESCE((SELECT SUM(icst_s.sales_freight_amount) FROM intl_consignments_surcharges_transactions icst_s WHERE icst_s.consignment_id = icst.consignment_id AND icst_s.consignment_surcharge_id <> $17), $18) AS sales_surcharges, icst.sales_fuel_surcharge_amount, icst.sales_freight_amount + COALESCE((SELECT SUM(icst_s.sales_freight_amount) FROM intl_consignments_surcharges_transactions icst_s WHERE icst_s.consignment_id = icst.consignment_id AND icst_s.consignment_surcharge_id <> $19), $20) + icst.sales_fuel_surcharge_amount AS sales_total, icst.supplier_freight_amount, COALESCE((SELECT SUM(icst_s.supplier_freight_amount) FROM intl_consignments_surcharges_transactions icst_s WHERE icst_s.consignment_id = icst.consignment_id AND icst_s.consignment_surcharge_id <> $21), $22) AS supplier_surcharges, icst.supplier_fuel_surcharge_amount, icst.supplier_freight_amount + COALESCE((SELECT SUM(icst_s.supplier_freight_amount) FROM intl_consignments_surcharges_transactions icst_s WHERE icst_s.consignment_id = icst.consignment_id AND icst_s.consignment_surcharge_id <> $23), $24) + icst.supplier_fuel_surcharge_amount AS supplier_total, icst.sales_freight_amount + COALESCE((SELECT SUM(icst_s.sales_freight_amount) FROM intl_consignments_surcharges_transactions icst_s WHERE icst_s.consignment_id = icst.consignment_id AND icst_s.consignment_surcharge_id <> $25), $26) + icst.sales_fuel_surcharge_amount - icst.supplier_freight_amount - COALESCE((SELECT SUM(icst_s.supplier_freight_amount) FROM intl_consignments_surcharges_transactions icst_s WHERE icst_s.consignment_id = icst.consignment_id AND icst_s.consignment_surcharge_id <> $27), $28) - icst.supplier_fuel_surcharge_amount AS profit, COALESCE(ntl_i_supplier.purchase_transaction_id, $29) AS pat_id, COALESCE(ntl_i_supplier.reference, $30) AS pa_transaction_reference, COALESCE(ntl_sa.sales_transaction_id, $31) AS sat_id, COALESCE(ntl_sa.reference, $32) AS sa_transaction_reference, $33 AS consignment_vat_duty_id, returned_to_itd.date AS returned_to_itd_date FROM intl_consignments_surcharges_transactions icst LEFT JOIN intl_consignments ic ON ic.id = icst.consignment_id LEFT JOIN intl_service i_service ON i_service.id = ic.service_id LEFT JOIN intl_supplier i_supplier ON i_supplier.id = icst.supplier_account_id LEFT JOIN intl_carrier i_carrier ON i_carrier.id = i_service.carrier_id LEFT JOIN sales_account sa ON sa.id = icst.sales_account_id LEFT JOIN company ON company.id = sa.company_id LEFT JOIN nominal_transaction_lines ntl_i_supplier ON ntl_i_supplier.id = icst.supplier_nominal_transaction_id LEFT JOIN nominal_transaction_lines ntl_sa ON ntl_sa.id = icst.sales_nominal_transaction_id LEFT JOIN intl_supplier_invoice isi ON isi.id = icst.supplier_linked_invoice_id LEFT JOIN returned_to_itd ON $34 WHERE /ic.ts_text_search @@ to_tsquery(UPPER($1))/ (ic.barcode = $1 OR ic.consignment_number = $1 OR ic.order_number = $1 OR ic.shipper_reference_1 = $1 OR ic.shipper_reference_2 = $1) AND icst.consignment_surcharge_id = $35 AND ic.status = $36 AND icst.status = $37 UNION ALL SELECT ukec.id, $38 as shipment_type, $39 AS transaction_type, CASE WHEN ukec.sales_nominal_transaction_id > $40 THEN $41 WHEN ukec.supplier_nominal_transaction_id <> $42 THEN $43 ELSE $44 END AS status, ukec.barcode, COALESCE(ukec.print_date, ukec.invoice_date) AS transaction_date, COALESCE(CONCAT(RTRIM(company.name), $45, sa.sales_account_reference), $46) AS customer_name, ukec_carrier.name AS carrier_name, ukec_supplier.name AS supplier_name, ukec_service.name AS service_name, ukec.supplier_invoice_number as supplier_invoice_number, ukec.exception_code as exception_code, $47 as zone_name, ukec.package_weight, ukec.sales_price, ukec.surcharge_sales_price AS sales_surcharges, COALESCE(ukec.sales_fuel_surcharge_amount, $48), ukec.sales_price + ukec.surcharge_sales_price + COALESCE(ukec.sales_fuel_surcharge_amount, $49) AS sales_total, ukec.supplier_cost_price, ukec.surcharge_cost_price AS supplier_surcharges, $50, ukec.supplier_cost_price + ukec.surcharge_cost_price AS supplier_total, (ukec.sales_price + COALESCE(ukec.sales_fuel_surcharge_amount, $51)) - (ukec.supplier_cost_price + ukec.surcharge_cost_price) AS profit, COALESCE(ntl_i_supplier.purchase_transaction_id, $52) AS pat_id, COALESCE(ntl_i_supplier.reference, $53) AS pa_transaction_reference, COALESCE(ntl_sa.sales_transaction_id, $54) AS sat_id, COALESCE(ntl_sa.reference, $55) AS sa_transaction_reference, $56 AS consignment_vat_duty_id, returned_to_itd.date AS returned_to_itd_date FROM uk_ecommerce_consignments ukec LEFT JOIN uk_ecommerce_supplier ukec_supplier ON ukec_supplier.id = ukec.supplier_account_id LEFT JOIN uk_ecommerce_carrier ukec_carrier ON ukec_carrier.id = ukec_supplier.carrier_id LEFT JOIN uk_ecommerce_service ukec_service ON ukec_service.id = ukec.service_id LEFT JOIN sales_account sa ON sa.id = ukec.sales_account_id LEFT JOIN company ON company.id = sa.company_id LEFT JOIN nominal_transaction_lines ntl_i_supplier ON ntl_i_supplier.id = ukec.supplier_nominal_transaction_id LEFT JOIN nominal_transaction_lines ntl_sa ON ntl_sa.id = ukec.sales_nominal_transaction_id LEFT JOIN returned_to_itd ON $57 WHERE /ukec.ts_text_search @@ to_tsquery(UPPER($1))/ (ukec.barcode = $1 OR ukec.consignment_number = $1 OR ukec.order_number = $1 OR ukec.shipper_reference_1 = $1 OR ukec.shipper_reference_2 = $1) AND ukec.status = $58 UNION ALL SELECT ukecs.id, $59 as shipment_type, $60 AS transaction_type, CASE WHEN ukecs.sales_nominal_transaction_id > $61 THEN $62 WHEN ukecs.supplier_nominal_transaction_id <> $63 THEN $64 ELSE $65 END AS status, ukecs.barcode, ukecs.invoice_date AS transaction_date, COALESCE(CONCAT(RTRIM(company.name), $66, sa.sales_account_reference), $67) AS customer_name, ukec_carrier.name AS carrier_name, ukec_supplier.name AS supplier_name, COALESCE(ukec_service.name, $68) AS service_name, ukecs.supplier_invoice_number as supplier_invoice_number, ukecs.exception_code as exception_code, $69 as zone_name, $70, ukecs.sales_price, $71 AS sales_surcharges, $72, ukecs.sales_price AS sales_total, ukecs.supplier_cost_price, $73 AS supplier_surcharges, $74, ukecs.supplier_cost_price AS supplier_total, ukecs.sales_price - ukecs.supplier_cost_price AS profit, COALESCE(ntl_i_supplier.purchase_transaction_id, $75) AS pat_id, COALESCE(ntl_i_supplier.reference, $76) AS pa_transaction_reference, COALESCE(ntl_sa.sales_transaction_id, $77) AS sat_id, COALESCE(ntl_sa.reference, $78) AS sa_transaction_reference, $79 AS consignment_vat_duty_id, $80 AS returned_to_itd_date FROM uk_ecommerce_consignment_surcharges ukecs LEFT JOIN uk_ecommerce_supplier ukec_supplier ON ukec_supplier.id = ukecs.supplier_account_id LEFT JOIN uk_ecommerce_carrier ukec_carrier ON ukec_carrier.id = ukec_supplier.carrier_id LEFT JOIN uk_ecommerce_service ukec_service ON ukec_service.id = ukecs.surcharge_id LEFT JOIN sales_account sa ON sa.id = ukecs.sales_account_id LEFT JOIN company ON company.id = sa.company_id LEFT JOIN nominal_transaction_lines ntl_i_supplier ON ntl_i_supplier.id = ukecs.supplier_nominal_transaction_id LEFT JOIN nominal_transaction_lines ntl_sa ON ntl_sa.id = ukecs.sales_nominal_transaction_id WHERE /*ukecs.ts_text_search @@ to_tsquery(UP
2 min < 0.1%	4 ms	31,893 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", "public"."connexx_shipments"."customer_order_source" 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: 19930812 Row progression: 19930812, 7885, 14 Row estimates - integration_store_id (=): 7885 - sales_account_id (=): 34363 - created_date (<=): 1993082 - created_date (>=): 1993082 - status (=): 3321802 - shipment_type (=): 9965406 - deleted_date (null): 18711711 - created_date (sort): 10 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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%	118,978 ms	1 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, package_length, package_width, package_height, consignment_number_postcode_key, carrier_id, service_id, tariff_id) (SELECT DISTINCT ON(csp.tracking_code) $1, $2, $3, now(), COALESCE(customer_reference, $4), $5, COALESCE(csid.item_value, $6), csp.tracking_code, cs.id, UPPER(concat(csp.tracking_code, $7, replace(cs.to_address_zip, $8, $9))), UPPER(COALESCE(csp.tracking_code, $10)), csp.weight, COALESCE(csid.currency, $11), $12, COALESCE(concat(from_address_company,$13, from_address_street_1, $14, from_address_zip), $15), COALESCE(to_address_first_name, $16), COALESCE(to_address_last_name, $17), COALESCE(to_address_phone, $18), COALESCE(to_address_company, $19), COALESCE(to_address_street_1, $20), COALESCE(to_address_street_2, $21), COALESCE(to_address_street_3, $22), COALESCE(to_address_city, $23), COALESCE(to_address_county_state, $24), UPPER(COALESCE(to_address_zip, $25)), COALESCE(to_address_country_iso, $26), COALESCE(to_address_email, $27), COALESCE(uec.name, $28), COALESCE(ues.name, $29), $30, $31, $32, $33, COALESCE(cs.date_converted_to_shipment, $34), COALESCE(cs.date_converted_to_shipment, $35), COALESCE(company.name, $36), COALESCE(cs.sales_account_id, $37), COALESCE(customer_reference, $38), $39, $40, $41, $42, $43, $44, $45, $46, COALESCE(sa.sales_account_reference, $47), $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, csp.length, csp.width, csp.height, UPPER(concat(csp.tracking_code, $63, replace(cs.to_address_zip, $64, $65))), uec.id, ues.id, sasw.tariff_id FROM connexx_shipment_packages csp LEFT JOIN connexx_shipments cs ON cs.id = csp.shipment_id LEFT JOIN connexx_quoted_rates cqr ON cqr.shipment_id = cs.id LEFT JOIN sales_account_shipping_whitelist sasw ON sasw.id = cqr.shipping_whitelist_id LEFT JOIN uk_ecommerce_carrier uec ON uec.id = sasw.carrier_id LEFT JOIN uk_ecommerce_service ues ON ues.id = sasw.service_id LEFT JOIN sales_account sa ON sa.id = cs.sales_account_id LEFT JOIN company ON company.id = sa.company_id LEFT JOIN connexx_shipment_item_descriptions csid ON csid.shipment_id = cs.id WHERE cs.shipment_type = $66 AND sasw.domestic_international = $67 AND cqr.is_selected = $68 AND csp.tracking_code != $69 AND cs.date_converted_to_shipment::date BETWEEN now() - INTERVAL $70 AND now()) 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, package_length = EXCLUDED.package_length, package_width = EXCLUDED.package_width, package_height = EXCLUDED.package_height, consignment_number_postcode_key = EXCLUDED.consignment_number_postcode_key, carrier_id = EXCLUDED.carrier_id, service_id = EXCLUDED.service_id, tariff_id = EXCLUDED.tariff_id
2 min < 0.1%	0 ms	2,384,105 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", "public"."connexx_shipments"."customer_order_source" FROM "public"."connexx_shipments" WHERE "public"."connexx_shipments"."shipment_bulk_upload_id" = $1 OFFSET $2 Covered by index on (shipment_bulk_upload_id) Rows: 19930812 Row progression: 19930812, 30 Row estimates - shipment_bulk_upload_id (=): 30 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 WHERE (customer_reference_2 IS NOT NULL) AND ((customer_reference_2)::text <> ''::text) - 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 - invoice_number WHERE (invoice_number IS NOT NULL) AND ((invoice_number)::text <> ''::text) - 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 WHERE (order_number IS NOT NULL) AND ((order_number)::text <> ''::text) - 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,109 ms	104 postgresitd
SELECT DISTINCT ON (CONCAT_ws('-', uketscl.package_type_id, uket.name, uketscl.service_id)) uketscl.id, uketscl.status, COALESCE(uketscl.created_by, $2), COALESCE(uketscl.created_date, $3), uketscl.tariff_id, uketscl.service_id, uketscl.package_type_id, uketscl.effective_start_date::date, CONCAT( uketscl.package_type_id, $4, uket.name, $5, uketscl.service_id) AS key_code, uket.name, ukept.weight_hi, uketscl.cost_price, COALESCE(ukcsl.standard_sales_price, $6), COALESCE(second_box_cost_price, $7) FROM uk_ecommerce_tariff_service_cost_link uketscl LEFT JOIN uk_ecommerce_tariff uket ON uket.id = uketscl.tariff_id LEFT JOIN uk_ecommerce_carrier uk_carrier ON uk_carrier.id = uket.carrier_id LEFT JOIN uk_ecommerce_package_type ukept ON ukept.id = uketscl.package_type_id LEFT JOIN LATERAL (SELECT id, standard_sales_price, effective_start_date FROM uk_ecommerce_carrier_service_link ukcsl WHERE ukcsl.package_type = uketscl.package_type_id AND ukcsl.service_id = uketscl.service_id AND ukcsl.carrier_id = uketscl.carrier_id AND ukcsl.effective_start_date::date <= current_date ORDER BY effective_start_date desc LIMIT $8) ukcsl ON $9 WHERE uket.supplier_account_id = $1 AND uketscl.status = $10 AND uket.status = $11 AND uketscl.effective_start_date::date <= current_date ORDER BY CONCAT_ws($12, uketscl.package_type_id, uket.name, uketscl.service_id), uketscl.effective_start_date DESC, key_code
2 min < 0.1%	0 ms	1,877,722 upadmin
SELECT "public"."sales_account"."id", "public"."sales_account"."status", "public"."sales_account"."created_date", "public"."sales_account"."created_by", "public"."sales_account"."financial_company", "public"."sales_account"."status_plus", "public"."sales_account"."company_id", "public"."sales_account"."sales_account_reference", "public"."sales_account"."trade_name", "public"."sales_account"."company_number", "public"."sales_account"."nature_of_business", "public"."sales_account"."base_currency", "public"."sales_account"."standard_price_level", "public"."sales_account"."standard_tax_code", "public"."sales_account"."ec_customer", "public"."sales_account"."ec_country", "public"."sales_account"."vat_reg_no", "public"."sales_account"."pdf_invoice", "public"."sales_account"."email_reports", "public"."sales_account"."excel_invoice", "public"."sales_account"."invoice_address_different", "public"."sales_account"."invoice_address", "public"."sales_account"."invoice_postcode", "public"."sales_account"."address_inc_postcode", "public"."sales_account"."invoice_email_address", "public"."sales_account"."invoice_layout", "public"."sales_account"."invoice_method", "public"."sales_account"."last_statement_date", "public"."sales_account"."no_vat", "public"."sales_account"."payment_type", "public"."sales_account"."settlement_days", "public"."sales_account"."statement_email_address", "public"."sales_account"."bank_account_number", "public"."sales_account"."bank_account_name", "public"."sales_account"."bank_sort_code", "public"."sales_account"."credit_terms_period", "public"."sales_account"."at_risk", "public"."sales_account"."bad_debt", "public"."sales_account"."bad_debt_reason", "public"."sales_account"."on_stop", "public"."sales_account"."on_stop_date", "public"."sales_account"."on_stop_reason", "public"."sales_account"."on_stop_user_id", "public"."sales_account"."no_credit_limit", "public"."sales_account"."pre_payment", "public"."sales_account"."priority_risk", "public"."sales_account"."dd_email", "public"."sales_account"."dd_reference", "public"."sales_account"."dd_transaction_type", "public"."sales_account"."dd_cancel", "public"."sales_account"."old_id", "public"."sales_account"."old_company_id", "public"."sales_account"."authorised_by", "public"."sales_account"."authorised_date", "public"."sales_account"."single_shipment_invoices", "public"."sales_account"."internal_credit_limit", "public"."sales_account"."line_discount_amount", "public"."sales_account"."settlement_discount_amount", "public"."sales_account"."credit_terms", "public"."sales_account"."bond", "public"."sales_account"."salesperson", "public"."sales_account"."old_internal_id", "public"."sales_account"."accounts_contact", "public"."sales_account"."accounts_phone", "public"."sales_account"."on_stop_reason_id", "public"."sales_account"."important_reminder", "public"."sales_account"."bad_debt_reason_id", "public"."sales_account"."amber_alert", "public"."sales_account"."amber_alert_amount", "public"."sales_account"."bad_debt_date", "public"."sales_account"."bad_debt_user_id", "public"."sales_account"."amber_alert_date", "public"."sales_account"."amber_alert_user_id", "public"."sales_account"."expected_monthly_sales", "public"."sales_account"."deferment_number", "public"."sales_account"."key_account", "public"."sales_account"."shipment_notification", "public"."sales_account"."shipment_authorisation", "public"."sales_account"."cost_centre", "public"."sales_account"."standard_margin", "public"."sales_account"."depot", "public"."sales_account"."last_modified_by", "public"."sales_account"."old_salesperson", "public"."sales_account"."account_ids", "public"."sales_account"."made_live_date", "public"."sales_account"."made_live_by", "public"."sales_account"."agent_limit", "public"."sales_account"."monthly_or_invoice_date", "public"."sales_account"."month_after", "public"."sales_account"."days", "public"."sales_account"."important_note", "public"."sales_account"."bank_account_sort_code", "public"."sales_account"."bond_amount", "public"."sales_account"."alert_type", "public"."sales_account"."alert_reason_id", "public"."sales_account"."alert_user_id", "public"."sales_account"."alert_date", "public"."sales_account"."alert_amount", "public"."sales_account"."credit_safe_id", "public"."sales_account"."credit_terms_json", "public"."sales_account"."duty_vat_bond_amount", "public"."sales_account"."activation_stage", "public"."sales_account"."account_manager_id", "public"."sales_account"."account_type", "public"."sales_account"."duty_vat_agreement", "public"."sales_account"."cc_email", "public"."sales_account"."sales_person_structure_id", "public"."sales_account"."account_manager_structure_id", "public"."sales_account"."logins", "public"."sales_account"."csv_invoice", "public"."sales_account"."old_sales_account_reference", "public"."sales_account"."iso_country", "public"."sales_account"."account_activation_date", "public"."sales_account"."industry_sector", "public"."sales_account"."default_settings", "public"."sales_account"."eori_number", "public"."sales_account"."uuid", "public"."sales_account"."return_method", "public"."sales_account"."evri_premium", "public"."sales_account"."collection_method", "public"."sales_account"."rejected_date", "public"."sales_account"."rejected_by", "public"."sales_account"."depot_v2", "public"."sales_account"."account_activation_by", "public"."sales_account"."zoho_id", "public"."sales_account"."credit_controller_id", "public"."sales_account"."margin_improvement_type", "public"."sales_account"."parent_id", "public"."sales_account"."first_transaction_date", "public"."sales_account"."last_transaction_date", "public"."sales_account"."use_parent_rates", "public"."sales_account"."dom_intl_posting_group", "public"."sales_account"."is_bc_ready", "public"."sales_account"."is_auditel_referral", "public"."sales_account"."july_gri", "public"."sales_account"."terms_are_bc_ready", "public"."sales_account"."bill_child_accounts_separately", "public"."sales_account"."zoho_crm_account_id", "public"."sales_account"."zoho_crm_account_id_updated_at" FROM "public"."sales_account" WHERE "public"."sales_account"."id" IN ($1) OFFSET $2 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: 6084 Row progression: 6084, 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
2 min < 0.1%	0 ms	236,027 upadmin
`INSERT INTO "public"."temp_connexx_marketplace_tracking_callbacks" ("created_at","payload_json") VALUES ($1,$2) RETURNING "public"."temp_connexx_marketplace_tracking_callbacks"."id", "public"."temp_connexx_marketplace_tracking_callbacks"."created_at", "public"."temp_connexx_marketplace_tracking_callbacks"."payload_json"`
2 min < 0.1%	1 ms	113,099 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
2 min < 0.1%	24 ms	4,077 postgresitd
`SELECT csaic.id, csaic.sales_account_id, identifier, csaic.token, cak.token, default_settings FROM connexx_sales_account_integration_credentials csaic JOIN sales_account sa ON sa.id = csaic.sales_account_id JOIN connexx_api_keys cak ON cak.sales_account_id = sa.id WHERE integration_type = $1 AND csaic.status = $2 AND ecartapi = $3`
2 min < 0.1%	1 ms	67,932 _avnadmin_monitor
`SELECT COUNT(oid) FROM ( SELECT oid FROM pg_catalog.pg_class WHERE relkind IN ($1 /, ... /) LIMIT $2 ) AS number_of_tables`