explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l1Yk

Settings
# exclusive inclusive rows x rows loops node
1. 0.137 0.971 ↑ 1.0 574 1

Sort (cost=1,217.95..1,219.40 rows=580 width=354) (actual time=0.945..0.971 rows=574 loops=1)

  • Sort Key: route.departure
  • Sort Method: quicksort Memory: 131kB
2. 0.000 0.834 ↑ 1.0 574 1

Nested Loop Anti Join (cost=0.71..1,191.33 rows=580 width=354) (actual time=0.010..0.834 rows=574 loops=1)

3. 0.434 0.434 ↑ 1.4 574 1

Index Scan using transport_route_unloading_datetime_index on route (cost=0.42..171.83 rows=823 width=354) (actual time=0.008..0.434 rows=574 loops=1)

  • Index Cond: (unloading_datetime > '2020-01-01 00:00:00'::timestamp without time zone)
  • Filter: ((transport_route_id IS NULL) AND (loading_datetime < '2020-01-31 23:59:59'::timestamp without time zone) AND (firm_id = 12) AND (shipping = 0))
  • Rows Removed by Filter: 287
4. 0.574 0.574 ↓ 0.0 0 574

Index Only Scan using transport_itinerary_route_id_index on itinerary (cost=0.29..1.24 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=574)

  • Index Cond: (route_id = route.route_id)
  • Heap Fetches: 0
Planning time : 0.166 ms
Execution time : 0.999 ms