explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y1Ou

Settings
# exclusive inclusive rows x rows loops node
1. 3.682 492,211.060 ↓ 11.6 58 1

GroupAggregate (cost=9,425,326.66..9,425,326.80 rows=5 width=556) (actual time=492,206.403..492,211.060 rows=58 loops=1)

  • Group Key: "*SELECT* 1"."productCategoryId", "*SELECT* 1"."productCategoryName", "*SELECT* 1".year, "*SELECT* 1".month
  • Buffers: shared hit=6,505,245 read=2
2. 27.229 492,207.378 ↓ 3,793.6 18,968 1

Sort (cost=9,425,326.66..9,425,326.68 rows=5 width=556) (actual time=492,206.214..492,207.378 rows=18,968 loops=1)

  • Sort Key: "*SELECT* 1"."productCategoryId", "*SELECT* 1"."productCategoryName", "*SELECT* 1".month
  • Sort Method: quicksort Memory: 2,610kB
  • Buffers: shared hit=6,505,245 read=2
3. 5.385 492,180.149 ↓ 3,793.6 18,968 1

Append (cost=3,239.55..9,425,326.61 rows=5 width=556) (actual time=106.250..492,180.149 rows=18,968 loops=1)

  • Buffers: shared hit=6,505,245 read=2
4. 5.981 460,965.657 ↓ 4,443.8 17,775 1

Subquery Scan on *SELECT* 1 (cost=3,239.55..4,671,907.38 rows=4 width=556) (actual time=106.249..460,965.657 rows=17,775 loops=1)

  • Buffers: shared hit=6,307,925
5. 55.476 460,959.676 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,239.55..4,671,907.34 rows=4 width=6,696) (actual time=106.248..460,959.676 rows=17,775 loops=1)

  • Buffers: shared hit=6,307,925
6.          

Initplan (for Nested Loop)

7. 0.002 0.016 ↑ 1.0 1 1

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

  • Buffers: shared hit=1
8. 0.012 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_2."importedAt" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
9. 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
10. 0.014 0.014 ↑ 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.014 rows=1 loops=1)

  • Index Cond: (name = 'finishedGood'::text)
  • Heap Fetches: 1
  • Buffers: shared hit=2
11. 28.019 460,904.170 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,205.85..4,671,865.46 rows=4 width=570) (actual time=106.224..460,904.170 rows=17,775 loops=1)

  • Buffers: shared hit=6,307,923
12. 28.254 460,805.051 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,205.70..4,671,856.79 rows=4 width=586) (actual time=106.210..460,805.051 rows=17,775 loops=1)

  • Buffers: shared hit=6,272,373
13. 31.948 460,741.247 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,205.56..4,671,848.11 rows=4 width=602) (actual time=106.199..460,741.247 rows=17,775 loops=1)

  • Buffers: shared hit=6,236,823
14. 28.435 460,673.749 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,205.41..4,671,839.43 rows=4 width=618) (actual time=106.189..460,673.749 rows=17,775 loops=1)

  • Buffers: shared hit=6,201,273
15. 19.978 460,609.764 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,205.27..4,671,830.75 rows=4 width=634) (actual time=106.180..460,609.764 rows=17,775 loops=1)

  • Buffers: shared hit=6,165,723
16. 24.758 460,554.236 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,205.13..4,671,829.30 rows=4 width=646) (actual time=106.169..460,554.236 rows=17,775 loops=1)

  • Buffers: shared hit=6,130,173
17. 24.149 460,493.928 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,204.98..4,671,825.59 rows=4 width=662) (actual time=106.159..460,493.928 rows=17,775 loops=1)

  • Buffers: shared hit=6,094,623
18. 34.477 460,434.229 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,204.84..4,671,822.27 rows=4 width=662) (actual time=106.146..460,434.229 rows=17,775 loops=1)

  • Buffers: shared hit=6,059,073
