explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0cZK

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

Hash Left Join (cost=1,056.87..11,555.16 rows=854 width=645) (actual rows= loops=)

  • Hash Cond: (a.user_role_id = b.id)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=483.31..10,930.81 rows=854 width=361) (actual rows= loops=)

  • Hash Cond: (a.company_id = c.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on employee a (cost=0.00..10,435.76 rows=854 width=361) (actual rows= loops=)

  • Filter: ((id)::text = '1950'::text)
4. 0.000 0.000 ↓ 0.0

Hash (cost=482.04..482.04 rows=102 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=33.30..482.04 rows=102 width=8) (actual rows= loops=)

  • Hash Cond: (d.id = c.user_role_id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on user_role d (cost=0.00..393.80 rows=14,380 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=32.02..32.02 rows=102 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on company c (cost=0.00..32.02 rows=102 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=393.80..393.80 rows=14,380 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on user_role b (cost=0.00..393.80 rows=14,380 width=8) (actual rows= loops=)