explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vBeb

Settings
# exclusive inclusive rows x rows loops node
1. 4,050.037 4,050.037 ↓ 33.4 367 1

Nested Loop Left Join (cost=262,592.66..262,598.76 rows=11 width=955) (actual time=4,040.889..4,050.037 rows=367 loops=1)

2.          

CTE params

3. 0.004 0.004 ↑ 1.0 1 1

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

4.          

CTE culture

5. 0.005 0.044 ↑ 1.0 1 1

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

6. 0.039 0.039 ↓ 0.0 0 1

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

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

CTE portfolio_implantation_match_data

8. 0.328 15.134 ↓ 33.4 367 1

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

  • Group Key: portfolio_implantation_1.id
9.          

Initplan (for GroupAggregate)

10. 0.008 0.008 ↑ 1.0 1 1

CTE Scan on params (cost=0.00..0.02 rows=1 width=4) (actual time=0.007..0.008 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.379 14.797 ↓ 33.4 367 1

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

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

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

14. 0.393 8.251 ↓ 33.4 367 1

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

15. 0.837 2.720 ↓ 33.4 367 1

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

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

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

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

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

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

  • Filter: (user_company_id = $2)
  • Rows Removed by Filter: 77
19. 5.138 5.138 ↓ 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.014..0.014 rows=0 loops=367)

  • Index Cond: (establishment_id = portfolio_implantation_1.establishment_id)
20. 5.872 5.872 ↓ 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.016..0.016 rows=0 loops=367)

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

CTE implantation_lpdi

22. 0.211 3,799.657 ↓ 33.4 367 1

Unique (cost=259,563.01..259,667.57 rows=11 width=32) (actual time=3,772.354..3,799.657 rows=367 loops=1)

23. 0.885 3,799.446 ↓ 34.0 374 1

Nested Loop Left Join (cost=259,563.01..259,667.54 rows=11 width=32) (actual time=3,772.352..3,799.446 rows=374 loops=1)

  • Join Filter: (building.id = building_address.building_id)
  • Rows Removed by Join Filter: 416
24. 0.566 3,773.238 ↓ 33.4 367 1

Merge Join (cost=259,562.45..259,572.45 rows=11 width=36) (actual time=3,772.250..3,773.238 rows=367 loops=1)

  • Merge Cond: (portfolio_implantation_match_data.portfolio_implantation_id = portfolio_implantation_2.id)
25. 0.295 3,771.097 ↓ 33.4 367 1

Sort (cost=259,364.17..259,364.19 rows=11 width=20) (actual time=3,770.962..3,771.097 rows=367 loops=1)

  • Sort Key: portfolio_implantation_match_data.portfolio_implantation_id
  • Sort Method: quicksort Memory: 45kB
26. 0.129 3,770.802 ↓ 33.4 367 1

Hash Right Join (cost=259,212.64..259,363.98 rows=11 width=20) (actual time=3,767.097..3,770.802 rows=367 loops=1)

  • Hash Cond: ((first(portfolio_implantation_match_data_1.match_building_id)) = portfolio_implantation_match_data.match_building_id)
27. 3.887 3,689.021 ↑ 1.4 108 1

GroupAggregate (cost=259,119.28..259,268.48 rows=147 width=12) (actual time=3,685.416..3,689.021 rows=108 loops=1)

  • Group Key: gen_match_cap_address_1.building_id
28. 11.671 3,685.134 ↓ 5.3 781 1

Sort (cost=259,119.28..259,119.65 rows=147 width=16) (actual time=3,685.072..3,685.134 rows=781 loops=1)

  • Sort Key: gen_match_cap_address_1.building_id
  • Sort Method: quicksort Memory: 57kB
29. 1.882 3,673.463 ↓ 5.3 781 1

Nested Loop (cost=0.64..259,113.99 rows=147 width=16) (actual time=4.073..3,673.463 rows=781 loops=1)

30. 1,326.742 3,669.238 ↓ 5.3 781 1

Hash Right Join (cost=0.36..258,161.89 rows=147 width=20) (actual time=4.029..3,669.238 rows=781 loops=1)

  • Hash Cond: (gen_match_cap_address_1.building_id = portfolio_implantation_match_data_1.match_building_id)
31. 2,342.378 2,342.378 ↓ 1.0 8,937,205 1

Seq Scan on gen_match_cap_address gen_match_cap_address_1 (cost=0.00..224,663.68 rows=8,932,368 width=8) (actual time=0.015..2,342.378 rows=8,937,205 loops=1)

