explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U9nsM

Settings
# exclusive inclusive rows x rows loops node
1. 2.567 23.834 ↑ 1,267.5 462 1

"Merge Left Join (cost=2,985.96..20,680.02 rows=585,576 width=376) (actual time=19.297..23.834 rows=462 loops=1)

  • Merge Cond: (pt.sm001000_pi2_programmation_travauxid = tp.sm001000_pi2_programmation_travauxid)
2. 0.182 5.860 ↑ 10.9 462 1

Merge Left Join (cost=842.44..956.32 rows=5,021 width=330) (actual time=5.305..5.860 rows=462 loops=1)

  • Merge Cond: (pt.sm001000_pi2_programmation_travauxid = ja.sm001000_pi2_programmation_travauxid)
3. 0.290 5.539 ↑ 4.5 462 1

Merge Left Join (cost=806.26..839.60 rows=2,092 width=322) (actual time=5.188..5.539 rows=462 loops=1)

  • Merge Cond: (pt.sm001000_pi2_programmation_travauxid = car.sm001000_pi2_programmation_travauxid)
4. 0.356 5.047 ↓ 1.2 462 1

Sort (cost=731.73..732.70 rows=391 width=290) (actual time=5.012..5.047 rows=462 loops=1)

  • Sort Key: pt.sm001000_pi2_programmation_travauxid
  • Sort Method: quicksort Memory: 238kB
5. 0.172 4.691 ↓ 1.2 462 1

Hash Join (cost=325.15..714.89 rows=391 width=290) (actual time=2.941..4.691 rows=462 loops=1)

  • Hash Cond: (dt.sm001000_pi1_programmeid = p.sm001000_pi1_programmeid)
  • Join Filter: (((dt.sm001000_pi1_voletid = v.sm001000_pi1_voletid) OR (dt.sm001000_pi1_voletid IS NULL)) AND ((dt.sm001000_pi1_sous_voletid = sv.sm001000_pi1_sous_voletid) OR (dt.sm001000_pi1_sous_voletid IS NULL)))
6. 0.110 4.327 ↓ 1.9 462 1

Hash Join (cost=307.79..690.45 rows=239 width=223) (actual time=2.743..4.327 rows=462 loops=1)

  • Hash Cond: (o.territoryid = t.territoryid)
7. 0.708 4.208 ↑ 1.0 462 1

Hash Join (cost=306.40..687.64 rows=484 width=221) (actual time=2.730..4.208 rows=462 loops=1)

  • Hash Cond: (o.accountid = dt.sm001000_pi_ni_orgn_reqr)
8. 0.809 0.809 ↑ 1.0 3,956 1

Seq Scan on accountbase o (cost=0.00..361.56 rows=3,956 width=55) (actual time=0.003..0.809 rows=3,956 loops=1)

9. 0.144 2.691 ↑ 1.0 462 1

Hash (cost=300.35..300.35 rows=484 width=182) (actual time=2.691..2.691 rows=462 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 88kB
10. 0.196 2.547 ↑ 1.0 462 1

Hash Join (cost=283.24..300.35 rows=484 width=182) (actual time=2.317..2.547 rows=462 loops=1)

  • Hash Cond: (pt.sm001000_pi2_dossier_transfertid = dt.sm001000_pi2_dossier_transfertid)
11. 0.046 0.046 ↑ 1.0 462 1

Seq Scan on progtravvers pt (cost=0.00..15.84 rows=484 width=100) (actual time=0.004..0.046 rows=462 loops=1)

12. 0.501 2.305 ↓ 1.0 2,241 1

Hash (cost=255.33..255.33 rows=2,233 width=114) (actual time=2.305..2.305 rows=2,241 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 304kB
13. 1.804 1.804 ↓ 1.0 2,241 1

Seq Scan on sm001000_pi2_dossier_transfertbase dt (cost=0.00..255.33 rows=2,233 width=114) (actual time=0.004..1.804 rows=2,241 loops=1)

14. 0.004 0.009 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=34) (actual time=0.009..0.009 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
15. 0.005 0.005 ↑ 1.0 17 1

Seq Scan on territorybase t (cost=0.00..1.17 rows=17 width=34) (actual time=0.003..0.005 rows=17 loops=1)

16. 0.017 0.192 ↓ 1.2 69 1

Hash (cost=16.63..16.63 rows=59 width=115) (actual time=0.192..0.192 rows=69 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
17. 0.024 0.175 ↓ 1.2 69 1

Hash Right Join (cost=7.69..16.63 rows=59 width=115) (actual time=0.092..0.175 rows=69 loops=1)

  • Hash Cond: (v.sm001000_pi1_programmeid = p.sm001000_pi1_programmeid)
18. 0.056 0.111 ↓ 1.1 66 1

Hash Right Join (cost=3.88..12.64 rows=59 width=54) (actual time=0.049..0.111 rows=66 loops=1)

  • Hash Cond: (sv.sm001000_pi1_voletid = v.sm001000_pi1_voletid)
19. 0.017 0.017 ↑ 1.1 52 1

Seq Scan on sm001000_pi1_sous_voletbase sv (cost=0.00..8.59 rows=59 width=35) (actual time=0.004..0.017 rows=52 loops=1)

20. 0.007 0.038 ↓ 1.0 40 1

Hash (cost=3.39..3.39 rows=39 width=35) (actual time=0.038..0.038 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
21. 0.031 0.031 ↓ 1.0 40 1

Seq Scan on sm001000_pi1_voletbase v (cost=0.00..3.39 rows=39 width=35) (actual time=0.004..0.031 rows=40 loops=1)

22. 0.007 0.040 ↑ 1.5 24 1

Hash (cost=3.36..3.36 rows=36 width=77) (actual time=0.040..0.040 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
23. 0.033 0.033 ↑ 1.5 24 1

Seq Scan on sm001000_pi1_programmebase p (cost=0.00..3.36 rows=36 width=77) (actual time=0.008..0.033 rows=24 loops=1)

24. 0.147 0.202 ↑ 2.3 458 1

Sort (cost=74.54..77.21 rows=1,070 width=48) (actual time=0.173..0.202 rows=458 loops=1)

  • Sort Key: car.sm001000_pi2_programmation_travauxid
  • Sort Method: quicksort Memory: 60kB
25. 0.055 0.055 ↑ 2.3 458 1

Seq Scan on coutsaareal car (cost=0.00..20.70 rows=1,070 width=48) (actual time=0.007..0.055 rows=458 loops=1)

26. 0.081 0.139 ↑ 1.0 462 1

Sort (cost=36.18..37.38 rows=480 width=24) (actual time=0.116..0.139 rows=462 loops=1)

  • Sort Key: ja.sm001000_pi2_programmation_travauxid
  • Sort Method: quicksort Memory: 61kB
27. 0.058 0.058 ↑ 1.0 462 1

Seq Scan on jouractn ja (cost=0.00..14.80 rows=480 width=24) (actual time=0.003..0.058 rows=462 loops=1)

28. 11.717 15.407 ↓ 1.5 33,883 1

Sort (cost=2,143.52..2,201.84 rows=23,326 width=48) (actual time=13.979..15.407 rows=33,883 loops=1)

  • Sort Key: tp.sm001000_pi2_programmation_travauxid
  • Sort Method: quicksort Memory: 3605kB
29. 3.690 3.690 ↓ 1.5 34,044 1

Seq Scan on travprir tp (cost=0.00..451.26 rows=23,326 width=48) (actual time=0.005..3.690 rows=34,044 loops=1)

Planning time : 4.065 ms