explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x6pI : review1 db

Settings
# exclusive inclusive rows x rows loops node
1. 0.059 274,691.268 ↓ 2.0 10 1

Limit (cost=11,670,401.18..11,670,401.32 rows=5 width=556) (actual time=274,689.823..274,691.268 rows=10 loops=1)

  • Buffers: shared hit=1,331,917, temp read=2,335,518 written=2,001
2. 1.102 274,691.209 ↓ 2.0 10 1

GroupAggregate (cost=11,670,401.18..11,670,401.32 rows=5 width=556) (actual time=274,689.822..274,691.209 rows=10 loops=1)

  • Group Key: "*SELECT* 1"."productCategoryId", "*SELECT* 1"."productCategoryName", "*SELECT* 1".year, "*SELECT* 1".month
  • Buffers: shared hit=1,331,917, temp read=2,335,518 written=2,001
3. 32.359 274,690.107 ↓ 1,005.6 5,028 1

Sort (cost=11,670,401.18..11,670,401.20 rows=5 width=556) (actual time=274,689.626..274,690.107 rows=5,028 loops=1)

  • Sort Key: "*SELECT* 1"."productCategoryId", "*SELECT* 1"."productCategoryName", "*SELECT* 1".month
  • Sort Method: quicksort Memory: 2,610kB
  • Buffers: shared hit=1,331,917, temp read=2,335,518 written=2,001
4. 5.872 274,657.748 ↓ 3,793.6 18,968 1

Append (cost=5,813,945.76..11,670,401.12 rows=5 width=556) (actual time=596.298..274,657.748 rows=18,968 loops=1)

  • Buffers: shared hit=1,331,917, temp read=2,335,518 written=2,001
5. 7.108 271,455.725 ↓ 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=596.298..271,455.725 rows=17,775 loops=1)

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

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

  • Buffers: shared hit=762,071, temp read=2,334,641 written=1,122
7. 35.486 271,297.388 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.61..5,820,383.56 rows=4 width=624) (actual time=596.278..271,297.388 rows=17,775 loops=1)

  • Buffers: shared hit=726,521, temp read=2,334,641 written=1,122
8. 34.895 271,226.352 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.47..5,820,374.89 rows=4 width=640) (actual time=596.263..271,226.352 rows=17,775 loops=1)

  • Buffers: shared hit=690,971, temp read=2,334,641 written=1,122
9. 33.090 271,138.132 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.32..5,820,366.21 rows=4 width=656) (actual time=596.252..271,138.132 rows=17,775 loops=1)

  • Buffers: shared hit=655,421, temp read=2,334,641 written=1,122
10. 20.152 271,051.717 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.18..5,820,357.53 rows=4 width=672) (actual time=596.240..271,051.717 rows=17,775 loops=1)

  • Buffers: shared hit=619,871, temp read=2,334,641 written=1,122
11. 33.339 271,031.565 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.03..5,820,349.31 rows=4 width=676) (actual time=596.224..271,031.565 rows=17,775 loops=1)

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

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

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

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

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

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

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

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

  • Buffers: shared hit=477,669, temp read=2,334,641 written=1,122
16. 73.622 270,647.995 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.33..5,820,335.94 rows=4 width=720) (actual time=596.152..270,647.995 rows=17,775 loops=1)

  • Buffers: shared hit=442,119, temp read=2,334,641 written=1,122
17. 32,627.951 270,485.498 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.19..5,820,335.31 rows=4 width=704) (actual time=596.135..270,485.498 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
18. 8.389 169.011 ↓ 4,168.0 4,168 1

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

  • Buffers: shared hit=24,170
19. 10.975 127.278 ↓ 4,168.0 4,168 1

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

  • Buffers: shared hit=15,834
20. 5.400 82.493 ↓ 2,415.0 2,415 1

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

  • Buffers: shared hit=4,392
21. 31.620 59.597 ↓ 972.0 972 1

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

  • Join Filter: (ic.id = p."industryCutId")
  • Rows Removed by Join Filter: 322,653
  • Buffers: shared hit=314
22. 10.717 10.717 ↓ 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.030..10.717 rows=4,315 loops=1)

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

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

  • Buffers: shared hit=94
