| 1757900 |
11:10:17
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1780708 |
09:55:52
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1780294 |
09:54:31
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1802588 |
09:00:23
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1802587 |
08:59:19
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1822195 |
08:09:17
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1824802 |
08:07:44
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1846964 |
06:23:56
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1846974 |
06:23:04
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1868906 |
06:07:58
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1868916 |
06:07:23
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1890773 |
05:08:42
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1890772 |
05:07:58
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1913748 |
04:09:55
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1912689 |
04:09:07
|
active
|
|
postgresitd
WITH ci_imports AS (SELECT sales_account_id, service, manifest_date::date, to_char(sales_account_id, 'fm00000000') || '-' || carrier || '-' || service || '-' || to_char(manifest_date::date, 'YYYYMMDD') AS cis_key, count(*) AS consignment_count FROM consignment_imports WHERE source = 'connexx' group by 1, 2, carrier, 3) UPDATE consignment_imports_summary cis SET number_of_consignments = ci_imports.consignment_count FROM ci_imports WHERE ci_imports.cis_key = cis.cis_key;
|
| 1924125 |
03:13:28
|
active
|
|
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, p
|
| 1956718 |
02:20:27
|
active
|
|
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, p
|
| 1956719 |
02:20:27
|
active
|
|
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, p
|
| 1956965 |
01:20:27
|
active
|
|
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, p
|
| 1970791 |
01:20:27
|
active
|
|
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, p
|
| 1981408 |
00:20:27
|
active
|
|
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, p
|
| 1981409 |
00:20:27
|
active
|
|
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, p
|
| 2013451 |
3.5 s
|
active
scanning heap
|
|
autovacuum: VACUUM public.consignment_imports_summary
|
| 2013479 |
0.1 s
|
active
|
|
pg_cron upadmin
REFRESH MATERIALIZED VIEW CONCURRENTLY shipment_data.mv_labels_monthly_actual
|
| 2013478 |
0.1 s
|
active
|
|
pg_cron upadmin
REFRESH MATERIALIZED VIEW CONCURRENTLY shipment_data.mv_labels_monthly_actual
|
| 2013476 |
0.1 s
|
active
|
|
pg_cron upadmin
REFRESH MATERIALIZED VIEW CONCURRENTLY shipment_data.mv_labels_monthly_actual
|
| 2013480 |
0.1 s
|
active
|
|
pg_cron upadmin
REFRESH MATERIALIZED VIEW CONCURRENTLY shipment_data.mb_shipments_rollup_mv
|
| 2013481 |
0.1 s
|
active
|
|
pg_cron upadmin
REFRESH MATERIALIZED VIEW CONCURRENTLY shipment_data.mb_shipments_rollup_mv
|
| 2013477 |
0.1 s
|
active
|
|
pg_cron upadmin
REFRESH MATERIALIZED VIEW CONCURRENTLY shipment_data.mb_shipments_rollup_mv
|