explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8B5f

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.015 ↓ 0.0 0 1

Nested Loop (cost=20.95..61.22 rows=1 width=58) (actual time=0.015..0.015 rows=0 loops=1)

2. 0.002 0.013 ↓ 0.0 0 1

Hash Join (cost=20.80..58.60 rows=1 width=4) (actual time=0.012..0.013 rows=0 loops=1)

  • Hash Cond: (asg.pno = proj.pno)
3. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on asg (cost=0.00..37.75 rows=18 width=8) (actual time=0.010..0.011 rows=0 loops=1)

  • Filter: ((dur = 12) OR (dur = 24))
4. 0.000 0.000 ↓ 0.0 0

Hash (cost=20.75..20.75 rows=4 width=4) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on proj (cost=0.00..20.75 rows=4 width=4) (never executed)

  • Filter: ((pname)::text = 'cad/cam'::text)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using emp_pkey on emp (cost=0.15..2.61 rows=1 width=62) (never executed)

  • Index Cond: (eno = asg.eno)
  • Filter: ((ename)::text <> 'j.doe'::text)
Planning time : 0.687 ms
Execution time : 0.166 ms