explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ik3W

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 11,429.247 ↑ 53,125.7 7 1

Finalize GroupAggregate (cost=322,855.33..403,341.98 rows=371,880 width=40) (actual time=11,240.611..11,429.247 rows=7 loops=1)

  • Group Key: (date_trunc('day'::text, pickup_datetime))
2. 192.790 11,520.228 ↑ 26,585.2 21 1

Gather Merge (cost=322,855.33..393,576.61 rows=558,290 width=40) (actual time=11,194.891..11,520.228 rows=21 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 161.572 11,327.438 ↑ 39,877.9 7 3 / 3

Partial GroupAggregate (cost=321,855.30..328,136.07 rows=279,145 width=40) (actual time=11,120.841..11,327.438 rows=7 loops=3)

  • Group Key: (date_trunc('day'::text, pickup_datetime))
4. 580.959 11,165.866 ↑ 1.2 237,676 3 / 3

Sort (cost=321,855.30..322,553.17 rows=279,145 width=13) (actual time=11,073.561..11,165.866 rows=237,676 loops=3)

  • Sort Key: (date_trunc('day'::text, pickup_datetime))
  • Sort Method: external merge Disk: 5776kB
5. 10,584.907 10,584.907 ↑ 1.2 237,676 3 / 3

Parallel Seq Scan on rides (cost=0.00..291,831.72 rows=279,145 width=13) (actual time=1.830..10,584.907 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
Planning time : 0.151 ms
Execution time : 11,521.826 ms