32. 0.067 0.118 ↓ 33.4 367 1

Hash (cost=0.22..0.22 rows=11 width=12) (actual time=0.118..0.118 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
33. 0.051 0.051 ↓ 33.4 367 1

CTE Scan on portfolio_implantation_match_data portfolio_implantation_match_data_1 (cost=0.00..0.22 rows=11 width=12) (actual time=0.003..0.051 rows=367 loops=1)

34. 2.343 2.343 ↑ 1.0 1 781

Index Only Scan using portfolio_implantation_pkey on portfolio_implantation portfolio_implantation_3 (cost=0.28..6.48 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=781)

  • Index Cond: (id = portfolio_implantation_match_data_1.portfolio_implantation_id)
  • Heap Fetches: 369
35. 0.209 81.652 ↓ 33.4 367 1

Hash (cost=93.23..93.23 rows=11 width=20) (actual time=81.652..81.652 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
36. 0.424 81.443 ↓ 33.4 367 1

Nested Loop Left Join (cost=0.44..93.23 rows=11 width=20) (actual time=14.840..81.443 rows=367 loops=1)

37. 15.326 15.326 ↓ 33.4 367 1

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

38. 65.693 65.693 ↓ 0.0 0 367

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

  • Index Cond: (id = portfolio_implantation_match_data.match_building_id)
  • Heap Fetches: 114
39. 0.842 1.575 ↑ 1.1 1,823 1

Sort (cost=198.28..203.20 rows=1,967 width=20) (actual time=1.277..1.575 rows=1,823 loops=1)

  • Sort Key: portfolio_implantation_2.id
  • Sort Method: quicksort Memory: 145kB
40. 0.733 0.733 ↓ 1.0 1,970 1

Seq Scan on portfolio_implantation portfolio_implantation_2 (cost=0.00..90.67 rows=1,967 width=20) (actual time=0.013..0.733 rows=1,970 loops=1)

41. 25.323 25.323 ↑ 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.013..0.069 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))
42.          

CTE data_implantation

43. 0.082 252.778 ↓ 33.4 367 1

Unique (cost=1,224.46..1,226.02 rows=11 width=252) (actual time=252.586..252.778 rows=367 loops=1)

44.          

Initplan (for Unique)

45. 0.046 0.046 ↑ 1.0 1 1

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

46. 0.001 0.001 ↑ 1.0 1 1

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

47. 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.000..0.001 rows=1 loops=1)

48. 0.885 252.648 ↓ 2.0 632 1

Sort (cost=1,224.40..1,225.18 rows=311 width=252) (actual time=252.584..252.648 rows=632 loops=1)

  • Sort Key: implantation_lpdi_1.portfolio_implantation_id
  • Sort Method: quicksort Memory: 185kB
49. 2.208 251.763 ↓ 2.0 632 1

Hash Left Join (cost=12.03..1,211.53 rows=311 width=252) (actual time=0.503..251.763 rows=632 loops=1)

  • Hash Cond: (ref_tranche_effectif_i18n.id = ref_tranche_effectif.id)
50. 0.722 249.528 ↓ 2.0 632 1

Nested Loop Left Join (cost=10.62..1,199.79 rows=311 width=291) (actual time=0.392..249.528 rows=632 loops=1)

51. 0.378 56.865 ↓ 33.4 367 1

Nested Loop Left Join (cost=10.06..373.65 rows=11 width=235) (actual time=0.345..56.865 rows=367 loops=1)

  • Join Filter: (ref_contract_type_i18n.id = portfolio_implantation_4.lease_ref_contract_type_id)
  • Rows Removed by Join Filter: 545
52. 0.397 56.487 ↓ 33.4 367 1

Nested Loop Left Join (cost=10.06..372.29 rows=11 width=231) (actual time=0.317..56.487 rows=367 loops=1)

  • Join Filter: (ref_lease_type_i18n.id = portfolio_implantation_4.ref_lease_type_id)
  • Rows Removed by Join Filter: 150
53. 0.202 56.090 ↓ 33.4 367 1

Nested Loop Left Join (cost=10.06..369.49 rows=11 width=213) (actual time=0.294..56.090 rows=367 loops=1)

54. 0.359 55.521 ↓ 33.4 367 1

Nested Loop Left Join (cost=9.62..296.47 rows=11 width=199) (actual time=0.279..55.521 rows=367 loops=1)

