explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fah1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=32,109,449,470.26..470,348,194,805,717,888.00 rows=23,517,408 width=800) (actual rows= loops=)

  • Hash Cond: ((dmc_detail_ligne_projet_dlp.dlp_pjt_numero = a.dlp_pjt_numero) AND (dmc_detail_ligne_projet_dlp.dlp_lpr_dw_id = a.dlp_lpr_dw_id) AND ((dmc_historique_montant_commerciaux_hmc.hmc_type_historique)::text = (a.hmc_type_historique)::text))
2.          

CTE multiville

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=32,103,843,714.12..32,103,843,873.00 rows=1,156 width=70) (actual rows= loops=)

  • Group Key: nb_ville.dlp_pjt_numero, nb_ville.hmc_type_historique, nb_ville.dlp_multiville
4. 0.000 0.000 ↓ 0.0

Sort (cost=32,103,843,714.12..32,103,843,743.00 rows=11,555 width=46) (actual rows= loops=)

  • Sort Key: nb_ville.dlp_pjt_numero, nb_ville.hmc_type_historique, nb_ville.dlp_multiville
5. 0.000 0.000 ↓ 0.0

Subquery Scan on nb_ville (cost=1,143,344.93..32,103,842,934.37 rows=11,555 width=46) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,143,344.93..32,103,842,818.82 rows=11,555 width=58) (actual rows= loops=)

  • Group Key: dlp_3.dlp_pjt_numero, hmc_3.hmc_type_historique, vaa_2.agglo_produit
7. 0.000 0.000 ↓ 0.0

Sort (cost=1,143,344.93..1,143,373.82 rows=11,555 width=18) (actual rows= loops=)

  • Sort Key: dlp_3.dlp_pjt_numero, hmc_3.hmc_type_historique, vaa_2.agglo_produit
8. 0.000 0.000 ↓ 0.0

Gather (cost=88,712.61..1,142,565.18 rows=11,555 width=18) (actual rows= loops=)

  • Workers Planned: 4
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=87,712.61..1,140,409.68 rows=2,889 width=18) (actual rows= loops=)

  • Hash Cond: ((hmc_3.pve_produit_version_elementaire_id = vaa_2.pve_dmc_id) AND (hmc_3.ccd_concedant_id = vaa_2.ccd_dmc_id))
10. 0.000 0.000 ↓ 0.0

Hash Join (cost=67,515.00..1,118,942.36 rows=29,196 width=14) (actual rows= loops=)

  • Hash Cond: (hmc_3.dlp_detail_ligne_projet_id = dlp_3.dlp_dmc_id)
11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dmc_historique_montant_commerciaux_hmc hmc_3 (cost=0.00..1,036,101.56 rows=5,838,353 width=14) (actual rows= loops=)

  • Filter: ((NOT hmc_histo) AND (hmc_pourcentage_ventilation_portefeuille <> 0.0) AND ((hmc_type_ventilation_initiale)::text = 'ACHAT'::text))
12. 0.000 0.000 ↓ 0.0

Hash (cost=67,478.82..67,478.82 rows=2,895 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_detail_ligne_projet_dlp dlp_3 (cost=0.00..67,478.82 rows=2,895 width=8) (actual rows= loops=)

  • Filter: (upper((dlp_libelle)::text) = 'ESPACE'::text)
14. 0.000 0.000 ↓ 0.0

Hash (cost=19,237.95..19,237.95 rows=63,977 width=24) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash Join (cost=13,501.79..19,237.95 rows=63,977 width=24) (actual rows= loops=)

  • Hash Cond: (vaa_2.pve_dmc_id = pve_1_2.pve_dmc_id)
16. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_var_agglo_vaa vaa_2 (cost=0.00..5,135.44 rows=228,844 width=20) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=12,916.95..12,916.95 rows=46,787 width=4) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_produit_version_elementaire_pve pve_1_2 (cost=0.00..12,916.95 rows=46,787 width=4) (actual rows= loops=)

  • Filter: ((pve_pdv_univers)::text = 'BUS'::text)
19.          

SubPlan (for GroupAggregate)

20. 0.000 0.000 ↓ 0.0

Result (cost=2,778,251.75..2,778,251.77 rows=1 width=4) (actual rows= loops=)

  • One-Time Filter: (hashed SubPlan 2)
21.          

CTE projet_mv

22. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=91,996.02..1,389,125.86 rows=1 width=12) (actual rows= loops=)

  • Group Key: dlp_1.dlp_pjt_numero
  • Filter: (count(DISTINCT vaa.agglo_produit) > 1)
