explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W79q : inner query filtered

Settings
# exclusive inclusive rows x rows loops node
1. 3.700 286,406.220 ↓ 19.0 95 1

GroupAggregate (cost=11,639,458.21..11,639,458.34 rows=5 width=556) (actual time=286,401.727..286,406.220 rows=95 loops=1)

  • Group Key: "*SELECT* 1"."productCategoryId", "*SELECT* 1"."productCategoryName", "*SELECT* 1".year, "*SELECT* 1".month
  • Buffers: shared hit=1,217,491, temp read=2,503,557 written=2,091
2. 35.189 286,402.520 ↓ 3,798.6 18,993 1

Sort (cost=11,639,458.21..11,639,458.22 rows=5 width=556) (actual time=286,401.466..286,402.520 rows=18,993 loops=1)

  • Sort Key: "*SELECT* 1"."productCategoryId", "*SELECT* 1"."productCategoryName", "*SELECT* 1".month
  • Sort Method: quicksort Memory: 2,611kB
  • Buffers: shared hit=1,217,491, temp read=2,503,557 written=2,091
3. 7.402 286,367.331 ↓ 3,798.6 18,993 1

Append (cost=5,813,945.76..11,639,458.15 rows=5 width=556) (actual time=742.430..286,367.331 rows=18,993 loops=1)

  • Buffers: shared hit=1,217,491, temp read=2,503,557 written=2,091
4. 9.079 270,733.296 ↓ 4,443.8 17,775 1

Subquery Scan on *SELECT* 1 (cost=5,813,945.76..5,820,392.36 rows=4 width=556) (actual time=742.429..270,733.296 rows=17,775 loops=1)

  • Buffers: shared hit=762,071, temp read=2,334,641 written=1,122
5. 80.684 270,724.217 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.76..5,820,392.32 rows=4 width=6,696) (actual time=742.428..270,724.217 rows=17,775 loops=1)

  • Buffers: shared hit=762,071, temp read=2,334,641 written=1,122
6. 28.092 270,590.208 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.61..5,820,383.56 rows=4 width=624) (actual time=742.407..270,590.208 rows=17,775 loops=1)

  • Buffers: shared hit=726,521, temp read=2,334,641 written=1,122
7. 29.232 270,508.791 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.47..5,820,374.89 rows=4 width=640) (actual time=742.392..270,508.791 rows=17,775 loops=1)

  • Buffers: shared hit=690,971, temp read=2,334,641 written=1,122
8. 27.325 270,426.234 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.32..5,820,366.21 rows=4 width=656) (actual time=742.378..270,426.234 rows=17,775 loops=1)

  • Buffers: shared hit=655,421, temp read=2,334,641 written=1,122
9. 20.744 270,345.584 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.18..5,820,357.53 rows=4 width=672) (actual time=742.364..270,345.584 rows=17,775 loops=1)

  • Buffers: shared hit=619,871, temp read=2,334,641 written=1,122
10. 34.924 270,324.840 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.03..5,820,349.31 rows=4 width=676) (actual time=742.345..270,324.840 rows=17,775 loops=1)

  • Buffers: shared hit=619,869, temp read=2,334,641 written=1,122
11. 39.274 270,254.366 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.89..5,820,347.86 rows=4 width=688) (actual time=742.334..270,254.366 rows=17,775 loops=1)

  • Buffers: shared hit=584,319, temp read=2,334,641 written=1,122
12. 44.176 270,179.542 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.75..5,820,344.15 rows=4 width=704) (actual time=742.321..270,179.542 rows=17,775 loops=1)

  • Buffers: shared hit=548,769, temp read=2,334,641 written=1,122
13. 35.577 270,099.816 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.61..5,820,340.83 rows=4 width=704) (actual time=742.307..270,099.816 rows=17,775 loops=1)

  • Buffers: shared hit=513,219, temp read=2,334,641 written=1,122
14. 31.788 270,010.914 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.47..5,820,339.86 rows=4 width=720) (actual time=742.294..270,010.914 rows=17,775 loops=1)

  • Buffers: shared hit=477,669, temp read=2,334,641 written=1,122
15. 49.568 269,925.801 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.33..5,820,335.94 rows=4 width=720) (actual time=742.281..269,925.801 rows=17,775 loops=1)

  • Buffers: shared hit=442,119, temp read=2,334,641 written=1,122
16. 31,803.950 269,787.358 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.19..5,820,335.31 rows=4 width=704) (actual time=742.253..269,787.358 rows=17,775 loops=1)

  • Join Filter: (mpv.id = mpv_1.id)
  • Rows Removed by Join Filter: 392,136,841
  • Buffers: shared hit=406,569, temp read=2,334,641 written=1,122
17. 12.715 182.336 ↓ 4,168.0 4,168 1

Nested Loop (cost=9.57..961.37 rows=1 width=648) (actual time=0.306..182.336 rows=4,168 loops=1)

  • Buffers: shared hit=24,170
18. 10.726 136.277 ↓ 4,168.0 4,168 1

Nested Loop (cost=9.42..953.20 rows=1 width=664) (actual time=0.293..136.277 rows=4,168 loops=1)

  • Buffers: shared hit=15,834
19. 5.158 86.911 ↓ 2,415.0 2,415 1

Nested Loop (cost=9.01..950.64 rows=1 width=648) (actual time=0.282..86.911 rows=2,415 loops=1)

  • Buffers: shared hit=4,392
20. 29.789 62.313 ↓ 972.0 972 1

Nested Loop (cost=8.73..940.46 rows=1 width=648) (actual time=0.270..62.313 rows=972 loops=1)

  • Join Filter: (ic.id = p."industryCutId")
  • Rows Removed by Join Filter: 322,653
  • Buffers: shared hit=314
21. 10.949 10.949 ↓ 179.8 4,315 1