55. 0.381 53.327 ↓ 33.4 367 1

Nested Loop Left Join (cost=9.18..203.47 rows=11 width=185) (actual time=0.227..53.327 rows=367 loops=1)

56. 1.072 34.596 ↓ 33.4 367 1

Nested Loop Left Join (cost=8.62..108.98 rows=11 width=168) (actual time=0.167..34.596 rows=367 loops=1)

57. 0.515 29.487 ↓ 33.4 367 1

Nested Loop Left Join (cost=0.28..83.47 rows=11 width=135) (actual time=0.024..29.487 rows=367 loops=1)

58. 27.504 27.504 ↓ 33.4 367 1

CTE Scan on implantation_lpdi implantation_lpdi_1 (cost=0.00..0.22 rows=11 width=16) (actual time=0.001..27.504 rows=367 loops=1)

59. 1.468 1.468 ↑ 1.0 1 367

Index Scan using portfolio_implantation_pkey on portfolio_implantation portfolio_implantation_4 (cost=0.28..7.57 rows=1 width=123) (actual time=0.004..0.004 rows=1 loops=367)

  • Index Cond: (id = implantation_lpdi_1.portfolio_implantation_id)
60. 1.753 4.037 ↓ 0.0 0 367

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

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

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

  • Filter: ((culture)::text = $11)
  • Rows Removed by Filter: 18
62. 0.367 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: 9kB
63. 1.101 1.101 ↓ 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.003..0.003 rows=0 loops=367)

  • Index Cond: (establishment_id = portfolio_implantation_4.establishment_id)
64. 18.350 18.350 ↓ 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.050..0.050 rows=0 loops=367)

  • Index Cond: (implantation_lpdi_1.building_id = building_id)
65. 1.835 1.835 ↓ 0.0 0 367

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

  • Index Cond: (implantation_lpdi_1.company_id = id)
66. 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)
67. 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)

68. 0.019 0.019 ↓ 1.1 11 1

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

  • Filter: ((culture)::text = $12)
  • Rows Removed by Filter: 10
69. 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)

70. 0.023 0.023 ↑ 1.0 2 1

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

  • Filter: ((culture)::text = $13)
  • Rows Removed by Filter: 2
71. 191.941 191.941 ↑ 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.368..0.523 rows=1 loops=367)

  • Index Cond: (address_id = implantation_lpdi_1.main_address_id)
72. 0.006 0.027 ↑ 1.0 18 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
73. 0.021 0.021 ↑ 1.0 18 1

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

74.          

CTE list_lots

75. 0.350 1.837 ↓ 27.6 387 1

Hash Right Join (cost=79.61..151.68 rows=14 width=37) (actual time=0.850..1.837 rows=387 loops=1)

  • Hash Cond: (lot.portfolio_implantation_id = portfolio_implantation_5.id)
76. 0.686 0.686 ↓ 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.018..0.686 rows=2,572 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 53
77. 0.079 0.801 ↓ 33.4 367 1