24. 0.016 0.124 ↓ 37.5 75 1

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

  • Buffers: shared hit=94
25. 0.018 0.048 ↓ 20.0 20 1

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

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

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

  • Buffers: shared hit=1
27. 0.006 0.017 ↓ 5.0 5 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
28. 0.011 0.011 ↓ 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.009..0.011 rows=5 loops=1)

  • Index Cond: ("businessLineId" = '50578e14-1825-4003-978e-620e3495e915'::uuid)
  • Buffers: shared hit=2
29. 0.060 0.060 ↓ 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.002..0.003 rows=4 loops=20)

  • Index Cond: ("productSubcategoryId" = psc.id)
  • Buffers: shared hit=91
30. 17.496 17.496 ↑ 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.009..0.018 rows=2 loops=972)

  • Index Cond: ("productId" = p.id)
  • Buffers: shared hit=4,078
31. 33.810 33.810 ↑ 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.008..0.014 rows=2 loops=2,415)

  • Index Cond: ("productVariantId" = pv.id)
  • Buffers: shared hit=11,442
32. 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
33. 189,385.570 237,688.536 ↑ 1.2 94,087 4,168

Group (cost=5,813,934.62..5,816,797.42 rows=114,512 width=96) (actual time=0.143..57.027 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
34.          

Initplan (for Group)

35. 0.002 0.014 ↑ 1.0 1 1

Limit (cost=33.55..33.55 rows=1 width=24) (actual time=0.013..0.014 rows=1 loops=1)

  • Buffers: shared hit=1
36. 0.010 0.012 ↑ 1,570.0 1 1

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

  • Sort Key: fi_2."importedAt" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
37. 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
38. 47,864.882 48,302.952 ↑ 1.2 94,087 4,168

Sort (cost=5,813,901.07..5,814,187.35 rows=114,512 width=38) (actual time=0.142..11.589 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
39. 18.869 438.070 ↑ 1.2 94,087 1

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

  • Buffers: shared hit=382,399
40. 48.886 136.940 ↓ 1.6 94,087 1

Hash Full Join (cost=3,194.44..4,669,995.51 rows=57,257 width=56) (actual time=32.273..136.940 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
41. 38.407 55.823 ↑ 1,570.8 124,880 1

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

  • Buffers: shared hit=1,422
42. 17.416 17.416 ↑ 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.023..17.416 rows=124,880 loops=1)

  • Filter: ("forecastImportId" = $0)
  • Buffers: shared hit=1,421
43. 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
44. 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
45. 6.075 32.231 ↓ 51.7 30,500 1

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

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

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

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

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

  • Buffers: shared hit=1,342
48. 0.002 0.004 ↑ 1,270.0 1 1

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

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

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

  • Buffers: shared hit=1
50. 94.087 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
51. 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
52. 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
53. 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
54. 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
55. 35.550 35.550 ↑ 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.002..0.002 rows=1 loops=17,775)

  • Index Cond: (id = m."subregionId")
  • Buffers: shared hit=35,550
56. 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
57. 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
58. 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
59. 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
60. 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
61. 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
62. 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
63. 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
64. 35.550 35.550 ↑ 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.002..0.002 rows=1 loops=17,775)

  • Index Cond: (id = p."marketingFocusId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
65. 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
66. 0.243 3,196.151 ↓ 1,193.0 1,193 1

Subquery Scan on *SELECT* 2 (cost=5,829,472.02..5,850,008.76 rows=1 width=556) (actual time=781.205..3,196.151 rows=1,193 loops=1)

  • Buffers: shared hit=569,846, temp read=877 written=879
67. 2.592 3,195.908 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,472.02..5,850,008.75 rows=1 width=6,696) (actual time=781.204..3,195.908 rows=1,193 loops=1)

  • Buffers: shared hit=569,846, temp read=877 written=879
