explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kcA7

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

Hash Left Join (cost=130.91..153.80 rows=599 width=440) (actual rows= loops=)

  • Hash Cond: (s.manager_staff_id = ms.staff_id)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=113.26..134.57 rows=599 width=231) (actual rows= loops=)

  • Hash Cond: (s.address_id = sad.address_id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=91.69..111.42 rows=599 width=170) (actual rows= loops=)

  • Hash Cond: (ad.city_id = city.city_id)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=73.19..91.34 rows=599 width=147) (actual rows= loops=)

  • Hash Cond: (c.store_id = s.store_id)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=21.57..38.14 rows=599 width=131) (actual rows= loops=)

  • Hash Cond: (c.address_id = ad.address_id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on customer c (cost=0.00..14.99 rows=599 width=70) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=14.03..14.03 rows=603 width=61) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on address ad (cost=0.00..14.03 rows=603 width=61) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=28.50..28.50 rows=1,850 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on store s (cost=0.00..28.50 rows=1,850 width=16) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=11.00..11.00 rows=600 width=23) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on city (cost=0.00..11.00 rows=600 width=23) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=14.03..14.03 rows=603 width=61) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on address sad (cost=0.00..14.03 rows=603 width=61) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=13.40..13.40 rows=340 width=209) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on staff ms (cost=0.00..13.40 rows=340 width=209) (actual rows= loops=)