explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a8UD

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

Finalize GroupAggregate (cost=314,017.79..394,514.37 rows=362,147 width=40) (actual time=1,090.211..1,157.038 rows=7 loops=1)

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

Gather Merge (cost=314,017.79..384,886.27 rows=559,452 width=40) (actual time=1,067.476..1,157.103 rows=21 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 236.055 3,080.913 ↑ 39,960.9 7 3

Partial GroupAggregate (cost=313,017.77..319,311.61 rows=279,726 width=40) (actual time=932.038..1,026.971 rows=7 loops=3)

  • Group Key: (date_trunc('day'::text, pickup_datetime))
4. 432.447 2,844.858 ↑ 1.2 237,676 3

Sort (cost=313,017.77..313,717.09 rows=279,726 width=13) (actual time=904.079..948.286 rows=237,676 loops=3)

  • Sort Key: (date_trunc('day'::text, pickup_datetime))
  • Sort Method: external merge Disk: 6776kB
  • Worker 0: Sort Method: external merge Disk: 5072kB
  • Worker 1: Sort Method: external merge Disk: 4904kB
5. 2,407.997 2,412.411 ↑ 1.2 237,676 3

Parallel Bitmap Heap Scan on rides (cost=221.81..282,930.44 rows=279,726 width=13) (actual time=1.588..804.137 rows=237,676 loops=3)

  • Recheck Cond: ((passenger_count > '1'::numeric) AND (pickup_datetime < '2016-01-08 00:00:00'::timestamp without time zone))
  • Rows Removed by Index Recheck: 841823
  • Heap Blocks: lossy=26110
6. 4.414 4.414 ↑ 1.5 661,760 1

Bitmap Index Scan on datetrunc (cost=0.00..53.97 rows=972,955 width=0) (actual time=4.414..4.414 rows=661,760 loops=1)

  • Index Cond: ((passenger_count > '1'::numeric) AND (pickup_datetime < '2016-01-08 00:00:00'::timestamp without time zone))