explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rkVi : local dev db

Settings
# exclusive inclusive rows x rows loops node
1. 14.864 29,848.656 ↓ 96.0 192 1

GroupAggregate (cost=45,185.44..45,185.49 rows=2 width=56) (actual time=29,823.346..29,848.656 rows=192 loops=1)

  • Group Key: "*SELECT* 1"."subBrandId", "*SELECT* 1"."subBrandName", "*SELECT* 1".year, "*SELECT* 1".month
  • Buffers: shared hit=1,872,524, temp read=1,320 written=1,320
2. 58.889 29,833.792 ↓ 14,480.5 28,961 1

Sort (cost=45,185.44..45,185.44 rows=2 width=56) (actual time=29,823.246..29,833.792 rows=28,961 loops=1)

  • Sort Key: "*SELECT* 1"."subBrandId", "*SELECT* 1"."subBrandName", "*SELECT* 1".month
  • Sort Method: quicksort Memory: 3,479kB
  • Buffers: shared hit=1,872,524, temp read=1,320 written=1,320
3. 0.000 29,774.903 ↓ 14,480.5 28,961 1

Append (cost=22,196.18..45,185.43 rows=2 width=56) (actual time=1,441.628..29,774.903 rows=28,961 loops=1)

  • Buffers: shared hit=1,872,524, temp read=1,320 written=1,320
4. 26.620 15,918.144 ↓ 24,995.0 24,995 1

Subquery Scan on *SELECT* 1 (cost=22,196.18..22,528.49 rows=1 width=56) (actual time=1,441.627..15,918.144 rows=24,995 loops=1)

  • Buffers: shared hit=830,378, temp read=908 written=907
5. 115.300 15,891.524 ↓ 24,995.0 24,995 1

Nested Loop (cost=22,196.18..22,528.48 rows=1 width=6,196) (actual time=1,441.626..15,891.524 rows=24,995 loops=1)

  • Buffers: shared hit=830,378, temp read=908 written=907
6. 61.429 15,751.229 ↓ 24,995.0 24,995 1

Nested Loop (cost=22,196.05..22,527.64 rows=1 width=124) (actual time=1,441.617..15,751.229 rows=24,995 loops=1)

  • Buffers: shared hit=780,388, temp read=908 written=907
7. 61.208 15,664.805 ↓ 24,995.0 24,995 1

Nested Loop (cost=22,195.92..22,526.76 rows=1 width=140) (actual time=1,441.612..15,664.805 rows=24,995 loops=1)

  • Buffers: shared hit=730,398, temp read=908 written=907
8. 42.986 15,578.602 ↓ 24,995.0 24,995 1

Nested Loop (cost=22,195.79..22,525.93 rows=1 width=156) (actual time=1,441.607..15,578.602 rows=24,995 loops=1)

  • Buffers: shared hit=680,408, temp read=908 written=907
9. 59.639 15,485.626 ↓ 24,995.0 24,995 1

Nested Loop (cost=22,195.66..22,525.16 rows=1 width=172) (actual time=1,441.600..15,485.626 rows=24,995 loops=1)

  • Buffers: shared hit=630,418, temp read=908 written=907
10. 54.941 15,375.997 ↓ 24,995.0 24,995 1

Nested Loop (cost=22,195.66..22,524.13 rows=1 width=176) (actual time=1,441.596..15,375.997 rows=24,995 loops=1)

  • Buffers: shared hit=605,423, temp read=908 written=907
11. 89.904 15,196.081 ↓ 24,995.0 24,995 1

Nested Loop (cost=22,195.66..22,522.70 rows=1 width=192) (actual time=1,441.591..15,196.081 rows=24,995 loops=1)

  • Buffers: shared hit=580,428, temp read=908 written=907
12. 1,619.225 14,940.733 ↓ 55,148.0 55,148 1

Nested Loop (cost=22,195.52..22,522.00 rows=1 width=160) (actual time=1,435.738..14,940.733 rows=55,148 loops=1)

  • Join Filter: (m.id = mpv."marketId")
  • Rows Removed by Join Filter: 3,143,436
  • Buffers: shared hit=470,132, temp read=908 written=907
13. 94.071 1,685.280 ↓ 55,148.0 55,148 1

Hash Join (cost=22,190.94..22,514.54 rows=1 width=172) (actual time=1,435.457..1,685.280 rows=55,148 loops=1)

  • Hash Cond: (mpv.id = rf."marketProductVariantId")
  • Buffers: shared hit=414,981, temp read=908 written=907
14. 36.491 162.412 ↓ 183.0 28,372 1

Nested Loop (cost=233.21..551.95 rows=155 width=116) (actual time=6.332..162.412 rows=28,372 loops=1)

  • Buffers: shared hit=54,349
15. 9.203 60.657 ↓ 181.3 8,158 1

Hash Join (cost=232.80..435.59 rows=45 width=100) (actual time=6.317..60.657 rows=8,158 loops=1)

  • Hash Cond: (pc."businessLineId" = bl.id)
  • Buffers: shared hit=229
16. 9.164 51.441 ↓ 181.3 8,158 1

Hash Join (cost=231.64..434.31 rows=45 width=116) (actual time=6.300..51.441 rows=8,158 loops=1)

  • Hash Cond: (psc."productCategoryId" = pc.id)
  • Buffers: shared hit=228
17. 9.307 42.242 ↓ 181.3 8,158 1

Hash Join (cost=229.79..432.32 rows=45 width=116) (actual time=6.262..42.242 rows=8,158 loops=1)

  • Hash Cond: (ic."productSubcategoryId" = psc.id)
  • Buffers: shared hit=227
18. 9.481 32.852 ↓ 181.3 8,158 1

Hash Join (cost=226.54..428.95 rows=45 width=116) (actual time=6.176..32.852 rows=8,158 loops=1)

  • Hash Cond: (p."industryCutId" = ic.id)
  • Buffers: shared hit=226