19. 28.616 460,364.202 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,204.71..4,671,821.29 rows=4 width=678) (actual time=106.133..460,364.202 rows=17,775 loops=1)

  • Buffers: shared hit=6,023,523
20. 41.691 460,300.036 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,204.57..4,671,817.38 rows=4 width=678) (actual time=106.118..460,300.036 rows=17,775 loops=1)

  • Buffers: shared hit=5,987,973
21. 14.089 460,205.020 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,204.43..4,671,816.74 rows=4 width=662) (actual time=106.106..460,205.020 rows=17,775 loops=1)

  • Buffers: shared hit=5,952,423
22. 34,388.489 460,190.931 ↓ 4,443.8 17,775 1

Nested Loop (cost=3,204.28..4,671,808.53 rows=4 width=678) (actual time=106.080..460,190.931 rows=17,775 loops=1)

  • Join Filter: ((forecast."marketProductVariantId" = mpv_1.id) OR (m_1."marketProductVariantId" = mpv_1.id))
  • Rows Removed by Join Filter: 392,136,841
  • Buffers: shared hit=5,952,421
23. 21.332 195.458 ↓ 4,168.0 4,168 1

Nested Loop (cost=9.84..954.16 rows=1 width=686) (actual time=0.266..195.458 rows=4,168 loops=1)

  • Buffers: shared hit=32,516
24. 12.299 140.782 ↓ 4,168.0 4,168 1

Nested Loop (cost=9.42..953.20 rows=1 width=680) (actual time=0.256..140.782 rows=4,168 loops=1)

  • Buffers: shared hit=15,834
25. 5.070 85.013 ↓ 2,415.0 2,415 1

Nested Loop (cost=9.01..950.64 rows=1 width=664) (actual time=0.246..85.013 rows=2,415 loops=1)

  • Buffers: shared hit=4,392
26. 30.422 62.447 ↓ 972.0 972 1

Nested Loop (cost=8.73..940.46 rows=1 width=664) (actual time=0.239..62.447 rows=972 loops=1)

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

  • Filter: ((type)::text = 'finishedGood'::text)
  • Rows Removed by Filter: 549
  • Buffers: shared hit=220
28. 17.119 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
29. 0.029 0.141 ↓ 37.5 75 1

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

  • Buffers: shared hit=94
30. 0.019 0.052 ↓ 20.0 20 1

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

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

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

  • Buffers: shared hit=1
32. 0.007 0.019 ↓ 5.0 5 1

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

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

  • Index Cond: ("businessLineId" = '50578e14-1825-4003-978e-620e3495e915'::uuid)
  • Buffers: shared hit=2
34. 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
35. 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
36. 43.470 43.470 ↑ 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.009..0.018 rows=2 loops=2,415)

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

Index Scan using "MarketProductVariant_pkey" on "MarketProductVariant" mpv_1 (cost=0.41..0.97 rows=1 width=22) (actual time=0.008..0.008 rows=1 loops=4,168)

  • Index Cond: (id = mpv.id)
  • Buffers: shared hit=16,682
38. 179,536.832 425,606.984 ↓ 1.6 94,087 4,168

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

  • 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=5,919,905
39. 166,965.912 246,037.040 ↑ 1,570.8 124,880 4,168

Nested Loop (cost=0.00..2,455,037.42 rows=196,162,080 width=28) (actual time=0.006..59.030 rows=124,880 loops=4,168)

  • Buffers: shared hit=5,918,562
40. 79,071.128 79,071.128 ↑ 1.0 124,880 4,168

Seq Scan on "MonthlyMarketProductVariantDemand" m_1 (cost=0.00..2,981.80 rows=124,944 width=28) (actual time=0.005..18.971 rows=124,880 loops=4,168)

  • Filter: ("forecastImportId" = $0)
  • Buffers: shared hit=5,918,561
41. 0.000 0.000 ↑ 1,570.0 1 520,499,840