Index Scan using product_formid_index on "Product" p (cost=0.28..928.56 rows=24 width=132) (actual time=0.029..10.949 rows=4,315 loops=1)

  • Filter: ((type)::text = 'finishedGood'::text)
  • Rows Removed by Filter: 549
  • Buffers: shared hit=220
22. 21.393 21.575 ↓ 37.5 75 4,315

Materialize (cost=8.44..11.18 rows=2 width=564) (actual time=0.000..0.005 rows=75 loops=4,315)

  • Buffers: shared hit=94
23. 0.021 0.182 ↓ 37.5 75 1

Nested Loop (cost=8.44..11.17 rows=2 width=564) (actual time=0.035..0.182 rows=75 loops=1)

  • Buffers: shared hit=94
24. 0.026 0.061 ↓ 20.0 20 1

Hash Join (cost=8.17..10.45 rows=1 width=564) (actual time=0.026..0.061 rows=20 loops=1)

  • Hash Cond: (psc."productCategoryId" = pc.id)
  • Buffers: shared hit=3
25. 0.021 0.021 ↑ 1.0 100 1

Seq Scan on "ProductSubcategory" psc (cost=0.00..2.00 rows=100 width=32) (actual time=0.004..0.021 rows=100 loops=1)

  • Buffers: shared hit=1
26. 0.005 0.014 ↓ 5.0 5 1

