explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7tRX

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 1,682.255 ↓ 7.0 7 1

Nested Loop Left Join (cost=59,081.41..71,154.02 rows=1 width=921) (actual time=1,352.030..1,682.255 rows=7 loops=1)

2. 0.014 1,682.210 ↓ 7.0 7 1

Nested Loop Left Join (cost=59,081.28..71,153.86 rows=1 width=785) (actual time=1,352.008..1,682.210 rows=7 loops=1)

3. 0.000 1,682.161 ↓ 7.0 7 1

Nested Loop Left Join (cost=59,081.14..71,153.71 rows=1 width=689) (actual time=1,351.990..1,682.161 rows=7 loops=1)

4. 30.235 1,695.220 ↓ 7.0 7 1

Gather (cost=59,081.01..71,153.49 rows=1 width=473) (actual time=1,351.967..1,695.220 rows=7 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 20.325 1,664.985 ↓ 2.0 2 3 / 3

Hash Join (cost=58,081.01..70,153.39 rows=1 width=473) (actual time=1,451.489..1,664.985 rows=2 loops=3)

  • Hash Cond: ("int".int_id = vst.vst_intervention_fk)
6. 97.043 1,644.552 ↑ 1.2 128,517 3 / 3

Hash Left Join (cost=58,076.81..69,546.83 rows=160,631 width=457) (actual time=1,199.002..1,644.552 rows=128,517 loops=3)

  • Hash Cond: ((pdl.pdl_id)::text = (dis.dis_pdl_fk)::text)
7. 96.533 1,256.638 ↑ 1.2 128,517 3 / 3

Hash Left Join (cost=42,447.70..53,496.06 rows=160,631 width=451) (actual time=906.161..1,256.638 rows=128,517 loops=3)

  • Hash Cond: (("int".int_pdl_fk)::text = (pdl.pdl_id)::text)
8. 45.125 536.157 ↑ 1.2 128,517 3 / 3

Hash Left Join (cost=16,085.06..26,711.76 rows=160,631 width=451) (actual time=280.025..536.157 rows=128,517 loops=3)

  • Hash Cond: (cpt.cpt_situation_fk = sic.sic_id)
9. 47.917 491.011 ↑ 1.2 128,517 3 / 3

Hash Left Join (cost=16,083.90..26,033.66 rows=160,631 width=375) (actual time=279.991..491.011 rows=128,517 loops=3)

  • Hash Cond: (cpt.cpt_type_fk = tco.tco_id)
10. 92.306 442.881 ↑ 1.2 128,517 3 / 3

Hash Left Join (cost=16,071.59..25,594.19 rows=160,631 width=364) (actual time=279.752..442.881 rows=128,517 loops=3)

  • Hash Cond: (("int".int_pdl_fk)::bpchar = cpt.cpt_pdl_fk)
11. 43.298 73.667 ↑ 1.2 128,517 3 / 3

Hash Left Join (cost=14.71..9,115.66 rows=160,631 width=345) (actual time=0.302..73.667 rows=128,517 loops=3)

  • Hash Cond: ("int".int_id = cri.cri_intervention_fk)
12. 30.094 30.094 ↑ 1.2 128,515 3 / 3

Parallel Seq Scan on t_intervention "int" (cost=0.00..8,498.31 rows=160,631 width=19) (actual time=0.014..30.094 rows=128,515 loops=3)

13. 0.035 0.275 ↑ 1.2 57 3 / 3

Hash (cost=13.89..13.89 rows=66 width=330) (actual time=0.275..0.275 rows=57 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
14. 0.083 0.240 ↑ 1.2 57 3 / 3

Hash Left Join (cost=1.04..13.89 rows=66 width=330) (actual time=0.088..0.240 rows=57 loops=3)

  • Hash Cond: (cri.cri_type_fk = tci.tci_id)
15. 0.133 0.133 ↑ 1.2 57 3 / 3

Seq Scan on t_cr_intervention cri (cost=0.00..12.66 rows=66 width=274) (actual time=0.023..0.133 rows=57 loops=3)

16. 0.004 0.024 ↑ 1.0 2 3 / 3

Hash (cost=1.02..1.02 rows=2 width=60) (actual time=0.024..0.024 rows=2 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 0.020 0.020 ↑ 1.0 2 3 / 3

Seq Scan on t_ref_type_cr_intervention tci (cost=0.00..1.02 rows=2 width=60) (actual time=0.018..0.020 rows=2 loops=3)

18. 145.096 276.908 ↓ 1.0 385,545 3 / 3

Hash (cost=11,238.61..11,238.61 rows=385,461 width=34) (actual time=276.908..276.908 rows=385,545 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 24,768kB
19. 131.812 131.812 ↓ 1.0 385,545 3 / 3

Seq Scan on t_compteur cpt (cost=0.00..11,238.61 rows=385,461 width=34) (actual time=0.028..131.812 rows=385,545 loops=3)

20. 0.081 0.213 ↑ 1.0 325 3 / 3

Hash (cost=8.25..8.25 rows=325 width=15) (actual time=0.213..0.213 rows=325 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
21. 0.132 0.132 ↑ 1.0 325 3 / 3

Seq Scan on t_ref_type_compteur tco (cost=0.00..8.25 rows=325 width=15) (actual time=0.040..0.132 rows=325 loops=3)

22. 0.008 0.021 ↑ 1.0 7 3 / 3

Hash (cost=1.07..1.07 rows=7 width=80) (actual time=0.021..0.021 rows=7 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
23. 0.013 0.013 ↑ 1.0 7 3 / 3

Seq Scan on t_ref_situation_compteur sic (cost=0.00..1.07 rows=7 width=80) (actual time=0.011..0.013 rows=7 loops=3)

24. 140.366 623.948 ↑ 1.0 385,545 3 / 3

Hash (cost=21,543.33..21,543.33 rows=385,545 width=15) (actual time=623.948..623.948 rows=385,545 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 21,792kB
25. 483.582 483.582 ↑ 1.0 385,545 3 / 3

Index Only Scan using t_pdl_pk on t_pdl pdl (cost=0.42..21,543.33 rows=385,545 width=15) (actual time=0.064..483.582 rows=385,545 loops=3)

  • Heap Fetches: 318,218
26. 149.890 290.871 ↓ 1.0 385,545 3 / 3

Hash (cost=10,810.16..10,810.16 rows=385,516 width=36) (actual time=290.871..290.871 rows=385,545 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 26,513kB
27. 140.981 140.981 ↓ 1.0 385,545 3 / 3

Seq Scan on t_disjoncteur dis (cost=0.00..10,810.16 rows=385,516 width=36) (actual time=0.039..140.981 rows=385,545 loops=3)

28. 0.010 0.108 ↓ 6.0 6 3 / 3

Hash (cost=4.18..4.18 rows=1 width=20) (actual time=0.107..0.108 rows=6 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
29. 0.010 0.098 ↓ 6.0 6 3 / 3

Nested Loop (cost=0.14..4.18 rows=1 width=20) (actual time=0.085..0.098 rows=6 loops=3)

30. 0.043 0.043 ↑ 1.0 1 3 / 3

Seq Scan on t_visiteur vis (cost=0.00..1.39 rows=1 width=4) (actual time=0.041..0.043 rows=1 loops=3)

  • Filter: ((vis_nni)::text = 'PYA704HKV'::text)
  • Rows Removed by Filter: 37
31. 0.045 0.045 ↓ 6.0 6 3 / 3

Index Scan using idx_vst_visiteur_fk on t_visite vst (cost=0.14..2.78 rows=1 width=24) (actual time=0.037..0.045 rows=6 loops=3)

  • Index Cond: (vst_visiteur_fk = vis.vis_id)
  • Filter: ((vst_date_debut_creneau >= '2020-06-20 00:00:00'::timestamp without time zone) AND (vst_date_fin_creneau < '2020-06-27 00:00:00'::timestamp without time zone) AND (vst_statut_visite_fk = 2))
  • Rows Removed by Filter: 10
32. 0.021 0.021 ↓ 0.0 0 7

Index Scan using t_ref_motif_cr_ko_pk on t_ref_motif_cr_ko tyko (cost=0.14..0.21 rows=1 width=220) (actual time=0.003..0.003 rows=0 loops=7)

  • Index Cond: (tyko_id = cri.cri_motif_ko_fk)
33. 0.035 0.035 ↑ 1.0 1 7

Index Scan using uidx_nb_fils_compteur on t_ref_nb_fils_compteur nfc (cost=0.14..0.15 rows=1 width=100) (actual time=0.005..0.005 rows=1 loops=7)

  • Index Cond: (nfc_id = cpt.cpt_nb_fils_fk)
34. 0.035 0.035 ↑ 1.0 1 7

Index Scan using t_ref_calibre_disjoncteur_pk on t_ref_calibre_disjoncteur cad (cost=0.14..0.15 rows=1 width=140) (actual time=0.005..0.005 rows=1 loops=7)

  • Index Cond: (cad_id = dis.dis_calibre_fk)
Planning time : 5.645 ms
Execution time : 1,696.070 ms