explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VAyY

Settings
# exclusive inclusive rows x rows loops node
1. 127.979 1,265.126 ↑ 56,289.9 7 1

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

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

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

  • Sort Key: (date_trunc('day'::text, pickup_datetime))
  • Sort Method: external merge Disk: 16744kB
3. 717.287 848.971 ↓ 1.0 713,029 1

Bitmap Heap Scan on rides (cost=44,018.25..304,338.25 rows=699,184 width=13) (actual time=141.779..848.971 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: 1620549
  • Heap Blocks: exact=47801
4. 131.684 131.684 ↑ 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=131.684..131.684 rows=2,333,578 loops=1)

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