explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ElS

options
# exclusive inclusive rows x rows loops node
1. 43.875 405.032 ↓ 2.5 3684 1
→

Sort (cost=25941.240..25944.910 rows=1468 width=1455) (actual time=398.543..405.032 rows=3684 loops=1)

  • 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: uniform_foxtrot.five_november, uniform_foxtrot.xray_kilo, uniform_foxtrot.echo_golf, romeo.foxtrot_golf
  • Sort Method: external merge Disk: 2256kB
2. 4.950 361.157 ↓ 2.5 3684 1
→

Hash Left Join (cost=17173.220..24933.020 rows=1468 width=1455) (actual time=233.188..361.157 rows=3684 loops=1)

  • 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: (mike_india.mike_charlie = echo_juliet.mike_charlie)
3. 2.671 349.234 ↓ 2.5 3684 1
→

Hash Left Join (cost=16883.980..24613.580 rows=1468 width=1450) (actual time=226.203..349.234 rows=3684 loops=1)

  • 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: (alpha_november.delta_bravo = xray_three_zulu.delta_bravo)
4. 16.377 346.550 ↓ 2.5 3684 1
→

Hash Anti Join (cost=16875.700..24585.120 rows=1468 width=1126) (actual time=226.168..346.550 rows=3684 loops=1)

  • 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: (alpha_november.foxtrot_papa = bravo_hotel.foxtrot_papa)
  • Join Filter: ((bravo_hotel.foxtrot_november > alpha_november.foxtrot_november) OR ((bravo_hotel.foxtrot_november = alpha_november.foxtrot_november) AND (bravo_hotel.five_xray > alpha_november.five_xray)))
5. 3.234 303.776 ↓ 1.4 3698 1
→

Hash Left Join (cost=13356.170..20068.200 rows=2652 width=1130) (actual time=199.729..303.776 rows=3698 loops=1)

  • 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: (november.delta_bravo = five_romeo_six.delta_bravo)
6. 41.774 300.523 ↓ 1.4 3698 1
→

Merge Right Join (cost=13341.220..20016.790 rows=2652 width=806) (actual time=199.684..300.523 rows=3698 loops=1)

  • 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: (november.uniform_seven = romeo.india)
7. 56.952 56.952 ↑ 1.0 153103 1
→

Index Scan using seven on yankee november (cost=0.000..6249.970 rows=153113 width=48) (actual time=0.020..56.952 rows=153103 loops=1)

  • 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. 2.368 201.797 ↓ 1.4 3698 1
→

Materialize (cost=13337.630..13350.890 rows=2652 width=762) (actual time=196.320..201.797 rows=3698 loops=1)

  • 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. 15.677 199.429 ↓ 1.4 3698 1
→

Sort (cost=13337.630..13344.260 rows=2652 width=762) (actual time=196.316..199.429 rows=3698 loops=1)

  • 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: romeo.india
  • Sort Method: external merge Disk: 1568kB
10. 21.312 183.752 ↓ 1.4 3698 1
→

Hash Right Join (cost=8964.640..12287.320 rows=2652 width=762) (actual time=151.178..183.752 rows=3698 loops=1)

  • 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: (alpha_november.foxtrot_papa = romeo.foxtrot_papa)
11. 13.972 16.162 ↑ 1.0 23832 1
→

Bitmap Heap Scan on yankee alpha_november (cost=525.150..3081.340 rows=23855 width=48) (actual time=2.498..16.162 rows=23832 loops=1)

  • Output: instlistattentechoix.inst_date, instlistattentechoix.inst_heur, instlistattentechoix.inst_dater, instlistattentechoix.inst_heurr, instlistattentechoix.teve_code, instlistattentechoix.choi_code
  • Recheck Cond: (alpha_november.delta_bravo = 12)
12. 2.190 2.190 ↑ 1.0 23832 1
→

Bitmap Index Scan on hotel_bravo (cost=0.000..519.180 rows=23855 width=0) (actual time=2.190..2.190 rows=23832 loops=1)

  • Index Cond: (alpha_november.delta_bravo = 12)
13. 8.014 146.278 ↓ 1.4 3682 1
→

Hash (cost=8165.340..8165.340 rows=2652 width=714) (actual time=146.278..146.278 rows=3682 loops=1)

  • 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
  • Buckets: 1024 Batches: 2 Memory Usage: 732kB
14. 2.859 138.264 ↓ 1.4 3682 1
→

