explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q7E1

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 38.968 3,844.477 ↓ 66.7 13,345 1

GroupAggregate (cost=336,819.15..459,656.82 rows=200 width=49) (actual time=2,899.104..3,844.477 rows=13,345 loops=1)

  • Group Key: trip_fare_25.medallion
2. 92.702 3,805.509 ↑ 1.8 200,257 1

Finalize GroupAggregate (cost=336,819.15..452,266.10 rows=369,411 width=45) (actual time=2,898.984..3,805.509 rows=200,257 loops=1)

  • Group Key: trip_fare_25.medallion, (date_trunc('day'::text, trip_fare_25.pickup_datetime))
3. 0.000 3,712.807 ↑ 1.3 560,224 1

Gather Merge (cost=336,819.15..442,107.30 rows=738,822 width=45) (actual time=2,898.972..3,712.807 rows=560,224 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 597.483 10,648.713 ↑ 2.0 186,741 3

Partial GroupAggregate (cost=335,819.13..355,828.88 rows=369,411 width=45) (actual time=2,893.062..3,549.571 rows=186,741 loops=3)

  • Group Key: trip_fare_25.medallion, (date_trunc('day'::text, trip_fare_25.pickup_datetime))
5. 8,969.406 10,051.230 ↑ 1.2 1,231,385 3

Sort (cost=335,819.13..339,667.16 rows=1,539,212 width=45) (actual time=2,893.046..3,350.410 rows=1,231,385 loops=3)

  • Sort Key: trip_fare_25.medallion, (date_trunc('day'::text, trip_fare_25.pickup_datetime))
  • Sort Method: external merge Disk: 75184kB
  • Worker 0: Sort Method: external merge Disk: 74536kB
  • Worker 1: Sort Method: external merge Disk: 74536kB
6. 1,081.824 1,081.824 ↑ 1.2 1,231,385 3

Parallel Seq Scan on trip_fare_25 (cost=0.00..82,933.15 rows=1,539,212 width=45) (actual time=0.484..360.608 rows=1,231,385 loops=3)

Planning time : 0.286 ms
Execution time : 3,866.547 ms