# | 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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
Planning time | : | 23.378 ms |
---|