23. 0.000 0.000 ↓ 0.0

Hash Join (cost=91,996.02..1,389,125.82 rows=4 width=16) (actual rows= loops=)

  • Hash Cond: (hmc_1.dlp_detail_ligne_projet_id = dlp_1.dlp_dmc_id)
24. 0.000 0.000 ↓ 0.0

Gather (cost=23,069.89..1,314,134.12 rows=2,310,675 width=16) (actual rows= loops=)

  • Workers Planned: 4
25. 0.000 0.000 ↓ 0.0

Hash Join (cost=22,069.89..1,082,066.62 rows=577,669 width=16) (actual rows= loops=)

  • Hash Cond: ((hmc_1.pve_produit_version_elementaire_id = vaa.pve_dmc_id) AND (hmc_1.ccd_concedant_id = vaa.ccd_dmc_id))
26. 0.000 0.000 ↓ 0.0

Hash Join (cost=13,501.79..1,064,929.42 rows=1,632,203 width=16) (actual rows= loops=)

  • Hash Cond: (hmc_1.pve_produit_version_elementaire_id = pve_1.pve_dmc_id)
27. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dmc_historique_montant_commerciaux_hmc hmc_1 (cost=0.00..1,036,101.56 rows=5,838,353 width=12) (actual rows= loops=)

  • Filter: ((NOT hmc_histo) AND (hmc_pourcentage_ventilation_portefeuille <> 0.0) AND ((hmc_type_ventilation_initiale)::text = 'ACHAT'::text))
28. 0.000 0.000 ↓ 0.0

Hash (cost=12,916.95..12,916.95 rows=46,787 width=4) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_produit_version_elementaire_pve pve_1 (cost=0.00..12,916.95 rows=46,787 width=4) (actual rows= loops=)

  • Filter: ((pve_pdv_univers)::text = 'BUS'::text)
30. 0.000 0.000 ↓ 0.0

Hash (cost=5,135.44..5,135.44 rows=228,844 width=20) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_var_agglo_vaa vaa (cost=0.00..5,135.44 rows=228,844 width=20) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash (cost=68,926.12..68,926.12 rows=1 width=8) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_detail_ligne_projet_dlp dlp_1 (cost=0.00..68,926.12 rows=1 width=8) (actual rows= loops=)

  • Filter: ((dlp_pjt_numero = dlp_3.dlp_pjt_numero) AND (upper((dlp_libelle)::text) = 'ESPACE'::text))
34. 0.000 0.000 ↓ 0.0

CTE Scan on projet_mv (cost=2,778,251.75..2,778,251.77 rows=1 width=4) (actual rows= loops=)

35.          

SubPlan (for Result)

36. 0.000 0.000 ↓ 0.0

Unique (cost=1,389,125.86..1,389,125.88 rows=4 width=12) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Sort (cost=1,389,125.86..1,389,125.87 rows=4 width=12) (actual rows= loops=)

  • Sort Key: vaa_1.agglo_produit
38. 0.000 0.000 ↓ 0.0

Hash Join (cost=91,996.02..1,389,125.82 rows=4 width=12) (actual rows= loops=)

  • Hash Cond: (hmc_2.dlp_detail_ligne_projet_id = dlp_2.dlp_dmc_id)
39. 0.000 0.000 ↓ 0.0

Gather (cost=23,069.89..1,314,134.12 rows=2,310,675 width=16) (actual rows= loops=)

  • Workers Planned: 4
40. 0.000 0.000 ↓ 0.0

Hash Join (cost=22,069.89..1,082,066.62 rows=577,669 width=16) (actual rows= loops=)

  • Hash Cond: ((hmc_2.pve_produit_version_elementaire_id = vaa_1.pve_dmc_id) AND (hmc_2.ccd_concedant_id = vaa_1.ccd_dmc_id))
41. 0.000 0.000 ↓ 0.0

Hash Join (cost=13,501.79..1,064,929.42 rows=1,632,203 width=16) (actual rows= loops=)

  • Hash Cond: (hmc_2.pve_produit_version_elementaire_id = pve_1_1.pve_dmc_id)
42. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dmc_historique_montant_commerciaux_hmc hmc_2 (cost=0.00..1,036,101.56 rows=5,838,353 width=12) (actual rows= loops=)

  • Filter: ((NOT hmc_histo) AND (hmc_pourcentage_ventilation_portefeuille <> 0.0) AND ((hmc_type_ventilation_initiale)::text = 'ACHAT'::text))
