explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VIj7

Settings
# exclusive inclusive rows x rows loops node
1. 10,520.939 10,520.939 ↓ 305.0 305 1

Nested Loop Left Join (cost=1,638.25..1,642.49 rows=1 width=1,309) (actual time=10,507.391..10,520.939 rows=305 loops=1)

2.          

CTE params

3. 0.002 0.002 ↑ 1.0 1 1

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

4.          

CTE culture

5. 0.004 0.034 ↑ 1.0 1 1

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

6. 0.030 0.030 ↓ 0.0 0 1

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

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

CTE asset_details

8. 0.087 0.734 ↓ 23.0 92 1

Nested Loop Left Join (cost=5.04..54.84 rows=4 width=54) (actual time=0.159..0.734 rows=92 loops=1)

9.          

Initplan (for Nested Loop Left Join)

10. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on params (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 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.122 0.369 ↓ 23.0 92 1

Hash Left Join (cost=4.57..20.99 rows=4 width=54) (actual time=0.133..0.369 rows=92 loops=1)

  • Hash Cond: (portfolio_asset.company_branch_id = company_branch_1.id)
  • Filter: ((company_branch_1.deleted_at IS NULL) AND ((portfolio_asset.company_branch_id IS NULL) OR (ARRAY[company_branch_1.user_community_id] && $3)))
13. 0.186 0.186 ↓ 4.6 92 1

Seq Scan on portfolio_asset (cost=0.00..16.38 rows=20 width=54) (actual time=0.035..0.186 rows=92 loops=1)

  • Filter: ((deleted_at IS NULL) AND (user_company_id = $2))
  • Rows Removed by Filter: 168
14. 0.017 0.061 ↑ 1.4 82 1

Hash (cost=3.14..3.14 rows=114 width=16) (actual time=0.061..0.061 rows=82 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
15. 0.044 0.044 ↑ 1.4 82 1

Seq Scan on company_branch company_branch_1 (cost=0.00..3.14 rows=114 width=16) (actual time=0.010..0.044 rows=82 loops=1)

16. 0.276 0.276 ↓ 0.0 0 92

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.003..0.003 rows=0 loops=92)

  • Index Cond: (address_id = portfolio_asset.main_address_id)
17.          

CTE implantation_lpdi

18. 3.505 20.496 ↓ 305.0 305 1

GroupAggregate (cost=226.44..226.54 rows=1 width=76) (actual time=16.596..20.496 rows=305 loops=1)

  • Group Key: portfolio_implantation_1.id
19.          

Initplan (for GroupAggregate)

20. 0.004 0.004 ↑ 1.0 1 1

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

21. 0.001 0.001 ↑ 1.0 1 1

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

22. 3.665 16.986 ↓ 6,923.0 6,923 1

Sort (cost=226.40..226.40 rows=1 width=100) (actual time=16.570..16.986 rows=6,923 loops=1)

  • Sort Key: portfolio_implantation_1.id
  • Sort Method: quicksort Memory: 1166kB
23. 3.538 13.321 ↓ 6,923.0 6,923 1

Nested Loop Left Join (cost=1.71..226.39 rows=1 width=100) (actual time=0.971..13.321 rows=6,923 loops=1)

24. 1.085 9.783 ↓ 6,923.0 6,923 1

Nested Loop Left Join (cost=1.27..217.93 rows=1 width=96) (actual time=0.964..9.783 rows=6,923 loops=1)

25. 0.486 5.038 ↓ 305.0 305 1

Nested Loop Left Join (cost=0.71..104.86 rows=1 width=92) (actual time=0.937..5.038 rows=305 loops=1)

  • Filter: ((portfolio_implantation_1.company_branch_id IS NULL) OR (ARRAY[company_branch_2.user_community_id] && $7))
26. 0.166 4.247 ↓ 305.0 305 1

Nested Loop Left Join (cost=0.56..104.40 rows=1 width=100) (actual time=0.918..4.247 rows=305 loops=1)

27. 0.196 2.251 ↓ 305.0 305 1

Hash Join (cost=0.13..95.93 rows=1 width=92) (actual time=0.899..2.251 rows=305 loops=1)

  • Hash Cond: (portfolio_implantation_1.portfolio_asset_id = asset_details.id)
28. 1.216 1.216 ↓ 5.5 305 1

Seq Scan on portfolio_implantation portfolio_implantation_1 (cost=0.00..95.59 rows=55 width=48) (actual time=0.038..1.216 rows=305 loops=1)

  • Filter: ((deleted_at IS NULL) AND (NOT is_vacant) AND (user_company_id = $6))
  • Rows Removed by Filter: 1665
29. 0.033 0.839 ↓ 23.0 92 1

Hash (cost=0.08..0.08 rows=4 width=52) (actual time=0.839..0.839 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
30. 0.806 0.806 ↓ 23.0 92 1

CTE Scan on asset_details (cost=0.00..0.08 rows=4 width=52) (actual time=0.161..0.806 rows=92 loops=1)

31. 1.830 1.830 ↑ 1.0 1 305

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

  • Index Cond: (establishment_id = portfolio_implantation_1.establishment_id)
32. 0.305 0.305 ↑ 1.0 1 305

Index Scan using company_branch_pkey on company_branch company_branch_2 (cost=0.14..0.46 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=305)

  • Index Cond: (id = portfolio_implantation_1.company_branch_id)
  • Filter: ((user_company_id = $6) AND (user_company_id = portfolio_implantation_1.user_company_id))
33. 3.660 3.660 ↑ 1.3 23 305

Index Scan using building_address_building_id on building_address (cost=0.56..112.76 rows=31 width=8) (actual time=0.004..0.012 rows=23 loops=305)

  • Index Cond: (building_id = portfolio_implantation_1.building_id)
34. 0.000 0.000 ↓ 0.0 0 6,923

Index Scan using gen_match_cap_address_pkey on gen_match_cap_address gen_match_cap_address_1 (cost=0.43..8.45 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=6,923)

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

CTE implantation_address

36. 0.140 21.662 ↓ 305.0 305 1

Unique (cost=120.44..120.58 rows=1 width=132) (actual time=21.428..21.662 rows=305 loops=1)

37. 0.690 21.522 ↓ 49.4 1,382 1

Sort (cost=120.44..120.51 rows=28 width=132) (actual time=21.426..21.522 rows=1,382 loops=1)

  • Sort Key: implantation_lpdi_1.portfolio_implantation_id
  • Sort Method: quicksort Memory: 251kB
38. 2.835 20.832 ↓ 49.4 1,382 1

Nested Loop Left Join (cost=2.84..119.76 rows=28 width=132) (actual time=0.197..20.832 rows=1,382 loops=1)

39. 0.331 15.557 ↓ 305.0 305 1

Nested Loop Left Join (cost=2.27..43.48 rows=1 width=795) (actual time=0.161..15.557 rows=305 loops=1)

40. 1.111 14.616 ↓ 305.0 305 1

Nested Loop Left Join (cost=1.98..37.70 rows=1 width=779) (actual time=0.138..14.616 rows=305 loops=1)

  • Join Filter: (ref_address_cardinal.id = address.ref_address_cardinal_id)
  • Rows Removed by Join Filter: 12559
41. 0.287 12.590 ↓ 305.0 305 1

Nested Loop Left Join (cost=1.98..35.76 rows=1 width=777) (actual time=0.120..12.590 rows=305 loops=1)

42. 0.335 11.998 ↓ 305.0 305 1

Nested Loop Left Join (cost=1.83..31.56 rows=1 width=769) (actual time=0.105..11.998 rows=305 loops=1)

43. 0.295 10.748 ↓ 305.0 305 1

Nested Loop Left Join (cost=1.40..25.62 rows=1 width=630) (actual time=0.086..10.748 rows=305 loops=1)

44. 0.179 9.233 ↓ 305.0 305 1

Nested Loop Left Join (cost=0.84..17.04 rows=1 width=618) (actual time=0.062..9.233 rows=305 loops=1)

45. 1.795 7.834 ↓ 305.0 305 1

Nested Loop Left Join (cost=0.28..8.45 rows=1 width=609) (actual time=0.035..7.834 rows=305 loops=1)

  • Join Filter: (portfolio_implantation_2.portfolio_asset_id = asset_details_1.id)
  • Rows Removed by Join Filter: 27755
46. 0.159 1.159 ↓ 305.0 305 1

Nested Loop Left Join (cost=0.28..8.32 rows=1 width=97) (actual time=0.018..1.159 rows=305 loops=1)

47. 0.085 0.085 ↓ 305.0 305 1

CTE Scan on implantation_lpdi implantation_lpdi_1 (cost=0.00..0.02 rows=1 width=12) (actual time=0.000..0.085 rows=305 loops=1)

48. 0.915 0.915 ↑ 1.0 1 305

Index Scan using portfolio_implantation_pkey on portfolio_implantation portfolio_implantation_2 (cost=0.28..8.29 rows=1 width=89) (actual time=0.003..0.003 rows=1 loops=305)

  • Index Cond: (id = implantation_lpdi_1.portfolio_implantation_id)
49. 4.880 4.880 ↓ 23.0 92 305

CTE Scan on asset_details asset_details_1 (cost=0.00..0.08 rows=4 width=520) (actual time=0.000..0.016 rows=92 loops=305)

50. 1.220 1.220 ↑ 1.0 1 305

Index Scan using gen_building_building_id on gen_building (cost=0.56..8.58 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=305)

  • Index Cond: (implantation_lpdi_1.building_id = building_id)
51. 1.220 1.220 ↑ 1.0 1 305

Index Scan using address_pkey on address (cost=0.56..8.58 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=305)

  • Index Cond: (implantation_lpdi_1.main_address_id = id)
52. 0.915 0.915 ↑ 1.0 1 305

Index Scan using address_street_pkey on address_street (cost=0.43..5.94 rows=1 width=147) (actual time=0.003..0.003 rows=1 loops=305)

  • Index Cond: (address.address_street_id = id)
  • Filter: (deleted_at IS NULL)
53. 0.305 0.305 ↑ 1.0 1 305

Index Scan using ref_address_street_type_pkey on ref_address_street_type (cost=0.15..4.17 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=305)

  • Index Cond: (id = address_street.ref_address_street_type_id)
54. 0.915 0.915 ↑ 1.0 41 305

Seq Scan on ref_address_cardinal (cost=0.00..1.42 rows=42 width=6) (actual time=0.001..0.003 rows=41 loops=305)

55. 0.610 0.610 ↑ 1.0 1 305

Index Scan using ref_postal_city_pkey on ref_postal_city (cost=0.29..5.78 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=305)

  • Index Cond: (address_street.ref_postal_city_id = id)
56. 2.440 2.440 ↑ 5.6 5 305

Index Scan using gen_address_address_id on gen_address (cost=0.56..74.40 rows=28 width=22) (actual time=0.005..0.008 rows=5 loops=305)

  • Index Cond: (address_id = implantation_lpdi_1.main_address_id)
57.          

CTE data_implantations

58. 0.231 37.837 ↓ 305.0 305 1

Unique (cost=2.11..32.09 rows=1 width=252) (actual time=22.229..37.837 rows=305 loops=1)

59.          

Initplan (for Unique)

60. 0.036 0.036 ↑ 1.0 1 1

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

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

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

63. 0.506 37.568 ↓ 305.0 305 1

Nested Loop Left Join (cost=2.05..32.03 rows=1 width=252) (actual time=22.227..37.568 rows=305 loops=1)

64. 0.397 36.757 ↓ 305.0 305 1

Nested Loop Left Join (cost=1.92..31.83 rows=1 width=331) (actual time=22.188..36.757 rows=305 loops=1)

65. 0.193 36.055 ↓ 305.0 305 1

Nested Loop Left Join (cost=1.78..31.66 rows=1 width=313) (actual time=22.162..36.055 rows=305 loops=1)

66. 1.464 35.252 ↓ 305.0 305 1

Nested Loop Left Join (cost=1.65..30.77 rows=1 width=312) (actual time=22.121..35.252 rows=305 loops=1)

  • Join Filter: (gen_establishment_search_1.ref_tranche_effectif_id = (ref_tranche_effectif_i18n.id)::text)
  • Rows Removed by Join Filter: 5248
67. 0.336 32.568 ↓ 305.0 305 1

Nested Loop Left Join (cost=1.65..29.05 rows=1 width=302) (actual time=22.065..32.568 rows=305 loops=1)

68. 0.198 31.927 ↓ 305.0 305 1

Nested Loop Left Join (cost=1.21..25.18 rows=1 width=284) (actual time=22.044..31.927 rows=305 loops=1)

69. 0.401 29.899 ↓ 305.0 305 1

Nested Loop Left Join (cost=0.78..16.84 rows=1 width=261) (actual time=22.021..29.899 rows=305 loops=1)

70. 0.118 23.398 ↓ 305.0 305 1

Nested Loop Left Join (cost=0.34..8.39 rows=1 width=243) (actual time=21.998..23.398 rows=305 loops=1)

71. 0.295 22.365 ↓ 305.0 305 1

Merge Left Join (cost=0.06..0.09 rows=1 width=140) (actual time=21.974..22.365 rows=305 loops=1)

  • Merge Cond: (implantation_lpdi_2.portfolio_implantation_id = implantation_address.portfolio_implantation_id)
72. 0.117 0.170 ↓ 305.0 305 1

Sort (cost=0.03..0.04 rows=1 width=12) (actual time=0.102..0.170 rows=305 loops=1)

  • Sort Key: implantation_lpdi_2.portfolio_implantation_id
  • Sort Method: quicksort Memory: 39kB
73. 0.053 0.053 ↓ 305.0 305 1

CTE Scan on implantation_lpdi implantation_lpdi_2 (cost=0.00..0.02 rows=1 width=12) (actual time=0.002..0.053 rows=305 loops=1)

74. 0.142 21.900 ↓ 305.0 305 1

Sort (cost=0.03..0.04 rows=1 width=132) (actual time=21.864..21.900 rows=305 loops=1)

  • Sort Key: implantation_address.portfolio_implantation_id
  • Sort Method: quicksort Memory: 68kB
75. 21.758 21.758 ↓ 305.0 305 1

CTE Scan on implantation_address (cost=0.00..0.02 rows=1 width=132) (actual time=21.432..21.758 rows=305 loops=1)

76. 0.915 0.915 ↑ 1.0 1 305

Index Scan using portfolio_implantation_pkey on portfolio_implantation portfolio_implantation_3 (cost=0.28..8.29 rows=1 width=107) (actual time=0.003..0.003 rows=1 loops=305)

  • Index Cond: (id = implantation_lpdi_2.portfolio_implantation_id)
77. 6.100 6.100 ↑ 1.0 1 305

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

  • Index Cond: (implantation_lpdi_2.company_id = id)
78. 1.830 1.830 ↑ 1.0 1 305

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.006..0.006 rows=1 loops=305)

  • Index Cond: (establishment_id = portfolio_implantation_3.establishment_id)
79. 0.305 0.305 ↑ 1.0 1 305

Index Scan using company_pkey on company establishment_company (cost=0.44..3.86 rows=1 width=22) (actual time=0.001..0.001 rows=1 loops=305)

  • Index Cond: (id = gen_establishment_search_1.company_id)
80. 1.220 1.220 ↑ 1.0 18 305

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=305)

  • Filter: ((culture)::text = $22)
  • Rows Removed by Filter: 18
