explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IZDS

Settings
# exclusive inclusive rows x rows loops node
1. 39.387 45.169 ↓ 0.0 0 1

Seq Scan on route (cost=1,772.50..7,175.94 rows=97,418 width=4) (actual time=45.169..45.169 rows=0 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 197248
2.          

SubPlan (for Seq Scan)

3. 5.782 5.782 ↓ 1.0 57,671 1

Index Only Scan using transport_itinerary_route_id_index on itinerary (cost=0.29..1,628.47 rows=57,612 width=4) (actual time=0.010..5.782 rows=57,671 loops=1)

  • Heap Fetches: 5380
Planning time : 0.066 ms
Execution time : 45.186 ms