explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a188

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,923.42..2,951.52 rows=2,810 width=24) (actual rows= loops=)

  • Output: a.name
  • Group Key: a.name
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,206.90..2,799.46 rows=49,584 width=24) (actual rows= loops=)

  • Output: a.name
  • Hash Cond: (r.depair = a.iata)
3. 0.000 0.000 ↓ 0.0

Seq Scan on public.routes r (cost=0.00..882.16 rows=57,216 width=4) (actual rows= loops=)

  • Output: r.rid, r.airline, r.depair, r.arrair
4. 0.000 0.000 ↓ 0.0

Hash (cost=1,176.36..1,176.36 rows=2,443 width=32) (actual rows= loops=)

  • Output: a.name, a.iata, routes.arrair
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,080.17..1,176.36 rows=2,443 width=32) (actual rows= loops=)

  • Output: a.name, a.iata, routes.arrair
  • Hash Cond: (a.iata = routes.arrair)
6. 0.000 0.000 ↓ 0.0

Seq Scan on public.airports a (cost=0.00..61.19 rows=2,819 width=28) (actual rows= loops=)

  • Output: a.iata, a.icao, a.name, a.cityid, a.latitude, a.longtitude, a.altitude
7. 0.000 0.000 ↓ 0.0

Hash (cost=1,049.63..1,049.63 rows=2,443 width=4) (actual rows= loops=)

  • Output: routes.arrair
8. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,025.20..1,049.63 rows=2,443 width=4) (actual rows= loops=)

  • Output: routes.arrair
  • Group Key: routes.arrair
9. 0.000 0.000 ↓ 0.0

Seq Scan on public.routes (cost=0.00..882.16 rows=57,216 width=4) (actual rows= loops=)