81. 0.610 0.610 ↑ 1.0 1 305

Index Scan using ref_tranche_effectif_pkey on ref_tranche_effectif (cost=0.14..0.82 rows=1 width=7) (actual time=0.002..0.002 rows=1 loops=305)

  • Index Cond: (id = ref_tranche_effectif_i18n.id)
82. 0.305 0.305 ↑ 1.0 1 305

Index Scan using ref_lease_type_i18n_pkey on ref_lease_type_i18n (cost=0.14..0.16 rows=1 width=22) (actual time=0.001..0.001 rows=1 loops=305)

  • Index Cond: ((id = portfolio_implantation_3.ref_lease_type_id) AND ((culture)::text = $23))
83. 0.305 0.305 ↓ 0.0 0 305

Index Scan using ref_contract_type_i18n_pkey on ref_contract_type_i18n (cost=0.13..0.16 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=305)

  • Index Cond: ((id = portfolio_implantation_3.lease_ref_contract_type_id) AND ((culture)::text = $24))
84.          

CTE list_lots

85. 1.226 179.825 ↓ 362.0 362 1

Nested Loop Left Join (cost=8.31..77.32 rows=1 width=41) (actual time=0.633..179.825 rows=362 loops=1)

86. 0.174 0.174 ↓ 305.0 305 1