Hash (cost=79.47..79.47 rows=11 width=4) (actual time=0.800..0.801 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
78. 0.290 0.722 ↓ 33.4 367 1

Nested Loop Left Join (cost=0.28..79.47 rows=11 width=4) (actual time=0.024..0.722 rows=367 loops=1)

79. 0.065 0.065 ↓ 33.4 367 1

CTE Scan on implantation_lpdi implantation_lpdi_2 (cost=0.00..0.22 rows=11 width=4) (actual time=0.001..0.065 rows=367 loops=1)

80. 0.367 0.367 ↑ 1.0 1 367

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

  • Index Cond: (id = implantation_lpdi_2.portfolio_implantation_id)
  • Filter: (deleted_at IS NULL)
81.          

CTE lot_grouped

82. 0.670 1.659 ↓ 33.4 367 1

GroupAggregate (cost=72.83..73.24 rows=11 width=12) (actual time=1.092..1.659 rows=367 loops=1)

  • Group Key: implantation_lpdi_3.portfolio_implantation_id
83. 0.143 0.989 ↓ 27.6 387 1

Sort (cost=72.83..72.86 rows=14 width=32) (actual time=0.967..0.989 rows=387 loops=1)

  • Sort Key: implantation_lpdi_3.portfolio_implantation_id
  • Sort Method: quicksort Memory: 55kB
84. 0.422 0.846 ↓ 27.6 387 1

Hash Right Join (cost=0.36..72.56 rows=14 width=32) (actual time=0.145..0.846 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
85. 0.318 0.318 ↓ 1.0 2,625 1

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

86. 0.053 0.106 ↓ 33.4 367 1

Hash (cost=0.22..0.22 rows=11 width=4) (actual time=0.106..0.106 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
87. 0.053 0.053 ↓ 33.4 367 1

CTE Scan on implantation_lpdi implantation_lpdi_3 (cost=0.00..0.22 rows=11 width=4) (actual time=0.002..0.053 rows=367 loops=1)

88.          

CTE implantation_lot_properties_unnest

89. 0.372 3.207 ↑ 3.7 383 1

HashAggregate (cost=57.65..71.65 rows=1,400 width=16) (actual time=3.080..3.207 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
90. 0.145 2.835 ↑ 1.8 766 1

Hash Left Join (cost=10.01..43.65 rows=1,400 width=16) (actual time=1.099..2.835 rows=766 loops=1)

  • Hash Cond: (ref_property_nature_id.ref_property_nature_id = ref_property_nature_i18n.id)
91. 0.095 2.486 ↑ 3.7 383 1

Nested Loop (cost=0.00..28.28 rows=1,400 width=16) (actual time=0.871..2.486 rows=383 loops=1)

92. 2.004 2.004 ↓ 27.6 387 1

CTE Scan on list_lots (cost=0.00..0.28 rows=14 width=44) (actual time=0.852..2.004 rows=387 loops=1)

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

94. 0.036 0.204 ↓ 248.0 248 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
95. 0.168 0.168 ↓ 248.0 248 1

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

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

SubPlan (for Seq Scan)

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

98.          

CTE natures

99. 1.659 3.269 ↓ 33.2 365 1

GroupAggregate (cost=192.40..232.03 rows=11 width=69) (actual time=1.715..3.269 rows=365 loops=1)

  • Group Key: implantation_lpdi_4.portfolio_implantation_id
100.          

Initplan (for GroupAggregate)

101. 0.002 0.002 ↑ 1.0 1 1

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

102. 0.174 1.608 ↑ 3.9 386 1

Sort (cost=192.38..196.13 rows=1,500 width=29) (actual time=1.576..1.608 rows=386 loops=1)

  • Sort Key: implantation_lpdi_4.portfolio_implantation_id
  • Sort Method: quicksort Memory: 51kB
103. 0.094 1.434 ↑ 3.9 386 1

Hash Left Join (cost=6.97..113.25 rows=1,500 width=29) (actual time=0.260..1.434 rows=386 loops=1)

  • Hash Cond: (ref_property_nature_id_1.ref_property_nature_id = ref_property_nature_i18n_1.id)
104. 0.043 1.258 ↑ 3.9 386 1

Nested Loop (cost=0.36..102.56 rows=1,500 width=12) (actual time=0.159..1.258 rows=386 loops=1)

105. 0.431 0.823 ↓ 26.1 392 1

Hash Join (cost=0.36..72.56 rows=15 width=32) (actual time=0.140..0.823 rows=392 loops=1)

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

107. 0.053 0.098 ↓ 33.4 367 1

Hash (cost=0.22..0.22 rows=11 width=4) (actual time=0.098..0.098 rows=367 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
108. 0.045 0.045 ↓ 33.4 367 1

CTE Scan on implantation_lpdi implantation_lpdi_4 (cost=0.00..0.22 rows=11 width=4) (actual time=0.002..0.045 rows=367 loops=1)

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

110. 0.029 0.082 ↓ 1.0 124 1

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

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

  • Filter: ((culture)::text = $27)
  • Rows Removed by Filter: 124
112.          

CTE calcul_lots

113. 2.766 260.223 ↓ 5.5 385 1

Nested Loop Left Join (cost=80.03..705.22 rows=70 width=12) (actual time=257.056..260.223 rows=385 loops=1)

114. 254.110 257.457 ↓ 5.5 385 1

Hash Right Join (cost=79.60..113.55 rows=70 width=20) (actual time=257.029..257.457 rows=385 loops=1)

  • Hash Cond: (implantation_lot_properties_unnest.portfolio_implantation_id = data_implantation_1.portfolio_implantation_id)
115. 3.347 3.347 ↑ 3.7 383 1

CTE Scan on implantation_lot_properties_unnest (cost=0.00..28.00 rows=1,400 width=16) (actual time=3.083..3.347 rows=383 loops=1)