explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dA9I

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=2,206,998.81..2,210,588.89 rows=1 width=154) (actual rows= loops=)

  • -> Subquery Scan on tmp (cost=2206998.81..2210588.89 rows=1 width=154) |
  • Filter: (NOT (SubPlan 1)) |
  • -> Unique (cost=2052309.01..2052309.02 rows=1 width=150) |
  • -> Sort (cost=2052309.01..2052309.02 rows=1 width=150) |
  • Sort Key: a.imported_data_id |
  • -> Nested Loop (cost=8626.83..2052309.00 rows=1 width=150) |
  • -> Nested Loop Left Join (cost=8626.40..2052282.74 rows=1 width=147) |
  • -> Nested Loop Left Join (cost=8626.11..2052282.43 rows=1 width=117) |
  • -> Nested Loop (cost=8625.82..2052282.11 rows=1 width=105) |
  • -> Nested Loop (cost=8625.40..2052280.01 rows=1 width=105) |
  • Join Filter: ((a.tsin)::text = (vbm_1.tcin)::text) |
  • -> Unique (cost=8625.40..8625.40 rows=1 width=8) |
  • -> Sort (cost=8625.40..8625.40 rows=1 width=8) |
  • Sort Key: vbm_1.tcin |
  • -> Bitmap Heap Scan on vendor_brand_mapping vbm_1 (cost=8469.55..8625.39 rows=1 width=8) |
  • Recheck Cond: ((((class_name)::text = 'SUNCARE'::text) AND ((department_name)::text = 'SKIN/BATH/FRAGRANCES'::text)) OR (((class_name)::text = 'PREMIUM SKIN CARE'::text) AND ((department_|
  • Filter: ((((division_name)::text = 'BEAUTY'::text) AND ((department_name)::text = 'SKIN/BATH/FRAGRANCES'::text) AND ((class_name)::text = 'SUNCARE'::text)) OR (((division_name)::text = 'B|
  • -> BitmapOr (cost=8469.55..8469.55 rows=35 width=0) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'SUNCARE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'SKIN/BATH/FRAGRANCES'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'PREMIUM SKIN CARE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'SKIN/BATH/FRAGRANCES'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'NATURALS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'SKIN/BATH/FRAGRANCES'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'HAND AND BODY LOTION'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'SKIN/BATH/FRAGRANCES'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'FACIAL SKINCARE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'SKIN/BATH/FRAGRANCES'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'DESIGNER FRAGRANCES'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'SKIN/BATH/FRAGRANCES'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'BATH'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'SKIN/BATH/FRAGRANCES'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'VITAMINS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PHARMACY-OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'SMOKER''S HEALTH'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PHARMACY-OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'PAIN RELIEF'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PHARMACY-OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'NUTRITION'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PHARMACY-OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'COUGH/COLD-PSE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PHARMACY-OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'COUGH-COLD-DEX'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PHARMACY-OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'COUGH/COLD'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PHARMACY-OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'ALLERGY'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PHARMACY-OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'WET DOG FOOD'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'WET CAT FOOD'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'RAWHIDE/CHEWS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'GROOMING AND WELLNESS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'FRESH PET'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'EDIBLE WELLNESS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'DRY DOG FOOD'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'DRY CAT FOOD'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'DOG TREATS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'CAT TREATS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PET CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'TRIAL SIZE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PERSONAL CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'TOOTHPASTE/TOOTHBRUSH'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PERSONAL CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'SOAP'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PERSONAL CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'SHAVE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PERSONAL CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'MOUTHWASH'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PERSONAL CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'MENS CARE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PERSONAL CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'HOLIDAY GIFT SETS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PERSONAL CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'DEODORANT'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'PERSONAL CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'SANITARY PROTECTION'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'PLAN/PROTECT & FEM TREATMENTS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'FIRST AID'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'EYECARE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'DIGESTIVE HEALTH'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'OTC'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'NATURALS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HOUSEHOLD CLEANING'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'LAUNDRY DETERGENTS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HOUSEHOLD CLEANING'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'LAUNDRY ADDITIVES'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HOUSEHOLD CLEANING'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'INSECTICIDES'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HOUSEHOLD CLEANING'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'DISH DETERGENTS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HOUSEHOLD CLEANING'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'CLEANING CHEMICALS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HOUSEHOLD CLEANING'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'AIR FRESHNERS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HOUSEHOLD CLEANING'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'TRIAL AND TRAVEL'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HAIR CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'SALON HAIR'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HAIR CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'MULTICULTURAL'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HAIR CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'HAIR COLOR/PERMS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HAIR CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'GENERAL MARKET HAIR'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'HAIR CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'TEEN/BUDGET'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'RIMMEL'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'REVLON'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'PRESTIGE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'PHYSICIANS/MULTICULTURAL'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'NYX'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'NEUTROGENA'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'NAILCARE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'MAYBELLINE'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'L''OREAL'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'HOLIDAY'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'E.L.F.'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'COVER GIRL'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'COTTON'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'BOOTS'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'ALMAY'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'COSMETICS'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'REFRIGERATED BABY FOOD'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'BABY CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'INFANT FORMULA'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'BABY CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'HEALTH & INGESTIBLES'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'BABY CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'BABY TOILETRIES'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'BABY CARE'::text) |
  • -> BitmapAnd (cost=119.04..119.04 rows=1 width=0) |
  • -> Bitmap Index Scan on vendor_brand_mapping_class_name_idx (cost=0.00..28.73 rows=573 width=0) |
  • Index Cond: ((class_name)::text = 'BABY FOOD'::text) |
  • -> Bitmap Index Scan on vendor_brand_mapping_department_name_idx (cost=0.00..90.07 rows=1818 width=0) |
  • Index Cond: ((department_name)::text = 'BABY CARE'::text) |
  • -> Seq Scan on assess_results_5642767 a (cost=0.00..2040923.20 rows=218512 width=97) |
  • Filter: ((combination = 5642767) AND (NOT (SubPlan 3))) |
  • SubPlan 3 |
  • -> Result (cost=0.43..8.45 rows=1 width=8) |
  • One-Time Filter: ((a.tsin)::text <> ''::text) |
  • -> Index Scan using vendor_brand_mapping_tcin_idx on vendor_brand_mapping vbm_2 (cost=0.43..8.45 rows=1 width=8) |
  • Index Cond: ((tcin)::text = (a.tsin)::text) |
  • Filter: ((code)::text = 'COP'::text) |
  • -> Index Only Scan using filters_to_urls_5642767_pkey on filters_to_urls_5642767 ftu_m (cost=0.42..2.10 rows=1 width=16) |
  • Index Cond: ((imported_data_id = a.imported_data_id) AND (chronicle_id = 5642767)) |
  • -> Index Scan using brands_id on brands b (cost=0.29..0.32 rows=1 width=16) |
  • Index Cond: (id = a.brand_id) |
  • -> Index Scan using product_categories_id_pkey on product_categories p (cost=0.29..0.31 rows=1 width=34) |
  • Index Cond: (id = a.category_id) |
  • -> Index Only Scan using vendor_brand_mapping_tcin_idx on vendor_brand_mapping vbm (cost=0.43..1.37 rows=1 width=8) |
  • Index Cond: (tcin = (a.tsin)::text) |
  • SubPlan 2 |
  • -> Seq Scan on super_product_categories spc (cost=0.00..24.88 rows=4 width=32) |
  • Filter: ((super_category_name IS NOT NULL) AND (lower((category_name)::text) = lower((p.department_name)::text))) |
  • SubPlan 1 |
  • -> Materialize (cost=154689.80..160775.89 rows=437609 width=8) |
  • -> Unique (cost=154689.80..156877.84 rows=437609 width=8) |
  • -> Sort (cost=154689.80..155783.82 rows=437609 width=8) |
  • Sort Key: filters_to_urls_5642767.imported_data_id |
  • -> Seq Scan on filters_to_urls_5642767 (cost=0.00..107702.40 rows=437609 width=8) |
  • Filter: ((chronicle_id = 5642767) AND (((filters ->> 'f271'::text) IS NOT NULL) OR ((filters ->> 'f219'::text) IS NOT NULL) OR ((filters ->> 'f220'::text) IS NOT NULL) OR ((filters ->> 'f221'::text) IS NOT NULL) OR ((filt|