19. 12.872 23.182 ↓ 181.3 8,158 1

Hash Join (cost=218.43..420.73 rows=45 width=116) (actual time=5.983..23.182 rows=8,158 loops=1)

  • Hash Cond: (pv."productId" = p.id)
  • Buffers: shared hit=223
20. 4.335 4.335 ↑ 1.0 8,814 1

Seq Scan on "ProductVariant" pv (cost=0.00..179.14 rows=8,814 width=32) (actual time=0.003..4.335 rows=8,814 loops=1)

  • Buffers: shared hit=91
21. 2.496 5.975 ↓ 175.2 4,380 1

Hash (cost=218.12..218.12 rows=25 width=132) (actual time=5.975..5.975 rows=4,380 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 732kB
  • Buffers: shared hit=132
22. 3.479 3.479 ↓ 175.2 4,380 1

Seq Scan on "Product" p (cost=0.00..218.12 rows=25 width=132) (actual time=0.005..3.479 rows=4,380 loops=1)

  • Filter: ((type)::text = 'finishedGood'::text)
  • Rows Removed by Filter: 541
  • Buffers: shared hit=132
23. 0.093 0.189 ↑ 1.0 227 1

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

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

Seq Scan on "IndustryCut" ic (cost=0.00..5.27 rows=227 width=32) (actual time=0.003..0.096 rows=227 loops=1)

  • Buffers: shared hit=3
25. 0.042 0.083 ↑ 1.0 100 1

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

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

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

  • Buffers: shared hit=1
27. 0.017 0.035 ↑ 1.0 38 1

Hash (cost=1.38..1.38 rows=38 width=32) (actual time=0.035..0.035 rows=38 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
28. 0.018 0.018 ↑ 1.0 38 1

Seq Scan on "ProductCategory" pc (cost=0.00..1.38 rows=38 width=32) (actual time=0.003..0.018 rows=38 loops=1)

  • Buffers: shared hit=1
29. 0.005 0.013 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=16) (actual time=0.013..0.013 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
30. 0.008 0.008 ↑ 1.0 7 1

Seq Scan on "BusinessLine" bl (cost=0.00..1.07 rows=7 width=16) (actual time=0.005..0.008 rows=7 loops=1)

  • Buffers: shared hit=1
31. 65.264 65.264 ↑ 1.0 3 8,158

Index Scan using marketproductvariant_productvariantid_marketid_unique on "MarketProductVariant" mpv (cost=0.41..2.56 rows=3 width=48) (actual time=0.004..0.008 rows=3 loops=8,158)

  • Index Cond: ("productVariantId" = pv.id)
  • Buffers: shared hit=54,120
32. 30.513 1,428.797 ↓ 263.4 60,055 1

Hash (cost=21,954.88..21,954.88 rows=228 width=88) (actual time=1,428.797..1,428.797 rows=60,055 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 2 (originally 1) Memory Usage: 3,585kB
  • Buffers: shared hit=360,632, temp read=481 written=671
33. 43.730 1,398.284 ↓ 263.4 60,055 1

Subquery Scan on rf (cost=21,946.90..21,954.88 rows=228 width=88) (actual time=1,244.457..1,398.284 rows=60,055 loops=1)

  • Buffers: shared hit=360,632, temp read=481 written=482
34. 73.705 1,354.554 ↓ 263.4 60,055 1

Group (cost=21,946.90..21,952.60 rows=228 width=96) (actual time=1,244.456..1,354.554 rows=60,055 loops=1)

  • 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=360,632, temp read=481 written=482
35.          

Initplan (for Group)

36. 0.003 0.019 ↑ 1.0 1 1

Limit (cost=1.10..1.11 rows=1 width=24) (actual time=0.016..0.019 rows=1 loops=1)

  • Buffers: shared hit=1
37. 0.011 0.016 ↑ 7.0 1 1

Sort (cost=1.10..1.12 rows=7 width=24) (actual time=0.015..0.016 rows=1 loops=1)

  • Sort Key: fi_2."importedAt" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
38. 0.005 0.005 ↑ 3.5 2 1

Seq Scan on "ForecastImport" fi_2 (cost=0.00..1.07 rows=7 width=24) (actual time=0.003..0.005 rows=2 loops=1)

  • Buffers: shared hit=1
39. 203.537 1,280.830 ↓ 387.7 88,404 1

Sort (cost=21,945.79..21,946.36 rows=228 width=38) (actual time=1,244.449..1,280.830 rows=88,404 loops=1)

  • 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 merge Disk: 3,848kB
  • Buffers: shared hit=360,632, temp read=481 written=482
40. 158.287 1,077.293 ↓ 387.7 88,404 1

Nested Loop (cost=6,252.77..21,936.86 rows=228 width=38) (actual time=151.157..1,077.293 rows=88,404 loops=1)

  • Buffers: shared hit=360,632
41. 120.546 476.986 ↓ 775.5 88,404 1

Hash Full Join (cost=6,236.59..19,630.57 rows=114 width=56) (actual time=151.139..476.986 rows=88,404 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: 54,448
  • Buffers: shared hit=4,171
42. 124.504 210.234 ↑ 3.5 111,146 1

Nested Loop (cost=0.00..7,518.05 rows=389,011 width=28) (actual time=4.895..210.234 rows=111,146 loops=1)

  • Buffers: shared hit=1,267
43. 30.157 30.157 ↑ 1.0 55,573 1

Seq Scan on "MonthlyMarketProductVariantDemand" m_1 (cost=0.00..2,654.32 rows=55,573 width=28) (actual time=4.880..30.157 rows=55,573 loops=1)

  • Filter: ("forecastImportId" = $0)
  • Rows Removed by Filter: 55,573
  • Buffers: shared hit=1,266
44. 55.567 55.573 ↑ 3.5 2 55,573

Materialize (cost=0.00..1.10 rows=7 width=0) (actual time=0.000..0.001 rows=2 loops=55,573)

  • Buffers: shared hit=1
45. 0.006 0.006 ↑ 3.5 2 1

Seq Scan on "ForecastImport" fi (cost=0.00..1.07 rows=7 width=0) (actual time=0.004..0.006 rows=2 loops=1)

  • Buffers: shared hit=1
46. 18.684 146.206 ↓ 25.6 31,714 1

Hash (cost=6,214.88..6,214.88 rows=1,241 width=28) (actual time=146.206..146.206 rows=31,714 loops=1)

  • Buckets: 32,768 (originally 2048) Batches: 1 (originally 1) Memory Usage: 2,115kB
  • Buffers: shared hit=2,904
47. 10.610 127.522 ↓ 25.6 31,714 1

Gather (cost=1,041.75..6,214.88 rows=1,241 width=28) (actual time=54.430..127.522 rows=31,714 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=2,904
48. 64.311 116.912 ↓ 21.7 15,857 2 / 2

Hash Join (cost=41.75..5,090.78 rows=730 width=28) (actual time=51.854..116.912 rows=15,857 loops=2)

  • Hash Cond: ((forecast."forecastImportId" = abf."forecastImportId") AND (forecast.year = abf.year))
  • Buffers: shared hit=2,904
49. 52.592 52.592 ↑ 1.2 124,073 2 / 2

Parallel Seq Scan on "MonthlyMarketProductVariantForecast" forecast (cost=0.00..4,282.68 rows=145,968 width=44) (actual time=0.005..52.592 rows=124,073 loops=2)

  • Buffers: shared hit=2,823
50. 0.002 0.009 ↑ 1,270.0 1 2 / 2

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=2
51. 0.007 0.007 ↑ 1,270.0 1 2 / 2

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

  • Buffers: shared hit=2
52. 176.808 442.020 ↑ 2.0 1 88,404

Bitmap Heap Scan on "MarketProductVariant" mpv_1 (cost=16.18..20.21 rows=2 width=22) (actual time=0.004..0.005 rows=1 loops=88,404)

  • Recheck Cond: ((forecast."marketProductVariantId" = id) OR (m_1."marketProductVariantId" = id))
  • Heap Blocks: exact=88,404
  • Buffers: shared hit=356,461
53. 88.404 265.212 ↓ 0.0 0 88,404

BitmapOr (cost=16.18..16.18 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=88,404)

  • Buffers: shared hit=268,057
54. 88.404 88.404 ↓ 0.0 0 88,404

Bitmap Index Scan on "MarketProductVariant_pkey" (cost=0.00..0.43 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=88,404)

  • Index Cond: (forecast."marketProductVariantId" = id)
  • Buffers: shared hit=96,135
55. 88.404 88.404 ↑ 1.0 1 88,404

Bitmap Index Scan on "MarketProductVariant_pkey" (cost=0.00..0.48 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=88,404)

  • Index Cond: (m_1."marketProductVariantId" = id)
  • Buffers: shared hit=171,922
56. 3,308.833 11,636.228 ↑ 1.0 58 55,148

Hash Join (cost=4.58..6.73 rows=59 width=20) (actual time=0.005..0.211 rows=58 loops=55,148)

  • Hash Cond: (m."currencyId" = c.id)
  • Buffers: shared hit=55,151
57. 3,198.575 8,327.348 ↑ 1.0 59 55,148

Hash Join (cost=2.45..4.44 rows=59 width=32) (actual time=0.004..0.151 rows=59 loops=55,148)

  • Hash Cond: (sr."regionId" = r.id)
  • Buffers: shared hit=55,150
58. 3,584.586 5,128.764 ↑ 1.0 59 55,148

Hash Join (cost=1.32..3.10 rows=59 width=48) (actual time=0.003..0.093 rows=59 loops=55,148)

  • Hash Cond: (m."subregionId" = sr.id)
  • Buffers: shared hit=55,149
59. 1,544.144 1,544.144 ↑ 1.0 59 55,148

Seq Scan on "Market" m (cost=0.00..1.59 rows=59 width=48) (actual time=0.002..0.028 rows=59 loops=55,148)

  • Buffers: shared hit=55,148
60. 0.008 0.034 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=32) (actual time=0.034..0.034 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
61. 0.026 0.026 ↑ 1.0 14 1

Seq Scan on "Subregion" sr (cost=0.00..1.14 rows=14 width=32) (actual time=0.003..0.026 rows=14 loops=1)

  • Buffers: shared hit=1
62. 0.004 0.009 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=16) (actual time=0.009..0.009 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
63. 0.005 0.005 ↑ 1.0 6 1

Seq Scan on "Region" r (cost=0.00..1.06 rows=6 width=16) (actual time=0.003..0.005 rows=6 loops=1)

  • Buffers: shared hit=1
64. 0.022 0.047 ↑ 1.0 50 1

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

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

Seq Scan on "Currency" c (cost=0.00..1.50 rows=50 width=20) (actual time=0.005..0.025 rows=50 loops=1)

  • Buffers: shared hit=1
66. 165.444 165.444 ↓ 0.0 0 55,148

Index Scan using subbrand_new_id_index on "SubBrand" sb (cost=0.14..0.64 rows=1 width=48) (actual time=0.003..0.003 rows=0 loops=55,148)

  • Index Cond: (id = p."subBrandId")
  • Filter: ("brandId" = 'a6ee9795-9453-479c-8f8e-f33e14e625e1'::uuid)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=110,296
67. 124.975 124.975 ↑ 1.0 1 24,995

Seq Scan on "Brand" b (cost=0.00..1.41 rows=1 width=16) (actual time=0.002..0.005 rows=1 loops=24,995)

  • Filter: (id = 'a6ee9795-9453-479c-8f8e-f33e14e625e1'::uuid)
  • Rows Removed by Filter: 32
  • Buffers: shared hit=24,995
68. 49.990 49.990 ↑ 1.0 1 24,995

Seq Scan on "ProductType" pt (cost=0.00..1.02 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=24,995)

  • Filter: (name = 'finishedGood'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=24,995
69. 49.990 49.990 ↑ 1.0 1 24,995

Index Only Scan using "Form_pkey" on "Form" f (cost=0.13..0.63 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=24,995)

  • Index Cond: (id = p."formId")
  • Heap Fetches: 24,995
  • Buffers: shared hit=49,990
70. 24.995 24.995 ↑ 1.0 1 24,995

Index Only Scan using "Demographic_pkey" on "Demographic" d (cost=0.13..0.63 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=24,995)

  • Index Cond: (id = p."demographicId")
  • Heap Fetches: 24,995
  • Buffers: shared hit=49,990
71. 24.995 24.995 ↑ 1.0 1 24,995

Index Only Scan using "MarketingManaged_pkey" on "MarketingManaged" mm (cost=0.13..0.63 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=24,995)

  • Index Cond: (id = p."marketingManagedId")
  • Heap Fetches: 24,995
  • Buffers: shared hit=49,990
72. 24.995 24.995 ↑ 1.0 1 24,995

Index Only Scan using "MarketingFocus_pkey" on "MarketingFocus" mf (cost=0.13..0.63 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=24,995)

  • Index Cond: (id = p."marketingFocusId")
  • Heap Fetches: 24,995
  • Buffers: shared hit=49,990
73. 5.150 14,674.509 ↓ 3,966.0 3,966 1

Subquery Scan on *SELECT* 2 (cost=22,192.63..22,656.93 rows=1 width=56) (actual time=2,285.842..14,674.509 rows=3,966 loops=1)

  • Buffers: shared hit=1,042,146, temp read=412 written=413
74. 26.963 14,669.359 ↓ 3,966.0 3,966 1

Nested Loop (cost=22,192.63..22,656.92 rows=1 width=6,196) (actual time=2,285.841..14,669.359 rows=3,966 loops=1)

  • Buffers: shared hit=1,042,146, temp read=412 written=413
75. 9.156 14,634.464 ↓ 3,966.0 3,966 1

Nested Loop (cost=22,192.49..22,656.52 rows=1 width=91) (actual time=2,285.824..14,634.464 rows=3,966 loops=1)

  • Buffers: shared hit=1,034,214, temp read=412 written=413
76. 9.084 14,617.376 ↓ 3,966.0 3,966 1

Nested Loop (cost=22,192.36..22,656.36 rows=1 width=107) (actual time=2,285.816..14,617.376 rows=3,966 loops=1)

  • Buffers: shared hit=1,026,282, temp read=412 written=413
77. 9.140 14,600.360 ↓ 3,966.0 3,966 1

Nested Loop (cost=22,192.23..22,656.20 rows=1 width=123) (actual time=2,285.809..14,600.360 rows=3,966 loops=1)

  • Buffers: shared hit=1,018,350, temp read=412 written=413
78. 13.587 14,583.288 ↓ 3,966.0 3,966 1

Nested Loop (cost=22,192.10..22,656.04 rows=1 width=139) (actual time=2,285.801..14,583.288 rows=3,966 loops=1)

  • Buffers: shared hit=1,010,418, temp read=412 written=413
79. 16.274 14,561.769 ↓ 3,966.0 3,966 1

Nested Loop (cost=22,191.97..22,655.88 rows=1 width=155) (actual time=2,285.791..14,561.769 rows=3,966 loops=1)

  • Buffers: shared hit=1,002,486, temp read=412 written=413
80. 13.719 14,533.597 ↓ 3,966.0 3,966 1

Nested Loop (cost=22,191.84..22,655.72 rows=1 width=159) (actual time=2,285.776..14,533.597 rows=3,966 loops=1)

  • Buffers: shared hit=994,554, temp read=412 written=413
81. 17.905 14,500.048 ↓ 3,966.0 3,966 1

Nested Loop (cost=22,191.84..22,654.30 rows=1 width=175) (actual time=2,285.767..14,500.048 rows=3,966 loops=1)

  • Buffers: shared hit=990,588, temp read=412 written=413
82. 33.500 14,469.013 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,191.70..22,654.13 rows=1 width=143) (actual time=2,285.758..14,469.013 rows=6,565 loops=1)

  • Join Filter: (sr_1."regionId" = r_1.id)
  • Rows Removed by Join Filter: 14,396
  • Buffers: shared hit=977,458, temp read=412 written=413
83. 16.872 14,422.383 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,191.70..22,653.00 rows=1 width=159) (actual time=2,285.750..14,422.383 rows=6,565 loops=1)

  • Buffers: shared hit=970,893, temp read=412 written=413
84. 19.007 14,392.381 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,191.56..22,652.61 rows=1 width=159) (actual time=2,285.744..14,392.381 rows=6,565 loops=1)

  • Buffers: shared hit=957,763, temp read=412 written=413
85. 18.551 14,360.244 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,191.42..22,652.45 rows=1 width=159) (actual time=2,285.739..14,360.244 rows=6,565 loops=1)

  • Buffers: shared hit=944,633, temp read=412 written=413
86. 17.814 14,328.563 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,191.29..22,651.90 rows=1 width=175) (actual time=2,285.732..14,328.563 rows=6,565 loops=1)

  • Buffers: shared hit=931,503, temp read=412 written=413
87. 18.923 14,297.619 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,191.15..22,651.61 rows=1 width=175) (actual time=2,285.726..14,297.619 rows=6,565 loops=1)

  • Buffers: shared hit=918,373, temp read=412 written=413
