explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mrT9

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

Nested Loop Left Join (cost=7,269.55..7,284.47 rows=19 width=1,147) (actual time=59.380..185.656 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.005 0.029 ↑ 1.0 1 1

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

6. 0.024 0.024 ↓ 0.0 0 1

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

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

CTE portfolio_implantation_match_data

8. 0.208 3.245 ↓ 33.4 367 1

GroupAggregate (cost=285.70..285.95 rows=11 width=16) (actual time=3.027..3.245 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.003..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.168 3.032 ↓ 33.4 367 1

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

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

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

14. 0.075 1.978 ↓ 33.4 367 1

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

15. 0.286 1.169 ↓ 33.4 367 1

Hash Left Join (cost=3.51..99.41 rows=11 width=20) (actual time=0.085..1.169 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.859 0.859 ↓ 6.3 367 1

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

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

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

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

Seq Scan on company_branch company_branch_1 (cost=0.00..3.42 rows=6 width=20) (actual time=0.010..0.019 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.059 24.198 ↓ 19.3 367 1

Unique (cost=1,879.90..1,879.99 rows=19 width=32) (actual time=24.123..24.198 rows=367 loops=1)

23. 0.144 24.139 ↓ 19.7 374 1

Sort (cost=1,879.90..1,879.95 rows=19 width=32) (actual time=24.121..24.139 rows=374 loops=1)

  • Sort Key: portfolio_implantation_2.id
  • Sort Method: quicksort Memory: 47kB
24. 0.257 23.995 ↓ 19.7 374 1

Hash Right Join (cost=1,527.55..1,879.49 rows=19 width=32) (actual time=8.483..23.995 rows=374 loops=1)

  • Hash Cond: ((first(portfolio_implantation_match_data_1.match_building_id)) = portfolio_implantation_match_data.match_building_id)
25. 15.394 17.222 ↑ 3.1 111 1

GroupAggregate (cost=1,260.39..1,606.51 rows=341 width=12) (actual time=1.939..17.222 rows=111 loops=1)

  • Group Key: building_address_1.building_id
26. 0.394 1.828 ↓ 4.3 1,481 1

Sort (cost=1,260.39..1,261.24 rows=341 width=16) (actual time=1.741..1.828 rows=1,481 loops=1)

  • Sort Key: building_address_1.building_id
  • Sort Method: quicksort Memory: 114kB
27. 0.302 1.434 ↓ 4.3 1,481 1

Nested Loop Left Join (cost=0.56..1,246.05 rows=341 width=16) (actual time=0.027..1.434 rows=1,481 loops=1)

28. 0.031 0.031 ↓ 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.001..0.031 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=8) (actual time=0.002..0.003 rows=3 loops=367)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
31. 0.337 6.383 ↓ 34.0 374 1

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

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

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

33. 0.025 4.107 ↓ 33.4 367 1

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

34. 3.348 3.348 ↓ 33.4 367 1

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

35. 0.734 0.734 ↑ 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.002..0.002 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.062 12.032 ↓ 19.3 367 1

Unique (cost=2,076.67..2,079.30 rows=19 width=252) (actual time=11.899..12.032 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.001..0.001 rows=1 loops=1)

42. 0.030 0.030 ↑ 1.0 1 1

CTE Scan on culture culture_2 (cost=0.00..0.02 rows=1 width=32) (actual time=0.030..0.030 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.535 11.938 ↓ 1.2 632 1

Sort (cost=2,076.61..2,077.93 rows=527 width=252) (actual time=11.897..11.938 rows=632 loops=1)

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

Hash Left Join (cost=12.37..2,052.78 rows=527 width=252) (actual time=0.453..11.403 rows=632 loops=1)

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

Nested Loop Left Join (cost=10.96..2,033.86 rows=527 width=287) (actual time=0.400..10.254 rows=632 loops=1)

47. 0.242 8.586 ↓ 19.3 367 1

Nested Loop Left Join (cost=10.40..592.27 rows=19 width=231) (actual time=0.389..8.586 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.256 8.344 ↓ 19.3 367 1

Nested Loop Left Join (cost=10.40..590.70 rows=19 width=227) (actual time=0.373..8.344 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.037 8.088 ↓ 19.3 367 1

Nested Loop Left Join (cost=10.40..586.82 rows=19 width=209) (actual time=0.319..8.088 rows=367 loops=1)

50. 0.068 7.684 ↓ 19.3 367 1

Nested Loop Left Join (cost=9.96..460.69 rows=19 width=195) (actual time=0.310..7.684 rows=367 loops=1)

51. 0.119 6.882 ↓ 19.3 367 1

Nested Loop Left Join (cost=9.52..300.05 rows=19 width=181) (actual time=0.300..6.882 rows=367 loops=1)

52. 0.618 5.662 ↓ 19.3 367 1

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

53. 0.363 1.741 ↓ 19.3 367 1

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

  • Hash Cond: (portfolio_implantation_3.id = implantation_lpdi_1.portfolio_implantation_id)
54. 1.168 1.168 ↓ 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.013..1.168 rows=1,970 loops=1)

55. 0.058 0.210 ↓ 19.3 367 1

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

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

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

57. 1.325 3.303 ↓ 0.0 0 367

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

  • Hash Cond: ((ref_tranche_effectif_i18n.id)::text = gen_establishment_search_1.ref_tranche_effectif_id)
58. 0.510 0.510 ↑ 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.005 rows=18 loops=102)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
60. 1.468 1.468 ↓ 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.004 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=17) (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.367 0.367 ↓ 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.001..0.001 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.045 0.045 ↓ 1.1 11 1

Seq Scan on ref_lease_type_i18n (cost=0.00..1.25 rows=10 width=22) (actual time=0.042..0.045 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.008..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..75.59 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.008 0.018 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=7) (actual time=0.018..0.018 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.658 2.559 ↓ 15.5 387 1

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

  • Hash Cond: (lot.portfolio_implantation_id = portfolio_implantation_4.id)
73. 0.507 0.507 ↓ 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.011..0.507 rows=2,572 loops=1)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
75. 0.376 1.257 ↓ 19.3 367 1

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

  • Hash Cond: (portfolio_implantation_4.id = implantation_lpdi_2.portfolio_implantation_id)
76. 0.788 0.788 ↓ 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.011..0.788 rows=1,447 loops=1)

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

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

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

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

79.          

CTE lot_grouped

80. 0.517 1.336 ↓ 19.3 367 1

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

  • Group Key: implantation_lpdi_3.portfolio_implantation_id
81. 0.124 0.819 ↓ 15.5 387 1

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

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

Hash Right Join (cost=0.62..72.92 rows=25 width=32) (actual time=0.118..0.695 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.218 0.218 ↓ 1.0 2,625 1

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

84. 0.049 0.092 ↓ 19.3 367 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
85. 0.043 0.043 ↓ 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.043 rows=367 loops=1)

86.          

CTE implantation_lot_properties_unnest

87. 0.338 3.803 ↑ 6.5 383 1

HashAggregate (cost=95.09..120.09 rows=2,500 width=16) (actual time=3.708..3.803 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.155 3.465 ↑ 3.3 766 1

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

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

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

90. 2.708 2.708 ↓ 15.5 387 1

CTE Scan on list_lots (cost=0.00..0.50 rows=25 width=44) (actual time=1.775..2.708 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.035 0.173 ↓ 248.0 248 1

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

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

Seq Scan on ref_property_nature_i18n (cost=0.00..10.00 rows=1 width=4) (actual time=0.017..0.138 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.472 2.797 ↓ 19.2 365 1

GroupAggregate (cost=277.44..343.51 rows=19 width=69) (actual time=1.359..2.797 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.130 1.324 ↑ 6.5 386 1

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

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

Hash Left Join (cost=7.23..136.32 rows=2,500 width=29) (actual time=0.213..1.194 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.038 ↑ 6.5 386 1

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

103. 0.376 0.679 ↓ 15.7 392 1

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

  • Hash Cond: (portfolio_implantation_lot_1.portfolio_implantation_id = implantation_lpdi_4.portfolio_implantation_id)
104. 0.213 0.213 ↓ 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.213 rows=2,625 loops=1)

105. 0.049 0.090 ↓ 19.3 367 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
106. 0.041 0.041 ↓ 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.041 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.026 0.071 ↓ 1.0 124 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
109. 0.045 0.045 ↓ 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.045 rows=124 loops=1)

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

CTE calcul_lots

111. 0.752 7.927 ↓ 1.7 385 1

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

112. 0.135 7.175 ↓ 1.7 385 1

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

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

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

114. 0.076 3.119 ↓ 20.4 367 1

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

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

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

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