explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Jtu

Settings
# exclusive inclusive rows x rows loops node
1. 32.274 37.138 ↓ 0.0 0 1

Seq Scan on route (cost=1,772.50..7,663.02 rows=70,657 width=4) (actual time=37.138..37.138 rows=0 loops=1)

  • Filter: ((NOT (hashed SubPlan 1)) AND (firm_id = 12))
  • Rows Removed by Filter: 197,248
2.          

SubPlan (for Seq Scan)

3. 4.864 4.864 ↓ 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.015..4.864 rows=57,671 loops=1)

  • Heap Fetches: 5,380
Planning time : 0.067 ms
Execution time : 37.153 ms