explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uE3

Settings
# exclusive inclusive rows x rows loops node
1. 130.085 130.085 ↓ 19.3 367 1

Nested Loop Left Join (cost=7,256.69..7,271.61 rows=19 width=1,147) (actual time=39.191..130.085 rows=367 loops=1)

2.          

CTE params

3. 0.001 0.001 ↑ 1.0 1 1

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

4.          

CTE culture

5. 0.003 0.023 ↑ 1.0 1 1

Aggregate (cost=1.26..1.27 rows=1 width=32) (actual time=0.023..0.023 rows=1 loops=1)

6. 0.020 0.020 ↓ 0.0 0 1

Function Scan on unnest culture (cost=0.00..1.25 rows=1 width=32) (actual time=0.020..0.020 rows=0 loops=1)

  • Filter: (culture ~ '^fr_FR_'::text)
  • Rows Removed by Filter: 2
7.          

CTE portfolio_implantation_match_data

8. 0.164 3.163 ↓ 33.4 367 1

GroupAggregate (cost=285.70..285.95 rows=11 width=16) (actual time=2.973..3.163 rows=367 loops=1)

  • Group Key: portfolio_implantation_1.id
9.          

Initplan (for GroupAggregate)

10. 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)

11. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on params params_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

12. 0.133 2.994 ↓ 33.4 367 1

Sort (cost=285.66..285.69 rows=11 width=32) (actual time=2.965..2.994 rows=367 loops=1)

  • Sort Key: portfolio_implantation_1.id
  • Sort Method: quicksort Memory: 45kB
13. 0.162 2.861 ↓ 33.4 367 1

Nested Loop Left Join (cost=4.38..285.47 rows=11 width=32) (actual time=0.094..2.861 rows=367 loops=1)

14. 0.070 1.965 ↓ 33.4 367 1

Nested Loop Left Join (cost=3.95..192.49 rows=11 width=28) (actual time=0.088..1.965 rows=367 loops=1)

15. 0.274 1.161 ↓ 33.4 367 1

Hash Left Join (cost=3.51..99.41 rows=11 width=20) (actual time=0.075..1.161 rows=367 loops=1)

  • Hash Cond: ((portfolio_implantation_1.user_company_id = company_branch_1.user_company_id) AND (portfolio_implantation_1.company_branch_id = company_branch_1.id))
  • Filter: ((company_branch_1.deleted_at IS NULL) AND ((portfolio_implantation_1.company_branch_id IS NULL) OR (array_remove(ARRAY[company_branch_1.user_community_id], NULL::integer) && $3)))
16. 0.866 0.866 ↓ 6.3 367 1

Seq Scan on portfolio_implantation portfolio_implantation_1 (cost=0.00..95.59 rows=58 width=28) (actual time=0.031..0.866 rows=367 loops=1)

  • Filter: ((deleted_at IS NULL) AND (user_company_id = $2))
  • Rows Removed by Filter: 1603
17. 0.003 0.021 ↑ 1.2 5 1