43. 0.000 0.000 ↓ 0.0

Hash (cost=12,916.95..12,916.95 rows=46,787 width=4) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_produit_version_elementaire_pve pve_1_1 (cost=0.00..12,916.95 rows=46,787 width=4) (actual rows= loops=)

  • Filter: ((pve_pdv_univers)::text = 'BUS'::text)
45. 0.000 0.000 ↓ 0.0

Hash (cost=5,135.44..5,135.44 rows=228,844 width=20) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_var_agglo_vaa vaa_1 (cost=0.00..5,135.44 rows=228,844 width=20) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Hash (cost=68,926.12..68,926.12 rows=1 width=4) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_detail_ligne_projet_dlp dlp_2 (cost=0.00..68,926.12 rows=1 width=4) (actual rows= loops=)

  • Filter: ((dlp_pjt_numero = dlp_3.dlp_pjt_numero) AND (upper((dlp_libelle)::text) = 'ESPACE'::text))
49. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=4,461,605.00..7,012,554.56 rows=23,517,408 width=776) (actual rows= loops=)

  • Hash Cond: (dmc_concedant_ccd.ccd_simba2_id = dmc_concedant_dept_cde.ccd_id)
50. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=4,461,600.95..6,804,802.46 rows=23,517,408 width=747) (actual rows= loops=)

  • Hash Cond: ((multiville.dlp_pjt_numero = dmc_detail_ligne_projet_dlp.dlp_pjt_numero) AND ((multiville.hmc_type_historique)::text = (dmc_historique_montant_commerciaux_hmc.hmc_type_historique)::text))
51. 0.000 0.000 ↓ 0.0

CTE Scan on multiville (cost=0.00..23.12 rows=1,156 width=214) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Hash (cost=2,064,845.83..2,064,845.83 rows=23,517,408 width=683) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Hash Join (cost=123,908.88..2,064,845.83 rows=23,517,408 width=683) (actual rows= loops=)

  • Hash Cond: (dmc_historique_montant_commerciaux_hmc.tpu_type_pub_id = dmc_type_pub_tpu.tpu_dmc_id)
54. 0.000 0.000 ↓ 0.0

Hash Join (cost=123,903.98..2,001,079.59 rows=23,517,408 width=672) (actual rows= loops=)

  • Hash Cond: (dmc_historique_montant_commerciaux_hmc.ste_societe_id = dmc_societe_ste.ste_dmc_id)
55. 0.000 0.000 ↓ 0.0

Hash Join (cost=123,902.82..1,901,969.35 rows=23,517,408 width=668) (actual rows= loops=)

  • Hash Cond: (dmc_historique_montant_commerciaux_hmc.ccd_concedant_id = dmc_concedant_ccd.ccd_dmc_id)
56. 0.000 0.000 ↓ 0.0

Hash Join (cost=123,895.79..1,838,767.50 rows=23,517,408 width=664) (actual rows= loops=)

  • Hash Cond: (dmc_historique_montant_commerciaux_hmc.cmc_commercial_initial_id = dmc_commercial_cmc_init.cmc_dmc_id)
57. 0.000 0.000 ↓ 0.0

Hash Join (cost=123,882.93..1,775,810.19 rows=23,517,408 width=664) (actual rows= loops=)

  • Hash Cond: (dmc_detail_ligne_projet_dlp.tan_tiers_annonceur_id = dmc_tiers_annonceur_tan.tan_dmc_id)
58. 0.000 0.000 ↓ 0.0

Hash Join (cost=122,364.47..1,712,546.17 rows=23,517,408 width=668) (actual rows= loops=)

  • Hash Cond: (dmc_historique_montant_commerciaux_hmc.dlp_detail_ligne_projet_id = dmc_detail_ligne_projet_dlp.dlp_dmc_id)
59. 0.000 0.000 ↓ 0.0

Hash Join (cost=50,543.75..1,578,991.80 rows=23,517,408 width=191) (actual rows= loops=)

  • Hash Cond: (dmc_historique_montant_commerciaux_hmc.pve_produit_version_elementaire_id = dmc_produit_version_elementaire_pve.pve_dmc_id)
60. 0.000 0.000 ↓ 0.0

Hash Join (cost=35,953.24..1,502,666.52 rows=23,517,408 width=179) (actual rows= loops=)

  • Hash Cond: (dmc_historique_montant_commerciaux_hmc.pvv_produit_version_vendu_id = dmc_produit_version_vendu_pvv.pvv_dmc_id)
61. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,750.04..1,406,729.37 rows=23,517,408 width=122) (actual rows= loops=)

  • Hash Cond: (dmc_historique_montant_commerciaux_hmc.cmc_commercial_portefeuille_id = dmc_commercial_cmc_port.cmc_dmc_id)
  • Join Filter: (((dmc_historique_montant_commerciaux_hmc.hmc_pourcentage_ventilation_portefeuille <> '0'::numeric) AND (dmc_calendrier_cal.cal_annee >= 2,000)) OR ((dmc_calendrier_cal.a (...)
62. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,737.18..1,336,237.30 rows=25,741,725 width=126) (actual rows= loops=)

  • Hash Cond: (dmc_historique_montant_commerciaux_hmc.cal_date_historique_id = dmc_calendrier_cal.cal_dmc_id)
63. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_historique_montant_commerciaux_hmc (cost=0.00..1,246,235.84 rows=33,621,484 width=118) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Hash (cost=1,283.09..1,283.09 rows=36,327 width=12) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_calendrier_cal (cost=0.00..1,283.09 rows=36,327 width=12) (actual rows= loops=)

  • Filter: ((cal_annee >= 2,000) OR (atterrissage IS NOT NULL))
66. 0.000 0.000 ↓ 0.0

Hash (cost=10.16..10.16 rows=216 width=12) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_commercial_cmc dmc_commercial_cmc_port (cost=0.00..10.16 rows=216 width=12) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Hash (cost=29,908.09..29,908.09 rows=343,609 width=61) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_produit_version_vendu_pvv (cost=0.00..29,908.09 rows=343,609 width=61) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Hash (cost=12,498.56..12,498.56 rows=167,356 width=16) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_produit_version_elementaire_pve (cost=0.00..12,498.56 rows=167,356 width=16) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash (cost=64,584.21..64,584.21 rows=578,921 width=481) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_detail_ligne_projet_dlp (cost=0.00..64,584.21 rows=578,921 width=481) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Hash (cost=1,253.84..1,253.84 rows=21,170 width=4) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Index Only Scan using dmc_tiers_annonceur_tan_pkey on dmc_tiers_annonceur_tan (cost=0.29..1,253.84 rows=21,170 width=4) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Hash (cost=10.16..10.16 rows=216 width=4) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_commercial_cmc dmc_commercial_cmc_init (cost=0.00..10.16 rows=216 width=4) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Hash (cost=4.79..4.79 rows=179 width=8) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_concedant_ccd (cost=0.00..4.79 rows=179 width=8) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Hash (cost=1.07..1.07 rows=7 width=8) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_societe_ste (cost=0.00..1.07 rows=7 width=8) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Hash (cost=3.29..3.29 rows=129 width=15) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_type_pub_tpu (cost=0.00..3.29 rows=129 width=15) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Hash (cost=2.91..2.91 rows=91 width=37) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_concedant_dept_cde (cost=0.00..2.91 rows=91 width=37) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Hash (cost=1,143,977.15..1,143,977.15 rows=863 width=18) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Subquery Scan on a (cost=1,143,852.04..1,143,977.15 rows=863 width=18) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,143,852.04..1,143,968.52 rows=863 width=18) (actual rows= loops=)

  • Group Key: r.dlp_pjt_numero, r.dlp_lpr_dw_id, r.hmc_type_historique
89. 0.000 0.000 ↓ 0.0

Sort (cost=1,143,852.04..1,143,873.61 rows=8,628 width=14) (actual rows= loops=)

  • Sort Key: r.dlp_pjt_numero, r.dlp_lpr_dw_id, r.hmc_type_historique
90. 0.000 0.000 ↓ 0.0

Subquery Scan on r (cost=1,141,449.97..1,143,288.00 rows=8,628 width=14) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Unique (cost=1,141,449.97..1,143,201.72 rows=8,628 width=18) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Sort (cost=1,141,449.97..1,141,741.93 rows=116,783 width=18) (actual rows= loops=)

  • Sort Key: dlp.dlp_pjt_numero, dlp.dlp_lpr_dw_id, dlp.dlp_dml_dw_id, hmc.hmc_type_historique, dlp.dlp_duree
93. 0.000 0.000 ↓ 0.0

Gather (cost=68,515.00..1,131,620.66 rows=116,783 width=18) (actual rows= loops=)

  • Workers Planned: 4
94. 0.000 0.000 ↓ 0.0

Hash Join (cost=67,515.00..1,118,942.36 rows=29,196 width=18) (actual rows= loops=)

  • Hash Cond: (hmc.dlp_detail_ligne_projet_id = dlp.dlp_dmc_id)
95. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dmc_historique_montant_commerciaux_hmc hmc (cost=0.00..1,036,101.56 rows=5,838,353 width=6) (actual rows= loops=)

  • Filter: ((NOT hmc_histo) AND (hmc_pourcentage_ventilation_portefeuille <> 0.0) AND ((hmc_type_ventilation_portefeuille)::text = 'ACHAT'::text))
96. 0.000 0.000 ↓ 0.0

Hash (cost=67,478.82..67,478.82 rows=2,895 width=20) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_detail_ligne_projet_dlp dlp (cost=0.00..67,478.82 rows=2,895 width=20) (actual rows= loops=)

  • Filter: (upper((dlp_libelle)::text) = 'ESPACE'::text)
98.          

SubPlan (for Hash Left Join)

99. 0.000 0.000 ↓ 0.0

Unique (cost=10,000,000,053.09..10,000,000,057.20 rows=1 width=10) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,000,053.09..10,000,000,057.20 rows=1 width=10) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Merge Join (cost=52.94..53.02 rows=1 width=14) (actual rows= loops=)

  • Merge Cond: ((pvv.pvv_dep_departement_geographique_libelle)::text = (dmc_commercial_departement_cde.dep_libelle)::text)
