explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vl3F

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.096 ↓ 3.0 3 1

Hash Semi Join (cost=2.16..3.29 rows=1 width=244) (actual time=0.094..0.096 rows=3 loops=1)

  • Output: e.nome
  • Hash Cond: (e.id_evento = p.id_evento)
  • Buffers: shared hit=3
2. 0.030 0.030 ↑ 1.0 9 1

Seq Scan on public.evento e (cost=0.00..1.09 rows=9 width=252) (actual time=0.029..0.030 rows=9 loops=1)

  • Output: e.id_evento, e.id_rh, e.nome, e.edicao, e.tema, e.data, e.horario
  • Buffers: shared hit=1
3. 0.002 0.051 ↓ 3.0 3 1

Hash (cost=2.15..2.15 rows=1 width=8) (actual time=0.051..0.051 rows=3 loops=1)

  • Output: p.id_evento
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
4. 0.012 0.049 ↓ 3.0 3 1

Hash Join (cost=1.07..2.15 rows=1 width=8) (actual time=0.046..0.049 rows=3 loops=1)

  • Output: p.id_evento
  • Inner Unique: true
  • Hash Cond: (p.id_equipamento = eq.id_equipamento)
  • Buffers: shared hit=2
5. 0.013 0.013 ↑ 1.0 5 1

Seq Scan on public.possui p (cost=0.00..1.05 rows=5 width=16) (actual time=0.012..0.013 rows=5 loops=1)

  • Output: p.id_equipamento, p.id_evento
  • Buffers: shared hit=1
6. 0.007 0.024 ↓ 3.0 3 1

Hash (cost=1.06..1.06 rows=1 width=8) (actual time=0.024..0.024 rows=3 loops=1)

  • Output: eq.id_equipamento
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
7. 0.017 0.017 ↓ 3.0 3 1

Seq Scan on public.equipamento eq (cost=0.00..1.06 rows=1 width=8) (actual time=0.014..0.017 rows=3 loops=1)

  • Output: eq.id_equipamento
  • Filter: (eq.tipo = 'eletrica'::bpchar)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1