explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Mgp

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

Sort (cost=32,932.12..32,932.12 rows=2 width=1,933) (actual rows= loops=)

  • Sort Key: y.order_master, y."order
2. 0.000 0.000 ↓ 0.0

Subquery Scan on y (cost=32,932.11..32,932.12 rows=2 width=1,933) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Unique (cost=32,932.11..32,932.11 rows=2 width=1,934) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=32,932.11..32,932.11 rows=2 width=1,934) (actual rows= loops=)

  • Sort Key: "*SELECT* 1".fk_intervention, "*SELECT* 1".fk_intervention_type_associe, ((xl.id_planning_calendrier_zone IS NOT NULL)) DESC
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=32,924.85..32,932.11 rows=2 width=1,934) (actual rows= loops=)

  • Hash Cond: (COALESCE("*SELECT* 1".fk_planning_calendrier_zone, xk.fk_planning_calendrier_zone) = xl.id_planning_calendrier_zone)
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=32,921.71..32,928.97 rows=2 width=1,873) (actual rows= loops=)

  • Join Filter: ((xk.the_geom ~ st_transform(st_setsrid(st_makepoint(("*SELECT* 1".lng)::double precision, ("*SELECT* 1".lat)::double precision), 4326), 31370)) AND _st_contains(xk.the_geom, st_transform(st_setsrid(st_makepoint(("*SELECT* 1".lng)::double precision, ("*SELECT* 1".lat)::double precision), 4326), 31370)))
7. 0.000 0.000 ↓ 0.0

Unique (cost=32,921.71..32,921.78 rows=2 width=1,869) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Sort (cost=32,921.71..32,921.72 rows=2 width=1,869) (actual rows= loops=)

  • Sort Key: "*SELECT* 1".fk_groupe, "*SELECT* 1".fk_intervention_maitre, "*SELECT* 1".fk_intervention, "*SELECT* 1".fk_intervention_type_associe, "*SELECT* 1".fk_conteneur, "*SELECT* 1"."order", "*SELECT* 1".order_master, "*SELECT* 1".report, "*SELECT* 1".report_apres_16h, "*SELECT* 1".date_report, "*SELECT* 1".depot, "*SELECT* 1".fk_partenaire, "*SELECT* 1".fk_type_partenaire, "*SELECT* 1".partenaire, "*SELECT* 1".rue, "*SELECT* 1".no, "*SELECT* 1".cp, "*SELECT* 1".localite, "*SELECT* 1".lat, "*SELECT* 1".lng, "*SELECT* 1".iso2_pays, "*SELECT* 1".hfrom1, "*SELECT* 1".hto1, "*SELECT* 1".hfrom2, "*SELECT* 1".hto2, "*SELECT* 1".poids_charger, "*SELECT* 1".volume_charger, "*SELECT* 1".coeff_volume_charger, "*SELECT* 1".duration_charger, "*SELECT* 1".poids_decharger, "*SELECT* 1".volume_decharger, "*SELECT* 1".coeff_volume_decharger, "*SELECT* 1".duration_decharger, "*SELECT* 1".type_vehicle_1, "*SELECT* 1".type_vehicle_2, "*SELECT* 1".type_vehicle_3, "*SELECT* 1".competence_1, "*SELECT* 1".competence_2, "*SELECT* 1".competence_3, "*SELECT* 1".competence_4, "*SELECT* 1".competence_5, "*SELECT* 1".competence_6, "*SELECT* 1".competence_7, "*SELECT* 1".competence_8, "*SELECT* 1".competence_9, "*SELECT* 1".competence_91, "*SELECT* 1".competence_92, "*SELECT* 1".competence_93, "*SELECT* 1".competence_94, "*SELECT* 1".localisation, "*SELECT* 1".fk_mission, "*SELECT* 1".help, "*SELECT* 1".turnover, "*SELECT* 1".cmt_1, "*SELECT* 1".cmpt_2, "*SELECT* 1".region, "*SELECT* 1".tour_position, "*SELECT* 1".fk_planning_calendrier_zone, "*SELECT* 1".est_actif_dans_ortec, "*SELECT* 1".lift, "*SELECT* 1".order_type, "*SELECT* 1".fk_tournee, "*SELECT* 1".hfrom_horaire, "*SELECT* 1".hto_horaire, "*SELECT* 1".est_horaire_valide, "*SELECT* 1".hfrom_theo, "*SELECT* 1".hto_theo, "*SELECT* 1".tournee_planifie
