# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 6.115 | 92.128 | ↓ 168.9 | 2,871 | 1 |
→
Sort (cost=223,441.29..223,441.34 rows=17 width=346) (actual time=91.373..92.128 rows=2,871 loops=1)
|
2. |
CTE a |
|||||
3. | 6.380 | 68.399 | ↑ 2.8 | 6,265 | 1 |
→
Nested Loop (cost=48.21..223,049.11 rows=17,415 width=548) (actual time=0.101..68.399 rows=6,265 loops=1) |
4. | 1.590 | 20.579 | ↑ 5.7 | 2,960 | 1 |
→
Nested Loop (cost=47.78..86,374.31 rows=17,004 width=412) (actual time=0.079..20.579 rows=2,960 loops=1) |
5. | 0.049 | 0.049 | ↑ 1.0 | 10 | 1 |
→
Index Scan using jdd_id_ca_idx on jdd i2_ (cost=0.28..35.53 rows=10 width=4) (actual time=0.014..0.049 rows=10 loops=1)
|
6. | 18.360 | 18.940 | ↑ 8.3 | 296 | 10 |
→
Bitmap Heap Scan on vm_requeteur_releves i1_ (cost=47.50..8,609.27 rows=2,461 width=412) (actual time=0.101..1.894 rows=296 loops=10)
|
7. | 0.580 | 0.580 | ↑ 8.3 | 296 | 10 |
→
Bitmap Index Scan on vm_requeteur_releves_id_jdd_idx (cost=0.00..46.88 rows=2,461 width=0) (actual time=0.058..0.058 rows=296 loops=10)
|
8. | 41.440 | 41.440 | ↓ 2.0 | 2 | 2,960 |
→
Index Scan using vm_requeteur_observations_id_releve_idx on vm_requeteur_observations i0_ (cost=0.43..8.03 rows=1 width=136) (actual time=0.007..0.014 rows=2 loops=2,960)
|
9. | 86.013 | 86.013 | ↓ 168.9 | 2,871 | 1 |
→
CTE Scan on a (cost=0.00..391.84 rows=17 width=346) (actual time=13.378..86.013 rows=2,871 loops=1)
|
Total runtime | : | 93.413 ms |
---|