68. 1.478 3,192.123 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,471.88..5,850,008.35 rows=1 width=591) (actual time=781.184..3,192.123 rows=1,193 loops=1)

  • Buffers: shared hit=567,460, temp read=877 written=879
69. 1.517 3,189.452 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,471.74..5,850,008.18 rows=1 width=607) (actual time=781.171..3,189.452 rows=1,193 loops=1)

  • Buffers: shared hit=565,074, temp read=877 written=879
70. 0.296 3,186.742 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,471.59..5,850,008.00 rows=1 width=623) (actual time=781.158..3,186.742 rows=1,193 loops=1)

  • Buffers: shared hit=562,688, temp read=877 written=879
71. 0.465 3,184.060 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,471.45..5,850,007.83 rows=1 width=639) (actual time=781.149..3,184.060 rows=1,193 loops=1)

  • Buffers: shared hit=560,302, temp read=877 written=879
72. 1.695 3,181.209 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,471.30..5,850,007.66 rows=1 width=655) (actual time=781.139..3,181.209 rows=1,193 loops=1)

  • Buffers: shared hit=557,916, temp read=877 written=879
73. 1.005 3,178.321 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,471.15..5,850,007.48 rows=1 width=659) (actual time=781.125..3,178.321 rows=1,193 loops=1)

  • Buffers: shared hit=555,530, temp read=877 written=879
74. 1.049 3,176.123 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,471.01..5,850,006.54 rows=1 width=675) (actual time=781.111..3,176.123 rows=1,193 loops=1)

  • Buffers: shared hit=553,144, temp read=877 written=879
75. 0.000 3,173.881 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,470.87..5,850,006.38 rows=1 width=675) (actual time=781.101..3,173.881 rows=1,193 loops=1)

  • Buffers: shared hit=550,758, temp read=877 written=879
76. 1.511 3,301.005 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,470.74..5,850,006.11 rows=1 width=691) (actual time=878.384..3,301.005 rows=1,193 loops=1)

  • Buffers: shared hit=548,008 read=225, temp read=877 written=879
77. 1.503 3,298.301 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,470.59..5,850,005.11 rows=1 width=691) (actual time=878.372..3,298.301 rows=1,193 loops=1)

  • Buffers: shared hit=545,622 read=225, temp read=877 written=879
78. 1.489 3,295.605 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,470.45..5,850,004.95 rows=1 width=691) (actual time=878.361..3,295.605 rows=1,193 loops=1)

  • Buffers: shared hit=543,236 read=225, temp read=877 written=879
79. 48.390 3,292.923 ↓ 1,193.0 1,193 1

Nested Loop (cost=5,829,470.31..5,849,996.78 rows=1 width=707) (actual time=878.346..3,292.923 rows=1,193 loops=1)

  • Join Filter: (p_1."industryCutId" = ic_1.id)
  • Rows Removed by Join Filter: 642,907
  • Buffers: shared hit=540,850 read=225, temp read=877 written=879
80. 46.229 3,210.181 ↓ 209.5 8,588 1

Nested Loop (cost=5,829,461.86..5,849,984.37 rows=41 width=175) (actual time=859.276..3,210.181 rows=8,588 loops=1)

  • Buffers: shared hit=540,756 read=225, temp read=877 written=879
81. 46.839 3,146.776 ↓ 209.5 8,588 1

Nested Loop (cost=5,829,461.58..5,849,967.21 rows=41 width=91) (actual time=857.253..3,146.776 rows=8,588 loops=1)

  • Buffers: shared hit=515,027 read=190, temp read=877 written=879
82. 7.851 3,082.761 ↓ 209.5 8,588 1

Nested Loop (cost=5,829,461.29..5,849,954.06 rows=41 width=91) (actual time=856.464..3,082.761 rows=8,588 loops=1)

  • Buffers: shared hit=489,268 read=149, temp read=877 written=879
