# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 4.511 | 264.749 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=55.62..55.63 rows=1 width=4) (actual time=264.749..264.749 rows=1 loops=1) |
2. | 48.428 | 260.238 | ↓ 3,239.1 | 22,674 | 1 |
→
Nested Loop (cost=1.12..55.60 rows=7 width=4) (actual time=0.030..260.238 rows=22,674 loops=1) |
3. | 46.928 | 189.136 | ↓ 3,239.1 | 22,674 | 1 |
→
Nested Loop (cost=0.97..54.00 rows=7 width=37) (actual time=0.024..189.136 rows=22,674 loops=1) |
4. | 41.029 | 119.534 | ↓ 3,239.1 | 22,674 | 1 |
→
Nested Loop (cost=0.83..52.83 rows=7 width=37) (actual time=0.020..119.534 rows=22,674 loops=1) |
5. | 7.018 | 7.018 | ↓ 1,588.6 | 23,829 | 1 |
→
Index Scan using x_dm5_caracteristiquearticlestock_00 on dm5_caracteristiquearticlestock caracteris1_ (cost=0.42..16.12 rows=15 width=33) (actual time=0.012..7.018 rows=23,829 loops=1)
|
6. | 71.487 | 71.487 | ↑ 1.0 | 1 | 23,829 |
→
Index Scan using x_dm5_quantitestock_00 on dm5_quantitestock quantitest0_ (cost=0.42..2.44 rows=1 width=70) (actual time=0.002..0.003 rows=1 loops=23,829)
|
7. | 22.674 | 22.674 | ↑ 1.0 | 1 | 22,674 |
→
Index Scan using dm5_caracteristiquelieustock_pkey on dm5_caracteristiquelieustock caracteris2_ (cost=0.14..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=1 loops=22,674)
|
8. | 22.674 | 22.674 | ↑ 1.0 | 1 | 22,674 |
→
Index Scan using dm5_lieustockage_pkey on dm5_lieustockage lieustocka3_ (cost=0.14..0.22 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=22,674)
|