# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 35.183 | 279,083.006 | ↓ 168.9 | 2,871 | 1 |
→
Sort (cost=50,309.85..50,309.89 rows=17 width=513) (actual time=279,081.515..279,083.006 rows=2,871 loops=1)
|
2. | 3,046.691 | 279,047.823 | ↓ 168.9 | 2,871 | 1 |
→
Nested Loop (cost=1,848.67..50,309.50 rows=17 width=513) (actual time=2,687.141..279,047.823 rows=2,871 loops=1)
|
3. | 4,291.546 | 273,806.602 | ↓ 342.6 | 731,510 | 1 |
→
Nested Loop (cost=1,848.39..49,953.69 rows=2,135 width=513) (actual time=714.657..273,806.602 rows=731,510 loops=1) |
4. | 21,791.920 | 22,477.968 | ↓ 525.3 | 2,166,992 | 1 |
→
Bitmap Heap Scan on vm_requeteur_observations i0_ (cost=1,847.97..16,138.51 rows=4,125 width=101) (actual time=689.233..22,477.968 rows=2,166,992 loops=1)
|
5. | 686.048 | 686.048 | ↓ 525.3 | 2,166,992 | 1 |
→
Bitmap Index Scan on vm_requeteur_observations_groupes_fonctionnels_idx (cost=0.00..1,846.93 rows=4,125 width=0) (actual time=686.048..686.048 rows=2,166,992 loops=1)
|
6. | 247,037.088 | 247,037.088 | ↓ 0.0 | 0 | 2,166,992 |
→
Index Scan using vm_requeteur_releves_rid_idx on vm_requeteur_releves i1_ (cost=0.43..8.19 rows=1 width=412) (actual time=0.114..0.114 rows=0 loops=2,166,992)
|
7. | 2,194.496 | 2,194.530 | ↑ 1.0 | 10 | 731,510 |
→
Materialize (cost=0.28..35.58 rows=10 width=4) (actual time=0.000..0.003 rows=10 loops=731,510) |
8. | 0.034 | 0.034 | ↑ 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.016..0.034 rows=10 loops=1)
|
Total runtime | : | 279,084.366 ms |
---|