explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yTo3

Settings
# exclusive inclusive rows x rows loops node
1. 616.564 616.564 ↑ 1.0 1 1

Limit (cost=351,981.43..352,030.12 rows=1 width=1,476) (actual time=616.553..616.564 rows=1 loops=1)

2.          

CTE params

3. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=68) (actual time=0.001..0.002 rows=1 loops=1)

4.          

CTE asset

5. 1.388 68.651 ↓ 15.2 4,418 1

Unique (cost=36,121.35..36,290.78 rows=290 width=119) (actual time=40.492..68.651 rows=4,418 loops=1)

6.          

Initplan (for Unique)

7. 0.004 0.004 ↑ 1.0 1 1

CTE Scan on params (cost=0.00..0.02 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

8. 0.000 0.000 ↓ 0.0 0

CTE Scan on params params_1 (cost=0.00..0.02 rows=1 width=32) (never executed)

9. 26.530 67.259 ↑ 1.3 5,985 1

WindowAgg (cost=36,121.31..36,271.91 rows=7,530 width=119) (actual time=40.491..67.259 rows=5,985 loops=1)

10. 3.154 40.729 ↑ 1.3 5,985 1

Sort (cost=36,121.31..36,140.14 rows=7,530 width=99) (actual time=40.291..40.729 rows=5,985 loops=1)

  • Sort Key: portfolio_asset_1.id, address_matched_by_building.main_address DESC
  • Sort Method: quicksort Memory: 660kB
11. 3.106 37.575 ↑ 1.3 5,985 1

Nested Loop Left Join (cost=6.94..35,636.44 rows=7,530 width=99) (actual time=0.175..37.575 rows=5,985 loops=1)

12. 0.885 21.215 ↓ 16.2 4,418 1

Hash Left Join (cost=6.38..2,425.23 rows=272 width=94) (actual time=0.151..21.215 rows=4,418 loops=1)

  • Hash Cond: (portfolio_asset_1.ref_building_period_id = ref_building_period_i18n.id)
13. 0.000 20.314 ↓ 16.2 4,418 1

Nested Loop Left Join (cost=5.00..2,423.14 rows=272 width=82) (actual time=0.117..20.314 rows=4,418 loops=1)

14. 0.862 2.754 ↓ 16.2 4,418 1

Hash Left Join (cost=4.57..127.81 rows=272 width=78) (actual time=0.090..2.754 rows=4,418 loops=1)

  • Hash Cond: (portfolio_asset_1.company_branch_id = company_branch.id)
  • Filter: ((company_branch.deleted_at IS NULL) AND ((portfolio_asset_1.company_branch_id IS NULL) OR (ARRAY[company_branch.user_community_id] && $2)))
15. 1.844 1.844 ↓ 15.2 4,418 1

Seq Scan on portfolio_asset portfolio_asset_1 (cost=0.00..122.49 rows=290 width=61) (actual time=0.023..1.844 rows=4,418 loops=1)

  • Filter: ((deleted_at IS NULL) AND (user_company_id = $1))
  • Rows Removed by Filter: 261
16. 0.024 0.048 ↑ 1.4 82 1

Hash (cost=3.14..3.14 rows=114 width=29) (actual time=0.048..0.048 rows=82 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
17. 0.024 0.024 ↑ 1.4 82 1

Seq Scan on company_branch (cost=0.00..3.14 rows=114 width=29) (actual time=0.009..0.024 rows=82 loops=1)

18. 17.672 17.672 ↑ 1.0 1 4,418

Index Scan using gen_match_cap_address_pkey on gen_match_cap_address match_building (cost=0.43..8.44 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4,418)

  • Index Cond: (address_id = portfolio_asset_1.main_address_id)
19. 0.005 0.016 ↑ 1.0 10 1

Hash (cost=1.25..1.25 rows=10 width=20) (actual time=0.016..0.016 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.011 0.011 ↑ 1.0 10 1

Seq Scan on ref_building_period_i18n (cost=0.00..1.25 rows=10 width=20) (actual time=0.007..0.011 rows=10 loops=1)

  • Filter: ((culture)::text = 'fr_FR'::text)
  • Rows Removed by Filter: 10
21. 13.254 13.254 ↑ 28.0 1 4,418

Index Scan using building_address_building_id on building_address address_matched_by_building (cost=0.56..121.82 rows=28 width=9) (actual time=0.003..0.003 rows=1 loops=4,418)

  • Index Cond: (building_id = portfolio_asset_1.building_id)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 0
22.          

CTE asset_address

23. 0.003 437.037 ↑ 290.0 1 1

Unique (cost=6,551.98..6,553.43 rows=290 width=600) (actual time=437.037..437.037 rows=1 loops=1)

24. 2.487 437.034 ↑ 290.0 1 1

Sort (cost=6,551.98..6,552.71 rows=290 width=600) (actual time=437.034..437.034 rows=1 loops=1)

  • Sort Key: portfolio_asset_2.id
  • Sort Method: quicksort Memory: 586kB
25. 50.176 434.547 ↓ 15.2 4,418 1

Hash Left Join (cost=3,275.72..6,540.12 rows=290 width=600) (actual time=245.897..434.547 rows=4,418 loops=1)

  • Hash Cond: (address_street.ref_address_street_type_id = ref_address_street_type.id)
26. 5.242 384.246 ↓ 15.2 4,418 1

Nested Loop Left Join (cost=3,266.97..6,514.65 rows=290 width=842) (actual time=245.726..384.246 rows=4,418 loops=1)

27. 25.755 308.316 ↓ 15.2 4,418 1

Hash Left Join (cost=3,266.41..4,023.55 rows=290 width=790) (actual time=245.674..308.316 rows=4,418 loops=1)

  • Hash Cond: (asset_1.id = portfolio_asset_2.id)
28. 34.729 280.152 ↓ 15.2 4,418 1

Hash Right Join (cost=3,097.13..3,853.51 rows=290 width=712) (actual time=243.199..280.152 rows=4,418 loops=1)

  • Hash Cond: (ref_postal_code.id = ref_postal_city.ref_postal_code_id)
29. 2.450 2.450 ↑ 1.0 29,034 1

Seq Scan on ref_postal_code (cost=0.00..499.39 rows=29,039 width=10) (actual time=0.013..2.450 rows=29,034 loops=1)

30. 2.947 242.973 ↓ 15.2 4,418 1

Hash (cost=3,093.51..3,093.51 rows=290 width=708) (actual time=242.973..242.973 rows=4,418 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 443kB
31. 2.198 240.026 ↓ 15.2 4,418 1

Nested Loop Left Join (cost=9.32..3,093.51 rows=290 width=708) (actual time=0.160..240.026 rows=4,418 loops=1)

32. 0.689 206.902 ↓ 15.2 4,418 1

Nested Loop Left Join (cost=9.02..1,811.21 rows=290 width=689) (actual time=0.127..206.902 rows=4,418 loops=1)

33. 40.993 139.943 ↓ 15.2 4,418 1

Nested Loop Left Join (cost=8.59..477.67 rows=290 width=550) (actual time=0.082..139.943 rows=4,418 loops=1)

34. 1.754 1.754 ↓ 15.2 4,418 1

CTE Scan on asset asset_1 (cost=0.00..5.80 rows=290 width=528) (actual time=0.002..1.754 rows=4,418 loops=1)

35. 35.344 97.196 ↑ 1.0 1 4,418

Hash Right Join (cost=8.59..10.18 rows=1 width=26) (actual time=0.019..0.022 rows=1 loops=4,418)

  • Hash Cond: (ref_address_cardinal.id = address.ref_address_cardinal_id)
36. 17.672 17.672 ↑ 1.0 42 4,418

Seq Scan on ref_address_cardinal (cost=0.00..1.42 rows=42 width=6) (actual time=0.002..0.004 rows=42 loops=4,418)

37. 4.418 44.180 ↑ 1.0 1 4,418

Hash (cost=8.58..8.58 rows=1 width=24) (actual time=0.010..0.010 rows=1 loops=4,418)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
38. 39.762 39.762 ↑ 1.0 1 4,418

Index Scan using address_pkey on address (cost=0.56..8.58 rows=1 width=24) (actual time=0.009..0.009 rows=1 loops=4,418)

  • Index Cond: (asset_1.main_address_id = id)
  • Filter: (deleted_at IS NULL)
39. 66.270 66.270 ↑ 1.0 1 4,418

Index Scan using address_street_pkey on address_street (cost=0.43..4.60 rows=1 width=147) (actual time=0.015..0.015 rows=1 loops=4,418)

  • Index Cond: (address.address_street_id = id)
  • Filter: (deleted_at IS NULL)
40. 30.926 30.926 ↑ 1.0 1 4,418

Index Scan using ref_postal_city_pkey on ref_postal_city (cost=0.29..4.42 rows=1 width=27) (actual time=0.007..0.007 rows=1 loops=4,418)

  • Index Cond: (address_street.ref_postal_city_id = id)
41. 0.964 2.409 ↑ 1.0 4,679 1

Hash (cost=110.79..110.79 rows=4,679 width=82) (actual time=2.409..2.409 rows=4,679 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 304kB
42. 1.445 1.445 ↑ 1.0 4,679 1

Seq Scan on portfolio_asset portfolio_asset_2 (cost=0.00..110.79 rows=4,679 width=82) (actual time=0.012..1.445 rows=4,679 loops=1)

43. 70.688 70.688 ↑ 1.0 1 4,418

Index Scan using gen_building_building_id on gen_building (cost=0.56..8.58 rows=1 width=60) (actual time=0.016..0.016 rows=1 loops=4,418)

  • Index Cond: (asset_1.building_id = building_id)
44. 0.066 0.125 ↑ 1.0 300 1

Hash (cost=5.00..5.00 rows=300 width=12) (actual time=0.125..0.125 rows=300 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
45. 0.059 0.059 ↑ 1.0 300 1

Seq Scan on ref_address_street_type (cost=0.00..5.00 rows=300 width=12) (actual time=0.013..0.059 rows=300 loops=1)

46.          

CTE list_implantation

47. 1.865 5.111 ↓ 6.5 4,418 1

Hash Left Join (cost=188.70..262.43 rows=679 width=902) (actual time=2.449..5.111 rows=4,418 loops=1)

  • Hash Cond: (asset_2.id = portfolio_implantation.portfolio_asset_id)
48. 0.819 0.819 ↓ 15.2 4,418 1

CTE Scan on asset asset_2 (cost=0.00..5.80 rows=290 width=4) (actual time=0.002..0.819 rows=4,418 loops=1)

49. 0.526 2.427 ↑ 2.2 664 1

Hash (cost=170.71..170.71 rows=1,439 width=886) (actual time=2.427..2.427 rows=664 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 149kB
50. 1.901 1.901 ↑ 1.0 1,439 1

Seq Scan on portfolio_implantation (cost=0.00..170.71 rows=1,439 width=886) (actual time=0.030..1.901 rows=1,439 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 532
51.          

CTE list_lots

52. 1.303 10.827 ↓ 5.0 4,418 1

Hash Left Join (cost=96.99..142.55 rows=887 width=41) (actual time=3.848..10.827 rows=4,418 loops=1)

  • Hash Cond: (list_implantation.id = lot.portfolio_implantation_id)
53. 8.174 8.174 ↓ 6.5 4,418 1

CTE Scan on list_implantation (cost=0.00..13.58 rows=679 width=8) (actual time=2.453..8.174 rows=4,418 loops=1)

54. 0.567 1.350 ↑ 1.0 2,573 1

Hash (cost=63.95..63.95 rows=2,643 width=36) (actual time=1.350..1.350 rows=2,573 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 210kB
55. 0.783 0.783 ↑ 1.0 2,573 1

Seq Scan on portfolio_implantation_lot lot (cost=0.00..63.95 rows=2,643 width=36) (actual time=0.015..0.783 rows=2,573 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 54
56.          

CTE implantation_lot_properties_unnest

57. 0.001 14.114 ↓ 0.0 0 1

Hash Left Join (cost=6.63..2,039.23 rows=88,700 width=69) (actual time=14.114..14.114 rows=0 loops=1)

  • Hash Cond: (ref_property_nature_id.ref_property_nature_id = ref_property_nature_i18n.id)
58.          

Initplan (for Hash Left Join)

59. 0.000 0.000 ↓ 0.0 0

CTE Scan on params params_2 (cost=0.00..0.02 rows=1 width=32) (never executed)

60. 1.996 14.113 ↓ 0.0 0 1

Nested Loop (cost=0.00..1,791.74 rows=88,700 width=52) (actual time=14.113..14.113 rows=0 loops=1)

61. 12.117 12.117 ↓ 5.0 4,418 1

CTE Scan on list_lots (cost=0.00..17.74 rows=887 width=48) (actual time=3.850..12.117 rows=4,418 loops=1)

62. 0.000 0.000 ↓ 0.0 0 4,418

Function Scan on unnest ref_property_nature_id (cost=0.00..1.00 rows=100 width=4) (actual time=0.000..0.000 rows=0 loops=4,418)

63. 0.000 0.000 ↓ 0.0 0

Hash (cost=5.08..5.08 rows=123 width=21) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Seq Scan on ref_property_nature_i18n (cost=0.00..5.08 rows=123 width=21) (never executed)

  • Filter: ((culture)::text = ($13)::text)
65.          

CTE grouped_lots

66. 15.395 18.807 ↑ 200.0 1 1

GroupAggregate (cost=321.51..4,383.78 rows=200 width=41) (actual time=18.807..18.807 rows=1 loops=1)

  • Group Key: list_implantation_1.id
67. 1.068 3.412 ↓ 1.5 4,418 1

Sort (cost=321.51..329.03 rows=3,011 width=49) (actual time=3.090..3.412 rows=4,418 loops=1)

  • Sort Key: list_implantation_1.id
  • Sort Method: quicksort Memory: 331kB
68. 0.692 2.344 ↓ 1.5 4,418 1

Hash Left Join (cost=22.07..147.53 rows=3,011 width=49) (actual time=1.304..2.344 rows=4,418 loops=1)

  • Hash Cond: (list_lots_1.portfolio_implantation_id = list_implantation_1.id)
69. 0.374 0.374 ↓ 5.0 4,418 1

CTE Scan on list_lots list_lots_1 (cost=0.00..17.74 rows=887 width=40) (actual time=0.002..0.374 rows=4,418 loops=1)

70. 0.181 1.278 ↓ 0.0 0 1

Hash (cost=13.58..13.58 rows=679 width=13) (actual time=1.278..1.278 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
71. 1.097 1.097 ↓ 6.5 4,418 1

CTE Scan on list_implantation list_implantation_1 (cost=0.00..13.58 rows=679 width=13) (actual time=0.002..1.097 rows=4,418 loops=1)

72.          

CTE stats_implantation

73. 0.001 0.905 ↓ 0.0 0 1

Hash Join (cost=6.50..36.23 rows=340 width=28) (actual time=0.905..0.905 rows=0 loops=1)

  • Hash Cond: (list_implantation_2.id = grouped_lots.portfolio_implantation_id)
74. 0.904 0.904 ↓ 0.0 0 1

CTE Scan on list_implantation list_implantation_2 (cost=0.00..13.58 rows=340 width=12) (actual time=0.904..0.904 rows=0 loops=1)

  • Filter: (is_vacant IS FALSE)
  • Rows Removed by Filter: 4418
75. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.00..4.00 rows=200 width=12) (never executed)

76. 0.000 0.000 ↓ 0.0 0

CTE Scan on grouped_lots (cost=0.00..4.00 rows=200 width=12) (never executed)

77.          

CTE data_by_natures_id

78. 0.326 0.329 ↓ 0.0 0 1

HashAggregate (cost=166,771.54..167,671.54 rows=40,000 width=32) (actual time=0.329..0.329 rows=0 loops=1)

  • Group Key: asset_3.id, implantation_lot_properties_unnest.ref_property_nature_id
79. 0.001 0.003 ↓ 0.0 0 1

Hash Left Join (cost=111,294.07..153,937.36 rows=570,408 width=36) (actual time=0.003..0.003 rows=0 loops=1)

  • Hash Cond: (implantation_lot_properties_unnest.portfolio_implantation_lot_id = list_lots_2.portfolio_implantation_lot_id)
80. 0.000 0.002 ↓ 0.0 0 1

Hash Left Join (cost=111,265.24..133,574.49 rows=128,615 width=36) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (implantation_lot_properties_unnest.portfolio_implantation_id = portfolio_implantation_1.id)
81. 0.001 0.002 ↓ 0.0 0 1

Hash Left Join (cost=111,057.05..132,873.55 rows=128,615 width=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: ((asset_3.building_id = building_nature_price_rent.building_id) AND (implantation_lot_properties_unnest.ref_property_nature_id = building_nature_price_rent.ref_property_nature_id))
82. 0.001 0.001 ↓ 0.0 0 1

Hash Left Join (cost=9.43..6,506.70 rows=128,615 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Hash Cond: (implantation_lot_properties_unnest.portfolio_asset_id = asset_3.id)
83. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on implantation_lot_properties_unnest (cost=0.00..1,774.00 rows=88,700 width=16) (actual time=0.000..0.000 rows=0 loops=1)

84. 0.000 0.000 ↓ 0.0 0

Hash (cost=5.80..5.80 rows=290 width=8) (never executed)

85. 0.000 0.000 ↓ 0.0 0

CTE Scan on asset asset_3 (cost=0.00..5.80 rows=290 width=8) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Hash (cost=57,559.45..57,559.45 rows=2,690,145 width=16) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Seq Scan on building_nature_price_rent (cost=0.00..57,559.45 rows=2,690,145 width=16) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Hash (cost=207.99..207.99 rows=16 width=20) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=199.60..207.99 rows=16 width=20) (never executed)

  • Hash Cond: (stats_implantation.portfolio_implantation_id = portfolio_implantation_1.id)
90. 0.000 0.000 ↓ 0.0 0

CTE Scan on stats_implantation (cost=0.00..6.80 rows=340 width=12) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Hash (cost=198.41..198.41 rows=95 width=16) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=194.15..198.41 rows=95 width=16) (never executed)

  • Hash Cond: (grouped_lots_1.portfolio_implantation_id = portfolio_implantation_1.id)
93. 0.000 0.000 ↓ 0.0 0

CTE Scan on grouped_lots grouped_lots_1 (cost=0.00..4.00 rows=100 width=12) (never executed)

  • Filter: (NOT is_multi_nature)
94. 0.000 0.000 ↓ 0.0 0

Hash (cost=170.71..170.71 rows=1,875 width=4) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Seq Scan on portfolio_implantation portfolio_implantation_1 (cost=0.00..170.71 rows=1,875 width=4) (never executed)

  • Filter: (NOT is_vacant)
96. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.74..17.74 rows=887 width=8) (never executed)

97. 0.000 0.000 ↓ 0.0 0

CTE Scan on list_lots list_lots_2 (cost=0.00..17.74 rows=887 width=8) (never executed)

98.          

CTE calcul_lots

99. 0.048 0.911 ↓ 0.0 0 1

Hash Right Join (cost=12,939.03..20,667.65 rows=150,790 width=12) (actual time=0.911..0.911 rows=0 loops=1)

  • Hash Cond: (implantation_lot_properties_unnest_1.portfolio_implantation_id = list_implantation_3.id)
100. 0.000 0.000 ↓ 0.0 0

Merge Right Join (cost=12,921.20..14,773.45 rows=88,700 width=16) (never executed)

  • Merge Cond: ((data_by_natures_id.id = implantation_lot_properties_unnest_1.portfolio_asset_id) AND (data_by_natures_id.ref_property_nature_id = implantation_lot_properties_unnest_1.ref_property_nature_id))
101. 0.000 0.000 ↓ 0.0 0

Sort (cost=3,857.54..3,957.54 rows=40,000 width=12) (never executed)

  • Sort Key: data_by_natures_id.id, data_by_natures_id.ref_property_nature_id
102. 0.000 0.000 ↓ 0.0 0

CTE Scan on data_by_natures_id (cost=0.00..800.00 rows=40,000 width=12) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Sort (cost=9,063.65..9,285.40 rows=88,700 width=20) (never executed)

  • Sort Key: implantation_lot_properties_unnest_1.portfolio_asset_id, implantation_lot_properties_unnest_1.ref_property_nature_id
104. 0.000 0.000 ↓ 0.0 0

CTE Scan on implantation_lot_properties_unnest implantation_lot_properties_unnest_1 (cost=0.00..1,774.00 rows=88,700 width=20) (never executed)

105. 0.000 0.863 ↓ 0.0 0 1

Hash (cost=13.58..13.58 rows=340 width=4) (actual time=0.863..0.863 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
106. 0.863 0.863 ↓ 0.0 0 1

CTE Scan on list_implantation list_implantation_3 (cost=0.00..13.58 rows=340 width=4) (actual time=0.862..0.863 rows=0 loops=1)

  • Filter: (NOT is_vacant)
  • Rows Removed by Filter: 4418
107.          

CTE implantation_market_comparison

108. 0.003 0.992 ↓ 0.0 0 1

HashAggregate (cost=32,339.10..32,341.10 rows=200 width=20) (actual time=0.992..0.992 rows=0 loops=1)

  • Group Key: list_implantation_4.id
109. 0.013 0.989 ↓ 0.0 0 1

Hash Right Join (cost=24,116.67..30,510.17 rows=243,857 width=16) (actual time=0.989..0.989 rows=0 loops=1)

  • Hash Cond: (calcul_lots.portfolio_implantation_id = implantation_computable.portfolio_implantation_id)
110. 0.000 0.000 ↓ 0.0 0

CTE Scan on calcul_lots (cost=0.00..3,015.80 rows=150,790 width=8) (never executed)

111. 0.000 0.976 ↓ 0.0 0 1

Hash (cost=24,112.64..24,112.64 rows=323 width=16) (actual time=0.976..0.976 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
112. 0.002 0.976 ↓ 0.0 0 1

Merge Join (cost=24,105.54..24,112.64 rows=323 width=16) (actual time=0.976..0.976 rows=0 loops=1)

  • Merge Cond: (implantation_computable.portfolio_implantation_id = list_implantation_4.id)
113. 0.017 0.974 ↓ 0.0 0 1

Sort (cost=24,060.02..24,060.26 rows=95 width=8) (actual time=0.974..0.974 rows=0 loops=1)

  • Sort Key: implantation_computable.portfolio_implantation_id
  • Sort Method: quicksort Memory: 25kB
114. 0.019 0.957 ↓ 0.0 0 1

Hash Join (cost=23,881.25..24,056.90 rows=95 width=8) (actual time=0.956..0.957 rows=0 loops=1)

  • Hash Cond: (portfolio_implantation_2.id = implantation_computable.portfolio_implantation_id)
115. 0.020 0.020 ↑ 1,875.0 1 1

Seq Scan on portfolio_implantation portfolio_implantation_2 (cost=0.00..170.71 rows=1,875 width=4) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (NOT is_vacant)
  • Rows Removed by Filter: 2
116. 0.000 0.918 ↓ 0.0 0 1

Hash (cost=23,880.00..23,880.00 rows=100 width=4) (actual time=0.918..0.918 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
117. 0.001 0.918 ↓ 0.0 0 1

Subquery Scan on implantation_computable (cost=23,877.00..23,880.00 rows=100 width=4) (actual time=0.918..0.918 rows=0 loops=1)

118. 0.004 0.917 ↓ 0.0 0 1

HashAggregate (cost=23,877.00..23,879.00 rows=100 width=5) (actual time=0.917..0.917 rows=0 loops=1)

  • Group Key: calcul_lots_1.portfolio_implantation_id
  • Filter: (bool_and(CASE WHEN (calcul_lots_1.rental_market_by_lot_and_nature IS NULL) THEN false ELSE true END) IS TRUE)
119. 0.001 0.913 ↓ 0.0 0 1

Hash Join (cost=22.03..21,328.65 rows=509,670 width=8) (actual time=0.912..0.913 rows=0 loops=1)

  • Hash Cond: (calcul_lots_1.portfolio_implantation_id = list_implantation_5.id)
120. 0.912 0.912 ↓ 0.0 0 1

CTE Scan on calcul_lots calcul_lots_1 (cost=0.00..3,015.80 rows=150,790 width=8) (actual time=0.912..0.912 rows=0 loops=1)

121. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.58..13.58 rows=676 width=4) (never executed)