explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gc5F

Settings
# exclusive inclusive rows x rows loops node
1. 26.038 220,405.675 ↑ 1,267.5 462 1

Merge Left Join (cost=2,985.96..43,803,100,830.24 rows=585,576 width=632) (actual time=1,107.072..220,405.675 rows=462 loops=1)

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

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

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

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

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

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

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

Hash Join (cost=325.15..714.89 rows=391 width=290) (actual time=6.092..21.858 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.220 21.308 ↓ 1.9 462 1

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

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

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

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

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

9. 0.307 5.781 ↑ 1.0 462 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 88kB
10. 0.337 5.474 ↑ 1.0 462 1

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

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

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

12. 0.670 5.051 ↓ 1.0 2,241 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 304kB
13. 4.381 4.381 ↓ 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.005..4.381 rows=2,241 loops=1)

14. 0.003 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.006 0.006 ↑ 1.0 17 1

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

16. 0.018 0.218 ↓ 1.2 69 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
17. 0.025 0.200 ↓ 1.2 69 1

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

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

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

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

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

20. 0.006 0.039 ↓ 1.0 40 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
21. 0.033 0.033 ↓ 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.033 rows=40 loops=1)

22. 0.019 0.056 ↑ 1.5 24 1

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

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

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

24. 0.598 0.699 ↑ 2.3 458 1

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

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

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

26. 0.497 0.625 ↑ 1.0 462 1

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

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

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

28. 310.230 314.356 ↓ 1.5 33,883 1

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

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

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

30.          

SubPlan (for Merge Left Join)

31. 3.696 877.338 ↑ 1.0 1 462

Aggregate (cost=318.08..318.09 rows=1 width=32) (actual time=1.899..1.899 rows=1 loops=462)

32. 873.642 873.642 ↑ 73.0 1 462

Seq Scan on coutaatravprir_10 (cost=0.00..317.90 rows=73 width=32) (actual time=1.175..1.891 rows=1 loops=462)

  • Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)
  • Rows Removed by Filter: 21310
33. 2.772 763.224 ↑ 1.0 1 462

Aggregate (cost=275.99..276.00 rows=1 width=32) (actual time=1.652..1.652 rows=1 loops=462)

34. 760.452 760.452 ↑ 63.0 1 462

Seq Scan on coutaatravprir_20 (cost=0.00..275.83 rows=63 width=32) (actual time=1.086..1.646 rows=1 loops=462)

  • Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)
  • Rows Removed by Filter: 18391
35. 2.310 507.738 ↑ 1.0 1 462

Aggregate (cost=184.77..184.78 rows=1 width=32) (actual time=1.099..1.099 rows=1 loops=462)

36. 505.428 505.428 ↓ 0.0 0 462

Seq Scan on coutaatravprir_30 (cost=0.00..184.66 rows=42 width=32) (actual time=0.822..1.094 rows=0 loops=462)

  • Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)
  • Rows Removed by Filter: 12271
37. 2.772 1,110.186 ↑ 1.0 1 462

Aggregate (cost=402.28..402.29 rows=1 width=32) (actual time=2.403..2.403 rows=1 loops=462)

38. 1,107.414 1,107.414 ↑ 92.0 1 462

Seq Scan on coutaatravprir_40 (cost=0.00..402.05 rows=92 width=32) (actual time=1.309..2.397 rows=1 loops=462)

  • Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)
  • Rows Removed by Filter: 26971
39. 2.772 889.350 ↑ 1.0 1 462

Aggregate (cost=322.76..322.77 rows=1 width=32) (actual time=1.925..1.925 rows=1 loops=462)

40. 886.578 886.578 ↑ 74.0 1 462

Seq Scan on coutaatravresp_10 (cost=0.00..322.58 rows=74 width=32) (actual time=1.190..1.919 rows=1 loops=462)

  • Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)
  • Rows Removed by Filter: 21638
41. 25.872 72,084.012 ↑ 1.0 1 462

Aggregate (cost=24,433.15..24,433.16 rows=1 width=32) (actual time=156.026..156.026 rows=1 loops=462)

42. 72,058.140 72,058.140 ↑ 54.5 69 462

Seq Scan on coutaatravprir (cost=0.00..24,423.75 rows=3,758 width=22) (actual time=18.311..155.970 rows=69 loops=462)

  • Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)
  • Rows Removed by Filter: 1659107
43. 26.796 71,833.146 ↑ 1.0 1 462

Aggregate (cost=24,433.15..24,433.16 rows=1 width=32) (actual time=155.483..155.483 rows=1 loops=462)

44. 71,806.350 71,806.350 ↑ 54.5 69 462

Seq Scan on coutaatravprir coutaatravprir_1 (cost=0.00..24,423.75 rows=3,758 width=22) (actual time=18.177..155.425 rows=69 loops=462)

  • Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)
  • Rows Removed by Filter: 1659107
45. 27.258 71,972.670 ↑ 1.0 1 462

Aggregate (cost=24,433.15..24,433.16 rows=1 width=32) (actual time=155.785..155.785 rows=1 loops=462)

46. 71,945.412 71,945.412 ↑ 54.5 69 462

Seq Scan on coutaatravprir coutaatravprir_2 (cost=0.00..24,423.75 rows=3,758 width=22) (actual time=18.306..155.726 rows=69 loops=462)

  • Filter: (sm001000_pi2_programmation_travauxid = pt.sm001000_pi2_programmation_travauxid)
  • Rows Removed by Filter: 1659107
Planning time : 23.378 ms