Materialize (cost=0.00..33.55 rows=1,570 width=0) (actual time=0.000..0.000 rows=1 loops=520,499,840)

  • Buffers: shared hit=1
42. 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
43. 6.223 33.112 ↓ 51.7 30,500 1

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

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

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

  • Hash Cond: ((forecast."forecastImportId" = abf."forecastImportId") AND (forecast.year = abf.year))
  • Buffers: shared hit=1,343
45. 10.452 10.452 ↑ 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..10.452 rows=118,009 loops=1)

  • Buffers: shared hit=1,342
46. 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
47. 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
48. 0.000 0.000 ↑ 1.0 1 17,775

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

  • Buffers: shared hit=2
49. 0.022 0.022 ↑ 1.0 1 1

Index Only Scan using "BusinessLine_pkey" on "BusinessLine" bl (cost=0.14..8.16 rows=1 width=16) (actual time=0.020..0.022 rows=1 loops=1)

  • Index Cond: (id = '50578e14-1825-4003-978e-620e3495e915'::uuid)
  • Heap Fetches: 1
  • Buffers: shared hit=2
50. 53.325 53.325 ↑ 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.003..0.003 rows=1 loops=17,775)

  • Index Cond: (id = mpv."marketId")
  • Buffers: shared hit=35,550
51. 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
52. 35.550 35.550 ↑ 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.002..0.002 rows=1 loops=17,775)

  • Index Cond: (id = sr."regionId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
53. 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
54. 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
55. 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
56. 35.550 35.550 ↑ 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.002..0.002 rows=1 loops=17,775)

  • Index Cond: (id = p."demographicId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
57. 35.550 35.550 ↑ 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.002..0.002 rows=1 loops=17,775)

  • Index Cond: (id = p."marketingManagedId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
58. 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
59. 71.100 71.100 ↑ 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.004..0.004 rows=1 loops=17,775)

  • Index Cond: (id = p."formId")
  • Heap Fetches: 17,775
  • Buffers: shared hit=35,550
60. 0.225 31,209.107 ↓ 1,193.0 1,193 1

Subquery Scan on *SELECT* 2 (cost=3,577.75..4,753,419.23 rows=1 width=556) (actual time=28,751.932..31,209.107 rows=1,193 loops=1)

  • Buffers: shared hit=197,320 read=2
61. 2.270 31,208.882 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,577.75..4,753,419.22 rows=1 width=6,696) (actual time=28,751.931..31,208.882 rows=1,193 loops=1)

  • Buffers: shared hit=197,320 read=2
62.          

Initplan (for Nested Loop)

63. 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
64. 0.016 0.018 ↑ 1,570.0 1 1

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

  • Sort Key: fi_3."importedAt" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
65. 0.002 0.002 ↑ 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.002 rows=1 loops=1)

  • Buffers: shared hit=1
66. 0.223 31,205.399 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,544.05..4,753,385.26 rows=1 width=599) (actual time=28,751.909..31,205.399 rows=1,193 loops=1)

  • Buffers: shared hit=194,934 read=2
67. 0.286 31,202.790 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,543.91..4,753,385.09 rows=1 width=615) (actual time=28,751.894..31,202.790 rows=1,193 loops=1)

  • Buffers: shared hit=192,548 read=2
68. 0.262 31,200.118 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,543.76..4,753,384.91 rows=1 width=631) (actual time=28,751.882..31,200.118 rows=1,193 loops=1)

  • Buffers: shared hit=190,162 read=2
69. 0.391 31,197.470 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,543.62..4,753,384.74 rows=1 width=647) (actual time=28,751.869..31,197.470 rows=1,193 loops=1)

  • Buffers: shared hit=187,776 read=2
70. 1.441 31,194.693 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,543.47..4,753,384.57 rows=1 width=663) (actual time=28,751.854..31,194.693 rows=1,193 loops=1)

  • Buffers: shared hit=185,390 read=2
