explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UzL : Optimization for: plan #Fa0Z

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.029 2,666.590 ↓ 2.9 23 1

Sort (cost=278,289.97..278,289.99 rows=8 width=36) (actual time=2,666.588..2,666.590 rows=23 loops=1)

  • Sort Key: times.stop_sequence
  • Sort Method: quicksort Memory: 26kB
2. 0.072 2,666.561 ↓ 2.9 23 1

Nested Loop (cost=0.29..278,289.85 rows=8 width=36) (actual time=206.512..2,666.561 rows=23 loops=1)

3. 2,666.305 2,666.305 ↑ 2.0 23 1

Seq Scan on gtfs_stop_times times (cost=0.00..277,938.89 rows=47 width=19) (actual time=206.416..2,666.305 rows=23 loops=1)

  • Filter: ((bundle_id = 'o_mta_nyc'::text) AND (trip_id = '114963'::text))
  • Rows Removed by Filter: 10499920
4. 0.184 0.184 ↑ 1.0 1 23

Index Scan using gtfs_stops_stop_id_idx on gtfs_stops stops (cost=0.29..7.46 rows=1 width=33) (actual time=0.008..0.008 rows=1 loops=23)

  • Index Cond: (stop_id = times.stop_id)