explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GyRS

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 4,260.366 ↑ 52,430.3 7 1

Finalize GroupAggregate (cost=323,163.16..404,288.73 rows=367,012 width=40) (actual time=4,115.189..4,260.366 rows=7 loops=1)

  • Group Key: (date_trunc('day'::text, pickup_datetime))
2. 72.456 4,260.356 ↑ 26,837.9 21 1

Gather Merge (cost=323,163.16..394,556.58 rows=563,596 width=40) (actual time=4,075.113..4,260.356 rows=21 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 126.957 4,187.900 ↑ 40,256.9 7 3 / 3

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

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

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

  • Sort Key: (date_trunc('day'::text, pickup_datetime))
  • Sort Method: external merge Disk: 5944kB
  • Worker 0: Sort Method: external merge Disk: 5432kB
  • Worker 1: Sort Method: external merge Disk: 5376kB
5. 3,825.943 3,825.943 ↑ 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.608..3,825.943 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.122 ms
Execution time : 4,263.190 ms