Hash (cost=8.16..8.16 rows=1 width=548) (actual time=0.014..0.014 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
27. 0.009 0.009 ↓ 5.0 5 1

Index Scan using productcategory_businesslineid_name_unique on "ProductCategory" pc (cost=0.14..8.16 rows=1 width=548) (actual time=0.007..0.009 rows=5 loops=1)

  • Index Cond: ("businessLineId" = '50578e14-1825-4003-978e-620e3495e915'::uuid)
  • Buffers: shared hit=2
28. 0.100 0.100 ↓ 2.0 4 20

Index Scan using industrycut_productsubcategoryid_name_unique on "IndustryCut" ic (cost=0.27..0.71 rows=2 width=32) (actual time=0.003..0.005 rows=4 loops=20)

  • Index Cond: ("productSubcategoryId" = psc.id)
  • Buffers: shared hit=91
29. 19.440 19.440 ↑ 1.0 2 972

Index Scan using productvariant_productid_skusuffix_unique on "ProductVariant" pv (cost=0.29..10.15 rows=2 width=32) (actual time=0.010..0.020 rows=2 loops=972)

  • Index Cond: ("productId" = p.id)
  • Buffers: shared hit=4,078
30. 38.640 38.640 ↑ 1.5 2 2,415

Index Scan using marketproductvariant_productvariantid_marketid_unique on "MarketProductVariant" mpv (cost=0.41..2.53 rows=3 width=48) (actual time=0.010..0.016 rows=2 loops=2,415)

  • Index Cond: ("productVariantId" = pv.id)
  • Buffers: shared hit=11,442
31. 33.344 33.344 ↑ 1.0 1 4,168

Index Only Scan using "BusinessLine_pkey" on "BusinessLine" bl (cost=0.14..8.16 rows=1 width=16) (actual time=0.005..0.008 rows=1 loops=4,168)

  • Index Cond: (id = '50578e14-1825-4003-978e-620e3495e915'::uuid)
  • Heap Fetches: 4,168
  • Buffers: shared hit=8,336
32. 188,631.157 237,801.072 ↑ 1.2 94,087 4,168

Group (cost=5,813,934.62..5,816,797.42 rows=114,512 width=96) (actual time=0.178..57.054 rows=94,087 loops=4,168)

  • Group Key: (COALESCE(forecast.year, m_1.year)), (COALESCE(forecast.month, m_1.month)), mpv_1.id, forecast.units, m_1.units
  • Buffers: shared hit=382,399, temp read=2,330,474 written=1,122
33.          

Initplan (for Group)

34. 0.002 0.019 ↑ 1.0 1 1

Limit (cost=33.55..33.55 rows=1 width=24) (actual time=0.018..0.019 rows=1 loops=1)

  • Buffers: shared hit=1
35. 0.015 0.017 ↑ 1,570.0 1 1

Sort (cost=33.55..37.48 rows=1,570 width=24) (actual time=0.017..0.017 rows=1 loops=1)

  • Sort Key: fi_2."importedAt" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
36. 0.002 0.002 ↑ 1,570.0 1 1

Seq Scan on "ForecastImport" fi_2 (cost=0.00..25.70 rows=1,570 width=24) (actual time=0.002..0.002 rows=1 loops=1)

  • Buffers: shared hit=1
37. 48,634.461 49,169.896 ↑ 1.2 94,087 4,168

Sort (cost=5,813,901.07..5,814,187.35 rows=114,512 width=38) (actual time=0.177..11.797 rows=94,087 loops=4,168)

  • Sort Key: (COALESCE(forecast.year, m_1.year)), (COALESCE(forecast.month, m_1.month)), mpv_1.id, forecast.units, m_1.units
  • Sort Method: external sort Disk: 4,488kB
  • Buffers: shared hit=382,399, temp read=2,330,474 written=1,122
38. 90.405 535.435 ↑ 1.2 94,087 1

Nested Loop (cost=3,210.15..5,801,146.62 rows=114,512 width=38) (actual time=32.597..535.435 rows=94,087 loops=1)

  • Buffers: shared hit=382,399
39. 64.227 162.769 ↓ 1.6 94,087 1

Hash Full Join (cost=3,194.44..4,669,995.51 rows=57,257 width=56) (actual time=32.574..162.769 rows=94,087 loops=1)

  • Hash Cond: ((m_1."marketProductVariantId" = forecast."marketProductVariantId") AND (m_1.month = forecast.month) AND (m_1.year = forecast.year))
  • Filter: ((COALESCE(forecast.year, m_1.year) = 2,020) AND ((COALESCE(forecast.month, m_1.month) = 1) OR (COALESCE(forecast.month, m_1.month) = 2) OR (COALESCE(forecast.month, m_1.month) = 3) OR (COALESCE(forecast.month, m_1.month) = 4) OR (COALESCE(forecast.month, m_1.month) = 5) OR (COALESCE(forecast.month, m_1.month) = 6) OR (COALESCE(forecast.month, m_1.month) = 7) OR (COALESCE(forecast.month, m_1.month) = 8) OR (COALESCE(forecast.month, m_1.month) = 9) OR (COALESCE(forecast.month, m_1.month) = 10) OR (COALESCE(forecast.month, m_1.month) = 11) OR (COALESCE(forecast.month, m_1.month) = 12)))
  • Rows Removed by Filter: 61,287
  • Buffers: shared hit=2,765
40. 44.265 66.021 ↑ 1,570.8 124,880 1

Nested Loop (cost=0.00..2,455,037.42 rows=196,162,080 width=28) (actual time=0.035..66.021 rows=124,880 loops=1)

  • Buffers: shared hit=1,422
41. 21.756 21.756 ↑ 1.0 124,880 1

Seq Scan on "MonthlyMarketProductVariantDemand" m_1 (cost=0.00..2,981.80 rows=124,944 width=28) (actual time=0.030..21.756 rows=124,880 loops=1)

  • Filter: ("forecastImportId" = $0)
  • Buffers: shared hit=1,421
42. 0.000 0.000 ↑ 1,570.0 1 124,880

Materialize (cost=0.00..33.55 rows=1,570 width=0) (actual time=0.000..0.000 rows=1 loops=124,880)

  • Buffers: shared hit=1
43. 0.001 0.001 ↑ 1,570.0 1 1

Seq Scan on "ForecastImport" fi (cost=0.00..25.70 rows=1,570 width=0) (actual time=0.001..0.001 rows=1 loops=1)

  • Buffers: shared hit=1
44. 6.104 32.521 ↓ 51.7 30,500 1

Hash (cost=3,184.12..3,184.12 rows=590 width=28) (actual time=32.521..32.521 rows=30,500 loops=1)

  • Buckets: 32,768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2,044kB
  • Buffers: shared hit=1,343
45. 16.146 26.417 ↓ 51.7 30,500 1

Hash Join (cost=41.75..3,184.12 rows=590 width=28) (actual time=0.026..26.417 rows=30,500 loops=1)

  • Hash Cond: ((forecast."forecastImportId" = abf."forecastImportId") AND (forecast.year = abf.year))
  • Buffers: shared hit=1,343
46. 10.265 10.265 ↑ 1.0 118,009 1

Seq Scan on "MonthlyMarketProductVariantForecast" forecast (cost=0.00..2,522.57 rows=118,057 width=44) (actual time=0.006..10.265 rows=118,009 loops=1)

  • Buffers: shared hit=1,342
47. 0.003 0.006 ↑ 1,270.0 1 1

Hash (cost=22.70..22.70 rows=1,270 width=20) (actual time=0.006..0.006 rows=1 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=1
48. 0.003 0.003 ↑ 1,270.0 1 1

Seq Scan on "AnnualBudgetForecast" abf (cost=0.00..22.70 rows=1,270 width=20) (actual time=0.002..0.003 rows=1 loops=1)

  • Buffers: shared hit=1
49. 0.000 282.261 ↑ 2.0 1 94,087

Bitmap Heap Scan on "MarketProductVariant" mpv_1 (cost=15.71..19.74 rows=2 width=22) (actual time=0.003..0.003 rows=1 loops=94,087)

  • Recheck Cond: ((forecast."marketProductVariantId" = id) OR (m_1."marketProductVariantId" = id))
  • Heap Blocks: exact=94,087
  • Buffers: shared hit=379,634
50. 94.087 282.261 ↓ 0.0 0 94,087

BitmapOr (cost=15.71..15.71 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=94,087)

  • Buffers: shared hit=285,547
51. 94.087 94.087 ↓ 0.0 0 94,087

Bitmap Index Scan on "MarketProductVariant_pkey" (cost=0.00..0.45 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=94,087)

  • Index Cond: (forecast."marketProductVariantId" = id)
  • Buffers: shared hit=92,668
52. 94.087 94.087 ↑ 1.0 1 94,087

Bitmap Index Scan on "MarketProductVariant_pkey" (cost=0.00..0.45 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=94,087)

  • Index Cond: (m_1."marketProductVariantId" = id)
  • Buffers: shared hit=192,879
53. 88.875 88.875 ↑ 1.0 1 17,775

Index Scan using "Market_pkey" on "Market" m (cost=0.14..0.16 rows=1 width=48) (actual time=0.005..0.005 rows=1 loops=17,775)

  • Index Cond: (id = mpv."marketId")
  • Buffers: shared hit=35,550
54. 53.325 53.325 ↑ 1.0 1 17,775

Index Scan using "Subregion_pkey" on "Subregion" sr (cost=0.14..0.98 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=17,775)

  • Index Cond: (id = m."subregionId")
  • Buffers: shared hit=35,550
55. 53.325 53.325 ↑ 1.0 1 17,775

Index Only Scan using "Region_pkey" on "Region" r (cost=0.13..0.24 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=17,775)

  • Index Cond: (id = sr."regionId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
56. 35.550 35.550 ↑ 1.0 1 17,775

Index Scan using "SubBrand_pkey" on "SubBrand" sb (cost=0.14..0.82 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=17,775)

  • Index Cond: (id = p."subBrandId")
  • Buffers: shared hit=35,550
57. 35.550 35.550 ↑ 1.0 1 17,775

Index Only Scan using "Brand_pkey" on "Brand" b (cost=0.14..0.92 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=17,775)

  • Index Cond: (id = sb."brandId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
58. 35.550 35.550 ↑ 1.0 1 17,775

Index Scan using "Currency_pkey" on "Currency" c (cost=0.14..0.36 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=17,775)

  • Index Cond: (id = m."currencyId")
  • Buffers: shared hit=35,550
59. 0.000 0.000 ↑ 1.0 1 17,775

Materialize (cost=0.14..8.17 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=17,775)

  • Buffers: shared hit=2
60. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using producttype_name_unique on "ProductType" pt (cost=0.14..8.16 rows=1 width=32) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (name = 'finishedGood'::text)
  • Heap Fetches: 1
  • Buffers: shared hit=2
61. 53.325 53.325 ↑ 1.0 1 17,775

Index Only Scan using "Demographic_pkey" on "Demographic" d (cost=0.14..2.16 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=17,775)

  • Index Cond: (id = p."demographicId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
62. 53.325 53.325 ↑ 1.0 1 17,775

Index Only Scan using "MarketingManaged_pkey" on "MarketingManaged" mm (cost=0.14..2.16 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=17,775)

  • Index Cond: (id = p."marketingManagedId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
63. 53.325 53.325 ↑ 1.0 1 17,775

Index Only Scan using "MarketingFocus_pkey" on "MarketingFocus" mf (cost=0.14..2.16 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=17,775)

  • Index Cond: (id = p."marketingFocusId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
64. 53.325 53.325 ↑ 1.0 1 17,775

Index Only Scan using "Form_pkey" on "Form" f (cost=0.14..2.16 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=17,775)

  • Index Cond: (id = p."formId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
65. 0.233 15,626.633 ↓ 1,218.0 1,218 1

Subquery Scan on *SELECT* 2 (cost=5,818,806.19..5,819,065.79 rows=1 width=556) (actual time=15,162.413..15,626.633 rows=1,218 loops=1)

  • Buffers: shared hit=455,420, temp read=168,916 written=969
66. 2.784 15,626.400 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,806.19..5,819,065.78 rows=1 width=6,696) (actual time=15,162.411..15,626.400 rows=1,218 loops=1)

  • Buffers: shared hit=455,420, temp read=168,916 written=969
67. 0.362 15,622.398 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,806.05..5,819,065.37 rows=1 width=591) (actual time=15,162.385..15,622.398 rows=1,218 loops=1)

  • Buffers: shared hit=452,984, temp read=168,916 written=969
68. 0.382 15,619.600 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,805.90..5,819,065.20 rows=1 width=607) (actual time=15,162.371..15,619.600 rows=1,218 loops=1)

  • Buffers: shared hit=450,548, temp read=168,916 written=969
69. 0.441 15,616.782 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,805.76..5,819,065.03 rows=1 width=623) (actual time=15,162.359..15,616.782 rows=1,218 loops=1)

  • Buffers: shared hit=448,112, temp read=168,916 written=969
70. 0.586 15,613.905 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,805.61..5,819,064.85 rows=1 width=639) (actual time=15,162.347..15,613.905 rows=1,218 loops=1)

  • Buffers: shared hit=445,676, temp read=168,916 written=969
71. 0.722 15,610.883 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,805.47..5,819,064.68 rows=1 width=655) (actual time=15,162.333..15,610.883 rows=1,218 loops=1)

  • Buffers: shared hit=443,240, temp read=168,916 written=969
72. 0.996 15,607.725 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,805.32..5,819,064.50 rows=1 width=659) (actual time=15,162.318..15,607.725 rows=1,218 loops=1)

  • Buffers: shared hit=440,804, temp read=168,916 written=969
73. 1.084 15,605.511 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,805.17..5,819,063.57 rows=1 width=675) (actual time=15,162.305..15,605.511 rows=1,218 loops=1)

  • Buffers: shared hit=438,368, temp read=168,916 written=969