CTE Scan on implantation_lpdi implantation_lpdi_3 (cost=0.00..0.02 rows=1 width=4) (actual time=0.008..0.174 rows=305 loops=1)

87. 54.290 178.425 ↑ 1.0 1 305

Hash Right Join (cost=8.31..77.29 rows=1 width=40) (actual time=0.332..0.585 rows=1 loops=305)

  • Hash Cond: (lot.portfolio_implantation_id = portfolio_implantation_4.id)
88. 122.000 122.000 ↓ 1.0 2,572 305

Seq Scan on portfolio_implantation_lot lot (cost=0.00..62.22 rows=2,571 width=36) (actual time=0.002..0.400 rows=2,572 loops=305)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 53
89. 0.305 2.135 ↑ 1.0 1 305

Hash (cost=8.29..8.29 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=305)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
90. 1.830 1.830 ↑ 1.0 1 305

Index Scan using portfolio_implantation_pkey on portfolio_implantation portfolio_implantation_4 (cost=0.28..8.29 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=305)

  • Index Cond: (id = implantation_lpdi_3.portfolio_implantation_id)
  • Filter: (deleted_at IS NULL)
91.          

CTE grouped_lots

92. 2.962 3.861 ↓ 305.0 305 1

GroupAggregate (cost=8.33..9.66 rows=1 width=37) (actual time=1.117..3.861 rows=305 loops=1)

  • Group Key: portfolio_implantation_5.id