83. 11.386 3,057.734 ↓ 209.5 8,588 1

Nested Loop (cost=5,829,460.88..5,849,749.75 rows=41 width=75) (actual time=856.450..3,057.734 rows=8,588 loops=1)

  • Buffers: shared hit=454,894 read=149, temp read=877 written=879
84. 2.517 3,037.760 ↓ 209.5 8,588 1

Nested Loop (cost=5,829,460.74..5,849,661.06 rows=41 width=91) (actual time=856.440..3,037.760 rows=8,588 loops=1)

  • Buffers: shared hit=437,718 read=149, temp read=877 written=879
85. 11.063 3,018.067 ↓ 209.5 8,588 1

Nested Loop (cost=5,829,460.59..5,849,572.37 rows=41 width=107) (actual time=856.430..3,018.067 rows=8,588 loops=1)

  • Buffers: shared hit=420,542 read=149, temp read=877 written=879
86. 6.069 2,998.416 ↓ 209.5 8,588 1

Nested Loop (cost=5,829,460.45..5,849,483.68 rows=41 width=123) (actual time=856.419..2,998.416 rows=8,588 loops=1)

  • Buffers: shared hit=403,366 read=149, temp read=877 written=879
87. 1,301.248 2,975.171 ↓ 209.5 8,588 1

Nested Loop (cost=5,829,460.30..5,849,394.99 rows=41 width=139) (actual time=856.401..2,975.171 rows=8,588 loops=1)

  • Join Filter: (rf."marketProductVariantId" = mpvsbe."parentMarketProductVariantId")
  • Rows Removed by Join Filter: 15,461,308
  • Buffers: shared hit=386,190 read=149, temp read=877 written=879
88. 2.986 968.127 ↓ 12.7 7,202 1

Nested Loop (cost=5,829,460.30..5,831,095.84 rows=565 width=144) (actual time=840.243..968.127 rows=7,202 loops=1)

  • Buffers: shared hit=386,190 read=81, temp read=877 written=879
89. 35.938 965.141 ↓ 12.7 7,202 1

Nested Loop (cost=5,829,460.16..5,831,080.61 rows=565 width=148) (actual time=840.225..965.141 rows=7,202 loops=1)

  • Join Filter: (sb_2.id = p_2."subBrandId")
  • Rows Removed by Join Filter: 446,524
  • Buffers: shared hit=386,188 read=81, temp read=877 written=879
90. 46.339 907.597 ↓ 12.7 7,202 1

Nested Loop (cost=5,829,447.01..5,830,530.58 rows=565 width=164) (actual time=840.169..907.597 rows=7,202 loops=1)

  • Join Filter: (m_2.id = mpv_3."marketId")
  • Rows Removed by Join Filter: 410,514
  • Buffers: shared hit=386,185 read=81, temp read=877 written=879
91. 0.118 0.306 ↑ 1.0 58 1

Merge Join (cost=22.81..23.93 rows=59 width=48) (actual time=0.139..0.306 rows=58 loops=1)

  • Merge Cond: (m_2."currencyId" = c_2.id)
  • Buffers: shared hit=6
92. 0.060 0.153 ↑ 1.0 59 1

Sort (cost=19.90..20.05 rows=59 width=32) (actual time=0.117..0.153 rows=59 loops=1)

  • Sort Key: m_2."currencyId
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=5
93. 0.028 0.093 ↑ 1.0 59 1

Hash Join (cost=14.26..18.16 rows=59 width=32) (actual time=0.057..0.093 rows=59 loops=1)

  • Hash Cond: (sr_2."regionId" = r_2.id)
  • Buffers: shared hit=5
94. 0.018 0.047 ↑ 1.0 59 1

Hash Join (cost=13.15..16.89 rows=59 width=48) (actual time=0.022..0.047 rows=59 loops=1)

  • Hash Cond: (m_2."subregionId" = sr_2.id)
  • Buffers: shared hit=4
95. 0.017 0.017 ↑ 1.0 59 1

