explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mOuh

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 1.570 ↑ 1.0 1 1

Aggregate (cost=278.94..278.95 rows=1 width=32) (actual time=1.570..1.570 rows=1 loops=1)

2. 0.014 1.548 ↓ 1.1 37 1

Sort (cost=278.44..278.53 rows=33 width=36) (actual time=1.546..1.548 rows=37 loops=1)

  • Sort Key: times.stop_sequence
  • Sort Method: quicksort Memory: 27kB
3. 0.036 1.534 ↓ 1.1 37 1

Hash Join (cost=149.11..277.61 rows=33 width=36) (actual time=1.505..1.534 rows=37 loops=1)

  • Hash Cond: (times.stop_id = stops.stop_id)
4. 0.016 0.037 ↓ 1.1 37 1

Bitmap Heap Scan on gtfs_stop_times times (cost=4.68..132.57 rows=33 width=22) (actual time=0.029..0.037 rows=37 loops=1)

  • Recheck Cond: (trip_id = 'VJ9ebedd41b2fc5ee4b08812f56b9943a1625985db'::text)
  • Filter: (bundle_id = 'ito_ny'::text)
  • Heap Blocks: exact=2
5. 0.021 0.021 ↓ 1.1 37 1

Bitmap Index Scan on gtfs_stop_times_trip_id_idx (cost=0.00..4.67 rows=33 width=0) (actual time=0.021..0.021 rows=37 loops=1)

  • Index Cond: (trip_id = 'VJ9ebedd41b2fc5ee4b08812f56b9943a1625985db'::text)
6. 0.733 1.461 ↑ 1.0 3,577 1

Hash (cost=99.71..99.71 rows=3,577 width=35) (actual time=1.461..1.461 rows=3,577 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 268kB
7. 0.728 0.728 ↑ 1.0 3,577 1

Seq Scan on gtfs_stops stops (cost=0.00..99.71 rows=3,577 width=35) (actual time=0.014..0.728 rows=3,577 loops=1)