74. 0.512 15,603.209 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,805.03..5,819,063.41 rows=1 width=675) (actual time=15,162.292..15,603.209 rows=1,218 loops=1)

  • Buffers: shared hit=435,932, temp read=168,916 written=969
75. 1.205 15,600.261 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,804.90..5,819,063.14 rows=1 width=691) (actual time=15,162.280..15,600.261 rows=1,218 loops=1)

  • Buffers: shared hit=433,496, temp read=168,916 written=969
76. 1.204 15,597.838 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,804.76..5,819,062.13 rows=1 width=691) (actual time=15,162.268..15,597.838 rows=1,218 loops=1)

  • Buffers: shared hit=431,060, temp read=168,916 written=969
77. 1.032 15,595.416 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,804.62..5,819,061.97 rows=1 width=691) (actual time=15,162.257..15,595.416 rows=1,218 loops=1)

  • Buffers: shared hit=428,624, temp read=168,916 written=969
78. 1.133 15,593.166 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,804.47..5,819,061.46 rows=1 width=707) (actual time=15,162.242..15,593.166 rows=1,218 loops=1)

  • Buffers: shared hit=426,188, temp read=168,916 written=969
79. 1.115 15,590.815 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,804.33..5,819,060.81 rows=1 width=175) (actual time=15,162.229..15,590.815 rows=1,218 loops=1)

  • Buffers: shared hit=423,752, temp read=168,916 written=969
80. 1.532 15,588.482 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,804.18..5,819,060.60 rows=1 width=175) (actual time=15,162.216..15,588.482 rows=1,218 loops=1)

  • Buffers: shared hit=421,316, temp read=168,916 written=969
81. 0.904 15,585.732 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,804.04..5,819,060.43 rows=1 width=175) (actual time=15,162.203..15,585.732 rows=1,218 loops=1)

  • Buffers: shared hit=418,880, temp read=168,916 written=969
82. 0.985 15,582.392 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,803.76..5,819,060.02 rows=1 width=91) (actual time=15,162.187..15,582.392 rows=1,218 loops=1)

  • Buffers: shared hit=415,226, temp read=168,916 written=969
83. 1.561 15,578.971 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,803.47..5,819,059.69 rows=1 width=91) (actual time=15,162.174..15,578.971 rows=1,218 loops=1)

  • Buffers: shared hit=411,536, temp read=168,916 written=969