Seq Scan on "Market" m_2 (cost=0.00..3.59 rows=59 width=48) (actual time=0.004..0.017 rows=59 loops=1)

  • Buffers: shared hit=3
96. 0.004 0.012 ↑ 10.0 14 1

Hash (cost=11.40..11.40 rows=140 width=32) (actual time=0.011..0.012 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
97. 0.008 0.008 ↑ 10.0 14 1

Seq Scan on "Subregion" sr_2 (cost=0.00..11.40 rows=140 width=32) (actual time=0.006..0.008 rows=14 loops=1)

  • Buffers: shared hit=1
98. 0.004 0.018 ↓ 1.2 6 1

Hash (cost=1.05..1.05 rows=5 width=16) (actual time=0.018..0.018 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
99. 0.014 0.014 ↓ 1.2 6 1

Seq Scan on "Region" r_2 (cost=0.00..1.05 rows=5 width=16) (actual time=0.013..0.014 rows=6 loops=1)

  • Buffers: shared hit=1
100. 0.027 0.035 ↑ 1.0 50 1

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

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

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

  • Buffers: shared hit=1
102. 24.935 860.952 ↓ 12.7 7,202 58

Materialize (cost=5,829,424.20..5,830,008.04 rows=565 width=148) (actual time=14.006..14.844 rows=7,202 loops=58)

  • Buffers: shared hit=386,179 read=81, temp read=877 written=879
103. 11.089 836.017 ↓ 12.7 7,202 1

Merge Join (cost=5,829,424.20..5,830,005.22 rows=565 width=148) (actual time=812.327..836.017 rows=7,202 loops=1)

  • Merge Cond: (rf."marketProductVariantId" = mpv_3.id)
  • Buffers: shared hit=386,179 read=81, temp read=877 written=879
104. 67.901 728.443 ↑ 1.2 94,083 1

Sort (cost=5,828,767.87..5,829,054.15 rows=114,512 width=32) (actual time=716.389..728.443 rows=94,083 loops=1)

  • Sort Key: rf."marketProductVariantId
  • Sort Method: external merge Disk: 3,504kB
  • Buffers: shared hit=382,399, temp read=877 written=879
105. 9.338 660.542 ↑ 1.2 94,087 1

Subquery Scan on rf (cost=5,813,542.62..5,816,405.42 rows=114,512 width=32) (actual time=623.106..660.542 rows=94,087 loops=1)

  • Buffers: shared hit=382,399, temp read=439 written=440
106. 17.872 651.204 ↑ 1.2 94,087 1

Group (cost=5,813,542.62..5,815,260.30 rows=114,512 width=96) (actual time=623.105..651.204 rows=94,087 loops=1)

  • 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=439 written=440
107.          

Initplan (for Group)

108. 0.002 0.020 ↑ 1.0 1 1

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

  • Buffers: shared hit=1
109. 0.015 0.018 ↑ 1,570.0 1 1

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

  • Sort Key: fi_3."importedAt" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
110. 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
111. 158.777 633.312 ↑ 1.2 94,087 1

Sort (cost=5,813,509.07..5,813,795.35 rows=114,512 width=32) (actual time=623.101..633.312 rows=94,087 loops=1)

  • 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 merge Disk: 3,512kB
  • Buffers: shared hit=382,399, temp read=439 written=440
112. 42.366 474.535 ↑ 1.2 94,087 1

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

  • Buffers: shared hit=382,399
113. 58.888 149.908 ↓ 1.6 94,087 1

Hash Full Join (cost=3,194.44..4,669,995.51 rows=57,257 width=56) (actual time=31.303..149.908 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
114. 40.559 59.766 ↑ 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..59.766 rows=124,880 loops=1)

  • Buffers: shared hit=1,422
115. 19.207 19.207 ↑ 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.031..19.207 rows=124,880 loops=1)

  • Filter: ("forecastImportId" = $1)
  • Buffers: shared hit=1,421
116. 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
117. 0.001 0.001 ↑ 1,570.0 1 1

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

  • Buffers: shared hit=1
118. 5.889 31.254 ↓ 51.7 30,500 1

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

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

Hash Join (cost=41.75..3,184.12 rows=590 width=28) (actual time=0.014..25.365 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
120. 9.606 9.606 ↑ 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.004..9.606 rows=118,009 loops=1)

  • Buffers: shared hit=1,342
121. 0.002 0.004 ↑ 1,270.0 1 1

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

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

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

  • Buffers: shared hit=1
123. 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
124. 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
125. 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
126. 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
127. 1.692 96.485 ↓ 57.6 8,416 1

Sort (cost=656.33..656.69 rows=146 width=116) (actual time=95.895..96.485 rows=8,416 loops=1)

  • Sort Key: mpv_3.id
  • Sort Method: quicksort Memory: 672kB
  • Buffers: shared hit=3,780 read=81
128. 0.424 94.793 ↓ 14.8 2,168 1

Nested Loop (cost=341.49..651.08 rows=146 width=116) (actual time=5.654..94.793 rows=2,168 loops=1)

  • Buffers: shared hit=3,780 read=81
129. 0.186 8.179 ↓ 15.4 663 1

Hash Join (cost=341.08..541.05 rows=43 width=100) (actual time=4.901..8.179 rows=663 loops=1)

  • Hash Cond: (pc_2."businessLineId" = bl_2.id)
  • Buffers: shared hit=172 read=4
130. 0.194 7.977 ↓ 15.4 663 1

Hash Join (cost=327.93..527.78 rows=43 width=116) (actual time=4.872..7.977 rows=663 loops=1)

  • Hash Cond: (psc_2."productCategoryId" = pc_2.id)
  • Buffers: shared hit=171 read=4
131. 0.200 7.764 ↓ 15.4 663 1

Hash Join (cost=314.78..514.52 rows=43 width=116) (actual time=4.843..7.764 rows=663 loops=1)

  • Hash Cond: (ic_2."productSubcategoryId" = psc_2.id)
  • Buffers: shared hit=170 read=4
132. 0.207 7.534 ↓ 15.4 663 1

Hash Join (cost=311.53..511.16 rows=43 width=116) (actual time=4.809..7.534 rows=663 loops=1)

  • Hash Cond: (p_2."industryCutId" = ic_2.id)
  • Buffers: shared hit=169 read=4
133. 1.198 7.253 ↓ 15.4 663 1

Hash Join (cost=303.42..502.94 rows=43 width=116) (actual time=4.725..7.253 rows=663 loops=1)

  • Hash Cond: (pv_2."productId" = p_2.id)
  • Buffers: shared hit=166 read=4
134. 1.346 1.346 ↓ 1.0 8,699 1

Seq Scan on "ProductVariant" pv_2 (cost=0.00..176.73 rows=8,673 width=32) (actual time=0.006..1.346 rows=8,699 loops=1)

  • Buffers: shared hit=90
135. 0.125 4.709 ↓ 22.9 549 1

Hash (cost=303.12..303.12 rows=24 width=132) (actual time=4.709..4.709 rows=549 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 92kB
  • Buffers: shared hit=76 read=4
136. 4.584 4.584 ↓ 22.9 549 1

Seq Scan on "Product" p_2 (cost=0.00..303.12 rows=24 width=132) (actual time=1.558..4.584 rows=549 loops=1)

  • Filter: ((type)::text = 'salesBundle'::text)
  • Rows Removed by Filter: 4,315
  • Buffers: shared hit=76 read=4
137. 0.035 0.074 ↑ 1.0 227 1

Hash (cost=5.27..5.27 rows=227 width=32) (actual time=0.074..0.074 rows=227 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared hit=3
138. 0.039 0.039 ↑ 1.0 227 1

Seq Scan on "IndustryCut" ic_2 (cost=0.00..5.27 rows=227 width=32) (actual time=0.007..0.039 rows=227 loops=1)

  • Buffers: shared hit=3
139. 0.016 0.030 ↑ 1.0 100 1

Hash (cost=2.00..2.00 rows=100 width=32) (actual time=0.030..0.030 rows=100 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=1
140. 0.014 0.014 ↑ 1.0 100 1

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

  • Buffers: shared hit=1
141. 0.008 0.019 ↑ 3.7 38 1

Hash (cost=11.40..11.40 rows=140 width=32) (actual time=0.019..0.019 rows=38 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
142. 0.011 0.011 ↑ 3.7 38 1

Seq Scan on "ProductCategory" pc_2 (cost=0.00..11.40 rows=140 width=32) (actual time=0.007..0.011 rows=38 loops=1)

  • Buffers: shared hit=1
143. 0.005 0.016 ↑ 20.0 7 1

Hash (cost=11.40..11.40 rows=140 width=16) (actual time=0.016..0.016 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
144. 0.011 0.011 ↑ 20.0 7 1

Seq Scan on "BusinessLine" bl_2 (cost=0.00..11.40 rows=140 width=16) (actual time=0.009..0.011 rows=7 loops=1)

  • Buffers: shared hit=1
145. 86.190 86.190 ↑ 1.0 3 663

Index Scan using marketproductvariant_productvariantid_marketid_unique on "MarketProductVariant" mpv_3 (cost=0.41..2.53 rows=3 width=48) (actual time=0.093..0.130 rows=3 loops=663)

  • Index Cond: ("productVariantId" = pv_2.id)
  • Buffers: shared hit=3,608 read=77
146. 21.532 21.606 ↑ 1.0 63 7,202

Materialize (cost=13.15..16.26 rows=63 width=16) (actual time=0.000..0.003 rows=63 loops=7,202)

  • Buffers: shared hit=3
147. 0.028 0.074 ↑ 1.0 63 1

Hash Join (cost=13.15..15.95 rows=63 width=16) (actual time=0.046..0.074 rows=63 loops=1)

  • Hash Cond: (sb_2."brandId" = b_2.id)
  • Buffers: shared hit=3
148. 0.025 0.025 ↑ 1.0 63 1

Seq Scan on "SubBrand" sb_2 (cost=0.00..2.63 rows=63 width=32) (actual time=0.012..0.025 rows=63 loops=1)

  • Buffers: shared hit=2
149. 0.014 0.021 ↑ 4.2 33 1

Hash (cost=11.40..11.40 rows=140 width=16) (actual time=0.021..0.021 rows=33 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
150. 0.007 0.007 ↑ 4.2 33 1

Seq Scan on "Brand" b_2 (cost=0.00..11.40 rows=140 width=16) (actual time=0.004..0.007 rows=33 loops=1)

  • Buffers: shared hit=1
151. 0.000 0.000 ↑ 1.0 1 7,202

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

  • Buffers: shared hit=2
152. 0.012 0.012 ↑ 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.012..0.012 rows=1 loops=1)

  • Index Cond: (name = 'salesBundle'::text)
  • Heap Fetches: 1
  • Buffers: shared hit=2
153. 705.440 705.796 ↑ 1.0 2,148 7,202

Materialize (cost=0.00..100.22 rows=2,148 width=43) (actual time=0.000..0.098 rows=2,148 loops=7,202)

  • Buffers: shared hit=68
154. 0.356 0.356 ↑ 1.0 2,148 1

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

  • Buffers: shared hit=68
155. 17.176 17.176 ↑ 1.0 1 8,588

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=8,588)

  • Index Cond: (id = p_2."formId")
  • Heap Fetches: 8,588
  • Buffers: shared hit=17,176
156. 8.588 8.588 ↑ 1.0 1 8,588

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

  • Index Cond: (id = p_2."demographicId")
  • Heap Fetches: 8,588
  • Buffers: shared hit=17,176
157. 17.176 17.176 ↑ 1.0 1 8,588

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=8,588)

  • Index Cond: (id = p_2."marketingManagedId")
  • Heap Fetches: 8,588
  • Buffers: shared hit=17,176
158. 8.588 8.588 ↑ 1.0 1 8,588

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

  • Index Cond: (id = p_2."marketingFocusId")
  • Heap Fetches: 8,588
  • Buffers: shared hit=17,176
159. 17.176 17.176 ↑ 1.0 1 8,588

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=8,588)

  • Index Cond: (id = mpvsbe."marketProductVariantId")
  • Buffers: shared hit=34,374
160. 17.176 17.176 ↑ 1.0 1 8,588

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=8,588)

  • Index Cond: (id = mpv_2."productVariantId")
  • Buffers: shared hit=25,800
161. 17.176 17.176 ↑ 1.0 1 8,588

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=8,588)

  • Index Cond: (id = pv_1."productId")
  • Buffers: shared hit=25,764
162. 34.223 34.352 ↓ 37.5 75 8,588

Materialize (cost=8.44..11.18 rows=2 width=564) (actual time=0.000..0.004 rows=75 loops=8,588)

  • Buffers: shared hit=94
163. 0.024 0.129 ↓ 37.5 75 1

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

  • Buffers: shared hit=94
164. 0.019 0.045 ↓ 20.0 20 1

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

  • Hash Cond: (psc_1."productCategoryId" = pc_1.id)
  • Buffers: shared hit=3
165. 0.015 0.015 ↑ 1.0 100 1

Seq Scan on "ProductSubcategory" psc_1 (cost=0.00..2.00 rows=100 width=32) (actual time=0.006..0.015 rows=100 loops=1)

  • Buffers: shared hit=1
166. 0.003 0.011 ↓ 5.0 5 1

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

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

Index Scan using productcategory_businesslineid_name_unique on "ProductCategory" pc_1 (cost=0.14..8.16 rows=1 width=548) (actual time=0.006..0.008 rows=5 loops=1)

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

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

  • Index Cond: ("productSubcategoryId" = psc_1.id)
  • Buffers: shared hit=91
169. 1.193 1.193 ↑ 1.0 1 1,193

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

  • Index Cond: (id = '50578e14-1825-4003-978e-620e3495e915'::uuid)
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
170. 1.193 1.193 ↑ 1.0 1 1,193

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,193)

  • Index Cond: (id = mpv_2."marketId")
  • Filter: (NOT "isHidden")
  • Buffers: shared hit=2,386
