explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pjcb

Settings
# exclusive inclusive rows x rows loops node
1. 6.581 278,714.665 ↓ 7.7 231 1

GroupAggregate (cost=11,670,529.70..11,670,530.52 rows=30 width=556) (actual time=278,706.251..278,714.665 rows=231 loops=1)

  • Group Key: "*SELECT* 1"."productCategoryId", "*SELECT* 1"."productCategoryName", "*SELECT* 1".year, "*SELECT* 1".month
  • Buffers: shared hit=1,526,495, temp read=2,335,518 written=2,001
2. 41.625 278,708.084 ↓ 878.8 26,363 1

Sort (cost=11,670,529.70..11,670,529.77 rows=30 width=556) (actual time=278,706.239..278,708.084 rows=26,363 loops=1)

  • Sort Key: "*SELECT* 1"."productCategoryId", "*SELECT* 1"."productCategoryName", "*SELECT* 1".month
  • Sort Method: quicksort Memory: 3,190kB
  • Buffers: shared hit=1,526,495, temp read=2,335,518 written=2,001
3. 7.527 278,666.459 ↓ 878.8 26,363 1

Append (cost=5,813,945.76..11,670,528.96 rows=30 width=556) (actual time=746.837..278,666.459 rows=26,363 loops=1)

  • Buffers: shared hit=1,526,489, temp read=2,335,518 written=2,001
4. 8.050 275,299.677 ↓ 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=746.836..275,299.677 rows=17,775 loops=1)

  • Buffers: shared hit=762,079, temp read=2,334,641 written=1,122
5. 82.176 275,291.627 ↓ 4,443.8 17,775 1

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

  • Buffers: shared hit=762,079, temp read=2,334,641 written=1,122
6. 30.382 275,156.126 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.61..5,820,383.56 rows=4 width=624) (actual time=746.808..275,156.126 rows=17,775 loops=1)

  • Buffers: shared hit=726,529, temp read=2,334,641 written=1,122
7. 28.947 275,072.419 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.47..5,820,374.89 rows=4 width=640) (actual time=746.794..275,072.419 rows=17,775 loops=1)

  • Buffers: shared hit=690,979, temp read=2,334,641 written=1,122
8. 27.905 274,990.147 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.32..5,820,366.21 rows=4 width=656) (actual time=746.779..274,990.147 rows=17,775 loops=1)

  • Buffers: shared hit=655,429, temp read=2,334,641 written=1,122
9. 20.579 274,908.917 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.18..5,820,357.53 rows=4 width=672) (actual time=746.766..274,908.917 rows=17,775 loops=1)

  • Buffers: shared hit=619,879, temp read=2,334,641 written=1,122
10. 40.056 274,888.338 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,945.03..5,820,349.31 rows=4 width=676) (actual time=746.735..274,888.338 rows=17,775 loops=1)

  • Buffers: shared hit=619,877, temp read=2,334,641 written=1,122
11. 36.407 274,812.732 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.89..5,820,347.86 rows=4 width=688) (actual time=746.726..274,812.732 rows=17,775 loops=1)

  • Buffers: shared hit=584,327, temp read=2,334,641 written=1,122
12. 36.983 274,740.775 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.75..5,820,344.15 rows=4 width=704) (actual time=746.710..274,740.775 rows=17,775 loops=1)

  • Buffers: shared hit=548,777, temp read=2,334,641 written=1,122
13. 41.959 274,668.242 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.61..5,820,340.83 rows=4 width=704) (actual time=746.699..274,668.242 rows=17,775 loops=1)

  • Buffers: shared hit=513,227, temp read=2,334,641 written=1,122
14. 36.988 274,572.958 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.47..5,820,339.86 rows=4 width=720) (actual time=746.673..274,572.958 rows=17,775 loops=1)

  • Buffers: shared hit=477,677, temp read=2,334,641 written=1,122
15. 51.740 274,482.645 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.33..5,820,335.94 rows=4 width=720) (actual time=746.659..274,482.645 rows=17,775 loops=1)

  • Buffers: shared hit=442,127, temp read=2,334,641 written=1,122
16. 32,657.802 274,342.030 ↓ 4,443.8 17,775 1

Nested Loop (cost=5,813,944.19..5,820,335.31 rows=4 width=704) (actual time=746.638..274,342.030 rows=17,775 loops=1)

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

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

  • Buffers: shared hit=24,175
18. 10.679 141.361 ↓ 4,168.0 4,168 1

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

  • Buffers: shared hit=15,839
