explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CJ0

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.061 ↑ 2.6 9 1

Hash Join (cost=3.45..26.03 rows=23 width=198) (actual time=0.054..0.061 rows=9 loops=1)

  • Hash Cond: (dep.department_id = emp.department_id)
2. 0.010 0.010 ↑ 19.3 27 1

Seq Scan on dep (cost=0.00..15.20 rows=520 width=128) (actual time=0.009..0.010 rows=27 loops=1)

3. 0.016 0.036 ↑ 1.0 9 1

Hash (cost=3.34..3.34 rows=9 width=70) (actual time=0.036..0.036 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.020 0.020 ↑ 1.0 9 1

Seq Scan on emp (cost=0.00..3.34 rows=9 width=70) (actual time=0.009..0.020 rows=9 loops=1)

  • Filter: (last_name ~~ 'S%'::text)
  • Rows Removed by Filter: 98
Planning time : 0.177 ms
Execution time : 0.087 ms