71. 0.853 31,192.059 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,543.32..4,753,384.39 rows=1 width=667) (actual time=28,751.839..31,192.059 rows=1,193 loops=1)

  • Buffers: shared hit=183,004 read=2
72. 0.996 31,190.013 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,543.18..4,753,383.46 rows=1 width=683) (actual time=28,751.824..31,190.013 rows=1,193 loops=1)

  • Buffers: shared hit=180,618 read=2
73. 0.272 31,187.824 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,543.04..4,753,383.29 rows=1 width=683) (actual time=28,751.810..31,187.824 rows=1,193 loops=1)

  • Buffers: shared hit=178,232 read=2
74. 1.105 31,185.166 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,542.91..4,753,383.02 rows=1 width=699) (actual time=28,751.795..31,185.166 rows=1,193 loops=1)

  • Buffers: shared hit=175,846 read=2
75. 1.141 31,182.868 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,542.76..4,753,382.02 rows=1 width=699) (actual time=28,751.783..31,182.868 rows=1,193 loops=1)

  • Buffers: shared hit=173,460 read=2
76. 1.047 31,180.534 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,542.62..4,753,381.86 rows=1 width=699) (actual time=28,751.768..31,180.534 rows=1,193 loops=1)

  • Buffers: shared hit=171,074 read=2
77. 52.342 31,178.294 ↓ 1,193.0 1,193 1

Nested Loop (cost=3,542.48..4,753,373.69 rows=1 width=715) (actual time=28,751.756..31,178.294 rows=1,193 loops=1)

  • Join Filter: (ic_1.id = p_1."industryCutId")
  • Rows Removed by Join Filter: 642,907
  • Buffers: shared hit=168,688 read=2
78. 6.197 31,091.600 ↓ 209.5 8,588 1

Nested Loop (cost=3,534.03..4,753,361.28 rows=41 width=183) (actual time=28,751.701..31,091.600 rows=8,588 loops=1)

  • Buffers: shared hit=168,594 read=2
79. 5.740 31,068.227 ↓ 209.5 8,588 1

Nested Loop (cost=3,533.75..4,753,344.12 rows=41 width=99) (actual time=28,751.686..31,068.227 rows=8,588 loops=1)

  • Buffers: shared hit=142,830 read=2
80. 3.543 31,045.311 ↓ 209.5 8,588 1

Nested Loop (cost=3,533.46..4,753,330.97 rows=41 width=99) (actual time=28,751.672..31,045.311 rows=8,588 loops=1)

  • Buffers: shared hit=117,030 read=2
81. 3.789 31,016.004 ↓ 209.5 8,588 1

Nested Loop (cost=3,533.05..4,753,126.67 rows=41 width=83) (actual time=28,751.656..31,016.004 rows=8,588 loops=1)

  • Buffers: shared hit=82,656 read=2
82. 3.572 30,995.039 ↓ 209.5 8,588 1

Nested Loop (cost=3,532.91..4,753,037.97 rows=41 width=99) (actual time=28,751.641..30,995.039 rows=8,588 loops=1)

  • Buffers: shared hit=65,480 read=2
83. 3.967 30,974.291 ↓ 209.5 8,588 1

Nested Loop (cost=3,532.76..4,752,949.28 rows=41 width=115) (actual time=28,751.626..30,974.291 rows=8,588 loops=1)

  • Buffers: shared hit=48,304 read=2
84. 7.795 30,953.148 ↓ 209.5 8,588 1

Nested Loop (cost=3,532.62..4,752,860.59 rows=41 width=131) (actual time=28,751.609..30,953.148 rows=8,588 loops=1)

  • Buffers: shared hit=31,128 read=2
85. 4.001 30,928.177 ↓ 209.5 8,588 1