Hash (cost=3.42..3.42 rows=6 width=20) (actual time=0.021..0.021 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
18. 0.018 0.018 ↑ 1.2 5 1

Seq Scan on company_branch company_branch_1 (cost=0.00..3.42 rows=6 width=20) (actual time=0.009..0.018 rows=5 loops=1)

  • Filter: (user_company_id = $2)
  • Rows Removed by Filter: 77
19. 0.734 0.734 ↓ 0.0 0 367

Index Scan using gen_establishment_search_establishment_id on gen_establishment_search (cost=0.43..8.45 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=367)

  • Index Cond: (establishment_id = portfolio_implantation_1.establishment_id)
20. 0.734 0.734 ↓ 0.0 0 367

Index Scan using gen_match_cap_address_pkey on gen_match_cap_address (cost=0.43..8.45 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=367)

  • Index Cond: (address_id = portfolio_implantation_1.main_address_id)
21.          

CTE implantation_lpdi

22. 0.066 14.342 ↓ 19.3 367 1

Unique (cost=1,880.75..1,880.85 rows=19 width=32) (actual time=14.255..14.342 rows=367 loops=1)

23. 0.163 14.276 ↓ 23.8 452 1

Sort (cost=1,880.75..1,880.80 rows=19 width=32) (actual time=14.254..14.276 rows=452 loops=1)

  • Sort Key: portfolio_implantation_2.id
  • Sort Method: quicksort Memory: 52kB
24. 0.280 14.113 ↓ 23.8 452 1

Hash Right Join (cost=1,527.55..1,880.35 rows=19 width=32) (actual time=8.276..14.113 rows=452 loops=1)

  • Hash Cond: ((first(portfolio_implantation_match_data_1.match_building_id)) = portfolio_implantation_match_data.match_building_id)
25. 5.707 7.629 ↑ 1.9 180 1

GroupAggregate (cost=1,260.39..1,607.36 rows=341 width=13) (actual time=2.049..7.629 rows=180 loops=1)

  • Group Key: building_address_1.main_address, building_address_1.building_id
26. 0.426 1.922 ↓ 4.3 1,481 1

Sort (cost=1,260.39..1,261.24 rows=341 width=17) (actual time=1.841..1.922 rows=1,481 loops=1)

  • Sort Key: building_address_1.main_address, building_address_1.building_id
  • Sort Method: quicksort Memory: 153kB
27. 0.365 1.496 ↓ 4.3 1,481 1

Nested Loop Left Join (cost=0.56..1,246.05 rows=341 width=17) (actual time=0.016..1.496 rows=1,481 loops=1)

28. 0.030 0.030 ↓ 33.4 367 1

CTE Scan on portfolio_implantation_match_data portfolio_implantation_match_data_1 (cost=0.00..0.22 rows=11 width=8) (actual time=0.000..0.030 rows=367 loops=1)

29. 1.101 1.101 ↑ 10.3 3 367

Index Scan using building_address_building_id on building_address building_address_1 (cost=0.56..112.95 rows=31 width=9) (actual time=0.002..0.003 rows=3 loops=367)

  • Index Cond: (building_id = portfolio_implantation_match_data_1.match_building_id)
30. 0.103 6.204 ↓ 34.0 374 1

Hash (cost=267.02..267.02 rows=11 width=40) (actual time=6.203..6.204 rows=374 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
31. 0.305 6.101 ↓ 34.0 374 1

Nested Loop Left Join (cost=1.28..267.02 rows=11 width=40) (actual time=3.024..6.101 rows=374 loops=1)

  • Join Filter: (building.id = building_address.building_id)
  • Rows Removed by Join Filter: 416
32. 0.057 4.695 ↓ 33.4 367 1

Nested Loop Left Join (cost=0.72..172.48 rows=11 width=36) (actual time=3.005..4.695 rows=367 loops=1)

33. 0.273 3.904 ↓ 33.4 367 1

Nested Loop (cost=0.28..79.47 rows=11 width=32) (actual time=2.986..3.904 rows=367 loops=1)

34. 3.264 3.264 ↓ 33.4 367 1

CTE Scan on portfolio_implantation_match_data (cost=0.00..0.22 rows=11 width=16) (actual time=2.975..3.264 rows=367 loops=1)

35. 0.367 0.367 ↑ 1.0 1 367

Index Scan using portfolio_implantation_pkey on portfolio_implantation portfolio_implantation_2 (cost=0.28..7.20 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=367)

  • Index Cond: (id = portfolio_implantation_match_data.portfolio_implantation_id)
36. 0.734 0.734 ↓ 0.0 0 367

Index Only Scan using building_pkey on building (cost=0.44..8.46 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=367)

  • Index Cond: (id = portfolio_implantation_match_data.match_building_id)
  • Heap Fetches: 114
37. 1.101 1.101 ↑ 1.0 1 367

Index Scan using building_address_address_id on building_address (cost=0.56..8.58 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=367)

  • Index Cond: ((portfolio_implantation_match_data.match_main_address_id = address_id) AND (address_id = portfolio_implantation_match_data.match_main_address_id))
38.          

CTE data_implantation

39. 0.070 11.307 ↓ 19.3 367 1

Unique (cost=2,062.91..2,065.59 rows=19 width=252) (actual time=11.173..11.307 rows=367 loops=1)

40.          

Initplan (for Unique)

41. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on culture culture_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.001 rows=1 loops=1)

42. 0.025 0.025 ↑ 1.0 1 1

CTE Scan on culture culture_2 (cost=0.00..0.02 rows=1 width=32) (actual time=0.024..0.025 rows=1 loops=1)

43. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on culture culture_3 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

44. 0.488 11.210 ↓ 1.2 632 1

Sort (cost=2,062.85..2,064.19 rows=537 width=252) (actual time=11.172..11.210 rows=632 loops=1)

  • Sort Key: implantation_lpdi_1.portfolio_implantation_id
  • Sort Method: quicksort Memory: 185kB
45. 1.086 10.722 ↓ 1.2 632 1

Hash Left Join (cost=12.37..2,038.50 rows=537 width=252) (actual time=0.447..10.722 rows=632 loops=1)

  • Hash Cond: (ref_tranche_effectif_i18n.id = ref_tranche_effectif.id)
46. 0.281 9.621 ↓ 1.2 632 1

Nested Loop Left Join (cost=10.96..2,019.24 rows=537 width=291) (actual time=0.404..9.621 rows=632 loops=1)

47. 0.234 7.872 ↓ 19.3 367 1

Nested Loop Left Join (cost=10.40..592.27 rows=19 width=235) (actual time=0.396..7.872 rows=367 loops=1)

  • Join Filter: (ref_contract_type_i18n.id = portfolio_implantation_3.lease_ref_contract_type_id)
  • Rows Removed by Join Filter: 545
48. 0.267 7.638 ↓ 19.3 367 1

Nested Loop Left Join (cost=10.40..590.69 rows=19 width=231) (actual time=0.382..7.638 rows=367 loops=1)

  • Join Filter: (ref_lease_type_i18n.id = portfolio_implantation_3.ref_lease_type_id)
  • Rows Removed by Join Filter: 150
49. 0.391 7.371 ↓ 19.3 367 1

Nested Loop Left Join (cost=10.40..586.82 rows=19 width=213) (actual time=0.340..7.371 rows=367 loops=1)

50. 0.044 6.980 ↓ 19.3 367 1

Nested Loop Left Join (cost=9.96..460.69 rows=19 width=199) (actual time=0.333..6.980 rows=367 loops=1)

51. 0.119 6.202 ↓ 19.3 367 1

Nested Loop Left Join (cost=9.52..300.05 rows=19 width=185) (actual time=0.325..6.202 rows=367 loops=1)

52. 0.704 4.982 ↓ 19.3 367 1

Nested Loop Left Join (cost=8.96..136.84 rows=19 width=168) (actual time=0.316..4.982 rows=367 loops=1)

53. 0.341 1.709 ↓ 19.3 367 1

Hash Right Join (cost=0.62..98.85 rows=19 width=135) (actual time=0.290..1.709 rows=367 loops=1)

  • Hash Cond: (portfolio_implantation_3.id = implantation_lpdi_1.portfolio_implantation_id)
54. 1.121 1.121 ↓ 1.0 1,970 1

Seq Scan on portfolio_implantation portfolio_implantation_3 (cost=0.00..90.67 rows=1,967 width=123) (actual time=0.014..1.121 rows=1,970 loops=1)

55. 0.055 0.247 ↓ 19.3 367 1

Hash (cost=0.38..0.38 rows=19 width=16) (actual time=0.247..0.247 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
56. 0.192 0.192 ↓ 19.3 367 1

CTE Scan on implantation_lpdi implantation_lpdi_1 (cost=0.00..0.38 rows=19 width=16) (actual time=0.001..0.192 rows=367 loops=1)

57. 1.060 2.569 ↓ 0.0 0 367

Hash Right Join (cost=8.34..9.89 rows=1 width=37) (actual time=0.005..0.007 rows=0 loops=367)

  • Hash Cond: ((ref_tranche_effectif_i18n.id)::text = gen_establishment_search_1.ref_tranche_effectif_id)
58. 0.408 0.408 ↑ 1.0 18 102

Seq Scan on ref_tranche_effectif_i18n (cost=0.00..1.45 rows=18 width=13) (actual time=0.001..0.004 rows=18 loops=102)

  • Filter: ((culture)::text = $12)
  • Rows Removed by Filter: 18
59. 0.367 1.101 ↓ 0.0 0 367

Hash (cost=8.33..8.33 rows=1 width=27) (actual time=0.003..0.003 rows=0 loops=367)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
60. 0.734 0.734 ↓ 0.0 0 367

Index Scan using gen_establishment_search_establishment_id on gen_establishment_search gen_establishment_search_1 (cost=0.43..8.33 rows=1 width=27) (actual time=0.002..0.002 rows=0 loops=367)

  • Index Cond: (establishment_id = portfolio_implantation_3.establishment_id)
61. 1.101 1.101 ↓ 0.0 0 367

Index Scan using gen_building_building_id on gen_building (cost=0.56..8.58 rows=1 width=21) (actual time=0.003..0.003 rows=0 loops=367)

  • Index Cond: (implantation_lpdi_1.building_id = building_id)
62. 0.734 0.734 ↓ 0.0 0 367

Index Scan using company_pkey on company (cost=0.44..8.46 rows=1 width=22) (actual time=0.002..0.002 rows=0 loops=367)

  • Index Cond: (implantation_lpdi_1.company_id = id)
63. 0.000 0.000 ↓ 0.0 0 367

Index Scan using company_pkey on company establishment_company (cost=0.44..6.64 rows=1 width=22) (actual time=0.000..0.000 rows=0 loops=367)

  • Index Cond: (id = gen_establishment_search_1.company_id)
64. 0.000 0.000 ↑ 10.0 1 367

Materialize (cost=0.00..1.30 rows=10 width=22) (actual time=0.000..0.000 rows=1 loops=367)

65. 0.040 0.040 ↓ 1.1 11 1

Seq Scan on ref_lease_type_i18n (cost=0.00..1.25 rows=10 width=22) (actual time=0.037..0.040 rows=11 loops=1)

  • Filter: ((culture)::text = $13)
  • Rows Removed by Filter: 10
66. 0.000 0.000 ↑ 1.0 2 367

Materialize (cost=0.00..1.06 rows=2 width=12) (actual time=0.000..0.000 rows=2 loops=367)

67. 0.010 0.010 ↑ 1.0 2 1

Seq Scan on ref_contract_type_i18n (cost=0.00..1.05 rows=2 width=12) (actual time=0.009..0.010 rows=2 loops=1)

  • Filter: ((culture)::text = $14)
  • Rows Removed by Filter: 2
68. 1.468 1.468 ↑ 28.0 1 367

Index Scan using gen_address_address_id on gen_address (cost=0.56..74.82 rows=28 width=60) (actual time=0.003..0.004 rows=1 loops=367)

  • Index Cond: (address_id = implantation_lpdi_1.main_address_id)
69. 0.005 0.015 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=7) (actual time=0.015..0.015 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
70. 0.010 0.010 ↑ 1.0 18 1

Seq Scan on ref_tranche_effectif (cost=0.00..1.18 rows=18 width=7) (actual time=0.006..0.010 rows=18 loops=1)

71.          

CTE list_lots

72. 0.289 1.726 ↓ 15.5 387 1

Hash Right Join (cost=97.08..169.32 rows=25 width=37) (actual time=0.961..1.726 rows=387 loops=1)

  • Hash Cond: (lot.portfolio_implantation_id = portfolio_implantation_4.id)
73. 0.511 0.511 ↓ 1.0 2,572 1

Seq Scan on portfolio_implantation_lot lot (cost=0.00..62.22 rows=2,571 width=36) (actual time=0.010..0.511 rows=2,572 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 53
74. 0.047 0.926 ↓ 19.3 367 1

Hash (cost=96.84..96.84 rows=19 width=4) (actual time=0.926..0.926 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
75. 0.167 0.879 ↓ 19.3 367 1

Hash Right Join (cost=0.62..96.84 rows=19 width=4) (actual time=0.126..0.879 rows=367 loops=1)

  • Hash Cond: (portfolio_implantation_4.id = implantation_lpdi_2.portfolio_implantation_id)
76. 0.616 0.616 ↓ 1.0 1,447 1

Seq Scan on portfolio_implantation portfolio_implantation_4 (cost=0.00..90.67 rows=1,444 width=4) (actual time=0.008..0.616 rows=1,447 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 523
77. 0.040 0.096 ↓ 19.3 367 1

Hash (cost=0.38..0.38 rows=19 width=4) (actual time=0.096..0.096 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
78. 0.056 0.056 ↓ 19.3 367 1

CTE Scan on implantation_lpdi implantation_lpdi_2 (cost=0.00..0.38 rows=19 width=4) (actual time=0.002..0.056 rows=367 loops=1)

79.          

CTE lot_grouped

80. 0.514 1.321 ↓ 19.3 367 1

GroupAggregate (cost=73.50..74.24 rows=19 width=12) (actual time=0.818..1.321 rows=367 loops=1)

  • Group Key: implantation_lpdi_3.portfolio_implantation_id
81. 0.115 0.807 ↓ 15.5 387 1

Sort (cost=73.50..73.56 rows=25 width=32) (actual time=0.788..0.807 rows=387 loops=1)

  • Sort Key: implantation_lpdi_3.portfolio_implantation_id
  • Sort Method: quicksort Memory: 55kB
82. 0.401 0.692 ↓ 15.5 387 1

Hash Right Join (cost=0.62..72.92 rows=25 width=32) (actual time=0.109..0.692 rows=387 loops=1)

  • Hash Cond: (portfolio_implantation_lot.portfolio_implantation_id = implantation_lpdi_3.portfolio_implantation_id)
  • Filter: (portfolio_implantation_lot.deleted_at IS NULL)
  • Rows Removed by Filter: 5
83. 0.208 0.208 ↓ 1.0 2,625 1

Seq Scan on portfolio_implantation_lot (cost=0.00..62.22 rows=2,622 width=40) (actual time=0.007..0.208 rows=2,625 loops=1)

84. 0.044 0.083 ↓ 19.3 367 1

Hash (cost=0.38..0.38 rows=19 width=4) (actual time=0.082..0.083 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
85. 0.039 0.039 ↓ 19.3 367 1

CTE Scan on implantation_lpdi implantation_lpdi_3 (cost=0.00..0.38 rows=19 width=4) (actual time=0.001..0.039 rows=367 loops=1)

86.          

CTE implantation_lot_properties_unnest

87. 0.318 2.900 ↑ 6.5 383 1

HashAggregate (cost=95.09..120.09 rows=2,500 width=16) (actual time=2.806..2.900 rows=383 loops=1)

  • Group Key: list_lots.portfolio_implantation_id, list_lots.portfolio_implantation_lot_id, ref_property_nature_id.ref_property_nature_id
88. 0.117 2.582 ↑ 3.3 766 1

Hash Left Join (cost=10.01..70.09 rows=2,500 width=16) (actual time=1.187..2.582 rows=766 loops=1)

  • Hash Cond: (ref_property_nature_id.ref_property_nature_id = ref_property_nature_i18n.id)
89. 0.017 2.267 ↑ 6.5 383 1

Nested Loop (cost=0.00..50.50 rows=2,500 width=16) (actual time=0.978..2.267 rows=383 loops=1)

90. 1.863 1.863 ↓ 15.5 387 1

CTE Scan on list_lots (cost=0.00..0.50 rows=25 width=44) (actual time=0.964..1.863 rows=387 loops=1)

91. 0.387 0.387 ↑ 100.0 1 387

Function Scan on unnest ref_property_nature_id (cost=0.00..1.00 rows=100 width=4) (actual time=0.001..0.001 rows=1 loops=387)

92. 0.034 0.198 ↓ 248.0 248 1

Hash (cost=10.00..10.00 rows=1 width=4) (actual time=0.198..0.198 rows=248 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
93. 0.164 0.164 ↓ 248.0 248 1

Seq Scan on ref_property_nature_i18n (cost=0.00..10.00 rows=1 width=4) (actual time=0.016..0.164 rows=248 loops=1)

  • Filter: ((culture)::text = ((SubPlan 13))::text)
94.          

SubPlan (for Seq Scan)

95. 0.000 0.000 ↑ 1.0 1 248

CTE Scan on params params_2 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=248)

96.          

CTE natures

97. 1.477 2.760 ↓ 19.2 365 1

GroupAggregate (cost=277.44..343.51 rows=19 width=69) (actual time=1.324..2.760 rows=365 loops=1)

  • Group Key: implantation_lpdi_4.portfolio_implantation_id
98.          

Initplan (for GroupAggregate)

99. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on culture culture_4 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

100. 0.113 1.282 ↑ 6.5 386 1

Sort (cost=277.42..283.67 rows=2,500 width=29) (actual time=1.256..1.282 rows=386 loops=1)

  • Sort Key: implantation_lpdi_4.portfolio_implantation_id
  • Sort Method: quicksort Memory: 51kB
101. 0.084 1.169 ↑ 6.5 386 1

Hash Left Join (cost=7.23..136.32 rows=2,500 width=29) (actual time=0.194..1.169 rows=386 loops=1)

  • Hash Cond: (ref_property_nature_id_1.ref_property_nature_id = ref_property_nature_i18n_1.id)
102. 0.000 1.016 ↑ 6.5 386 1

Nested Loop (cost=0.62..122.92 rows=2,500 width=12) (actual time=0.109..1.016 rows=386 loops=1)

103. 0.375 0.659 ↓ 15.7 392 1

Hash Join (cost=0.62..72.92 rows=25 width=32) (actual time=0.101..0.659 rows=392 loops=1)

  • Hash Cond: (portfolio_implantation_lot_1.portfolio_implantation_id = implantation_lpdi_4.portfolio_implantation_id)
104. 0.203 0.203 ↓ 1.0 2,625 1

Seq Scan on portfolio_implantation_lot portfolio_implantation_lot_1 (cost=0.00..62.22 rows=2,622 width=32) (actual time=0.006..0.203 rows=2,625 loops=1)

105. 0.039 0.081 ↓ 19.3 367 1

Hash (cost=0.38..0.38 rows=19 width=4) (actual time=0.080..0.081 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
106. 0.042 0.042 ↓ 19.3 367 1

CTE Scan on implantation_lpdi implantation_lpdi_4 (cost=0.00..0.38 rows=19 width=4) (actual time=0.001..0.042 rows=367 loops=1)

107. 0.392 0.392 ↑ 100.0 1 392

Function Scan on unnest ref_property_nature_id_1 (cost=0.00..1.00 rows=100 width=4) (actual time=0.001..0.001 rows=1 loops=392)

108. 0.022 0.069 ↓ 1.0 124 1

Hash (cost=5.08..5.08 rows=123 width=21) (actual time=0.069..0.069 rows=124 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
109. 0.047 0.047 ↓ 1.0 124 1

Seq Scan on ref_property_nature_i18n ref_property_nature_i18n_1 (cost=0.00..5.08 rows=123 width=21) (actual time=0.011..0.047 rows=124 loops=1)

  • Filter: ((culture)::text = $26)
  • Rows Removed by Filter: 124
110.          

CTE calcul_lots

111. 0.767 5.234 ↓ 1.7 385 1

Nested Loop Left Join (cost=99.16..2,062.17 rows=225 width=12) (actual time=4.152..5.234 rows=385 loops=1)

112. 0.129 4.467 ↓ 1.7 385 1

Hash Right Join (cost=98.73..160.35 rows=225 width=20) (actual time=4.123..4.467 rows=385 loops=1)

  • Hash Cond: (implantation_lot_properties_unnest.portfolio_implantation_id = data_implantation_1.portfolio_implantation_id)
113. 3.038 3.038 ↑ 6.5 383 1

CTE Scan on implantation_lot_properties_unnest (cost=0.00..50.00 rows=2,500 width=16) (actual time=2.808..3.038 rows=383 loops=1)

114. 0.049 1.300 ↓ 20.4 367 1

Hash (cost=98.50..98.50 rows=18 width=8) (actual time=1.300..1.300 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
115. 1.251 1.251 ↓ 20.4 367 1

Hash Join (cost=0.62..98.50 rows=18 width=8) (actual time=0.157..1.251 rows=367 loops=1)

  • Hash Cond: (portfolio_implantation_5.id = data_implantation_1.portfolio_implantation_id)