84. 0.479 15,574.974 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,803.06..5,819,054.71 rows=1 width=75) (actual time=15,162.158..15,574.974 rows=1,218 loops=1)

  • Buffers: shared hit=406,642, temp read=168,916 written=969
85. 0.479 15,572.059 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,802.91..5,819,052.52 rows=1 width=91) (actual time=15,162.141..15,572.059 rows=1,218 loops=1)

  • Buffers: shared hit=404,206, temp read=168,916 written=969
86. 0.440 15,569.144 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,802.77..5,819,050.33 rows=1 width=107) (actual time=15,162.127..15,569.144 rows=1,218 loops=1)

  • Buffers: shared hit=401,770, temp read=168,916 written=969
87. 0.776 15,566.268 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,802.62..5,819,048.14 rows=1 width=123) (actual time=15,162.111..15,566.268 rows=1,218 loops=1)

  • Buffers: shared hit=399,334, temp read=168,916 written=969
88. 245.759 15,563.056 ↓ 1,218.0 1,218 1

Nested Loop (cost=5,818,802.48..5,819,045.95 rows=1 width=139) (actual time=15,162.096..15,563.056 rows=1,218 loops=1)

  • Join Filter: (mpv_4.id = mpvsbe."parentMarketProductVariantId")
  • Rows Removed by Join Filter: 2,531,274
  • Buffers: shared hit=396,898, temp read=168,916 written=969
89. 0.670 15,175.817 ↓ 294.8 1,179 1

Nested Loop (cost=5,818,802.48..5,818,822.22 rows=4 width=144) (actual time=15,161.918..15,175.817 rows=1,179 loops=1)

  • Buffers: shared hit=396,830, temp read=168,916 written=969
90. 0.805 15,175.147 ↓ 294.8 1,179 1

Nested Loop (cost=5,818,802.33..5,818,814.00 rows=4 width=148) (actual time=15,161.899..15,175.147 rows=1,179 loops=1)

  • Buffers: shared hit=396,828, temp read=168,916 written=969
91. 1.289 15,171.984 ↓ 294.8 1,179 1

Nested Loop (cost=5,818,802.19..5,818,810.29 rows=4 width=164) (actual time=15,161.884..15,171.984 rows=1,179 loops=1)

  • Buffers: shared hit=394,470, temp read=168,916 written=969
92. 0.592 15,169.516 ↓ 294.8 1,179 1

Nested Loop (cost=5,818,802.05..5,818,806.97 rows=4 width=164) (actual time=15,161.871..15,169.516 rows=1,179 loops=1)

  • Buffers: shared hit=392,112, temp read=168,916 written=969
93. 1.424 15,166.566 ↓ 294.8 1,179 1

Nested Loop (cost=5,818,801.92..5,818,806.00 rows=4 width=180) (actual time=15,161.851..15,166.566 rows=1,179 loops=1)

  • Buffers: shared hit=389,754, temp read=168,916 written=969
94. 0.719 15,162.784 ↓ 294.8 1,179 1

Merge Join (cost=5,818,801.77..5,818,802.08 rows=4 width=180) (actual time=15,161.836..15,162.784 rows=1,179 loops=1)

  • Merge Cond: (m_2."currencyId" = c_2.id)
  • Buffers: shared hit=387,396, temp read=168,916 written=969
95. 2.562 15,162.015 ↓ 294.8 1,179 1

Sort (cost=5,818,798.86..5,818,798.87 rows=4 width=164) (actual time=15,161.792..15,162.015 rows=1,179 loops=1)

  • Sort Key: m_2."currencyId
  • Sort Method: quicksort Memory: 362kB
  • Buffers: shared hit=387,395, temp read=168,916 written=969
96. 2.626 15,159.453 ↓ 294.8 1,179 1

Nested Loop (cost=5,813,552.33..5,818,798.82 rows=4 width=164) (actual time=668.507..15,159.453 rows=1,179 loops=1)

  • Buffers: shared hit=387,395, temp read=168,916 written=969
97. 2,658.184 15,152.111 ↓ 294.8 1,179 1

Nested Loop (cost=5,813,552.19..5,818,798.19 rows=4 width=148) (actual time=668.476..15,152.111 rows=1,179 loops=1)

  • Join Filter: (mpv_3.id = mpv_4.id)
  • Rows Removed by Join Filter: 32,741,097
  • Buffers: shared hit=385,037, temp read=168,916 written=969
98. 0.694 21.607 ↓ 348.0 348 1

Nested Loop (cost=9.57..961.37 rows=1 width=116) (actual time=0.570..21.607 rows=348 loops=1)

  • Buffers: shared hit=2,638
99. 0.772 18.129 ↓ 348.0 348 1

Nested Loop (cost=9.42..953.20 rows=1 width=132) (actual time=0.556..18.129 rows=348 loops=1)

  • Buffers: shared hit=1,942
100. 0.704 14.179 ↓ 227.0 227 1

Nested Loop (cost=9.01..950.64 rows=1 width=116) (actual time=0.540..14.179 rows=227 loops=1)

  • Buffers: shared hit=904
101. 3.835 11.279 ↓ 183.0 183 1

Nested Loop (cost=8.73..940.46 rows=1 width=116) (actual time=0.526..11.279 rows=183 loops=1)

  • Join Filter: (ic_2.id = p_2."industryCutId")
  • Rows Removed by Join Filter: 40,992
  • Buffers: shared hit=314
102. 4.150 4.150 ↓ 22.9 549 1

Index Scan using product_formid_index on "Product" p_2 (cost=0.28..928.56 rows=24 width=132) (actual time=0.058..4.150 rows=549 loops=1)

  • Filter: ((type)::text = 'salesBundle'::text)
  • Rows Removed by Filter: 4,315
  • Buffers: shared hit=220
103. 3.061 3.294 ↓ 37.5 75 549

Materialize (cost=8.44..11.18 rows=2 width=32) (actual time=0.000..0.006 rows=75 loops=549)

  • Buffers: shared hit=94
