explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YQDI : Optimization for: plan #tnSo

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 315.930 3,048.396 ↑ 53,125.7 7 1

GroupAggregate (cost=379,174.39..389,777.21 rows=371,880 width=40) (actual time=2,614.100..3,048.396 rows=7 loops=1)

  • Group Key: (date_trunc('day'::text, pickup_datetime))
2. 694.433 2,732.466 ↓ 1.1 713,029 1

Sort (cost=379,174.39..380,849.27 rows=669,949 width=13) (actual time=2,521.034..2,732.466 rows=713,029 loops=1)

  • Sort Key: (date_trunc('day'::text, pickup_datetime))
  • Sort Method: external merge Disk: 16,744kB
3. 1,664.983 2,038.033 ↓ 1.1 713,029 1

Bitmap Heap Scan on rides (cost=43,257.14..302,892.46 rows=669,949 width=13) (actual time=394.315..2,038.033 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. 373.050 373.050 ↓ 1.0 2,333,578 1

Bitmap Index Scan on i_rides_pickup_datetime (cost=0.00..43,089.66 rows=2,332,963 width=0) (actual time=373.050..373.050 rows=2,333,578 loops=1)

  • Index Cond: (pickup_datetime < '2016-01-08 00:00:00'::timestamp without time zone)
Planning time : 0.173 ms
Execution time : 3,056.408 ms