Hash Left Join (cost=2376.710..8165.340 rows=2652 width=714) (actual time=80.882..138.264 rows=3682 loops=1)

  • 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: (romeo.alpha_seven = delta_xray.alpha_seven)
15. 2.171 135.289 ↓ 1.4 3682 1
→

Hash Left Join (cost=2370.580..8122.750 rows=2652 width=633) (actual time=80.756..135.289 rows=3682 loops=1)

  • 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: (romeo.zulu_papa = delta_alpha.zulu_papa)
16. 2.610 133.028 ↓ 1.4 3682 1
→

Hash Join (cost=2368.190..8110.400 rows=2652 width=592) (actual time=80.647..133.028 rows=3682 loops=1)

  • 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: (sierra.delta_bravo = bravo_five.delta_bravo)
17. 3.215 130.389 ↓ 1.4 3682 1
→

Hash Join (cost=2353.240..8058.980 rows=2652 width=268) (actual time=80.605..130.389 rows=3682 loops=1)

  • 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: (mike_india.alpha_seven = quebec.alpha_seven)
18. 4.826 126.836 ↓ 1.4 3682 1
→

Nested Loop (cost=2347.110..8016.390 rows=2652 width=187) (actual time=80.255..126.836 rows=3682 loops=1)

  • 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. 14.318 107.262 ↓ 1.2 3687 1
→

Hash Join (cost=2347.110..3604.280 rows=3077 width=187) (actual time=80.234..107.262 rows=3687 loops=1)

  • 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: (uniform_foxtrot.echo_golf = mike_india.echo_golf)
20. 12.965 12.965 ↑ 1.0 33807 1
→

Seq Scan on whiskey_november (cost=0.000..846.070 rows=33807 width=103) (actual time=0.048..12.965 rows=33807 loops=1)

  • 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. 2.606 79.979 ↓ 1.2 3687 1
→

Hash (cost=2308.650..2308.650 rows=3077 width=89) (actual time=79.979..79.979 rows=3687 loops=1)

  • 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
  • Buckets: 1024 Batches: 1 Memory Usage: 288kB
22. 44.024 77.373 ↓ 1.2 3687 1
→

Hash Right Join (cost=388.260..2308.650 rows=3077 width=89) (actual time=25.656..77.373 rows=3687 loops=1)

  • 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: (romeo.mike_charlie = mike_india.mike_charlie)
  • Filter: ((mike_india.alpha_seven = 'papa'::bpchar) OR (romeo.alpha_seven = ANY ('whiskey_golf'::bpchar[])))
23. 11.383 11.383 ↑ 1.0 32770 1
→

Seq Scan on juliet (cost=0.000..536.700 rows=32770 width=39) (actual time=0.009..11.383 rows=32770 loops=1)

  • 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. 7.806 21.966 ↑ 1.0 9432 1
→

Hash (cost=270.360..270.360 rows=9432 width=54) (actual time=21.966..21.966 rows=9432 loops=1)

  • 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
  • Buckets: 1024 Batches: 1 Memory Usage: 579kB
25. 14.160 14.160 ↑ 1.0 9432 1
→

Seq Scan on hotel_oscar (cost=0.000..270.360 rows=9432 width=54) (actual time=0.056..14.160 rows=9432 loops=1)

  • 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: (mike_india.echo_six five_romeo_foxtrot NULL)
26. 14.748 14.748 ↑ 1.0 1 3687
→

Index Scan using seven on yankee sierra (cost=0.000..1.420 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=3687)

  • 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: (sierra.uniform_seven = mike_india.zulu_juliet)
27. 0.235 0.338 ↑ 1.0 139 1
→

Hash (cost=4.390..4.390 rows=139 width=86) (actual time=0.338..0.338 rows=139 loops=1)

  • Output: servdernierdossier.serv_nom, servdernierdossier.serv_code
  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
28. 0.103 0.103 ↑ 1.0 139 1
→

Seq Scan on mike_tango quebec (cost=0.000..4.390 rows=139 width=86) (actual time=0.007..0.103 rows=139 loops=1)

  • Output: servdernierdossier.serv_nom, servdernierdossier.serv_code
29. 0.015 0.029 ↑ 12.9 17 1
→

Hash (cost=12.200..12.200 rows=220 width=328) (actual time=0.029..0.029 rows=17 loops=1)

  • Output: tevedernierdossier.teve_libe, tevedernierdossier.teve_code
  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
