explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VkwZ

Settings
# exclusive inclusive rows x rows loops node
1. 45.780 51.490 ↓ 0.0 0 1

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

  • Filter: ((NOT (hashed SubPlan 1)) AND (firma1_id = 12))
  • Rows Removed by Filter: 197248
2.          

SubPlan (for Seq Scan)

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

  • Heap Fetches: 5380
Planning time : 0.087 ms
Execution time : 51.503 ms