explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Izx

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 8,419.902 ↑ 51,735.3 7 1

Finalize GroupAggregate (cost=322,920.53..403,417.10 rows=362,147 width=40) (actual time=8,356.818..8,419.902 rows=7 loops=1)

  • Group Key: (date_trunc('day'::text, pickup_datetime))
2. 0.000 8,454.323 ↑ 26,640.6 21 1

Gather Merge (cost=322,920.53..393,789.01 rows=559,452 width=40) (actual time=8,336.237..8,454.323 rows=21 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 170.943 25,081.233 ↑ 39,960.9 7 3

Partial GroupAggregate (cost=321,920.51..328,214.34 rows=279,726 width=40) (actual time=8,286.067..8,360.411 rows=7 loops=3)

  • Group Key: (date_trunc('day'::text, pickup_datetime))
4. 485.184 24,910.290 ↑ 1.2 237,676 3

Sort (cost=321,920.51..322,619.82 rows=279,726 width=13) (actual time=8,268.937..8,303.430 rows=237,676 loops=3)

  • Sort Key: (date_trunc('day'::text, pickup_datetime))
  • Sort Method: external merge Disk: 5904kB
  • Worker 0: Sort Method: external merge Disk: 5432kB
  • Worker 1: Sort Method: external merge Disk: 5416kB
5. 24,425.106 24,425.106 ↑ 1.2 237,676 3

Parallel Seq Scan on rides (cost=0.00..291,833.18 rows=279,726 width=13) (actual time=0.244..8,141.702 rows=237,676 loops=3)

  • Filter: ((passenger_count > '1'::numeric) AND (pickup_datetime < '2016-01-08 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3397943