Nested Loop (cost=3,532.47..4,752,771.90 rows=41 width=147) (actual time=28,751.592..30,928.177 rows=8,588 loops=1)

  • Buffers: shared hit=13,952 read=2
86. 1,341.825 30,924.176 ↓ 209.5 8,588 1

Nested Loop (cost=3,532.33..4,752,763.22 rows=41 width=151) (actual time=28,751.574..30,924.176 rows=8,588 loops=1)

  • Join Filter: (mpv_4.id = mpvsbe."parentMarketProductVariantId")
  • Rows Removed by Join Filter: 15,461,308
  • Buffers: shared hit=13,950 read=2
87. 2.417 28,818.939 ↓ 12.7 7,202 1

Merge Join (cost=3,532.33..4,734,464.07 rows=565 width=156) (actual time=28,747.771..28,818.939 rows=7,202 loops=1)

  • Merge Cond: (m_2."currencyId" = c_2.id)
  • Buffers: shared hit=13,882 read=2
88. 48.180 28,816.455 ↓ 12.7 7,202 1

Nested Loop (cost=3,529.41..4,819,695.86 rows=565 width=140) (actual time=28,747.725..28,816.455 rows=7,202 loops=1)

  • Join Filter: (m_2.id = mpv_3."marketId")
  • Rows Removed by Join Filter: 417,716
  • Buffers: shared hit=13,881 read=2
89. 0.063 0.701 ↑ 1.0 59 1

Nested Loop (cost=0.29..83.84 rows=59 width=32) (actual time=0.044..0.701 rows=59 loops=1)

  • Join Filter: (sr_2."regionId" = r_2.id)
  • Rows Removed by Join Filter: 158
  • Buffers: shared hit=158
90. 0.162 0.579 ↑ 1.0 59 1

Nested Loop (cost=0.29..78.35 rows=59 width=48) (actual time=0.032..0.579 rows=59 loops=1)

  • Buffers: shared hit=157
91. 0.181 0.181 ↑ 1.0 59 1

Index Scan using market_currencyid_index on "Market" m_2 (cost=0.14..20.75 rows=59 width=48) (actual time=0.018..0.181 rows=59 loops=1)

  • Buffers: shared hit=39
92. 0.236 0.236 ↑ 1.0 1 59

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

  • Index Cond: (id = m_2."subregionId")
  • Buffers: shared hit=118
93. 0.050 0.059 ↑ 1.2 4 59

Materialize (cost=0.00..1.07 rows=5 width=16) (actual time=0.000..0.001 rows=4 loops=59)

  • Buffers: shared hit=1
94. 0.009 0.009 ↓ 1.2 6 1

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

  • Buffers: shared hit=1
95. 24.234 28,767.574 ↓ 12.7 7,202 59

Materialize (cost=3,529.13..4,819,113.41 rows=565 width=140) (actual time=482.721..487.586 rows=7,202 loops=59)

  • Buffers: shared hit=13,723 read=2
96. 1.656 28,743.340 ↓ 12.7 7,202 1

Hash Join (cost=3,529.13..4,819,110.58 rows=565 width=140) (actual time=28,480.529..28,743.340 rows=7,202 loops=1)

  • Hash Cond: (p_2."subBrandId" = sb_2.id)
  • Buffers: shared hit=13,723 read=2
97. 1.655 28,741.630 ↓ 12.7 7,202 1

Hash Join (cost=3,512.40..4,819,086.08 rows=565 width=156) (actual time=28,480.465..28,741.630 rows=7,202 loops=1)

  • Hash Cond: (pc_2."businessLineId" = bl_2.id)
  • Buffers: shared hit=13,720 read=2
98. 186.092 28,739.966 ↓ 12.7 7,202 1

Nested Loop (cost=3,499.25..4,819,071.41 rows=565 width=172) (actual time=28,480.448..28,739.966 rows=7,202 loops=1)

  • Join Filter: (ic_2.id = p_2."industryCutId")
  • Rows Removed by Join Filter: 1,627,652
  • Buffers: shared hit=13,719 read=2