104. 0.026 0.233 ↓ 37.5 75 1

Nested Loop (cost=8.44..11.17 rows=2 width=32) (actual time=0.065..0.233 rows=75 loops=1)

  • Buffers: shared hit=94
105. 0.038 0.087 ↓ 20.0 20 1

Hash Join (cost=8.17..10.45 rows=1 width=32) (actual time=0.047..0.087 rows=20 loops=1)

  • Hash Cond: (psc_2."productCategoryId" = pc_2.id)
  • Buffers: shared hit=3
106. 0.028 0.028 ↑ 1.0 100 1

Seq Scan on "ProductSubcategory" psc_2 (cost=0.00..2.00 rows=100 width=32) (actual time=0.009..0.028 rows=100 loops=1)

  • Buffers: shared hit=1
107. 0.005 0.021 ↓ 5.0 5 1

Hash (cost=8.16..8.16 rows=1 width=32) (actual time=0.021..0.021 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
108. 0.016 0.016 ↓ 5.0 5 1

Index Scan using productcategory_businesslineid_name_unique on "ProductCategory" pc_2 (cost=0.14..8.16 rows=1 width=32) (actual time=0.013..0.016 rows=5 loops=1)

  • Index Cond: ("businessLineId" = '50578e14-1825-4003-978e-620e3495e915'::uuid)
  • Buffers: shared hit=2
109. 0.120 0.120 ↓ 2.0 4 20

Index Scan using industrycut_productsubcategoryid_name_unique on "IndustryCut" ic_2 (cost=0.27..0.71 rows=2 width=32) (actual time=0.004..0.006 rows=4 loops=20)

  • Index Cond: ("productSubcategoryId" = psc_2.id)
  • Buffers: shared hit=91
110. 2.196 2.196 ↑ 2.0 1 183

Index Scan using productvariant_productid_skusuffix_unique on "ProductVariant" pv_2 (cost=0.29..10.15 rows=2 width=32) (actual time=0.010..0.012 rows=1 loops=183)

  • Index Cond: ("productId" = p_2.id)
  • Buffers: shared hit=590
111. 3.178 3.178 ↑ 1.5 2 227

Index Scan using marketproductvariant_productvariantid_marketid_unique on "MarketProductVariant" mpv_3 (cost=0.41..2.53 rows=3 width=48) (actual time=0.009..0.014 rows=2 loops=227)

  • Index Cond: ("productVariantId" = pv_2.id)
  • Buffers: shared hit=1,038
112. 2.784 2.784 ↑ 1.0 1 348

Index Only Scan using "BusinessLine_pkey" on "BusinessLine" bl_2 (cost=0.14..8.16 rows=1 width=16) (actual time=0.004..0.008 rows=1 loops=348)

  • Index Cond: (id = '50578e14-1825-4003-978e-620e3495e915'::uuid)
  • Heap Fetches: 348
  • Buffers: shared hit=696
113. 7,889.838 12,472.320 ↑ 1.2 94,087 348

Group (cost=5,813,542.62..5,815,260.30 rows=114,512 width=96) (actual time=1.916..35.840 rows=94,087 loops=348)

  • Group Key: (COALESCE(forecast_1.year, m_3.year)), (COALESCE(forecast_1.month, m_3.month)), mpv_4.id, forecast_1.units, m_3.units
  • Buffers: shared hit=382,399, temp read=168,569 written=969
114.          

Initplan (for Group)

115. 0.002 0.018 ↑ 1.0 1 1

Limit (cost=33.55..33.55 rows=1 width=24) (actual time=0.017..0.018 rows=1 loops=1)

  • Buffers: shared hit=1
116. 0.013 0.016 ↑ 1,570.0 1 1

Sort (cost=33.55..37.48 rows=1,570 width=24) (actual time=0.016..0.016 rows=1 loops=1)

  • Sort Key: fi_3."importedAt" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
117. 0.003 0.003 ↑ 1,570.0 1 1

Seq Scan on "ForecastImport" fi_3 (cost=0.00..25.70 rows=1,570 width=24) (actual time=0.002..0.003 rows=1 loops=1)

  • Buffers: shared hit=1
118. 4,073.727 4,582.464 ↑ 1.2 94,087 348

Sort (cost=5,813,509.07..5,813,795.35 rows=114,512 width=32) (actual time=1.915..13.168 rows=94,087 loops=348)

  • Sort Key: (COALESCE(forecast_1.year, m_3.year)), (COALESCE(forecast_1.month, m_3.month)), mpv_4.id, forecast_1.units, m_3.units
  • Sort Method: external sort Disk: 3,872kB
  • Buffers: shared hit=382,399, temp read=168,569 written=969
119. 66.193 508.737 ↑ 1.2 94,087 1

Nested Loop (cost=3,210.15..5,801,146.62 rows=114,512 width=32) (actual time=32.263..508.737 rows=94,087 loops=1)

  • Buffers: shared hit=382,399
120. 62.697 160.283 ↓ 1.6 94,087 1

Hash Full Join (cost=3,194.44..4,669,995.51 rows=57,257 width=56) (actual time=32.241..160.283 rows=94,087 loops=1)

  • Hash Cond: ((m_3."marketProductVariantId" = forecast_1."marketProductVariantId") AND (m_3.month = forecast_1.month) AND (m_3.year = forecast_1.year))
  • Filter: ((COALESCE(forecast_1.year, m_3.year) = 2,020) AND ((COALESCE(forecast_1.month, m_3.month) = 1) OR (COALESCE(forecast_1.month, m_3.month) = 2) OR (COALESCE(forecast_1.month, m_3.month) = 3) OR (COALESCE(forecast_1.month, m_3.month) = 4) OR (COALESCE(forecast_1.month, m_3.month) = 5) OR (COALESCE(forecast_1.month, m_3.month) = 6) OR (COALESCE(forecast_1.month, m_3.month) = 7) OR (COALESCE(forecast_1.month, m_3.month) = 8) OR (COALESCE(forecast_1.month, m_3.month) = 9) OR (COALESCE(forecast_1.month, m_3.month) = 10) OR (COALESCE(forecast_1.month, m_3.month) = 11) OR (COALESCE(forecast_1.month, m_3.month) = 12)))
  • Rows Removed by Filter: 61,287
  • Buffers: shared hit=2,765
121. 44.095 65.398 ↑ 1,570.8 124,880 1

Nested Loop (cost=0.00..2,455,037.42 rows=196,162,080 width=28) (actual time=0.035..65.398 rows=124,880 loops=1)

  • Buffers: shared hit=1,422
122. 21.303 21.303 ↑ 1.0 124,880 1

Seq Scan on "MonthlyMarketProductVariantDemand" m_3 (cost=0.00..2,981.80 rows=124,944 width=28) (actual time=0.027..21.303 rows=124,880 loops=1)

  • Filter: ("forecastImportId" = $1)
  • Buffers: shared hit=1,421
123. 0.000 0.000 ↑ 1,570.0 1 124,880

Materialize (cost=0.00..33.55 rows=1,570 width=0) (actual time=0.000..0.000 rows=1 loops=124,880)

  • Buffers: shared hit=1
124. 0.003 0.003 ↑ 1,570.0 1 1

Seq Scan on "ForecastImport" fi_1 (cost=0.00..25.70 rows=1,570 width=0) (actual time=0.003..0.003 rows=1 loops=1)

  • Buffers: shared hit=1
125. 5.897 32.188 ↓ 51.7 30,500 1

Hash (cost=3,184.12..3,184.12 rows=590 width=28) (actual time=32.188..32.188 rows=30,500 loops=1)

  • Buckets: 32,768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2,044kB
  • Buffers: shared hit=1,343
126. 16.013 26.291 ↓ 51.7 30,500 1

Hash Join (cost=41.75..3,184.12 rows=590 width=28) (actual time=0.024..26.291 rows=30,500 loops=1)

  • Hash Cond: ((forecast_1."forecastImportId" = abf_1."forecastImportId") AND (forecast_1.year = abf_1.year))
  • Buffers: shared hit=1,343
127. 10.272 10.272 ↑ 1.0 118,009 1

Seq Scan on "MonthlyMarketProductVariantForecast" forecast_1 (cost=0.00..2,522.57 rows=118,057 width=44) (actual time=0.007..10.272 rows=118,009 loops=1)

  • Buffers: shared hit=1,342
128. 0.002 0.006 ↑ 1,270.0 1 1

Hash (cost=22.70..22.70 rows=1,270 width=20) (actual time=0.006..0.006 rows=1 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=1
129. 0.004 0.004 ↑ 1,270.0 1 1

Seq Scan on "AnnualBudgetForecast" abf_1 (cost=0.00..22.70 rows=1,270 width=20) (actual time=0.004..0.004 rows=1 loops=1)

  • Buffers: shared hit=1
130. 94.087 282.261 ↑ 2.0 1 94,087

Bitmap Heap Scan on "MarketProductVariant" mpv_4 (cost=15.71..19.74 rows=2 width=16) (actual time=0.003..0.003 rows=1 loops=94,087)

  • Recheck Cond: ((forecast_1."marketProductVariantId" = id) OR (m_3."marketProductVariantId" = id))
  • Heap Blocks: exact=94,087
  • Buffers: shared hit=379,634
131. 0.000 188.174 ↓ 0.0 0 94,087

BitmapOr (cost=15.71..15.71 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=94,087)

  • Buffers: shared hit=285,547
132. 94.087 94.087 ↓ 0.0 0 94,087

Bitmap Index Scan on "MarketProductVariant_pkey" (cost=0.00..0.45 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=94,087)

  • Index Cond: (forecast_1."marketProductVariantId" = id)
  • Buffers: shared hit=92,668
133. 94.087 94.087 ↑ 1.0 1 94,087

Bitmap Index Scan on "MarketProductVariant_pkey" (cost=0.00..0.45 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=94,087)

  • Index Cond: (m_3."marketProductVariantId" = id)
  • Buffers: shared hit=192,879
134. 4.716 4.716 ↑ 1.0 1 1,179

Index Scan using "Market_pkey" on "Market" m_2 (cost=0.14..0.16 rows=1 width=48) (actual time=0.004..0.004 rows=1 loops=1,179)

  • Index Cond: (id = mpv_3."marketId")
  • Buffers: shared hit=2,358
135. 0.033 0.050 ↑ 1.0 50 1

Sort (cost=2.91..3.04 rows=50 width=16) (actual time=0.040..0.050 rows=50 loops=1)

  • Sort Key: c_2.id
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=1
136. 0.017 0.017 ↑ 1.0 50 1

Seq Scan on "Currency" c_2 (cost=0.00..1.50 rows=50 width=16) (actual time=0.012..0.017 rows=50 loops=1)

  • Buffers: shared hit=1
137. 2.358 2.358 ↑ 1.0 1 1,179

Index Scan using "Subregion_pkey" on "Subregion" sr_2 (cost=0.14..0.98 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1,179)

  • Index Cond: (id = m_2."subregionId")
  • Buffers: shared hit=2,358
138. 2.358 2.358 ↑ 1.0 1 1,179

Index Only Scan using "Region_pkey" on "Region" r_2 (cost=0.13..0.24 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,179)

  • Index Cond: (id = sr_2."regionId")
  • Heap Fetches: 1,179
  • Buffers: shared hit=2,358
139. 1.179 1.179 ↑ 1.0 1 1,179

Index Scan using "SubBrand_pkey" on "SubBrand" sb_2 (cost=0.14..0.82 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,179)

  • Index Cond: (id = p_2."subBrandId")
  • Buffers: shared hit=2,358
140. 2.358 2.358 ↑ 1.0 1 1,179

Index Only Scan using "Brand_pkey" on "Brand" b_2 (cost=0.14..0.92 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,179)

  • Index Cond: (id = sb_2."brandId")
  • Heap Fetches: 1,179
  • Buffers: shared hit=2,358
141. 0.000 0.000 ↑ 1.0 1 1,179

Materialize (cost=0.14..8.17 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=1,179)

  • Buffers: shared hit=2
142. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using producttype_name_unique on "ProductType" pt_2 (cost=0.14..8.16 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (name = 'salesBundle'::text)
  • Heap Fetches: 1
  • Buffers: shared hit=2
143. 141.099 141.480 ↑ 1.0 2,148 1,179

Materialize (cost=0.00..100.22 rows=2,148 width=43) (actual time=0.000..0.120 rows=2,148 loops=1,179)

  • Buffers: shared hit=68
144. 0.381 0.381 ↑ 1.0 2,148 1

Seq Scan on "MarketProductVariantSalesBundleEntry" mpvsbe (cost=0.00..89.48 rows=2,148 width=43) (actual time=0.059..0.381 rows=2,148 loops=1)

  • Buffers: shared hit=68
145. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using "Form_pkey" on "Form" f_2 (cost=0.14..2.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = p_2."formId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
146. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using "Demographic_pkey" on "Demographic" d_2 (cost=0.14..2.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = p_2."demographicId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
147. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using "MarketingManaged_pkey" on "MarketingManaged" mm_2 (cost=0.14..2.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = p_2."marketingManagedId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
148. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using "MarketingFocus_pkey" on "MarketingFocus" mf_2 (cost=0.14..2.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = p_2."marketingFocusId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
149. 2.436 2.436 ↑ 1.0 1 1,218

Index Scan using "MarketProductVariant_pkey" on "MarketProductVariant" mpv_2 (cost=0.41..4.98 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = mpvsbe."marketProductVariantId")
  • Buffers: shared hit=4,894
150. 2.436 2.436 ↑ 1.0 1 1,218

Index Scan using "ProductVariant_pkey" on "ProductVariant" pv_1 (cost=0.29..0.32 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = mpv_2."productVariantId")
  • Buffers: shared hit=3,690
151. 2.436 2.436 ↑ 1.0 1 1,218

Index Scan using "Product_pkey" on "Product" p_1 (cost=0.28..0.42 rows=1 width=132) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = pv_1."productId")
  • Buffers: shared hit=3,654
152. 1.218 1.218 ↑ 1.0 1 1,218

Index Scan using "IndustryCut_pkey" on "IndustryCut" ic_1 (cost=0.14..0.17 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,218)

  • Index Cond: (id = p_1."industryCutId")
  • Buffers: shared hit=2,436
153. 1.218 1.218 ↑ 1.0 1 1,218

Index Scan using "ProductSubcategory_pkey" on "ProductSubcategory" psc_1 (cost=0.14..0.21 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,218)

  • Index Cond: (id = ic_1."productSubcategoryId")
  • Buffers: shared hit=2,436
154. 1.218 1.218 ↑ 1.0 1 1,218

Index Scan using "ProductCategory_pkey" on "ProductCategory" pc_1 (cost=0.14..0.64 rows=1 width=548) (actual time=0.001..0.001 rows=1 loops=1,218)

  • Index Cond: (id = psc_1."productCategoryId")
  • Buffers: shared hit=2,436
155. 1.218 1.218 ↑ 1.0 1 1,218

Index Only Scan using "BusinessLine_pkey" on "BusinessLine" bl_1 (cost=0.14..0.51 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1,218)

  • Index Cond: (id = pc_1."businessLineId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
156. 1.218 1.218 ↑ 1.0 1 1,218

Index Scan using "Market_pkey" on "Market" (cost=0.14..0.16 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,218)

  • Index Cond: (id = mpv_2."marketId")
  • Filter: (NOT "isHidden")
  • Buffers: shared hit=2,436
157. 1.218 1.218 ↑ 1.0 1 1,218

Index Scan using "Subregion_pkey" on "Subregion" sr_1 (cost=0.14..0.99 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,218)

  • Index Cond: (id = "Market"."subregionId")
  • Buffers: shared hit=2,436
158. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using "Region_pkey" on "Region" r_1 (cost=0.13..0.24 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = sr_1."regionId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
159. 1.218 1.218 ↑ 1.0 1 1,218

Index Scan using "SubBrand_pkey" on "SubBrand" sb_1 (cost=0.14..0.16 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,218)

  • Index Cond: (id = p_1."subBrandId")
  • Buffers: shared hit=2,436
160. 1.218 1.218 ↑ 1.0 1 1,218

Index Only Scan using "Brand_pkey" on "Brand" b_1 (cost=0.14..0.92 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1,218)

  • Index Cond: (id = sb_1."brandId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
161. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using producttype_name_unique on "ProductType" pt_1 (cost=0.15..0.18 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (name = (p_1.type)::text)
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
162. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using "Form_pkey" on "Form" f_1 (cost=0.14..0.17 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = p_1."formId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
163. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using "Demographic_pkey" on "Demographic" d_1 (cost=0.14..0.17 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = p_1."demographicId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
164. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using "MarketingManaged_pkey" on "MarketingManaged" mm_1 (cost=0.14..0.17 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = p_1."marketingManagedId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
165. 2.436 2.436 ↑ 1.0 1 1,218

Index Only Scan using "MarketingFocus_pkey" on "MarketingFocus" mf_1 (cost=0.14..0.17 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: (id = p_1."marketingFocusId")
  • Heap Fetches: 1,218
  • Buffers: shared hit=2,436
166. 1.218 1.218 ↑ 1.0 1 1,218

Index Scan using "Currency_pkey" on "Currency" c_1 (cost=0.14..0.36 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=1,218)

  • Index Cond: (id = m_2."currencyId")
  • Buffers: shared hit=2,436
Planning time : 24.131 ms
Execution time : 286,409.249 ms