9. 0.000 0.000 ↓ 0.0

Append (cost=32,504.93..32,921.71 rows=2 width=1,869) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=32,504.93..32,505.34 rows=1 width=1,807) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Unique (cost=32,504.93..32,505.34 rows=1 width=1,809) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Sort (cost=32,504.93..32,505.07 rows=269 width=1,809) (actual rows= loops=)

  • Sort Key: pp.fk_intervention, pp.fk_intervention_type_associe, ((tt5.fk_type = 1)) DESC, ((tt5.fk_type = 9)) DESC
13. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=24,198.82..32,502.76 rows=269 width=1,809) (actual rows= loops=)

  • Hash Cond: (tt4.vehicule = tt5.id_planning_driver)
  • Join Filter: CASE WHEN (pp.fk_planning_driver_flux IS NOT NULL) THEN (tt5.id_planning_driver = pp.fk_planning_driver_flux) ELSE true END
14. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=24,193.03..29,815.90 rows=269 width=1,583) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=24,192.94..29,782.29 rows=269 width=1,583) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=24,192.86..29,756.19 rows=269 width=1,583) (actual rows= loops=)

  • Join Filter: (SubPlan 2)
17. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=24,192.77..28,757.51 rows=1 width=1,587) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=24,192.71..28,754.45 rows=1 width=1,587) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Subquery Scan on pp (cost=24,192.62..28,751.35 rows=1 width=1,595) (actual rows= loops=)

  • Filter: ((pp.id_planning_rendezvous = pp.fk_planning_rendezvous_compare) AND CASE WHEN ((pp.libelle_mission)::text = 'RECUPEL'::text) THEN (((SubPlan 3) = 0) AND ((SubPlan 4) > 0)) ELSE true END)
20. 0.000 0.000 ↓ 0.0

Unique (cost=24,192.62..24,192.99 rows=243 width=1,866) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Sort (cost=24,192.62..24,192.75 rows=243 width=1,866) (actual rows= loops=)

  • Sort Key: b.fk_intervention, c.id_intervention_type_associe, ((b.date_fin IS NULL)) DESC, b.date_fin DESC, ((f.fk_flux_noeud_type = 1)) DESC, ((hh2.id_conteneur = p3.id_conteneur)) DESC, ((hh.id_conteneur = p3.id_conteneur)) DESC, f."position" DESC, ((j.fk_type = 6)) DESC, j.est_master DESC, ((j2.fk_type = 6)) DESC, j2.est_master DESC, (CASE WHEN (e.id_mission = 2) THEN (xv.creation_time <= (((a.date)::text || ' 16:00:00'::text))::timestamp without time zone) ELSE (xv.creation_time < (((a.date)::text || ' 16:00:00'::text))::timestamp without time zone) END) DESC, xv.creation_time DESC, tu1."position" DESC
22. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=59.59..24,190.70 rows=243 width=1,866) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=59.50..16,946.51 rows=243 width=505) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=59.44..16,499.38 rows=243 width=501) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Nested Loop (cost=59.36..16,043.65 rows=243 width=483) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Nested Loop (cost=59.27..15,234.02 rows=342 width=475) (actual rows= loops=)

  • Join Filter: (b.fk_intervention = tu.fk_intervention)
27. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=59.18..14,962.78 rows=144 width=499) (actual rows= loops=)

  • Hash Cond: (t4.vehicule = t5.id_planning_driver)
28. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=53.39..14,956.91 rows=144 width=497) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=53.30..14,687.07 rows=144 width=481) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=53.22..14,418.47 rows=144 width=461) (actual rows= loops=)

  • Join Filter: (t2.fk_donneur_ordre = t1.id_planning_agenda_donneur_ordre)
31. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=53.13..12,895.18 rows=144 width=465) (actual rows= loops=)

  • Join Filter: (t1.date_agenda = a.date)
32. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=53.08..12,891.55 rows=144 width=461) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=52.99..12,805.94 rows=31 width=449) (actual rows= loops=)

  • Join Filter: (xu.fk_date = a.id_calendrier)
34. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=52.93..12,751.24 rows=31 width=440) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=52.85..12,690.80 rows=31 width=440) (actual rows= loops=)

  • Join Filter: ((xk_1.creation_time)::date < a.date)
36. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=52.76..12,632.85 rows=31 width=440) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Nested Loop (cost=52.68..12,574.93 rows=31 width=440) (actual rows= loops=)

  • Join Filter: (j2.fk_pays = m2.id_pays)
38. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=52.68..12,573.01 rows=31 width=441) (actual rows= loops=)

  • Join Filter: ((xs.debut_statut)::date < a.date)
39. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=52.59..12,490.90 rows=37 width=441) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=52.53..12,423.32 rows=37 width=426) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Nested Loop (cost=52.45..12,354.27 rows=37 width=408) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=52.36..12,285.06 rows=37 width=346) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Nested Loop (cost=52.28..12,215.93 rows=37 width=346) (actual rows= loops=)

  • Join Filter: (j.fk_pays = m.id_pays)
44. 0.000 0.000 ↓ 0.0

Nested Loop (cost=52.28..12,213.84 rows=37 width=347) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Nested Loop (cost=52.19..11,984.07 rows=123 width=339) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=52.10..11,753.12 rows=123 width=331) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Nested Loop (cost=52.05..11,528.48 rows=123 width=316) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.96..11,298.91 rows=123 width=298) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.87..11,066.96 rows=124 width=236) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.79..10,286.13 rows=418 width=228) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.70..9,501.27 rows=418 width=220) (actual rows= loops=)

  • Join Filter: (b.fk_intervention = f.fk_intervention)
52. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.62..9,234.36 rows=141 width=200) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.53..8,309.32 rows=492 width=200) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=51.45..8,221.47 rows=47 width=196) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=51.36..7,656.21 rows=47 width=197) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=51.27..7,407.62 rows=47 width=177) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.22..7,325.54 rows=47 width=175) (actual rows= loops=)

  • Join Filter: (b.fk_intervention = g2.fk_intervention)
58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.13..7,232.64 rows=49 width=167) (actual rows= loops=)

  • Join Filter: (b.fk_intervention = g3.fk_intervention)
59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=51.04..7,111.30 rows=64 width=159) (actual rows= loops=)

  • Join Filter: (b.fk_intervention = g5.fk_intervention)
60. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=50.96..6,953.93 rows=83 width=145) (actual rows= loops=)

  • Hash Cond: (el.fk_option_mission = ek.id_option_mission)
61. 0.000 0.000 ↓ 0.0

Hash Join (cost=32.83..6,935.49 rows=83 width=143) (actual rows= loops=)

  • Hash Cond: (c.fk_mission = e.id_mission)
62. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=21.36..6,923.76 rows=49 width=125) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=21.30..6,835.95 rows=49 width=121) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Nested Loop (cost=21.22..6,744.45 rows=49 width=96) (actual rows= loops=)

  • Join Filter: (b.fk_intervention = ee.fk_intervention)
65. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=21.13..6,641.03 rows=55 width=84) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=21.04..6,536.68 rows=55 width=80) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20.96..6,430.78 rows=55 width=64) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20.87..6,272.71 rows=55 width=64) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20.79..6,054.20 rows=117 width=56) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20.70..5,579.39 rows=254 width=44) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20.61..4,930.77 rows=347 width=36) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_calendriers_date on calendriers a (cost=0.06..3.06 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (date = '2018-12-06'::date)
73. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on planning_rendezvous b (cost=20.56..4,925.91 rows=600 width=32) (actual rows= loops=)

  • Recheck Cond: (fk_date = a.id_calendrier)
  • Filter: ((date_fin IS NULL) AND (fk_date_type = 3))
74. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_planning_rendezvous_fk_date (cost=0.00..20.53 rows=3,628 width=0) (actual rows= loops=)

  • Index Cond: (fk_date = a.id_calendrier)
75. 0.000 0.000 ↓ 0.0

Index Scan using interventions_pkey on interventions b2 (cost=0.09..1.87 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id_intervention = b.fk_intervention)
  • Filter: (fk_groupe = ANY ('{11,50}'::integer[]))
76. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_types_associes_intervention on interventions_types_associes c (cost=0.09..1.87 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (fk_intervention = b.fk_intervention)
  • Filter: (fk_mission <> 2)
77. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_liaisons_liaison on interventions_liaisons b23 (cost=0.08..1.86 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_intervention_liaison = b.fk_intervention)
  • Filter: (fk_type_liaison = 2)
78. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_rendezvous_interv_type on planning_rendezvous ab (cost=0.09..2.87 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_date_type = ANY ('{4,5}'::integer[])) AND (fk_intervention = b.fk_intervention))
  • Filter: ((date_fin IS NULL) AND (date_rdv < b.date_rdv))
79. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_rendezvous_horaire_fk_planning_rendezvous on planning_rendezvous_horaire b1 (cost=0.09..1.92 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (fk_planning_rendezvous = b.id_planning_rendezvous)
  • Filter: (fk_planning_rendezvous_type = 1)
80. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_interventions_partenaires_intervparttype on interventions_partenaires ip20 (cost=0.09..1.89 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((fk_partenaire_type = 20) AND (fk_intervention = b2.id_intervention))
81. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_preencodage_intervention on interventions_preencodage ee (cost=0.09..1.88 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (fk_intervention = b2.id_intervention)
82. 0.000 0.000 ↓ 0.0

Index Scan using idx_ressources_logistiques_fk_intervention_type_associe on ressources_logistiques d (cost=0.08..1.86 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (fk_intervention_type_associe = c.id_intervention_type_associe)
83. 0.000 0.000 ↓ 0.0

Index Scan using seq_interventions_missions_options_fk_intervention on interventions_missions_options el (cost=0.06..1.79 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_intervention = b.fk_intervention)
84. 0.000 0.000 ↓ 0.0

Hash (cost=10.36..10.36 rows=318 width=18) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=5.23..10.36 rows=318 width=18) (actual rows= loops=)

  • Hash Cond: (efe.fk_mission = e.id_mission)
86. 0.000 0.000 ↓ 0.0

Seq Scan on missions_libelles efe (cost=0.00..4.95 rows=318 width=14) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Hash (cost=4.57..4.57 rows=189 width=8) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Seq Scan on missions e (cost=0.00..4.57 rows=189 width=8) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Hash (cost=14.72..14.72 rows=974 width=10) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.16..14.72 rows=974 width=10) (actual rows= loops=)

  • Hash Cond: (ek.fk_option_valeur = em.id_option_valeur)
91. 0.000 0.000 ↓ 0.0

Seq Scan on options_missions ek (cost=0.00..12.92 rows=974 width=8) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Hash (cost=1.07..1.07 rows=25 width=10) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Seq Scan on options_valeurs em (cost=0.00..1.07 rows=25 width=10) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_partenaires_intervparttype on interventions_partenaires g5 (cost=0.09..1.89 rows=1 width=14) (actual rows= loops=)

  • Index Cond: ((fk_partenaire_type = 5) AND (fk_intervention = ee.fk_intervention))
95. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_interventions_partenaires_intervparttype on interventions_partenaires g3 (cost=0.09..1.89 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_partenaire_type = 3) AND (fk_intervention = ee.fk_intervention))
96. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_interventions_partenaires_intervparttype on interventions_partenaires g2 (cost=0.09..1.89 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_partenaire_type = 2) AND (fk_intervention = ee.fk_intervention))
97. 0.000 0.000 ↓ 0.0

Index Scan using modeles_familles_pkey on modeles_familles t7 (cost=0.06..1.75 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (id_modeles_famille = ee.fk_famille)
98. 0.000 0.000 ↓ 0.0

Index Scan using idx_fk_modele_modeles_dimensions on modeles_dimensions ef (cost=0.09..5.28 rows=2 width=24) (actual rows= loops=)

  • Index Cond: (fk_modele = ee.fk_modele)
  • Filter: (date_fin IS NULL)
99. 0.000 0.000 ↓ 0.0

Index Scan using idx_modeles_classifications_modele on modeles_classifications efu (cost=0.09..12.02 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (fk_modele = ee.fk_modele)
  • Filter: (fk_modele_classification_type = 9)
100. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_partenaires_contacts_moraux_conteneurs on partenaires_contacts o3 (cost=0.09..1.87 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_partenaire_moral = g3.fk_partenaire)
101. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_conteneurs_types on conteneurs p3 (cost=0.09..1.88 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((fk_type = 6) AND (id_conteneur = o3.fk_conteneur_contact))
102. 0.000 0.000 ↓ 0.0

Index Scan using idx_flux_interventions_intervention on flux_interventions f (cost=0.09..1.88 rows=3 width=20) (actual rows= loops=)

  • Index Cond: (fk_intervention = g2.fk_intervention)
  • Filter: (fk_flux_noeud_type = ANY ('{1,2}'::integer[]))
103. 0.000 0.000 ↓ 0.0

Index Scan using conteneurs_pkey on conteneurs hh (cost=0.09..1.88 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id_conteneur = f.fk_conteneur_de)
104. 0.000 0.000 ↓ 0.0

Index Scan using idx_partenaires_contacts_conteneur_contact on partenaires_contacts h (cost=0.09..1.87 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (fk_conteneur_contact = hh.id_conteneur)
105. 0.000 0.000 ↓ 0.0

Index Scan using idx_partenaires_contacts_adresses on partenaires_contacts_adresses j (cost=0.09..1.87 rows=1 width=70) (actual rows= loops=)

  • Index Cond: (fk_partenaire_contact = h.id_partenaire_contact)
106. 0.000 0.000 ↓ 0.0

Index Scan using partenaires_moraux_pkey on partenaires_moraux k (cost=0.09..1.87 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (id_partenaire_moral = h.fk_partenaire_moral)
107. 0.000 0.000 ↓ 0.0

Index Scan using codes_postaux_pkey on codes_postaux l (cost=0.06..1.83 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (id_code_postal = j.fk_code_postal)
108. 0.000 0.000 ↓ 0.0

Index Scan using conteneurs_pkey on conteneurs hh2 (cost=0.09..1.88 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id_conteneur = f.fk_conteneur_a)
109. 0.000 0.000 ↓ 0.0

Index Scan using idx_partenaires_contacts_conteneur_contact on partenaires_contacts h2 (cost=0.09..1.87 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (fk_conteneur_contact = hh2.id_conteneur)
110. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.03 rows=8 width=7) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Seq Scan on pays m (cost=0.00..1.02 rows=8 width=7) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Index Only Scan using partenaires_physiques_langues_pkey on partenaires_physiques_langues n (cost=0.09..1.87 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_partenaire_physique = h.fk_partenaire_physique)
113. 0.000 0.000 ↓ 0.0

Index Scan using idx_partenaires_contacts_adresses on partenaires_contacts_adresses j2 (cost=0.09..1.87 rows=1 width=70) (actual rows= loops=)

  • Index Cond: (fk_partenaire_contact = h2.id_partenaire_contact)
114. 0.000 0.000 ↓ 0.0

Index Scan using partenaires_moraux_pkey on partenaires_moraux k2 (cost=0.09..1.87 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (id_partenaire_moral = h2.fk_partenaire_moral)
115. 0.000 0.000 ↓ 0.0

Index Scan using codes_postaux_pkey on codes_postaux l2 (cost=0.06..1.83 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (id_code_postal = j2.fk_code_postal)
116. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_statuts_interventions on interventions_statuts xs (cost=0.09..2.22 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (fk_intervention = b.fk_intervention)
  • Filter: ((fk_evenement = ANY ('{6,69,1002}'::integer[])) OR ((fk_evenement = 318) AND (fin_statut IS NULL)))
117. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.03 rows=8 width=7) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Seq Scan on pays m2 (cost=0.00..1.02 rows=8 width=7) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Index Only Scan using partenaires_physiques_langues_pkey on partenaires_physiques_langues n2 (cost=0.09..1.87 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_partenaire_physique = h2.fk_partenaire_physique)
120. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_liaisons_interventions on interventions_liaisons xk_1 (cost=0.08..1.87 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((fk_type_liaison = 14) AND (fk_intervention = b.fk_intervention))
121. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_partenaires_interventions on interventions_partenaires xt (cost=0.09..1.89 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((fk_intervention = b.fk_intervention) AND (fk_partenaire = 507729))
  • Filter: (fk_partenaire_type = 2)
122. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_ortec_order_fk_intervention on planning_ortec_order xu (cost=0.06..1.76 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (fk_intervention = b.fk_intervention)
  • Filter: (date_fin IS NULL)
123. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_rendezvous_interv_type on planning_rendezvous xv (cost=0.09..2.76 rows=2 width=16) (actual rows= loops=)

  • Index Cond: ((fk_date_type = 3) AND (fk_intervention = b.fk_intervention))
  • Filter: (date_fin IS NULL)
124. 0.000 0.000 ↓ 0.0

Materialize (cost=0.06..3.06 rows=1 width=8) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_agenda_donneur_ordre_date on planning_agenda_donneur_ordre t1 (cost=0.06..3.06 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (date_agenda = '2018-12-06'::date)
  • Filter: realise
126. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_agenda_partenaire on planning_agenda t2 (cost=0.09..10.52 rows=16 width=12) (actual rows= loops=)

  • Index Cond: (id_partenaire = g3.fk_partenaire)
127. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_agenda_horaire_fk_planning_agenda on planning_agenda_horaire t3 (cost=0.08..1.86 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (fk_planning_agenda = t2.id_planning_agenda)
128. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_tournee_planning_agenda on planning_tournee t4 (cost=0.09..1.87 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (fk_planning_agenda = t2.id_planning_agenda)
129. 0.000 0.000 ↓ 0.0

Hash (cost=4.83..4.83 rows=276 width=10) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Seq Scan on planning_tournee_driver t5 (cost=0.00..4.83 rows=276 width=10) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Index Scan using idx_conteneurs_interventions on conteneurs tu (cost=0.09..1.88 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (fk_intervention = f.fk_intervention)
132. 0.000 0.000 ↓ 0.0

Index Scan using idx_conteneurs_est_dans_fk_conteneur on conteneurs_est_dans tu1 (cost=0.09..2.36 rows=2 width=12) (actual rows= loops=)

  • Index Cond: (fk_conteneur = tu.id_conteneur)
133. 0.000 0.000 ↓ 0.0

Index Scan using conteneurs_pkey on conteneurs tu4 (cost=0.09..1.88 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (id_conteneur = tu1.fk_dans_conteneur)
134. 0.000 0.000 ↓ 0.0

Index Scan using idx_conteneurs_statuts_evenements_open2 on conteneurs_statuts tu2 (cost=0.06..1.84 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_conteneur = tu.id_conteneur) AND (fk_evenement = 63))
135. 0.000 0.000 ↓ 0.0

Index Scan using idx_flux_interventions_intervention on flux_interventions tu3 (cost=0.09..1.89 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (fk_intervention = b.fk_intervention)
  • Filter: ((date_fin IS NULL) AND (fk_flux_noeud_type = 1) AND ("position" = 1))
136.          

SubPlan (forNested Loop Left Join)

137. 0.000 0.000 ↓ 0.0

Aggregate (cost=14.14..14.14 rows=1 width=32) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.34..14.14 rows=1 width=9) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.26..9.59 rows=1 width=13) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.17..9.39 rows=2 width=17) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Index Scan using lignes_financieres_idx7 on lignes_financieres za (cost=0.09..3.21 rows=2 width=17) (actual rows= loops=)

  • Index Cond: (fk_intervention = b.fk_intervention)
  • Filter: (fk_partenaire_de = 8146)
142. 0.000 0.000 ↓ 0.0

Index Scan using lignes_financieres_documents_idx on lignes_financieres_documents wa (cost=0.09..3.09 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_ligne = za.id_ligne)
143. 0.000 0.000 ↓ 0.0

Index Scan using documents_financier_pk on documents_financier va (cost=0.09..0.10 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id_document_financier = wa.fk_document_financier)
  • Filter: (fk_type = 15)
144. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_rendezvous_interv_type on planning_rendezvous wk (cost=0.09..4.54 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((fk_date_type = 3) AND (fk_intervention = b.fk_intervention))
  • Filter: ((date_fin IS NULL) AND (fk_date = a.id_calendrier))
145. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.26..13.69 rows=1 width=0) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.17..9.37 rows=1 width=8) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_liaisons_intervention on interventions_liaisons ya (cost=0.08..3.18 rows=2 width=4) (actual rows= loops=)

  • Index Cond: (fk_intervention = b23.fk_intervention)
  • Filter: (fk_type_liaison = 2)
148. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_interventions_types_associes_intervention on interventions_types_associes yb (cost=0.09..3.09 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((fk_intervention = ya.fk_intervention_liaison) AND (fk_mission = 25))
149. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_rendezvous_interv_type on planning_rendezvous yc (cost=0.09..4.32 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((fk_date_type = 3) AND (fk_intervention = yb.fk_intervention))
  • Filter: (((date_fin IS NULL) OR (date_fin >= a.date)) AND (fk_date = a.id_calendrier))
150.          

SubPlan (forSubquery Scan)

151. 0.000 0.000 ↓ 0.0

Limit (cost=9.37..9.37 rows=1 width=8) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Aggregate (cost=9.37..9.37 rows=1 width=8) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.17..9.37 rows=1 width=0) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_liaisons_intervention on interventions_liaisons il1 (cost=0.09..3.18 rows=2 width=4) (actual rows= loops=)

  • Index Cond: (fk_intervention = (pp.fk_intervention_maitre)::integer)
  • Filter: (fk_type_liaison = 2)
155. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_interventions_types_associes_intervention on interventions_types_associes il2 (cost=0.09..3.09 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((fk_intervention = il1.fk_intervention_liaison) AND (fk_mission = 2))
156. 0.000 0.000 ↓ 0.0

Limit (cost=9.38..9.38 rows=1 width=8) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Aggregate (cost=9.38..9.38 rows=1 width=8) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.17..9.38 rows=1 width=0) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_liaisons_intervention on interventions_liaisons il11 (cost=0.09..3.19 rows=2 width=4) (actual rows= loops=)

  • Index Cond: (fk_intervention = (pp.fk_intervention_maitre)::integer)
  • Filter: ((fk_type_liaison = 2) AND (fk_intervention_liaison <> (pp.fk_intervention)::integer))
160. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_rendezvous_rdv_interv on planning_rendezvous il22 (cost=0.09..3.09 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((fk_date_type = 3) AND (date_rdv = pp.drdv) AND (fk_intervention = il11.fk_intervention_liaison))
  • Filter: (date_fin IS NULL)
161. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_actions_interv_event on interventions_actions xw (cost=0.09..3.09 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((fk_evenement = 850) AND (fk_intervention = (pp.fk_intervention)::integer))
  • Filter: ((debut_action > pp.creation_time_drdv) AND ((debut_action)::date < pp.drdv))
162. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_agenda_donneur_ordre_date on planning_agenda_donneur_ordre tt1 (cost=0.06..3.06 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (date_agenda = pp.dprepa)
  • Filter: realise
163. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_agenda_donneur_ordre on planning_agenda tt2 (cost=0.09..13.54 rows=619 width=12) (actual rows= loops=)

  • Index Cond: (fk_donneur_ordre = tt1.id_planning_agenda_donneur_ordre)
164.          

SubPlan (forNested Loop Left Join)

165. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_partenaires_contacts_conteneur_contact on partenaires_contacts (cost=0.09..3.09 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (fk_conteneur_contact = pp.fk_conteneur_flux_de)
166. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_planning_agenda_horaire_fk_planning_agenda on planning_agenda_horaire tt3 (cost=0.08..0.09 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (fk_planning_agenda = tt2.id_planning_agenda)
167. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_planning_tournee_planning_agenda on planning_tournee tt4 (cost=0.09..0.12 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_planning_agenda = tt2.id_planning_agenda)
168. 0.000 0.000 ↓ 0.0

Hash (cost=4.83..4.83 rows=276 width=12) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Seq Scan on planning_tournee_driver tt5 (cost=0.00..4.83 rows=276 width=12) (actual rows= loops=)

170.          

SubPlan (forHash Left Join)

171. 0.000 0.000 ↓ 0.0

Limit (cost=0.26..9.95 rows=1 width=4) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.26..9.95 rows=1 width=4) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.17..9.36 rows=1 width=8) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_liaisons_intervention on interventions_liaisons yaa (cost=0.09..3.18 rows=2 width=4) (actual rows= loops=)

  • Index Cond: (fk_intervention = (pp.fk_intervention_maitre)::integer)
  • Filter: (fk_type_liaison = 2)
175. 0.000 0.000 ↓ 0.0

Index Scan using idx_interventions_types_entrees_interventions on interventions_types_entrees ybb (cost=0.09..3.09 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (fk_intervention = yaa.fk_intervention_liaison)
  • Filter: (fk_type = 35)
176. 0.000 0.000 ↓ 0.0

Index Scan using idx_fk_intervention_financier_statuts on financier_statuts ycc (cost=0.08..0.58 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (fk_intervention = ybb.fk_intervention)
  • Filter: ((fk_evenement = 249) AND ((fin_statut IS NULL) OR ((fin_statut)::date = pp.drdv)))
177. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=416.37..416.37 rows=1 width=1,766) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Unique (cost=416.37..416.37 rows=1 width=1,766) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Sort (cost=416.37..416.37 rows=1 width=1,766) (actual rows= loops=)

  • Sort Key: c_1.id_partenaire_moral
180. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6.58..416.37 rows=1 width=1,766) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.53..416.29 rows=1 width=147) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.44..416.17 rows=1 width=137) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.35..414.83 rows=1 width=137) (actual rows= loops=)

  • Join Filter: (c_1.id_partenaire_moral = g.fk_partenaire)
184. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.30..414.76 rows=1 width=141) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6.27..414.73 rows=1 width=142) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.21..414.67 rows=1 width=127) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.13..414.54 rows=1 width=70) (actual rows= loops=)

  • Join Filter: CASE WHEN (b_1.fk_partenaire_contact IS NOT NULL) THEN (cd.id_partenaire_contact = b_1.fk_partenaire_contact) ELSE true END
188. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6.04..412.45 rows=1 width=66) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.96..409.45 rows=1 width=62) (actual rows= loops=)

190. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.87..82.17 rows=109 width=32) (actual rows= loops=)

  • Hash Cond: (b_1.fk_planning_tournee_driver = a_1.id_planning_driver)
191. 0.000 0.000 ↓ 0.0

Seq Scan on planning_ortec_ressource_config b_1 (cost=0.00..76.11 rows=371 width=32) (actual rows= loops=)

  • Filter: ((date_fin IS NULL) AND (jour = 3))
192. 0.000 0.000 ↓ 0.0

Hash (cost=5.59..5.59 rows=81 width=4) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Seq Scan on planning_tournee_driver a_1 (cost=0.00..5.59 rows=81 width=4) (actual rows= loops=)

  • Filter: (est_attribue AND (fk_type = ANY ('{1,2}'::integer[])) AND (fk_societe <> ALL ('{469301,469299,491494,528754}'::integer[])) AND (fk_depot <> ALL ('{39,290794,1578330,2307869,2307884}'::integer[])))
194. 0.000 0.000 ↓ 0.0

Index Scan using idx_partenaires_moraux_types on partenaires_moraux c_1 (cost=0.09..3.00 rows=1 width=30) (actual rows= loops=)

  • Index Cond: ((fk_type = 2) AND (id_partenaire_moral = b_1.fk_partenaire_moral))
  • Filter: (id_partenaire_moral <> ALL ('{461630,376536,376546,557174}'::integer[]))
195. 0.000 0.000 ↓ 0.0

Index Only Scan using partenaires_groupes_entrees_pkey on partenaires_groupes_entrees cc (cost=0.09..2.99 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_partenaire_moral = b_1.fk_partenaire_moral)
196. 0.000 0.000 ↓ 0.0

Index Scan using idx_partenaires_contacts_moraux_conteneurs on partenaires_contacts cd (cost=0.09..2.09 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_partenaire_moral = c_1.id_partenaire_moral)
197. 0.000 0.000 ↓ 0.0

Index Scan using idx_partenaires_contacts_adresses on partenaires_contacts_adresses d_1 (cost=0.09..0.12 rows=1 width=65) (actual rows= loops=)

  • Index Cond: (fk_partenaire_contact = cd.id_partenaire_contact)
198. 0.000 0.000 ↓ 0.0

Index Scan using codes_postaux_pkey on codes_postaux e_1 (cost=0.06..0.06 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (id_code_postal = d_1.fk_code_postal)
199. 0.000 0.000 ↓ 0.0

Index Scan using pays_pkey on pays f_1 (cost=0.03..0.03 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (id_pays = d_1.fk_pays)
200. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_partenaires_depots_liens_fk_partenaire on planning_partenaires_depots_liens g (cost=0.06..0.06 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_partenaire = cd.fk_partenaire_moral)
201. 0.000 0.000 ↓ 0.0

Index Scan using idx_partenaires_contacts_conteneur_contact on partenaires_contacts h_1 (cost=0.09..1.34 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_conteneur_contact = g.fk_conteneur_depot)
202. 0.000 0.000 ↓ 0.0

Index Scan using idx_partenaires_contacts_adresses on partenaires_contacts_adresses i (cost=0.09..0.12 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (fk_partenaire_contact = h_1.id_partenaire_contact)
203. 0.000 0.000 ↓ 0.0

Index Scan using codes_postaux_pkey on codes_postaux j_1 (cost=0.06..0.06 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id_code_postal = i.fk_code_postal)
204. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..4.36 rows=24 width=205,134) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

Seq Scan on planning_calendriers_zones_geometries xk (cost=0.00..4.33 rows=24 width=205,134) (actual rows= loops=)

  • Filter: (date_fin IS NULL)
206. 0.000 0.000 ↓ 0.0

Hash (cost=3.13..3.13 rows=1 width=9) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

Index Scan using idx_planning_calendrier_zones_fk_type on planning_calendrier_zones xl (cost=0.06..3.13 rows=1 width=9) (actual rows= loops=)

  • Index Cond: (fk_type = 1)
  • Filter: est_active