explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JC88

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

Nested Loop (cost=5.51..33.06 rows=1 width=28) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.37..28.74 rows=24 width=21) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.09..26.96 rows=5 width=17) (actual rows= loops=)

  • Hash Cond: (a.stop_id = stopa.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on routes a (cost=0.00..18.74 rows=1,174 width=10) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=5.08..5.08 rows=1 width=15) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on stops stopa (cost=0.00..5.08 rows=1 width=15) (actual rows= loops=)

  • Filter: ((name)::text = 'Craiglockhart'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using route_pkey on routes b (cost=0.28..0.35 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (((num)::text = (a.num)::text) AND ((company)::text = (a.company)::text))
8. 0.000 0.000 ↓ 0.0

Index Scan using stops_pkey on stops stopb (cost=0.14..0.18 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (id = b.stop_id)
  • Filter: ((name)::text = 'London Road'::text)