explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qypi

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 3,723.574 ↑ 52,430.3 7 1

Finalize GroupAggregate (cost=323,163.16..404,288.73 rows=367,012 width=40) (actual time=3,587.262..3,723.574 rows=7 loops=1)

  • Group Key: (date_trunc('day'::text, pickup_datetime))
2. 75.715 3,723.565 ↑ 26,837.9 21 1

Gather Merge (cost=323,163.16..394,556.58 rows=563,596 width=40) (actual time=3,550.692..3,723.565 rows=21 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 102.598 3,647.850 ↑ 40,256.9 7 3 / 3

Partial GroupAggregate (cost=322,163.14..328,503.59 rows=281,798 width=40) (actual time=3,502.559..3,647.850 rows=7 loops=3)

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

Sort (cost=322,163.14..322,867.63 rows=281,798 width=13) (actual time=3,481.955..3,545.252 rows=237,676 loops=3)

  • Sort Key: (date_trunc('day'::text, pickup_datetime))
  • Sort Method: external merge Disk: 5816kB
  • Worker 0: Sort Method: external merge Disk: 5512kB
  • Worker 1: Sort Method: external merge Disk: 5424kB
5. 3,335.145 3,335.145 ↑ 1.2 237,676 3 / 3

Parallel Seq Scan on rides (cost=0.00..291,838.36 rows=281,798 width=13) (actual time=0.549..3,335.145 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.172 ms
Execution time : 3,726.696 ms