88. 15.738 14,265.566 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,191.01..22,651.40 rows=1 width=175) (actual time=2,285.720..14,265.566 rows=6,565 loops=1)

  • Buffers: shared hit=905,243, temp read=412 written=413
89. 21.276 14,230.133 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,190.86..22,651.23 rows=1 width=175) (actual time=2,285.714..14,230.133 rows=6,565 loops=1)

  • Buffers: shared hit=892,113, temp read=412 written=413
90. 18.131 14,189.162 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,190.58..22,650.86 rows=1 width=91) (actual time=2,285.706..14,189.162 rows=6,565 loops=1)

  • Buffers: shared hit=872,297, temp read=412 written=413
91. 29.733 14,144.771 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,190.29..22,650.55 rows=1 width=91) (actual time=2,285.698..14,144.771 rows=6,565 loops=1)

  • Buffers: shared hit=852,602, temp read=412 written=413
92. 5,829.041 14,075.648 ↓ 6,565.0 6,565 1

Nested Loop (cost=22,189.88..22,645.65 rows=1 width=75) (actual time=2,285.684..14,075.648 rows=6,565 loops=1)

  • Join Filter: (rf_1."marketProductVariantId" = mpvsbe."parentMarketProductVariantId")
  • Rows Removed by Join Filter: 11,333,512
  • Buffers: shared hit=826,342, temp read=412 written=413
