# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.054 | 496.886 | ↑ 75,000.0 | 24 | 1 |
→
Finalize GroupAggregate (cost=140,181.08..419,828.43 rows=1,800,000 width=76) (actual time=274.777..496.886 rows=24 loops=1)
|
2. | 0.000 | 496.832 | ↑ 15,000.0 | 120 | 1 |
→
Gather Merge (cost=140,181.08..370,328.43 rows=1,800,000 width=76) (actual time=267.811..496.832 rows=120 loops=1)
|
3. | 811.065 | 2,309.905 | ↑ 18,750.0 | 24 | 5 |
→
Partial GroupAggregate (cost=139,181.02..154,931.02 rows=450,000 width=76) (actual time=253.951..461.981 rows=24 loops=5)
|
4. | 1,101.250 | 1,498.840 | ↑ 1.2 | 360,000 | 5 |
→
Sort (cost=139,181.02..140,306.02 rows=450,000 width=90) (actual time=241.263..299.768 rows=360,000 loops=5)
|
5. | 397.590 | 397.590 | ↑ 1.2 | 360,000 | 5 |
→
Parallel Seq Scan on snapshot (cost=0.00..27,711.00 rows=450,000 width=90) (actual time=0.017..79.518 rows=360,000 loops=5) |
Planning time | : | 0.134 ms |
---|---|---|
Execution time | : | 500.241 ms |