93. 0.122 0.899 ↓ 362.0 362 1

Sort (cost=8.33..8.34 rows=1 width=45) (actual time=0.874..0.899 rows=362 loops=1)

  • Sort Key: portfolio_implantation_5.id
  • Sort Method: quicksort Memory: 53kB
94. 0.001 0.777 ↓ 362.0 362 1

Nested Loop Left Join (cost=0.28..8.32 rows=1 width=45) (actual time=0.018..0.777 rows=362 loops=1)

95. 0.052 0.052 ↓ 362.0 362 1

CTE Scan on list_lots (cost=0.00..0.02 rows=1 width=40) (actual time=0.000..0.052 rows=362 loops=1)

96. 0.724 0.724 ↑ 1.0 1 362

Index Scan using portfolio_implantation_pkey on portfolio_implantation portfolio_implantation_5 (cost=0.28..8.29 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=362)

  • Index Cond: (id = list_lots.portfolio_implantation_id)
97.          

CTE implantation_lot_properties_unnest

98. 0.703 182.763 ↓ 3.6 361 1

HashAggregate (cost=13.66..14.66 rows=100 width=20) (actual time=182.688..182.763 rows=361 loops=1)

  • Group Key: list_lots_1.portfolio_asset_id, list_lots_1.portfolio_implantation_id, list_lots_1.portfolio_implantation_lot_id, ref_property_nature_id.ref_property_nature_id
