explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y7qb

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.824 ↑ 1.0 1 1

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

  • Output: dtd.id
  • Buffers: shared hit=152
2. 0.439 0.816 ↑ 7.0 1 1

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

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

Seq Scan on public.documentosigno ds (cost=0.00..174.89 rows=3,189 width=16) (actual time=0.017..0.347 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.008 0.030 ↑ 1.1 38 1

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

  • Output: et.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=7
5. 0.022 0.022 ↑ 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.010..0.022 rows=38 loops=1)

  • Output: et.id
  • Index Cond: (et.idsubtramite = 5632)
  • Buffers: shared hit=7
6. 0.006 0.006 ↑ 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.005..0.006 rows=1 loops=1)

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