explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dnJ2

Settings
# exclusive inclusive rows x rows loops node
1. 32.591 75.331 ↓ 137,022.0 137,022 1

Hash Left Join (cost=4,741.27..12,152.31 rows=1 width=4) (actual time=20.521..75.331 rows=137,022 loops=1)

  • Hash Cond: (route.route_id = itinerary.route_id)
  • Filter: (itinerary.itinerary_id IS NULL)
  • Rows Removed by Filter: 6,744
2. 22.299 22.299 ↓ 1.0 143,766 1

Seq Scan on route (cost=0.00..5,403.44 rows=141,314 width=4) (actual time=0.028..22.299 rows=143,766 loops=1)

  • Filter: (firm_id = 12)
  • Rows Removed by Filter: 53,482
3. 5.655 20.441 ↓ 1.0 57,668 1

Hash (cost=4,021.12..4,021.12 rows=57,612 width=8) (actual time=20.441..20.441 rows=57,668 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 2,253kB
4. 14.786 14.786 ↓ 1.0 57,671 1

Seq Scan on itinerary (cost=0.00..4,021.12 rows=57,612 width=8) (actual time=0.014..14.786 rows=57,671 loops=1)

Planning time : 0.676 ms
Execution time : 78.043 ms