99. 0.192 2.041 ↑ 1.0 227 1

Nested Loop (cost=0.56..166.25 rows=227 width=32) (actual time=0.929..2.041 rows=227 loops=1)

  • Buffers: shared hit=450 read=1
100. 0.080 1.249 ↑ 1.0 100 1

Nested Loop (cost=0.29..93.74 rows=100 width=32) (actual time=0.910..1.249 rows=100 loops=1)

  • Buffers: shared hit=78 read=1
101. 0.067 0.067 ↑ 3.7 38 1

Index Scan using productcategory_businesslineid_name_unique on "ProductCategory" pc_2 (cost=0.14..50.25 rows=140 width=32) (actual time=0.020..0.067 rows=38 loops=1)

  • Buffers: shared hit=3
102. 1.102 1.102 ↑ 1.0 3 38

Index Scan using productsubcategory_productcategoryid_name_unique on "ProductSubcategory" psc_2 (cost=0.14..0.28 rows=3 width=32) (actual time=0.027..0.029 rows=3 loops=38)

  • Index Cond: ("productCategoryId" = pc_2.id)
  • Buffers: shared hit=75 read=1
103. 0.600 0.600 ↑ 1.0 2 100

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

  • Index Cond: ("productSubcategoryId" = psc_2.id)
  • Buffers: shared hit=372
104. 85.929 28,551.833 ↓ 12.7 7,202 227

Materialize (cost=3,498.69..4,816,982.75 rows=565 width=172) (actual time=0.263..125.779 rows=7,202 loops=227)

  • Buffers: shared hit=13,269 read=1
105. 18,026.338 28,465.904 ↓ 12.7 7,202 1

Nested Loop (cost=3,498.69..4,816,979.92 rows=565 width=172) (actual time=59.754..28,465.904 rows=7,202 loops=1)

  • Join Filter: ((forecast_1."marketProductVariantId" = mpv_4.id) OR (m_3."marketProductVariantId" = mpv_4.id))
  • Rows Removed by Join Filter: 203,973,414
  • Buffers: shared hit=13,269 read=1
106. 79.286 184.083 ↓ 1.6 94,087 1

Hash Full Join (cost=3,194.44..4,669,995.51 rows=57,257 width=56) (actual time=31.824..184.083 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
107. 45.422 73.028 ↑ 1,570.8 124,880 1

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

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

  • Filter: ("forecastImportId" = $1)
  • Buffers: shared hit=1,421
109. 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
110. 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
111. 5.880 31.769 ↓ 51.7 30,500 1

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

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

Hash Join (cost=41.75..3,184.12 rows=590 width=28) (actual time=0.026..25.889 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
113. 10.032 10.032 ↑ 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.005..10.032 rows=118,009 loops=1)

  • Buffers: shared hit=1,342
114. 0.003 0.008 ↑ 1,270.0 1 1

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

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

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

  • Buffers: shared hit=1
116. 10,241.231 10,255.483 ↓ 14.8 2,168 94,087

Materialize (cost=304.25..693.14 rows=146 width=164) (actual time=0.000..0.109 rows=2,168 loops=94,087)

  • Buffers: shared hit=10,504 read=1
117. 2.055 14.252 ↓ 14.8 2,168 1

Nested Loop (cost=304.25..692.41 rows=146 width=164) (actual time=2.795..14.252 rows=2,168 loops=1)

  • Buffers: shared hit=10,504 read=1
118. 0.343 7.861 ↓ 14.8 2,168 1

Nested Loop (cost=303.83..612.97 rows=146 width=148) (actual time=1.521..7.861 rows=2,168 loops=1)

  • Buffers: shared hit=3,994
119. 0.997 3.540 ↓ 15.4 663 1

Hash Join (cost=303.42..502.94 rows=43 width=132) (actual time=1.495..3.540 rows=663 loops=1)

  • Hash Cond: (pv_2."productId" = p_2.id)
  • Buffers: shared hit=308
120. 1.070 1.070 ↓ 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.070 rows=8,699 loops=1)

  • Buffers: shared hit=90
