explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HOU6 : Optimization for: plan #aVm

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 99.526 10,113.190 ↑ 1.0 1 1

Aggregate (cost=215,099.18..215,099.19 rows=1 width=8) (actual time=10,113.190..10,113.190 rows=1 loops=1)

2. 98.442 10,013.664 ↑ 8.1 225,019 1

Nested Loop (cost=0.43..210,554.65 rows=1,817,810 width=0) (actual time=1.131..10,013.664 rows=225,019 loops=1)

3. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on rates (cost=0.00..1.07 rows=1 width=4) (actual time=0.014..0.020 rows=1 loops=1)

  • Filter: (description = 'JFK'::text)
  • Rows Removed by Filter: 5
4. 9,915.202 9,915.202 ↑ 9.7 225,019 1

Index Only Scan using i_rides_rate_code on rides (cost=0.43..188,739.86 rows=2,181,372 width=4) (actual time=1.114..9,915.202 rows=225,019 loops=1)

  • Index Cond: (rate_code = rates.rate_code)
  • Heap Fetches: 225,019
Planning time : 0.303 ms
Execution time : 10,113.250 ms