99. 0.319 182.060 ↓ 7.2 722 1

Hash Left Join (cost=10.01..12.41 rows=100 width=20) (actual time=0.868..182.060 rows=722 loops=1)

  • Hash Cond: (ref_property_nature_id.ref_property_nature_id = ref_property_nature_i18n.id)
100. 0.598 181.558 ↓ 3.6 361 1

Nested Loop (cost=0.00..2.02 rows=100 width=20) (actual time=0.665..181.558 rows=361 loops=1)

101. 180.236 180.236 ↓ 362.0 362 1

CTE Scan on list_lots list_lots_1 (cost=0.00..0.02 rows=1 width=48) (actual time=0.636..180.236 rows=362 loops=1)

102. 0.724 0.724 ↑ 100.0 1 362

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

103. 0.033 0.183 ↓ 248.0 248 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
104. 0.150 0.150 ↓ 248.0 248 1

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

  • Filter: ((culture)::text = ((SubPlan 16))::text)
105.          

SubPlan (for Seq Scan)

106. 0.000 0.000 ↑ 1.0 1 248

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

107.          

CTE stats_implantations

108. 0.275 14.112 ↓ 305.0 305 1

Nested Loop Left Join (cost=0.28..8.37 rows=1 width=12) (actual time=1.144..14.112 rows=305 loops=1)