93. 16.121 2,431.812 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,189.88..22,519.66 rows=1 width=80) (actual time=2,045.895..2,431.812 rows=4,907 loops=1)

  • Buffers: shared hit=463,224, temp read=412 written=413
94. 14.978 2,405.877 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,189.75..22,518.83 rows=1 width=96) (actual time=2,045.890..2,405.877 rows=4,907 loops=1)

  • Buffers: shared hit=453,410, temp read=412 written=413
95. 15.540 2,381.085 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,189.62..22,517.95 rows=1 width=112) (actual time=2,045.884..2,381.085 rows=4,907 loops=1)

  • Buffers: shared hit=443,596, temp read=412 written=413
96. 14.189 2,355.731 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,189.49..22,517.13 rows=1 width=128) (actual time=2,045.878..2,355.731 rows=4,907 loops=1)

  • Buffers: shared hit=433,782, temp read=412 written=413
97. 18.616 2,326.821 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,189.36..22,516.35 rows=1 width=144) (actual time=2,045.872..2,326.821 rows=4,907 loops=1)

  • Buffers: shared hit=423,968, temp read=412 written=413
98. 12.719 2,293.484 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,189.36..22,515.32 rows=1 width=148) (actual time=2,045.866..2,293.484 rows=4,907 loops=1)

  • Buffers: shared hit=419,061, temp read=412 written=413