121. 0.157 1.473 ↓ 22.9 549 1

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

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

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

  • Filter: ((type)::text = 'salesBundle'::text)
  • Rows Removed by Filter: 4,315
  • Buffers: shared hit=218
123. 3.978 3.978 ↑ 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.006 rows=3 loops=663)

  • Index Cond: ("productVariantId" = pv_2.id)
  • Buffers: shared hit=3,686
124. 4.336 4.336 ↑ 1.0 1 2,168

Index Only Scan using "MarketProductVariant_pkey" on "MarketProductVariant" mpv_4 (cost=0.41..0.54 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=2,168)

  • Index Cond: (id = mpv_3.id)
  • Heap Fetches: 0
  • Buffers: shared hit=6,510 read=1
125. 0.006 0.009 ↑ 20.0 7 1

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

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

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

  • Buffers: shared hit=1
127. 0.009 0.054 ↑ 1.0 63 1

Hash (cost=15.95..15.95 rows=63 width=16) (actual time=0.054..0.054 rows=63 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=3
128. 0.016 0.045 ↑ 1.0 63 1

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

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

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

  • Buffers: shared hit=2
130. 0.008 0.014 ↑ 4.2 33 1

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

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

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

  • Buffers: shared hit=1
132. 0.056 0.067 ↑ 1.0 50 1

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

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

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

  • Buffers: shared hit=1
134. 763.055 763.412 ↑ 1.0 2,148 7,202

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

  • Buffers: shared hit=68
135. 0.357 0.357 ↑ 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.357 rows=2,148 loops=1)

  • Buffers: shared hit=68
136. 0.000 0.000 ↑ 1.0 1 8,588

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

  • Buffers: shared hit=2
137. 0.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

  • Index Cond: (name = 'salesBundle'::text)
  • Heap Fetches: 1
  • Buffers: shared hit=2
138. 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
139. 17.176 17.176 ↑ 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.002..0.002 rows=1 loops=8,588)

  • Index Cond: (id = p_2."demographicId")
  • Heap Fetches: 8,588
  • Buffers: shared hit=17,176
140. 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
141. 17.176 17.176 ↑ 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.002..0.002 rows=1 loops=8,588)

  • Index Cond: (id = p_2."marketingFocusId")
  • Heap Fetches: 8,588
  • Buffers: shared hit=17,176
142. 25.764 25.764 ↑ 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.003..0.003 rows=1 loops=8,588)

  • Index Cond: (id = mpvsbe."marketProductVariantId")
  • Buffers: shared hit=34,374
143. 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
144. 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
145. 34.204 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
146. 0.008 0.148 ↓ 37.5 75 1

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

  • Buffers: shared hit=94
147. 0.030 0.060 ↓ 20.0 20 1

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

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

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

  • Buffers: shared hit=1
149. 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
150. 0.011 0.011 ↓ 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.009..0.011 rows=5 loops=1)

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

  • Index Cond: ("productSubcategoryId" = psc_1.id)
  • Buffers: shared hit=91
152. 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
153. 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
154. 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
155. 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
156. 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
157. 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
158. 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
159. 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
160. 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
161. 2.386 2.386 ↑ 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.002..0.002 rows=1 loops=1,193)

  • Index Cond: (id = p_1."marketingManagedId")
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
162. 2.386 2.386 ↑ 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.002..0.002 rows=1 loops=1,193)

  • Index Cond: (id = p_1."marketingFocusId")
  • Heap Fetches: 1,193
  • Buffers: shared hit=2,386
163. 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 : 33.519 ms
Execution time : 492,213.878 ms