# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.236 | 18.707 | ↑ 7.2 | 117 | 1 |
→
Sort (cost=1,519.55..1,521.66 rows=844 width=21) (actual time=18.690..18.707 rows=117 loops=1)
|
2. | 1.520 | 18.471 | ↑ 7.2 | 117 | 1 |
→
HashAggregate (cost=1,470.09..1,478.53 rows=844 width=21) (actual time=18.441..18.471 rows=117 loops=1)
|
3. | 3.348 | 16.951 | ↑ 1.1 | 4,018 | 1 |
→
Hash Join (cost=796.39..1,435.89 rows=4,559 width=13) (actual time=10.187..16.951 rows=4,018 loops=1)
|
4. | 3.602 | 3.602 | ↑ 1.0 | 15,254 | 1 |
→
Seq Scan on productos prod (cost=0.00..536.23 rows=15,383 width=4) (actual time=0.017..3.602 rows=15,254 loops=1) |
5. | 1.318 | 10.001 | ↑ 1.1 | 4,018 | 1 |
→
Hash (cost=739.40..739.40 rows=4,559 width=17) (actual time=10.001..10.001 rows=4,018 loops=1)
|
6. | 8.683 | 8.683 | ↑ 1.1 | 4,018 | 1 |
→
Seq Scan on v_productos_es p (cost=0.00..739.40 rows=4,559 width=17) (actual time=0.024..8.683 rows=4,018 loops=1)
|