# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 1,605.463 | 84,105.005 | ↓ 342.5 | 731,510 | 1 |
→
Nested Loop (cost=292.39..48,397.69 rows=2,136 width=8) (actual time=568.605..84,105.005 rows=731,510 loops=1) |
2. | 19,114.411 | 19,656.774 | ↓ 525.3 | 2,166,992 | 1 |
→
Bitmap Heap Scan on vm_requeteur_observations o (cost=291.97..14,582.51 rows=4,125 width=8) (actual time=554.146..19,656.774 rows=2,166,992 loops=1)
|
3. | 542.363 | 542.363 | ↓ 525.3 | 2,166,992 | 1 |
→
Bitmap Index Scan on vm_requeteur_observations_groupes_fonctionnels_idx (cost=0.00..290.93 rows=4,125 width=0) (actual time=542.363..542.363 rows=2,166,992 loops=1)
|
4. | 62,842.768 | 62,842.768 | ↓ 0.0 | 0 | 2,166,992 |
→
Index Only Scan using vm_requeteur_releves_rid_idx on vm_requeteur_releves r (cost=0.43..8.19 rows=1 width=4) (actual time=0.028..0.029 rows=0 loops=2,166,992)
|
Total runtime | : | 84,275.618 ms |
---|