109. 5.523 12.922 ↓ 305.0 305 1

Nested Loop Left Join (cost=0.00..0.05 rows=1 width=12) (actual time=1.124..12.922 rows=305 loops=1)

  • Join Filter: (implantation_lpdi_4.portfolio_implantation_id = grouped_lots_1.portfolio_implantation_id)
  • Rows Removed by Join Filter: 92720
110. 0.079 0.079 ↓ 305.0 305 1

CTE Scan on implantation_lpdi implantation_lpdi_4 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.079 rows=305 loops=1)

111. 7.320 7.320 ↓ 305.0 305 305

CTE Scan on grouped_lots grouped_lots_1 (cost=0.00..0.02 rows=1 width=12) (actual time=0.004..0.024 rows=305 loops=305)

112. 0.915 0.915 ↑ 1.0 1 305

Index Scan using portfolio_implantation_pkey on portfolio_implantation portfolio_implantation_6 (cost=0.28..8.29 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=305)

  • Index Cond: (id = implantation_lpdi_4.portfolio_implantation_id)
113.          

CTE natures

114. 1.417 2.903 ↓ 304.0 304 1

GroupAggregate (cost=84.33..86.97 rows=1 width=69) (actual time=1.496..2.903 rows=304 loops=1)

  • Group Key: implantation_lpdi_5.portfolio_implantation_id
115.          

Initplan (for GroupAggregate)

116. 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.001..0.002 rows=1 loops=1)

117. 0.155 1.484 ↓ 3.6 363 1

Sort (cost=84.31..84.56 rows=100 width=29) (actual time=1.437..1.484 rows=363 loops=1)

  • Sort Key: implantation_lpdi_5.portfolio_implantation_id
  • Sort Method: quicksort Memory: 53kB
118. 0.174 1.329 ↓ 3.6 363 1

Hash Left Join (cost=6.65..80.98 rows=100 width=29) (actual time=0.258..1.329 rows=363 loops=1)

  • Hash Cond: (ref_property_nature_id_1.ref_property_nature_id = ref_property_nature_i18n_1.id)
119. 0.367 1.155 ↓ 3.6 363 1

Nested Loop (cost=0.04..74.10 rows=100 width=12) (actual time=0.152..1.155 rows=363 loops=1)

120. 0.392 0.788 ↓ 363.0 363 1

Hash Join (cost=0.03..72.10 rows=1 width=32) (actual time=0.137..0.788 rows=363 loops=1)

  • Hash Cond: (portfolio_implantation_lot.portfolio_implantation_id = implantation_lpdi_5.portfolio_implantation_id)
121. 0.298 0.298 ↓ 1.0 2,625 1

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

122. 0.098 0.098 ↓ 305.0 305 1

Hash (cost=0.02..0.02 rows=1 width=4) (actual time=0.098..0.098 rows=305 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB