explain.depesz.com

A tool for finding a real cause for slow queries.

Result: WSV

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=25941.24..25944.91 rows=1468 width=1455) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, r_e_choi.choi_pref, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, servdernierdossier.serv_nom, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.choi_pref, servdernierchoix.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, tevedernierchoix.teve_libe, r_e_hist.ident, tevedernierchoix.teve_code, s_e_efev.efev_depe, instdernierchoix.inst_date, instdernierchoix.inst_heur, instdernierchoix.inst_dater, instdernierchoix.inst_heurr, r_e_hist.prescr_indi_code, instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, tevelistattentechoix.teve_libe, r_e_hist.urge_code, instdernierchoix.inst_code, r_e_choi.info_code, r_e_info.info_libe
  • Sort Key: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, r_e_choi.choi_pref
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17173.22..24933.02 rows=1468 width=1455) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, r_e_choi.choi_pref, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, servdernierdossier.serv_nom, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.choi_pref, servdernierchoix.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, tevedernierchoix.teve_libe, r_e_hist.ident, tevedernierchoix.teve_code, s_e_efev.efev_depe, instdernierchoix.inst_date, instdernierchoix.inst_heur, instdernierchoix.inst_dater, instdernierchoix.inst_heurr, r_e_hist.prescr_indi_code, instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, tevelistattentechoix.teve_libe, r_e_hist.urge_code, instdernierchoix.inst_code, r_e_choi.info_code, r_e_info.info_libe
  • Hash Cond: (r_e_hist.hist_code = s_e_efev.hist_code)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=16883.98..24613.58 rows=1468 width=1450) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_info.info_libe, servdernierchoix.serv_nom, instdernierchoix.inst_date, instdernierchoix.inst_heur, instdernierchoix.inst_dater, instdernierchoix.inst_heurr, instdernierchoix.inst_code, tevedernierchoix.teve_libe, tevedernierchoix.teve_code, instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, tevelistattentechoix.teve_libe
  • Hash Cond: (instlistattentechoix.teve_code = tevelistattentechoix.teve_code)
4. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=16875.70..24585.12 rows=1468 width=1126) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_info.info_libe, servdernierchoix.serv_nom, instdernierchoix.inst_date, instdernierchoix.inst_heur, instdernierchoix.inst_dater, instdernierchoix.inst_heurr, instdernierchoix.inst_code, tevedernierchoix.teve_libe, tevedernierchoix.teve_code, instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code
  • Hash Cond: (instlistattentechoix.choi_code = instdoublonlisteattente.choi_code)
  • Join Filter: ((instdoublonlisteattente.inst_dater > instlistattentechoix.inst_dater) OR ((instdoublonlisteattente.inst_dater = instlistattentechoix.inst_dater) AND (instdoublonlisteattente.inst_heurr > instlistattentechoix.inst_heurr)))
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13356.17..20068.20 rows=2652 width=1130) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_info.info_libe, servdernierchoix.serv_nom, instdernierchoix.inst_date, instdernierchoix.inst_heur, instdernierchoix.inst_dater, instdernierchoix.inst_heurr, instdernierchoix.inst_code, tevedernierchoix.teve_libe, tevedernierchoix.teve_code, instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, instlistattentechoix.choi_code
  • Hash Cond: (instdernierchoix.teve_code = tevedernierchoix.teve_code)
6. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=13341.22..20016.79 rows=2652 width=806) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_info.info_libe, servdernierchoix.serv_nom, instdernierchoix.inst_date, instdernierchoix.inst_heur, instdernierchoix.inst_dater, instdernierchoix.inst_heurr, instdernierchoix.inst_code, instdernierchoix.teve_code, instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, instlistattentechoix.choi_code
  • Merge Cond: (instdernierchoix.inst_code = r_e_choi.choi_inst)
7. 0.000 0.000 ↓ 0.0

Index Scan using r_e_inst_pkey on public.r_e_inst instdernierchoix (cost=0.00..6249.97 rows=153113 width=48) (actual time=.. rows= loops=)

  • Output: instdernierchoix.inst_code, instdernierchoix.choi_code, instdernierchoix.hist_code, instdernierchoix.indi_code, instdernierchoix.serv_code, instdernierchoix.teve_code, instdernierchoix.inst_date, instdernierchoix.inst_heur, instdernierchoix.inst_comm, instdernierchoix.ident, instdernierchoix.inst_heurr, instdernierchoix.inst_dater, instdernierchoix.msor_code
8. 0.000 0.000 ↓ 0.0

Materialize (cost=13337.63..13350.89 rows=2652 width=762) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst, r_e_info.info_libe, servdernierchoix.serv_nom, instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, instlistattentechoix.choi_code
9. 0.000 0.000 ↓ 0.0

Sort (cost=13337.63..13344.26 rows=2652 width=762) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst, r_e_info.info_libe, servdernierchoix.serv_nom, instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, instlistattentechoix.choi_code
  • Sort Key: r_e_choi.choi_inst
10. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8964.64..12287.32 rows=2652 width=762) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst, r_e_info.info_libe, servdernierchoix.serv_nom, instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, instlistattentechoix.choi_code
  • Hash Cond: (instlistattentechoix.choi_code = r_e_choi.choi_code)
11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on public.r_e_inst instlistattentechoix (cost=525.15..3081.34 rows=23855 width=48) (actual time=.. rows= loops=)

  • Output: instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, instlistattentechoix.choi_code
  • Recheck Cond: (instlistattentechoix.teve_code = 12)
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on r_e_inst_fk6 (cost=0.00..519.18 rows=23855 width=0) (actual time=.. rows= loops=)

  • Index Cond: (instlistattentechoix.teve_code = 12)
13. 0.000 0.000 ↓ 0.0

Hash (cost=8165.34..8165.34 rows=2652 width=714) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst, r_e_info.info_libe, servdernierchoix.serv_nom
14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2376.71..8165.34 rows=2652 width=714) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst, r_e_info.info_libe, servdernierchoix.serv_nom
  • Hash Cond: (r_e_choi.serv_code = servdernierchoix.serv_code)
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2370.58..8122.75 rows=2652 width=633) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst, r_e_info.info_libe
  • Hash Cond: (r_e_choi.info_code = r_e_info.info_code)
16. 0.000 0.000 ↓ 0.0

Hash Join (cost=2368.19..8110.40 rows=2652 width=592) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, tevedernierdossier.teve_libe, tevedernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst
  • Hash Cond: (instdernierdossier.teve_code = tevedernierdossier.teve_code)
17. 0.000 0.000 ↓ 0.0

Hash Join (cost=2353.24..8058.98 rows=2652 width=268) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, servdernierdossier.serv_nom, instdernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst
  • Hash Cond: (r_e_hist.serv_code = servdernierdossier.serv_code)
18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2347.11..8016.39 rows=2652 width=187) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, instdernierdossier.teve_code, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst
19. 0.000 0.000 ↓ 0.0

Hash Join (cost=2347.11..3604.28 rows=3077 width=187) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_code, s_m_indi.indi_nomjf, s_m_indi.indi_civil, r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, r_e_hist.hist_inst, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst
  • Hash Cond: (s_m_indi.indi_code = r_e_hist.indi_code)
20. 0.000 0.000 ↓ 0.0

Seq Scan on public.s_m_indi (cost=0.00..846.07 rows=33807 width=103) (actual time=.. rows= loops=)

  • Output: s_m_indi.indi_code, s_m_indi.indi_nom, s_m_indi.indi_prnom, s_m_indi.indi_nomjf, s_m_indi.indi_sexe, s_m_indi.indi_civil, s_m_indi.indi_dnais, s_m_indi.indi_etat, s_m_indi.ident, s_m_indi.indi_lunai, s_m_indi.indi_deces, s_m_indi.indi_hnais
21. 0.000 0.000 ↓ 0.0

Hash (cost=2308.65..2308.65 rows=3077 width=89) (actual time=.. rows= loops=)

  • Output: r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, r_e_hist.indi_code, r_e_hist.hist_inst, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst
22. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=388.26..2308.65 rows=3077 width=89) (actual time=.. rows= loops=)

  • Output: r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, r_e_hist.indi_code, r_e_hist.hist_inst, r_e_choi.choi_pref, r_e_choi.serv_code, r_e_choi.choi_code, r_e_choi.info_code, r_e_choi.choi_inst
  • Hash Cond: (r_e_choi.hist_code = r_e_hist.hist_code)
  • Filter: ((r_e_hist.serv_code = 'CLI4'::bpchar) OR (r_e_choi.serv_code = ANY ('{M401,M402,M403,M404,M405,M406,M407,M408,M409,M411,M412,M413,M414,M415,M416,M417,M418,M419,M421,M423,CLI4}'::bpchar[])))
23. 0.000 0.000 ↓ 0.0

Seq Scan on public.r_e_choi (cost=0.00..536.70 rows=32770 width=39) (actual time=.. rows= loops=)

  • Output: r_e_choi.choi_code, r_e_choi.hist_code, r_e_choi.serv_code, r_e_choi.choi_pref, r_e_choi.choi_inst, r_e_choi.ident, r_e_choi.info_code
24. 0.000 0.000 ↓ 0.0

Hash (cost=270.36..270.36 rows=9432 width=54) (actual time=.. rows= loops=)

  • Output: r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, r_e_hist.indi_code, r_e_hist.hist_inst
25. 0.000 0.000 ↓ 0.0

Seq Scan on public.r_e_hist (cost=0.00..270.36 rows=9432 width=54) (actual time=.. rows= loops=)

  • Output: r_e_hist.hist_code, r_e_hist.serv_code, r_e_hist.hist_dmdr, r_e_hist.hist_fmdr, r_e_hist.ident, r_e_hist.prescr_indi_code, r_e_hist.urge_code, r_e_hist.indi_code, r_e_hist.hist_inst
  • Filter: (r_e_hist.hist_dsor IS NULL)
26. 0.000 0.000 ↓ 0.0

Index Scan using r_e_inst_pkey on public.r_e_inst instdernierdossier (cost=0.00..1.42 rows=1 width=8) (actual time=.. rows= loops=)

  • Output: instdernierdossier.inst_code, instdernierdossier.choi_code, instdernierdossier.hist_code, instdernierdossier.indi_code, instdernierdossier.serv_code, instdernierdossier.teve_code, instdernierdossier.inst_date, instdernierdossier.inst_heur, instdernierdossier.inst_comm, instdernierdossier.ident, instdernierdossier.inst_heurr, instdernierdossier.inst_dater, instdernierdossier.msor_code
  • Index Cond: (instdernierdossier.inst_code = r_e_hist.hist_inst)
27. 0.000 0.000 ↓ 0.0

Hash (cost=4.39..4.39 rows=139 width=86) (actual time=.. rows= loops=)

  • Output: servdernierdossier.serv_nom, servdernierdossier.serv_code
28. 0.000 0.000 ↓ 0.0

Seq Scan on public.s_s_serv servdernierdossier (cost=0.00..4.39 rows=139 width=86) (actual time=.. rows= loops=)

  • Output: servdernierdossier.serv_nom, servdernierdossier.serv_code
29. 0.000 0.000 ↓ 0.0

Hash (cost=12.20..12.20 rows=220 width=328) (actual time=.. rows= loops=)

  • Output: tevedernierdossier.teve_libe, tevedernierdossier.teve_code
30. 0.000 0.000 ↓ 0.0

Seq Scan on public.r_e_teve tevedernierdossier (cost=0.00..12.20 rows=220 width=328) (actual time=.. rows= loops=)

  • Output: tevedernierdossier.teve_libe, tevedernierdossier.teve_code
31. 0.000 0.000 ↓ 0.0

Hash (cost=1.62..1.62 rows=62 width=46) (actual time=.. rows= loops=)

  • Output: r_e_info.info_libe, r_e_info.info_code
32. 0.000 0.000 ↓ 0.0

Seq Scan on public.r_e_info (cost=0.00..1.62 rows=62 width=46) (actual time=.. rows= loops=)

  • Output: r_e_info.info_libe, r_e_info.info_code
33. 0.000 0.000 ↓ 0.0

Hash (cost=4.39..4.39 rows=139 width=86) (actual time=.. rows= loops=)

  • Output: servdernierchoix.serv_nom, servdernierchoix.serv_code
34. 0.000 0.000 ↓ 0.0

Seq Scan on public.s_s_serv servdernierchoix (cost=0.00..4.39 rows=139 width=86) (actual time=.. rows= loops=)

  • Output: servdernierchoix.serv_nom, servdernierchoix.serv_code
35. 0.000 0.000 ↓ 0.0

Hash (cost=12.20..12.20 rows=220 width=328) (actual time=.. rows= loops=)

  • Output: tevedernierchoix.teve_libe, tevedernierchoix.teve_code
36. 0.000 0.000 ↓ 0.0

Seq Scan on public.r_e_teve tevedernierchoix (cost=0.00..12.20 rows=220 width=328) (actual time=.. rows= loops=)

  • Output: tevedernierchoix.teve_libe, tevedernierchoix.teve_code
37. 0.000 0.000 ↓ 0.0

Hash (cost=3081.34..3081.34 rows=23855 width=24) (actual time=.. rows= loops=)

  • Output: instdoublonlisteattente.choi_code, instdoublonlisteattente.inst_dater, instdoublonlisteattente.inst_heurr
38. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on public.r_e_inst instdoublonlisteattente (cost=525.15..3081.34 rows=23855 width=24) (actual time=.. rows= loops=)

  • Output: instdoublonlisteattente.choi_code, instdoublonlisteattente.inst_dater, instdoublonlisteattente.inst_heurr
  • Recheck Cond: (instdoublonlisteattente.teve_code = 12)
39. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on r_e_inst_fk6 (cost=0.00..519.18 rows=23855 width=0) (actual time=.. rows= loops=)

  • Index Cond: (instdoublonlisteattente.teve_code = 12)
40. 0.000 0.000 ↓ 0.0

Hash (cost=8.27..8.27 rows=1 width=328) (actual time=.. rows= loops=)

  • Output: tevelistattentechoix.teve_libe, tevelistattentechoix.teve_code
41. 0.000 0.000 ↓ 0.0

Index Scan using r_e_teve_pkey on public.r_e_teve tevelistattentechoix (cost=0.00..8.27 rows=1 width=328) (actual time=.. rows= loops=)

  • Output: tevelistattentechoix.teve_libe, tevelistattentechoix.teve_code
  • Index Cond: (tevelistattentechoix.teve_code = 12)
42. 0.000 0.000 ↓ 0.0

Hash (cost=179.11..179.11 rows=8811 width=9) (actual time=.. rows= loops=)

  • Output: s_e_efev.efev_depe, s_e_efev.hist_code
43. 0.000 0.000 ↓ 0.0

Seq Scan on public.s_e_efev (cost=0.00..179.11 rows=8811 width=9) (actual time=.. rows= loops=)

  • Output: s_e_efev.efev_depe, s_e_efev.hist_code