explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yEDB

Settings
# exclusive inclusive rows x rows loops node
1. 37.254 84.666 ↓ 139,580.0 139,580 1

Hash Left Join (cost=4,741.27..12,425.57 rows=1 width=4) (actual time=17.827..84.666 rows=139,580 loops=1)

  • Hash Cond: (route.route_id = itinerary.route_id)
  • Filter: (itinerary.itinerary_id IS NULL)
  • Rows Removed by Filter: 57,668
2. 29.594 29.594 ↓ 1.0 197,248 1

Seq Scan on route (cost=0.00..4,916.35 rows=194,835 width=8) (actual time=0.003..29.594 rows=197,248 loops=1)

3. 5.537 17.818 ↓ 1.0 57,668 1

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

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

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

Planning time : 0.137 ms
Execution time : 87.240 ms