30. 0.014 0.014 ↑ 12.9 17 1
→

Seq Scan on xray_three_tango bravo_five (cost=0.000..12.200 rows=220 width=328) (actual time=0.006..0.014 rows=17 loops=1)

  • Output: tevedernierdossier.teve_libe, tevedernierdossier.teve_code
31. 0.034 0.090 ↑ 1.0 62 1
→

Hash (cost=1.620..1.620 rows=62 width=46) (actual time=0.090..0.090 rows=62 loops=1)

  • Output: r_e_info.info_libe, r_e_info.info_code
  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
32. 0.056 0.056 ↑ 1.0 62 1
→

Seq Scan on charlie (cost=0.000..1.620 rows=62 width=46) (actual time=0.039..0.056 rows=62 loops=1)

  • Output: r_e_info.info_libe, r_e_info.info_code
33. 0.061 0.116 ↑ 1.0 139 1
→

Hash (cost=4.390..4.390 rows=139 width=86) (actual time=0.116..0.116 rows=139 loops=1)

  • Output: servdernierchoix.serv_nom, servdernierchoix.serv_code
  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
34. 0.055 0.055 ↑ 1.0 139 1
→

Seq Scan on mike_tango delta_xray (cost=0.000..4.390 rows=139 width=86) (actual time=0.006..0.055 rows=139 loops=1)

  • Output: servdernierchoix.serv_nom, servdernierchoix.serv_code
35. 0.009 0.019 ↑ 12.9 17 1
→

Hash (cost=12.200..12.200 rows=220 width=328) (actual time=0.019..0.019 rows=17 loops=1)

  • Output: tevedernierchoix.teve_libe, tevedernierchoix.teve_code
  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
36. 0.010 0.010 ↑ 12.9 17 1
→

Seq Scan on xray_three_tango five_romeo_six (cost=0.000..12.200 rows=220 width=328) (actual time=0.005..0.010 rows=17 loops=1)

  • Output: tevedernierchoix.teve_libe, tevedernierchoix.teve_code
37. 10.758 26.397 ↑ 1.0 23832 1
→

Hash (cost=3081.340..3081.340 rows=23855 width=24) (actual time=26.397..26.397 rows=23832 loops=1)

  • Output: instdoublonlisteattente.choi_code, instdoublonlisteattente.inst_dater, instdoublonlisteattente.inst_heurr
  • Buckets: 4096 Batches: 2 Memory Usage: 563kB
38. 13.455 15.639 ↑ 1.0 23832 1
→

Bitmap Heap Scan on yankee bravo_hotel (cost=525.150..3081.340 rows=23855 width=24) (actual time=2.487..15.639 rows=23832 loops=1)

  • Output: instdoublonlisteattente.choi_code, instdoublonlisteattente.inst_dater, instdoublonlisteattente.inst_heurr
  • Recheck Cond: (bravo_hotel.delta_bravo = 12)
39. 2.184 2.184 ↑ 1.0 23832 1
→

Bitmap Index Scan on hotel_bravo (cost=0.000..519.180 rows=23855 width=0) (actual time=2.184..2.184 rows=23832 loops=1)

  • Index Cond: (bravo_hotel.delta_bravo = 12)
40. 0.002 0.013 ↑ 1.0 1 1
→

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

  • Output: tevelistattentechoix.teve_libe, tevelistattentechoix.teve_code
  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
41. 0.011 0.011 ↑ 1.0 1 1
→

Index Scan using hotel_papa on xray_three_tango xray_three_zulu (cost=0.000..8.270 rows=1 width=328) (actual time=0.010..0.011 rows=1 loops=1)

  • Output: tevelistattentechoix.teve_libe, tevelistattentechoix.teve_code
  • Index Cond: (xray_three_zulu.delta_bravo = 12)
42. 3.145 6.973 ↑ 1.0 8749 1
→

Hash (cost=179.110..179.110 rows=8811 width=9) (actual time=6.973..6.973 rows=8749 loops=1)

  • Output: s_e_efev.efev_depe, s_e_efev.hist_code
  • Buckets: 1024 Batches: 1 Memory Usage: 308kB
43. 3.828 3.828 ↑ 1.0 8811 1
→

Seq Scan on five_oscar (cost=0.000..179.110 rows=8811 width=9) (actual time=0.006..3.828 rows=8811 loops=1)

  • Output: s_e_efev.efev_depe, s_e_efev.hist_code