99. 14.729 2,266.044 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,189.22..22,514.95 rows=1 width=132) (actual time=2,045.861..2,266.044 rows=4,907 loops=1)

  • Buffers: shared hit=409,247, temp read=412 written=413
100. 14.241 2,236.594 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,189.08..22,514.59 rows=1 width=148) (actual time=2,045.854..2,236.594 rows=4,907 loops=1)

  • Buffers: shared hit=399,433, temp read=412 written=413
101. 29.468 2,207.632 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,188.94..22,513.94 rows=1 width=148) (actual time=2,045.848..2,207.632 rows=4,907 loops=1)

  • Join Filter: (sr_2."regionId" = r_2.id)
  • Rows Removed by Join Filter: 12,830
  • Buffers: shared hit=389,619, temp read=412 written=413
102. 12.833 2,163.443 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,188.94..22,512.80 rows=1 width=164) (actual time=2,045.836..2,163.443 rows=4,907 loops=1)

  • Buffers: shared hit=384,712, temp read=412 written=413
103. 25.998 2,135.889 ↓ 4,907.0 4,907 1

Nested Loop (cost=22,188.80..22,512.42 rows=1 width=164) (actual time=2,045.830..2,135.889 rows=4,907 loops=1)

  • Buffers: shared hit=374,898, temp read=412 written=413
104. 12.476 2,085.356 ↓ 4,907.0 4,907 1

Hash Join (cost=22,188.66..22,512.26 rows=1 width=148) (actual time=2,045.822..2,085.356 rows=4,907 loops=1)

  • Hash Cond: (mpv_3.id = rf_1."marketProductVariantId")
  • Buffers: shared hit=365,084, temp read=412 written=413
105. 3.746 29.228 ↓ 13.9 2,155 1

Nested Loop (cost=233.21..551.95 rows=155 width=116) (actual time=2.095..29.228 rows=2,155 loops=1)

  • Buffers: shared hit=4,452
106. 1.028 17.610 ↓ 14.6 656 1

Hash Join (cost=232.80..435.59 rows=45 width=100) (actual time=2.081..17.610 rows=656 loops=1)

  • Hash Cond: (pc_2."businessLineId" = bl_2.id)
  • Buffers: shared hit=229
107. 1.050 16.563 ↓ 14.6 656 1

Hash Join (cost=231.64..434.31 rows=45 width=116) (actual time=2.049..16.563 rows=656 loops=1)

  • Hash Cond: (psc_2."productCategoryId" = pc_2.id)
  • Buffers: shared hit=228
108. 1.172 15.470 ↓ 14.6 656 1

Hash Join (cost=229.79..432.32 rows=45 width=116) (actual time=2.001..15.470 rows=656 loops=1)

  • Hash Cond: (ic_2."productSubcategoryId" = psc_2.id)
  • Buffers: shared hit=227
109. 1.122 14.180 ↓ 14.6 656 1

Hash Join (cost=226.54..428.95 rows=45 width=116) (actual time=1.879..14.180 rows=656 loops=1)

  • Hash Cond: (p_2."industryCutId" = ic_2.id)
  • Buffers: shared hit=226
110. 6.592 12.834 ↓ 14.6 656 1

