# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.057 | 24.893 | ↓ 462.0 | 462 | 1 |
→
Subquery Scan on journalaction (cost=646.58..646.62 rows=1 width=116) (actual time=24.559..24.893 rows=462 loops=1)
|
2. | 0.259 | 24.836 | ↓ 477.0 | 477 | 1 |
→
WindowAgg (cost=646.58..646.61 rows=1 width=124) (actual time=24.558..24.836 rows=477 loops=1) |
3. | 0.310 | 24.577 | ↓ 477.0 | 477 | 1 |
→
Sort (cost=646.58..646.59 rows=1 width=116) (actual time=24.551..24.577 rows=477 loops=1)
|
4. | 4.793 | 24.267 | ↓ 477.0 | 477 | 1 |
→
Nested Loop (cost=142.93..646.57 rows=1 width=116) (actual time=0.959..24.267 rows=477 loops=1)
|
5. | 0.578 | 7.447 | ↓ 40.1 | 4,009 | 1 |
→
Nested Loop (cost=142.51..584.23 rows=100 width=132) (actual time=0.930..7.447 rows=4,009 loops=1) |
6. | 0.152 | 1.109 | ↓ 40.0 | 480 | 1 |
→
Merge Join (cost=142.09..152.94 rows=12 width=132) (actual time=0.911..1.109 rows=480 loops=1)
|
7. | 0.018 | 0.673 | ↑ 29.7 | 32 | 1 |
→
Sort (cost=104.66..107.03 rows=949 width=64) (actual time=0.670..0.673 rows=32 loops=1)
|
8. | 0.019 | 0.655 | ↑ 28.8 | 33 | 1 |
→
Hash Join (cost=5.09..57.73 rows=949 width=64) (actual time=0.644..0.655 rows=33 loops=1)
|
9. | 0.582 | 0.582 | ↑ 61.8 | 33 | 1 |
→
Seq Scan on statut_nature sn (cost=0.00..30.40 rows=2,040 width=12) (actual time=0.580..0.582 rows=33 loops=1) |
10. | 0.025 | 0.054 | ↑ 1.0 | 93 | 1 |
→
Hash (cost=3.93..3.93 rows=93 width=56) (actual time=0.054..0.054 rows=93 loops=1)
|
11. | 0.029 | 0.029 | ↑ 1.0 | 93 | 1 |
→
Seq Scan on sm001000_pi9_nature_evenement_affairebase nea (cost=0.00..3.93 rows=93 width=56) (actual time=0.006..0.029 rows=93 loops=1) |
12. | 0.175 | 0.284 | ↑ 1.0 | 480 | 1 |
→
Sort (cost=37.42..38.63 rows=484 width=80) (actual time=0.236..0.284 rows=480 loops=1)
|
13. | 0.109 | 0.109 | ↑ 1.0 | 462 | 1 |
→
Seq Scan on progtravvers pt (cost=0.00..15.84 rows=484 width=80) (actual time=0.005..0.109 rows=462 loops=1) |
14. | 5.760 | 5.760 | ↑ 1.1 | 8 | 480 |
→
Index Scan using ix_pi2_prog_trav00000 on sm001000_pi8_etape_dossierbase ed (cost=0.42..35.85 rows=9 width=32) (actual time=0.003..0.012 rows=8 loops=480)
|
15. | 12.027 | 12.027 | ↑ 2.0 | 1 | 4,009 |
→
Index Scan using "INDEX_sm001000_pi8_etape_dossierid" on sm001000_pi8_action_dossierbase ad (cost=0.42..0.60 rows=2 width=48) (actual time=0.003..0.003 rows=1 loops=4,009)
|
Planning time | : | 2.415 ms |
---|