explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OBgT

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 2.065 ↑ 1.0 1 1

Nested Loop (cost=30.10..214.44 rows=1 width=8) (actual time=1.533..2.065 rows=1 loops=1)

  • Output: dtd.id
  • Buffers: shared hit=152
2. 1.095 2.043 ↑ 7.0 1 1

Hash Join (cost=29.96..213.22 rows=7 width=8) (actual time=1.511..2.043 rows=1 loops=1)

  • Output: ds.idarchivobinario
  • Inner Unique: true
  • Hash Cond: (ds.ideventotramitacion = et.id)
  • Buffers: shared hit=150
3. 0.839 0.839 ↓ 1.0 3,191 1

Seq Scan on public.documentosigno ds (cost=0.00..174.89 rows=3,189 width=16) (actual time=0.057..0.839 rows=3,191 loops=1)

  • Output: ds.id, ds.idsigno, ds.idtramitesigno, ds.md5, ds.nombre, ds.size, ds.tipodocumento, ds.idarchivobinario, ds.ideventotramitacion, ds.idtiposubtramite, ds.archivodescargado, ds.descripcion, ds.descripcionerror
  • Buffers: shared hit=143
4. 0.029 0.109 ↑ 1.1 38 1

Hash (cost=29.45..29.45 rows=41 width=8) (actual time=0.108..0.109 rows=38 loops=1)

  • Output: et.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=7
5. 0.080 0.080 ↑ 1.1 38 1

Index Scan using eventotramitacion_idsubtramite_idx on public.eventotramitacion et (cost=0.29..29.45 rows=41 width=8) (actual time=0.038..0.080 rows=38 loops=1)

  • Output: et.id
  • Index Cond: (et.idsubtramite = 5632)
  • Buffers: shared hit=7
6. 0.018 0.018 ↑ 1.0 1 1

Index Scan using documentaciontramitesdocumento_iddocumento_idx on public.documentaciontramitesdocumento dtd (cost=0.14..0.16 rows=1 width=16) (actual time=0.017..0.018 rows=1 loops=1)

  • Output: dtd.borradoenseguimiento, dtd.id, dtd.iddocumento, dtd.idtramite
  • Index Cond: (dtd.iddocumento = ds.idarchivobinario)
  • Buffers: shared hit=2