explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g9s5

Settings
# exclusive inclusive rows x rows loops node
1. 125.349 1,268.813 ↑ 56,289.9 7 1

GroupAggregate (cost=384,161.63..395,315.95 rows=394,029 width=40) (actual time=1,100.570..1,268.813 rows=7 loops=1)

  • Group Key: (date_trunc('day'::text, pickup_datetime))
2. 286.892 1,143.464 ↓ 1.0 713,029 1

Sort (cost=384,161.63..385,909.59 rows=699,184 width=13) (actual time=1,064.886..1,143.464 rows=713,029 loops=1)

  • Sort Key: (date_trunc('day'::text, pickup_datetime))
  • Sort Method: external merge Disk: 16,744kB
3. 718.006 856.572 ↓ 1.0 713,029 1

Bitmap Heap Scan on rides (cost=44,018.25..304,338.25 rows=699,184 width=13) (actual time=148.546..856.572 rows=713,029 loops=1)

  • Recheck Cond: (pickup_datetime < '2016-01-08 00:00:00'::timestamp without time zone)
  • Filter: (passenger_count > '1'::numeric)
  • Rows Removed by Filter: 1,620,549
  • Heap Blocks: exact=47,801
4. 138.566 138.566 ↑ 1.0 2,333,578 1

Bitmap Index Scan on i_rides_pickup_datetime (cost=0.00..43,843.46 rows=2,373,736 width=0) (actual time=138.566..138.566 rows=2,333,578 loops=1)

  • Index Cond: (pickup_datetime < '2016-01-08 00:00:00'::timestamp without time zone)
Planning time : 0.160 ms
Execution time : 1,271.750 ms