explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cyrM

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 1.106 ↑ 4.4 16 1

Hash Join (cost=2.41..38.02 rows=70 width=126) (actual time=0.085..1.106 rows=16 loops=1)

  • Buffers: shared hit=2 read=12
2. 0.239 1.087 ↑ 5.0 4 1

Hash Join (cost=1.09..35.8 rows=20 width=85) (actual time=0.071..1.087 rows=4 loops=1)

  • Buffers: shared hit=1 read=12
3. 0.838 0.838 ↑ 1.0 1,000 1

Seq Scan on employees employees (cost=0..22 rows=1,000 width=64) (actual time=0.015..0.838 rows=1,000 loops=1)

  • Buffers: shared read=12
4. 0.002 0.010 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=21) (actual time=0.01..0.01 rows=4 loops=1)

  • Buffers: shared hit=1
5. 0.008 0.008 ↑ 1.0 4 1

Seq Scan on dept dept (cost=0..1.04 rows=4 width=21) (actual time=0.006..0.008 rows=4 loops=1)

  • Buffers: shared hit=1
6. 0.006 0.010 ↓ 1.1 15 1

Hash (cost=1.14..1.14 rows=14 width=41) (actual time=0.01..0.01 rows=15 loops=1)

  • Buffers: shared hit=1
7. 0.004 0.004 ↓ 1.1 15 1

Seq Scan on emp emp (cost=0..1.14 rows=14 width=41) (actual time=0.003..0.004 rows=15 loops=1)

  • Buffers: shared hit=1