# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 96.622 | 3,213.053 | ↓ 2.0 | 2 | 1 |
→
Gather (cost=269,314.70..390,148.13 rows=1 width=16) (actual time=3,145.344..3,213.053 rows=2 loops=1)
|
2. | 263.406 | 3,116.431 | ↑ 1.0 | 1 | 3 |
→
Parallel Hash Join (cost=268,314.70..389,148.03 rows=1 width=16) (actual time=3,056.417..3,116.431 rows=1 loops=3)
|
3. | 362.988 | 2,072.755 | ↑ 346,270.0 | 1 | 3 |
→
Hash Join (cost=130,050.77..217,409.26 rows=346,270 width=78) (actual time=1,961.336..2,072.755 rows=1 loops=3)
|
4. | 116.513 | 116.513 | ↑ 1.2 | 1,231,385 | 3 |
→
Parallel Seq Scan on trip_fare_25 (cost=0.00..79,085.12 rows=1,539,212 width=82) (actual time=0.061..116.513 rows=1,231,385 loops=3) |
5. | 0.005 | 1,593.254 | ↑ 45,623.0 | 1 | 3 |
→
Hash (cost=129,366.43..129,366.43 rows=45,623 width=12) (actual time=1,593.254..1,593.254 rows=1 loops=3)
|
6. | 525.611 | 1,593.249 | ↑ 45,623.0 | 1 | 3 |
→
HashAggregate (cost=128,339.91..128,910.20 rows=45,623 width=12) (actual time=1,593.049..1,593.249 rows=1 loops=3)
|
7. | 1,067.638 | 1,067.638 | ↓ 1.0 | 3,694,154 | 3 |
→
Seq Scan on trip_fare_25 trip_fare_25_1 (cost=0.00..109,869.36 rows=3,694,109 width=12) (actual time=0.045..1,067.638 rows=3,694,154 loops=3) |
8. | 492.213 | 780.270 | ↑ 1.2 | 1,231,385 | 3 |
→
Parallel Hash (cost=86,434.31..86,434.31 rows=1,539,231 width=86) (actual time=780.270..780.270 rows=1,231,385 loops=3)
|
9. | 288.057 | 288.057 | ↑ 1.2 | 1,231,385 | 3 |
→
Parallel Seq Scan on trip_data_25 (cost=0.00..86,434.31 rows=1,539,231 width=86) (actual time=19.202..288.057 rows=1,231,385 loops=3) |
Planning time | : | 1.580 ms |
---|---|---|
Execution time | : | 3,219.106 ms |