# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 15.617 | 1,748.833 | ↑ 1.0 | 30 | 1 |
→
Limit (cost=85,807.23..85,808.73 rows=30 width=28) (actual time=1,733.146..1,748.833 rows=30 loops=1) |
2. | 0.065 | 1,733.216 | ↑ 65.6 | 30 | 1 |
→
Finalize GroupAggregate (cost=85,807.23..85,885.99 rows=1,969 width=28) (actual time=1,733.144..1,733.216 rows=30 loops=1)
|
3. | 0.000 | 1,733.151 | ↑ 48.8 | 121 | 1 |
→
Sort (cost=85,807.23..85,822.00 rows=5,907 width=28) (actual time=1,733.132..1,733.151 rows=121 loops=1)
|
4. | 51.632 | 1,745.777 | ↓ 1.1 | 6,743 | 1 |
→
Gather (cost=84,826.82..85,437.21 rows=5,907 width=28) (actual time=1,693.514..1,745.777 rows=6,743 loops=1)
|
5. | 115.126 | 1,694.145 | ↑ 1.2 | 1,686 | 4 |
→
Partial HashAggregate (cost=83,826.82..83,846.51 rows=1,969 width=28) (actual time=1,693.596..1,694.145 rows=1,686 loops=4)
|
6. | 525.174 | 1,579.019 | ↑ 1.3 | 393,265 | 4 |
→
Hash Left Join (cost=51,491.01..80,021.18 rows=507,419 width=20) (actual time=959.886..1,579.019 rows=393,265 loops=4)
|
7. | 96.264 | 96.264 | ↑ 1.3 | 393,265 | 4 |
→
Parallel Seq Scan on import_timer (cost=0.00..15,097.19 rows=507,419 width=20) (actual time=0.021..96.264 rows=393,265 loops=4) |
8. | 561.360 | 957.581 | ↓ 1.0 | 1,581,979 | 4 |
→
Hash (cost=25,648.56..25,648.56 rows=1,575,156 width=8) (actual time=957.581..957.581 rows=1,581,979 loops=4)
|
9. | 396.221 | 396.221 | ↓ 1.0 | 1,581,979 | 4 |
→
Seq Scan on imports (cost=0.00..25,648.56 rows=1,575,156 width=8) (actual time=0.028..396.221 rows=1,581,979 loops=4) |