171. 1.193 1.193 ↑ 1.0 1 1,193

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,193)

  • Index Cond: (id = "Market"."subregionId")
  • Buffers: shared hit=2,386
172. 2.386 2.386 ↑ 1.0 1 1,193

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,193)

  • Index Cond: (id = sr_1."regionId")
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
173. 1.193 1.193 ↑ 1.0 1 1,193

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,193)

  • Index Cond: (id = p_1."subBrandId")
  • Buffers: shared hit=2,386
174. 1.193 1.193 ↑ 1.0 1 1,193

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,193)

  • Index Cond: (id = sb_1."brandId")
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
175. 1.193 1.193 ↑ 1.0 1 1,193

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

  • Index Cond: (name = (p_1.type)::text)
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
176. 2.386 2.386 ↑ 1.0 1 1,193

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,193)

  • Index Cond: (id = p_1."formId")
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
177. 2.386 2.386 ↑ 1.0 1 1,193

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,193)

  • Index Cond: (id = p_1."demographicId")
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
178. 1.193 1.193 ↑ 1.0 1 1,193

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

  • Index Cond: (id = p_1."marketingManagedId")
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
179. 1.193 1.193 ↑ 1.0 1 1,193

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

  • Index Cond: (id = p_1."marketingFocusId")
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
180. 1.193 1.193 ↑ 1.0 1 1,193

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,193)

  • Index Cond: (id = m_2."currencyId")
  • Buffers: shared hit=2,386
Planning time : 21.247 ms
Execution time : 225,367.764 ms