explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R4j5

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 12.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..5,411.76 rows=1 width=4) (actual time=12.018..12.018 rows=0 loops=1)

  • Filter: (itinerary.itinerary_id IS NULL)
2. 12.018 12.018 ↓ 0.0 0 1

Seq Scan on route (cost=0.00..5,403.44 rows=1 width=8) (actual time=12.018..12.018 rows=0 loops=1)

  • Filter: (firma1_id = 12)
  • Rows Removed by Filter: 197,248
3. 0.000 0.000 ↓ 0.0 0

Index Scan using transport_itinerary_route_id_index on itinerary (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Index Cond: (route_id = route.route_id)
Planning time : 0.141 ms
Execution time : 12.045 ms