explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZHKu

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=)

2. 0.000 0.000 ↓ 0.0

Subquery Scan on tmp (cost=2,206,998.81..2,210,588.89 rows=1 width=154) (actual rows= loops=)

  • Filter: (NOT (SubPlan 1))
3. 0.000 0.000 ↓ 0.0

Unique (cost=2,052,309.01..2,052,309.02 rows=1 width=150) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=2,052,309.01..2,052,309.02 rows=1 width=150) (actual rows= loops=)

  • Sort Key: a.imported_data_id
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,626.83..2,052,309.00 rows=1 width=150) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8,626.40..2,052,282.74 rows=1 width=147) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8,626.11..2,052,282.43 rows=1 width=117) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,625.82..2,052,282.11 rows=1 width=105) (actual rows= loops=)

  • -> 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) |
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,625.40..2,052,280.01 rows=1 width=105) (actual rows= loops=)

  • Join Filter: ((a.tsin)::text = (vbm_1.tcin)::text)
  • Index Cond: ((imported_data_id = a.imported_data_id) AND (chronicle_id = 5642767))
10. 0.000 0.000 ↓ 0.0

Unique (cost=8,625.40..8,625.40 rows=1 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Sort (cost=8,625.40..8,625.40 rows=1 width=8) (actual rows= loops=)

  • Sort Key: vbm_1.tcin
12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on vendor_brand_mapping vbm_1 (cost=8,469.55..8,625.39 rows=1 width=8) (actual rows= loops=)

  • 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|
13. 0.000 0.000 ↓ 0.0

BitmapOr (cost=8,469.55..8,469.55 rows=35 width=0) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
15. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
16. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
17. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
18. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
19. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
20. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
21. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
22. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
23. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
24. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
25. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
26. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
27. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
28. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
29. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
30. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
31. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
32. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
33. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
34. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
35. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
36. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
37. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
38. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
39. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
40. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
41. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
42. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
43. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
44. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
45. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
46. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
47. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
48. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
49. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
50. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
51. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
52. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
53. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
54. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
55. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
56. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
57. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
58. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
59. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
60. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
61. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
62. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
63. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
64. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
65. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
66. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
67. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
68. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
69. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
70. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
71. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
72. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
73. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
74. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
75. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
76. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
77. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
78. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
79. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
80. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
81. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
82. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
83. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
84. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=119.04..119.04 rows=1 width=0) (actual rows= loops=)

  • -> 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)
85. 0.000 0.000 ↓ 0.0

Seq Scan on assess_results_5642767 a (cost=0.00..2,040,923.20 rows=218,512 width=97) (actual rows= loops=)

  • Filter: ((combination = 5642767) AND (NOT (SubPlan 3)))
86.          

SubPlan (forSeq Scan)

87. 0.000 0.000 ↓ 0.0

Result (cost=0.43..8.45 rows=1 width=8) (actual rows= loops=)

  • 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)
88. 0.000 0.000 ↓ 0.0

Index Scan using brands_id on brands b (cost=0.29..0.32 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = a.brand_id)
89. 0.000 0.000 ↓ 0.0

Index Scan using product_categories_id_pkey on product_categories p (cost=0.29..0.31 rows=1 width=34) (actual rows= loops=)

  • Index Cond: (id = a.category_id)
90. 0.000 0.000 ↓ 0.0

Index Only Scan using vendor_brand_mapping_tcin_idx on vendor_brand_mapping vbm (cost=0.43..1.37 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (tcin = (a.tsin)::text)
91.          

SubPlan (forNested Loop)

92. 0.000 0.000 ↓ 0.0

Seq Scan on super_product_categories spc (cost=0.00..24.88 rows=4 width=32) (actual rows= loops=)

  • Filter: ((super_category_name IS NOT NULL) AND (lower((category_name)::text) = lower((p.department_name)::text)))
93.          

SubPlan (forSubquery Scan)

94. 0.000 0.000 ↓ 0.0

Materialize (cost=154,689.80..160,775.89 rows=437,609 width=8) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Unique (cost=154,689.80..156,877.84 rows=437,609 width=8) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Sort (cost=154,689.80..155,783.82 rows=437,609 width=8) (actual rows= loops=)

  • Sort Key: filters_to_urls_5642767.imported_data_id
97. 0.000 0.000 ↓ 0.0

Seq Scan on filters_to_urls_5642767 (cost=0.00..107,702.40 rows=437,609 width=8) (actual rows= loops=)

  • 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|