Hash Join (cost=218.43..420.73 rows=45 width=116) (actual time=1.651..12.834 rows=656 loops=1)

  • Hash Cond: (pv_2."productId" = p_2.id)
  • Buffers: shared hit=223
111. 4.611 4.611 ↑ 1.0 8,814 1

Seq Scan on "ProductVariant" pv_2 (cost=0.00..179.14 rows=8,814 width=32) (actual time=0.005..4.611 rows=8,814 loops=1)

  • Buffers: shared hit=91
112. 0.320 1.631 ↓ 21.6 541 1

Hash (cost=218.12..218.12 rows=25 width=132) (actual time=1.630..1.631 rows=541 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 91kB
  • Buffers: shared hit=132
113. 1.311 1.311 ↓ 21.6 541 1

Seq Scan on "Product" p_2 (cost=0.00..218.12 rows=25 width=132) (actual time=0.038..1.311 rows=541 loops=1)

  • Filter: ((type)::text = 'salesBundle'::text)
  • Rows Removed by Filter: 4,380
  • Buffers: shared hit=132
114. 0.111 0.224 ↑ 1.0 227 1

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

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

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

  • Buffers: shared hit=3
116. 0.067 0.118 ↑ 1.0 100 1

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

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

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

  • Buffers: shared hit=1
118. 0.022 0.043 ↑ 1.0 38 1

Hash (cost=1.38..1.38 rows=38 width=32) (actual time=0.043..0.043 rows=38 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
119. 0.021 0.021 ↑ 1.0 38 1

Seq Scan on "ProductCategory" pc_2 (cost=0.00..1.38 rows=38 width=32) (actual time=0.003..0.021 rows=38 loops=1)

  • Buffers: shared hit=1
120. 0.006 0.019 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=16) (actual time=0.019..0.019 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
121. 0.013 0.013 ↑ 1.0 7 1

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

  • Buffers: shared hit=1
122. 7.872 7.872 ↑ 1.0 3 656

Index Scan using marketproductvariant_productvariantid_marketid_unique on "MarketProductVariant" mpv_3 (cost=0.41..2.56 rows=3 width=48) (actual time=0.006..0.012 rows=3 loops=656)

  • Index Cond: ("productVariantId" = pv_2.id)
  • Buffers: shared hit=4,223
123. 44.746 2,043.652 ↓ 263.4 60,055 1

Hash (cost=21,952.60..21,952.60 rows=228 width=32) (actual time=2,043.651..2,043.652 rows=60,055 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 4,031kB
  • Buffers: shared hit=360,632, temp read=412 written=413
124. 65.320 1,998.906 ↓ 263.4 60,055 1

Subquery Scan on rf_1 (cost=21,946.90..21,952.60 rows=228 width=32) (actual time=1,774.727..1,998.906 rows=60,055 loops=1)

  • Buffers: shared hit=360,632, temp read=412 written=413
125. 101.322 1,933.586 ↓ 263.4 60,055 1

Group (cost=21,946.90..21,950.32 rows=228 width=96) (actual time=1,774.725..1,933.586 rows=60,055 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=360,632, temp read=412 written=413
126.          

Initplan (for Group)

127. 0.004 0.028 ↑ 1.0 1 1

Limit (cost=1.10..1.11 rows=1 width=24) (actual time=0.025..0.028 rows=1 loops=1)

  • Buffers: shared hit=1
128. 0.018 0.024 ↑ 7.0 1 1

Sort (cost=1.10..1.12 rows=7 width=24) (actual time=0.023..0.024 rows=1 loops=1)

  • Sort Key: fi_3."importedAt" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
129. 0.006 0.006 ↑ 3.5 2 1

Seq Scan on "ForecastImport" fi_3 (cost=0.00..1.07 rows=7 width=24) (actual time=0.004..0.006 rows=2 loops=1)

  • Buffers: shared hit=1
130. 296.438 1,832.236 ↓ 387.7 88,404 1

Sort (cost=21,945.79..21,946.36 rows=228 width=32) (actual time=1,774.721..1,832.236 rows=88,404 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,296kB
  • Buffers: shared hit=360,632, temp read=412 written=413
131. 248.162 1,535.798 ↓ 387.7 88,404 1

Nested Loop (cost=6,252.77..21,936.86 rows=228 width=32) (actual time=234.867..1,535.798 rows=88,404 loops=1)

  • Buffers: shared hit=360,632
132. 155.740 668.808 ↓ 775.5 88,404 1

Hash Full Join (cost=6,236.59..19,630.57 rows=114 width=56) (actual time=234.845..668.808 rows=88,404 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: 54,448
  • Buffers: shared hit=4,171
133. 183.915 285.575 ↑ 3.5 111,146 1

Nested Loop (cost=0.00..7,518.05 rows=389,011 width=28) (actual time=7.304..285.575 rows=111,146 loops=1)

  • Buffers: shared hit=1,267
134. 46.087 46.087 ↑ 1.0 55,573 1

Seq Scan on "MonthlyMarketProductVariantDemand" m_3 (cost=0.00..2,654.32 rows=55,573 width=28) (actual time=7.280..46.087 rows=55,573 loops=1)

  • Filter: ("forecastImportId" = $1)
  • Rows Removed by Filter: 55,573
  • Buffers: shared hit=1,266
135. 55.565 55.573 ↑ 3.5 2 55,573

Materialize (cost=0.00..1.10 rows=7 width=0) (actual time=0.000..0.001 rows=2 loops=55,573)

  • Buffers: shared hit=1
136. 0.008 0.008 ↑ 3.5 2 1

Seq Scan on "ForecastImport" fi_1 (cost=0.00..1.07 rows=7 width=0) (actual time=0.006..0.008 rows=2 loops=1)

  • Buffers: shared hit=1
137. 23.396 227.493 ↓ 25.6 31,714 1

Hash (cost=6,214.88..6,214.88 rows=1,241 width=28) (actual time=227.492..227.493 rows=31,714 loops=1)

  • Buckets: 32,768 (originally 2048) Batches: 1 (originally 1) Memory Usage: 2,115kB
  • Buffers: shared hit=2,904
138. 13.250 204.097 ↓ 25.6 31,714 1

Gather (cost=1,041.75..6,214.88 rows=1,241 width=28) (actual time=116.377..204.097 rows=31,714 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=2,904
139. 107.736 190.847 ↓ 21.7 15,857 2 / 2

Hash Join (cost=41.75..5,090.78 rows=730 width=28) (actual time=113.206..190.847 rows=15,857 loops=2)

  • Hash Cond: ((forecast_1."forecastImportId" = abf_1."forecastImportId") AND (forecast_1.year = abf_1.year))
  • Buffers: shared hit=2,904
140. 83.099 83.099 ↑ 1.2 124,073 2 / 2

Parallel Seq Scan on "MonthlyMarketProductVariantForecast" forecast_1 (cost=0.00..4,282.68 rows=145,968 width=44) (actual time=0.006..83.099 rows=124,073 loops=2)

  • Buffers: shared hit=2,823
141. 0.004 0.012 ↑ 1,270.0 1 2 / 2

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=2
142. 0.008 0.008 ↑ 1,270.0 1 2 / 2

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

  • Buffers: shared hit=2
143. 176.808 618.828 ↑ 2.0 1 88,404

Bitmap Heap Scan on "MarketProductVariant" mpv_4 (cost=16.18..20.21 rows=2 width=16) (actual time=0.006..0.007 rows=1 loops=88,404)

  • Recheck Cond: ((forecast_1."marketProductVariantId" = id) OR (m_3."marketProductVariantId" = id))
  • Heap Blocks: exact=88,404
  • Buffers: shared hit=356,461
144. 176.808 442.020 ↓ 0.0 0 88,404

BitmapOr (cost=16.18..16.18 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=88,404)

  • Buffers: shared hit=268,057
145. 88.404 88.404 ↓ 0.0 0 88,404

Bitmap Index Scan on "MarketProductVariant_pkey" (cost=0.00..0.43 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=88,404)

  • Index Cond: (forecast_1."marketProductVariantId" = id)
  • Buffers: shared hit=96,135
146. 176.808 176.808 ↑ 1.0 1 88,404

Bitmap Index Scan on "MarketProductVariant_pkey" (cost=0.00..0.48 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=88,404)

  • Index Cond: (m_3."marketProductVariantId" = id)
  • Buffers: shared hit=171,922
147. 24.535 24.535 ↑ 1.0 1 4,907

Index Scan using market_new_id_index on "Market" m_2 (cost=0.14..0.16 rows=1 width=48) (actual time=0.005..0.005 rows=1 loops=4,907)

  • Index Cond: (id = mpv_3."marketId")
  • Buffers: shared hit=9,814
148. 14.721 14.721 ↑ 1.0 1 4,907

Index Scan using subregion_new_id_index on "Subregion" sr_2 (cost=0.14..0.36 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=4,907)

  • Index Cond: (id = m_2."subregionId")
  • Buffers: shared hit=9,814
149. 14.721 14.721 ↑ 1.5 4 4,907

Seq Scan on "Region" r_2 (cost=0.00..1.06 rows=6 width=16) (actual time=0.002..0.003 rows=4 loops=4,907)

  • Buffers: shared hit=4,907
150. 14.721 14.721 ↑ 1.0 1 4,907

Index Scan using subbrand_new_id_index on "SubBrand" sb_2 (cost=0.14..0.64 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=4,907)

  • Index Cond: (id = p_2."subBrandId")
  • Buffers: shared hit=9,814
151. 14.721 14.721 ↑ 1.0 1 4,907

Index Only Scan using brand_new_id_index on "Brand" b_2 (cost=0.14..0.35 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=4,907)

  • Index Cond: (id = sb_2."brandId")
  • Heap Fetches: 4,907
  • Buffers: shared hit=9,814
152. 14.721 14.721 ↑ 1.0 1 4,907

Index Only Scan using "Currency_pkey" on "Currency" c_2 (cost=0.14..0.36 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=4,907)

  • Index Cond: (id = m_2."currencyId")
  • Heap Fetches: 4,907
  • Buffers: shared hit=9,814
153. 14.721 14.721 ↑ 1.0 1 4,907

Seq Scan on "ProductType" pt_2 (cost=0.00..1.02 rows=1 width=32) (actual time=0.002..0.003 rows=1 loops=4,907)

  • Filter: (name = 'salesBundle'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4,907
154. 14.721 14.721 ↑ 1.0 1 4,907

Index Only Scan using "Form_pkey" on "Form" f_2 (cost=0.13..0.63 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=4,907)

  • Index Cond: (id = p_2."formId")
  • Heap Fetches: 4,907
  • Buffers: shared hit=9,814
155. 9.814 9.814 ↑ 1.0 1 4,907

Index Only Scan using "Demographic_pkey" on "Demographic" d_2 (cost=0.13..0.63 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=4,907)

  • Index Cond: (id = p_2."demographicId")
  • Heap Fetches: 4,907
  • Buffers: shared hit=9,814
156. 9.814 9.814 ↑ 1.0 1 4,907

Index Only Scan using "MarketingManaged_pkey" on "MarketingManaged" mm_2 (cost=0.13..0.63 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=4,907)

  • Index Cond: (id = p_2."marketingManagedId")
  • Heap Fetches: 4,907
  • Buffers: shared hit=9,814
157. 9.814 9.814 ↑ 1.0 1 4,907

Index Only Scan using "MarketingFocus_pkey" on "MarketingFocus" mf_2 (cost=0.13..0.63 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=4,907)

  • Index Cond: (id = p_2."marketingFocusId")
  • Heap Fetches: 4,907
  • Buffers: shared hit=9,814
158. 5,814.795 5,814.795 ↑ 1.0 2,311 4,907

Seq Scan on "MarketProductVariantSalesBundleEntry" mpvsbe (cost=0.00..97.11 rows=2,311 width=43) (actual time=0.005..1.185 rows=2,311 loops=4,907)

  • Buffers: shared hit=363,118
159. 39.390 39.390 ↑ 1.0 1 6,565

Index Scan using "MarketProductVariant_pkey" on "MarketProductVariant" mpv_2 (cost=0.41..4.89 rows=1 width=48) (actual time=0.006..0.006 rows=1 loops=6,565)

  • Index Cond: (id = mpvsbe."marketProductVariantId")
  • Buffers: shared hit=26,260
160. 26.260 26.260 ↑ 1.0 1 6,565

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

  • Index Cond: (id = mpv_2."productVariantId")
  • Buffers: shared hit=19,695
161. 19.695 19.695 ↑ 1.0 1 6,565

Index Scan using "Product_pkey" on "Product" p_1 (cost=0.28..0.37 rows=1 width=132) (actual time=0.003..0.003 rows=1 loops=6,565)

  • Index Cond: (id = pv_1."productId")
  • Buffers: shared hit=19,816
162. 19.695 19.695 ↑ 1.0 1 6,565

Index Scan using industrycut_new_id_index on "IndustryCut" ic_1 (cost=0.14..0.17 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=6,565)

  • Index Cond: (id = p_1."industryCutId")
  • Buffers: shared hit=13,130
163. 13.130 13.130 ↑ 1.0 1 6,565

Index Scan using productsubcategory_new_id_index on "ProductSubcategory" psc_1 (cost=0.14..0.21 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=6,565)

  • Index Cond: (id = ic_1."productSubcategoryId")
  • Buffers: shared hit=13,130
164. 13.130 13.130 ↑ 1.0 1 6,565

Index Scan using productcategory_new_id_index on "ProductCategory" pc_1 (cost=0.14..0.28 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=6,565)

  • Index Cond: (id = psc_1."productCategoryId")
  • Buffers: shared hit=13,130
165. 13.130 13.130 ↑ 1.0 1 6,565

Index Only Scan using businessline_new_id_index on "BusinessLine" bl_1 (cost=0.13..0.47 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=6,565)

  • Index Cond: (id = pc_1."businessLineId")
  • Heap Fetches: 6,565
  • Buffers: shared hit=13,130
166. 13.130 13.130 ↑ 1.0 1 6,565

Index Scan using market_new_id_index on "Market" (cost=0.14..0.16 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=6,565)

  • Index Cond: (id = mpv_2."marketId")
  • Filter: (NOT "isHidden")
  • Buffers: shared hit=13,130
167. 13.130 13.130 ↑ 1.0 1 6,565

Index Scan using subregion_new_id_index on "Subregion" sr_1 (cost=0.14..0.36 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=6,565)

  • Index Cond: (id = "Market"."subregionId")
  • Buffers: shared hit=13,130
168. 13.130 13.130 ↑ 2.0 3 6,565

Seq Scan on "Region" r_1 (cost=0.00..1.06 rows=6 width=16) (actual time=0.001..0.002 rows=3 loops=6,565)

  • Buffers: shared hit=6,565
169. 13.130 13.130 ↑ 1.0 1 6,565

Index Scan using subbrand_new_id_index on "SubBrand" sb_1 (cost=0.14..0.16 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=6,565)

  • Index Cond: (id = p_1."subBrandId")
  • Filter: ("brandId" = 'a6ee9795-9453-479c-8f8e-f33e14e625e1'::uuid)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=13,130
170. 19.830 19.830 ↑ 1.0 1 3,966

Seq Scan on "Brand" b_1 (cost=0.00..1.41 rows=1 width=16) (actual time=0.003..0.005 rows=1 loops=3,966)

  • Filter: (id = 'a6ee9795-9453-479c-8f8e-f33e14e625e1'::uuid)
  • Rows Removed by Filter: 32
  • Buffers: shared hit=3,966
171. 11.898 11.898 ↑ 1.0 1 3,966

Index Only Scan using producttype_name_unique on "ProductType" pt_1 (cost=0.13..0.15 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=3,966)

  • Index Cond: (name = (p_1.type)::text)
  • Heap Fetches: 3,966
  • Buffers: shared hit=7,932
172. 7.932 7.932 ↑ 1.0 1 3,966

Index Only Scan using "Form_pkey" on "Form" f_1 (cost=0.13..0.15 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=3,966)

  • Index Cond: (id = p_1."formId")
  • Heap Fetches: 3,966
  • Buffers: shared hit=7,932
173. 7.932 7.932 ↑ 1.0 1 3,966

Index Only Scan using "Demographic_pkey" on "Demographic" d_1 (cost=0.13..0.15 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=3,966)

  • Index Cond: (id = p_1."demographicId")
  • Heap Fetches: 3,966
  • Buffers: shared hit=7,932
174. 7.932 7.932 ↑ 1.0 1 3,966

Index Only Scan using "MarketingManaged_pkey" on "MarketingManaged" mm_1 (cost=0.13..0.15 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=3,966)

  • Index Cond: (id = p_1."marketingManagedId")
  • Heap Fetches: 3,966
  • Buffers: shared hit=7,932
175. 7.932 7.932 ↑ 1.0 1 3,966

Index Only Scan using "MarketingFocus_pkey" on "MarketingFocus" mf_1 (cost=0.13..0.15 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=3,966)

  • Index Cond: (id = p_1."marketingFocusId")
  • Heap Fetches: 3,966
  • Buffers: shared hit=7,932
176. 7.932 7.932 ↑ 1.0 1 3,966

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

  • Index Cond: (id = m_2."currencyId")
  • Buffers: shared hit=7,932
Planning time : 25.423 ms
Execution time : 33,041.428 ms