19. 5.106 89.627 ↓ 2,415.0 2,415 1

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

  • Buffers: shared hit=4,397
20. 32.553 65.081 ↓ 972.0 972 1

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

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

  • Filter: ((type)::text = 'finishedGood'::text)
  • Rows Removed by Filter: 549
  • Buffers: shared hit=225
22. 21.377 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.031 0.198 ↓ 37.5 75 1

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

  • Buffers: shared hit=94
24. 0.030 0.067 ↓ 20.0 20 1

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

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

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

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
27. 0.010 0.010 ↓ 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.010 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. 41.055 41.055 ↑ 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.017 rows=2 loops=2,415)

  • Index Cond: ("productVariantId" = pv.id)
  • Buffers: shared hit=11,442
31. 37.512 37.512 ↑ 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.009 rows=1 loops=4,168)

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

Group (cost=5,813,934.62..5,816,797.42 rows=114,512 width=96) (actual time=0.179..57.940 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,402, temp read=2,330,474 written=1,122
33.          

Initplan (for Group)

34. 0.002 0.043 ↑ 1.0 1 1

Limit (cost=33.55..33.55 rows=1 width=24) (actual time=0.042..0.043 rows=1 loops=1)

  • Buffers: shared hit=4
35. 0.036 0.041 ↑ 1,570.0 1 1

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

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

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

  • Buffers: shared hit=1
37. 49,123.675 49,678.392 ↑ 1.2 94,087 4,168

Sort (cost=5,813,901.07..5,814,187.35 rows=114,512 width=38) (actual time=0.178..11.919 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,402, temp read=2,330,474 written=1,122
38. 98.272 554.717 ↑ 1.2 94,087 1

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

  • Buffers: shared hit=382,402
39. 64.972 174.184 ↓ 1.6 94,087 1

Hash Full Join (cost=3,194.44..4,669,995.51 rows=57,257 width=56) (actual time=36.272..174.184 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,768
40. 49.212 73.008 ↑ 1,570.8 124,880 1

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

  • Buffers: shared hit=1,425
41. 23.796 23.796 ↑ 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.049..23.796 rows=124,880 loops=1)

  • Filter: ("forecastImportId" = $0)
  • Buffers: shared hit=1,424
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.739 36.204 ↓ 51.7 30,500 1

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

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

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

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

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

  • Buffers: shared hit=1,342
47. 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
48. 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
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.027 0.027 ↑ 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.026..0.027 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. 1.558 3,359.255 ↓ 330.3 8,588 1

Subquery Scan on *SELECT* 2 (cost=5,829,465.86..5,850,136.60 rows=26 width=556) (actual time=730.736..3,359.255 rows=8,588 loops=1)

  • Buffers: shared hit=764,410, temp read=877 written=879
66. 13.065 3,357.697 ↓ 330.3 8,588 1

Hash Join (cost=5,829,465.86..5,850,136.34 rows=26 width=6,696) (actual time=730.735..3,357.697 rows=8,588 loops=1)

  • Hash Cond: (m_2."currencyId" = c_1.id)
  • Buffers: shared hit=764,410, temp read=877 written=879
67. 2.483 3,344.608 ↓ 330.3 8,588 1

Nested Loop (cost=5,829,463.74..5,850,133.22 rows=26 width=591) (actual time=730.681..3,344.608 rows=8,588 loops=1)

  • Buffers: shared hit=764,409, temp read=877 written=879
68. 2.885 3,324.949 ↓ 330.3 8,588 1

Nested Loop (cost=5,829,463.59..5,850,128.74 rows=26 width=607) (actual time=730.672..3,324.949 rows=8,588 loops=1)

  • Buffers: shared hit=747,233, temp read=877 written=879
69. 2.874 3,304.888 ↓ 330.3 8,588 1

Nested Loop (cost=5,829,463.45..5,850,124.26 rows=26 width=623) (actual time=730.665..3,304.888 rows=8,588 loops=1)

  • Buffers: shared hit=730,057, temp read=877 written=879
70. 4.235 3,284.838 ↓ 330.3 8,588 1

Nested Loop (cost=5,829,463.30..5,850,119.78 rows=26 width=639) (actual time=730.656..3,284.838 rows=8,588 loops=1)

  • Buffers: shared hit=712,881, temp read=877 written=879
71. 6.801 3,263.427 ↓ 330.3 8,588 1

Nested Loop (cost=5,829,463.16..5,850,115.29 rows=26 width=655) (actual time=730.649..3,263.427 rows=8,588 loops=1)

  • Buffers: shared hit=695,705, temp read=877 written=879
72. 8.147 3,248.038 ↓ 330.3 8,588 1

Nested Loop (cost=5,829,463.01..5,850,091.25 rows=26 width=671) (actual time=730.641..3,248.038 rows=8,588 loops=1)

  • Buffers: shared hit=678,529, temp read=877 written=879
73. 6.414 3,231.303 ↓ 330.3 8,588 1

Nested Loop (cost=5,829,462.87..5,850,087.07 rows=26 width=671) (actual time=730.632..3,231.303 rows=8,588 loops=1)

  • Join Filter: (sr_1."regionId" = r_1.id)
  • Rows Removed by Join Filter: 20,772
  • Buffers: shared hit=661,353, temp read=877 written=879
74. 9.105 3,224.889 ↓ 330.3 8,588 1

Nested Loop (cost=5,829,462.87..5,850,084.06 rows=26 width=687) (actual time=730.622..3,224.889 rows=8,588 loops=1)

  • Buffers: shared hit=661,352, temp read=877 written=879
75. 11.838 3,207.196 ↓ 330.3 8,588 1

Nested Loop (cost=5,829,462.73..5,850,058.30 rows=26 width=687) (actual time=730.612..3,207.196 rows=8,588 loops=1)

  • Buffers: shared hit=644,176, temp read=877 written=879
76. 7.173 3,186.770 ↓ 214.7 8,588 1

Nested Loop (cost=5,829,462.58..5,850,051.21 rows=40 width=691) (actual time=730.599..3,186.770 rows=8,588 loops=1)

  • Buffers: shared hit=627,000, temp read=877 written=879
77. 7.732 3,171.009 ↓ 214.7 8,588 1

Nested Loop (cost=5,829,462.43..5,850,030.99 rows=40 width=707) (actual time=730.590..3,171.009 rows=8,588 loops=1)

  • Buffers: shared hit=609,824, temp read=877 written=879
78. 7.736 3,154.689 ↓ 214.7 8,588 1

Nested Loop (cost=5,829,462.29..5,850,005.28 rows=40 width=175) (actual time=730.577..3,154.689 rows=8,588 loops=1)

  • Buffers: shared hit=592,648, temp read=877 written=879
79. 8.743 3,138.365 ↓ 214.7 8,588 1

Nested Loop (cost=5,829,462.15..5,849,996.76 rows=40 width=175) (actual time=730.568..3,138.365 rows=8,588 loops=1)

  • Buffers: shared hit=575,472, temp read=877 written=879
80. 6.150 3,121.034 ↓ 214.7 8,588 1

Nested Loop (cost=5,829,462.00..5,849,990.10 rows=40 width=175) (actual time=730.556..3,121.034 rows=8,588 loops=1)

  • Buffers: shared hit=558,296, temp read=877 written=879
81. 5.111 3,097.708 ↓ 214.7 8,588 1

Nested Loop (cost=5,829,461.72..5,849,973.36 rows=40 width=91) (actual time=730.543..3,097.708 rows=8,588 loops=1)

  • Buffers: shared hit=532,532, temp read=877 written=879
82. 8.133 3,075.421 ↓ 214.7 8,588 1

Nested Loop (cost=5,829,461.43..5,849,960.53 rows=40 width=91) (actual time=730.532..3,075.421 rows=8,588 loops=1)

  • Buffers: shared hit=506,732, temp read=877 written=879
83. 9.308 3,058.700 ↓ 209.5 8,588 1

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

  • Buffers: shared hit=489,556, temp read=877 written=879
84. 9.649 3,032.216 ↓ 209.5 8,588 1

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

  • Buffers: shared hit=455,182, temp read=877 written=879
85. 9.815 3,013.979 ↓ 209.5 8,588 1

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

  • Buffers: shared hit=438,006, temp read=877 written=879
86. 10.053 2,995.576 ↓ 209.5 8,588 1

Nested Loop (cost=5,829,460.59..5,849,572.37 rows=41 width=107) (actual time=730.483..2,995.576 rows=8,588 loops=1)

  • Buffers: shared hit=420,830, temp read=877 written=879
87. 4.704 2,976.935 ↓ 209.5 8,588 1

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

  • Buffers: shared hit=403,654, temp read=877 written=879
88. 1,353.928 2,955.055 ↓ 209.5 8,588 1

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

  • Join Filter: (rf."marketProductVariantId" = mpvsbe."parentMarketProductVariantId")
  • Rows Removed by Join Filter: 15,461,308
  • Buffers: shared hit=386,478, temp read=877 written=879
89. 3.031 859.321 ↓ 12.7 7,202 1

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

  • Buffers: shared hit=386,410, temp read=877 written=879
90. 37.763 856.290 ↓ 12.7 7,202 1

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

  • Join Filter: (sb_2.id = p_2."subBrandId")
  • Rows Removed by Join Filter: 446,524
  • Buffers: shared hit=386,408, temp read=877 written=879
91. 47.418 796.921 ↓ 12.7 7,202 1

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

  • Join Filter: (m_2.id = mpv_3."marketId")
  • Rows Removed by Join Filter: 410,514
  • Buffers: shared hit=386,405, temp read=877 written=879
92. 0.107 0.259 ↑ 1.0 58 1

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

  • Merge Cond: (m_2."currencyId" = c_2.id)
  • Buffers: shared hit=6
93. 0.050 0.119 ↑ 1.0 59 1

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

  • Sort Key: m_2."currencyId
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=5
94. 0.015 0.069 ↑ 1.0 59 1

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

  • Hash Cond: (sr_2."regionId" = r_2.id)
  • Buffers: shared hit=5
95. 0.022 0.046 ↑ 1.0 59 1

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

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

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

  • Buffers: shared hit=3
97. 0.003 0.009 ↑ 10.0 14 1

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

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

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

  • Buffers: shared hit=1
99. 0.002 0.008 ↓ 1.2 6 1

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

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

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

  • Buffers: shared hit=1
101. 0.028 0.033 ↑ 1.0 50 1

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

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

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

  • Buffers: shared hit=1
103. 25.155 749.244 ↓ 12.7 7,202 58

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

  • Buffers: shared hit=386,399, temp read=877 written=879
104. 10.616 724.089 ↓ 12.7 7,202 1

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

  • Merge Cond: (rf."marketProductVariantId" = mpv_3.id)
  • Buffers: shared hit=386,399, temp read=877 written=879
105. 68.703 703.949 ↑ 1.2 94,083 1

Sort (cost=5,828,767.87..5,829,054.15 rows=114,512 width=32) (actual time=692.321..703.949 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
106. 9.594 635.246 ↑ 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=596.633..635.246 rows=94,087 loops=1)

  • Buffers: shared hit=382,399, temp read=439 written=440
107. 18.673 625.652 ↑ 1.2 94,087 1

Group (cost=5,813,542.62..5,815,260.30 rows=114,512 width=96) (actual time=596.632..625.652 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
108.          

Initplan (for Group)

109. 0.003 0.017 ↑ 1.0 1 1

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

  • Buffers: shared hit=1
110. 0.011 0.014 ↑ 1,570.0 1 1

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

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

Sort (cost=5,813,509.07..5,813,795.35 rows=114,512 width=32) (actual time=596.629..606.962 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
113. 28.797 457.048 ↑ 1.2 94,087 1

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

  • Buffers: shared hit=382,399
114. 54.295 145.990 ↓ 1.6 94,087 1

Hash Full Join (cost=3,194.44..4,669,995.51 rows=57,257 width=56) (actual time=34.507..145.990 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
115. 38.932 57.234 ↑ 1,570.8 124,880 1

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

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

  • Filter: ("forecastImportId" = $1)
  • Buffers: shared hit=1,421
117. 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
118. 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
119. 6.293 34.461 ↓ 51.7 30,500 1

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

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

Hash Join (cost=41.75..3,184.12 rows=590 width=28) (actual time=0.018..28.168 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
121. 10.824 10.824 ↑ 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.006..10.824 rows=118,009 loops=1)

  • Buffers: shared hit=1,342
122. 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
123. 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
124. 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
125. 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
126. 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
127. 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
128. 1.302 9.524 ↓ 57.6 8,416 1

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

  • Sort Key: mpv_3.id
  • Sort Method: quicksort Memory: 672kB
  • Buffers: shared hit=4,000
129. 0.719 8.222 ↓ 14.8 2,168 1

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

  • Buffers: shared hit=4,000
130. 0.160 4.188 ↓ 15.4 663 1

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

  • Hash Cond: (pc_2."businessLineId" = bl_2.id)
  • Buffers: shared hit=314
131. 0.154 4.014 ↓ 15.4 663 1

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

  • Hash Cond: (psc_2."productCategoryId" = pc_2.id)
  • Buffers: shared hit=313
132. 0.154 3.846 ↓ 15.4 663 1

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

  • Hash Cond: (ic_2."productSubcategoryId" = psc_2.id)
  • Buffers: shared hit=312
133. 0.169 3.664 ↓ 15.4 663 1

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

  • Hash Cond: (p_2."industryCutId" = ic_2.id)
  • Buffers: shared hit=311
134. 0.950 3.427 ↓ 15.4 663 1

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

  • Hash Cond: (pv_2."productId" = p_2.id)
  • Buffers: shared hit=308
135. 1.018 1.018 ↓ 1.0 8,699 1

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

  • Buffers: shared hit=90
136. 0.134 1.459 ↓ 22.9 549 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 92kB
  • Buffers: shared hit=218
137. 1.325 1.325 ↓ 22.9 549 1

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

  • Filter: ((type)::text = 'salesBundle'::text)
  • Rows Removed by Filter: 4,315
  • Buffers: shared hit=218
138. 0.036 0.068 ↑ 1.0 227 1

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

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

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

  • Buffers: shared hit=3
140. 0.014 0.028 ↑ 1.0 100 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=1
141. 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
142. 0.006 0.014 ↑ 3.7 38 1

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

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

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

  • Buffers: shared hit=1
144. 0.004 0.014 ↑ 20.0 7 1

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

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

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

  • Buffers: shared hit=1
146. 3.315 3.315 ↑ 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.003..0.005 rows=3 loops=663)

  • Index Cond: ("productVariantId" = pv_2.id)
  • Buffers: shared hit=3,686
147. 21.543 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
148. 0.027 0.063 ↑ 1.0 63 1

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

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

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

  • Buffers: shared hit=2
150. 0.008 0.016 ↑ 4.2 33 1

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

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

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

  • Buffers: shared hit=1
152. 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
153. 0.020 0.020 ↑ 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.019..0.020 rows=1 loops=1)

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

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

  • Buffers: shared hit=68
155. 0.359 0.359 ↑ 1.0 2,148 1

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

  • Buffers: shared hit=68
156. 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
157. 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
158. 8.588 8.588 ↑ 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.001..0.001 rows=1 loops=8,588)

  • Index Cond: (id = p_2."marketingManagedId")
  • Heap Fetches: 8,588
  • Buffers: shared hit=17,176
159. 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
160. 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
161. 8.588 8.588 ↑ 1.0 1 8,588

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

  • Index Cond: (id = mpv_2."marketId")
  • Filter: (NOT "isHidden")
  • Buffers: shared hit=17,176
162. 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
163. 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
164. 8.588 8.588 ↑ 1.0 1 8,588

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

  • Index Cond: (id = p_1."industryCutId")
  • Buffers: shared hit=17,176
165. 8.588 8.588 ↑ 1.0 1 8,588

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

  • Index Cond: (id = ic_1."productSubcategoryId")
  • Buffers: shared hit=17,176
166. 8.588 8.588 ↑ 1.0 1 8,588

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

  • Index Cond: (id = psc_1."productCategoryId")
  • Buffers: shared hit=17,176
167. 8.588 8.588 ↑ 1.0 1 8,588

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

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

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

  • Index Cond: (name = (p_1.type)::text)
  • Heap Fetches: 8,588
  • Buffers: shared hit=17,176
169. 8.588 8.588 ↑ 1.0 1 8,588

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

  • Index Cond: (id = "Market"."subregionId")
  • Buffers: shared hit=17,176
170. 0.000 0.000 ↑ 1.7 3 8,588

Materialize (cost=0.00..1.07 rows=5 width=16) (actual time=0.000..0.000 rows=3 loops=8,588)

  • Buffers: shared hit=1
171. 0.007 0.007 ↑ 1.0 5 1

Seq Scan on "Region" r_1 (cost=0.00..1.05 rows=5 width=16) (actual time=0.005..0.007 rows=5 loops=1)

  • Buffers: shared hit=1
172. 8.588 8.588 ↑ 1.0 1 8,588

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

  • Index Cond: (id = p_1."subBrandId")
  • Buffers: shared hit=17,176
173. 8.588 8.588 ↑ 1.0 1 8,588

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = p_1."marketingFocusId")
  • Heap Fetches: 8,588
  • Buffers: shared hit=17,176
178. 0.011 0.024 ↑ 1.0 50 1

Hash (cost=1.50..1.50 rows=50 width=20) (actual time=0.024..0.024 rows=50 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
179. 0.013 0.013 ↑ 1.0 50 1

Seq Scan on "Currency" c_1 (cost=0.00..1.50 rows=50 width=20) (actual time=0.007..0.013 rows=50 loops=1)

  • Buffers: shared hit=1
Planning time : 23.402 ms
Execution time : 278,719.111 ms