102. 0.000 0.000 ↓ 0.0

Sort (cost=8.45..8.46 rows=1 width=10) (actual rows= loops=)

  • Sort Key: pvv.pvv_dep_departement_geographique_libelle
103. 0.000 0.000 ↓ 0.0

Index Scan using dmc_produit_version_vendu_pvv_pkey on dmc_produit_version_vendu_pvv pvv (cost=0.42..8.44 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (pvv_dmc_id = dmc_produit_version_vendu_pvv.pvv_dmc_id)
104. 0.000 0.000 ↓ 0.0

Sort (cost=44.49..44.52 rows=13 width=14) (actual rows= loops=)

  • Sort Key: dmc_commercial_departement_cde.dep_libelle
105. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_commercial_departement_cde (cost=0.00..44.25 rows=13 width=14) (actual rows= loops=)

  • Filter: (cmc_commercial_id = dmc_detail_ligne_projet_dlp.cmc_dmc_id)
106. 0.000 0.000 ↓ 0.0

Index Only Scan using dmc_commercial_cmc_pkey on dmc_commercial_cmc (cost=0.14..4.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (cmc_dmc_id = dmc_detail_ligne_projet_dlp.cmc_dmc_id)
107. 0.000 0.000 ↓ 0.0

Unique (cost=10,000,000,053.09..10,000,000,057.20 rows=1 width=10) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,000,053.09..10,000,000,057.20 rows=1 width=10) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Merge Join (cost=52.94..53.02 rows=1 width=14) (actual rows= loops=)

  • Merge Cond: ((pvv_1.pvv_dep_departement_geographique_libelle)::text = (dmc_commercial_departement_cde_1.dep_libelle)::text)
110. 0.000 0.000 ↓ 0.0

Sort (cost=8.45..8.46 rows=1 width=10) (actual rows= loops=)

  • Sort Key: pvv_1.pvv_dep_departement_geographique_libelle
111. 0.000 0.000 ↓ 0.0

Index Scan using dmc_produit_version_vendu_pvv_pkey on dmc_produit_version_vendu_pvv pvv_1 (cost=0.42..8.44 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (pvv_dmc_id = dmc_produit_version_vendu_pvv.pvv_dmc_id)
112. 0.000 0.000 ↓ 0.0

Sort (cost=44.49..44.52 rows=13 width=14) (actual rows= loops=)

  • Sort Key: dmc_commercial_departement_cde_1.dep_libelle
113. 0.000 0.000 ↓ 0.0

Seq Scan on dmc_commercial_departement_cde dmc_commercial_departement_cde_1 (cost=0.00..44.25 rows=13 width=14) (actual rows= loops=)

  • Filter: (cmc_commercial_id = dmc_detail_ligne_projet_dlp.cmc_dmc_id)
114. 0.000 0.000 ↓ 0.0

Index Only Scan using dmc_commercial_cmc_pkey on dmc_commercial_cmc dmc_commercial_cmc_1 (cost=0.14..4.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (cmc_dmc_id = dmc_detail_ligne_projet_dlp.cmc_dmc_id)