explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NvuE

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6.206 ↓ 0.0 0 1

Nested Loop (cost=0.00..206,008.08 rows=1 width=101) (actual time=6.206..6.206 rows=0 loops=1)

  • Output: subtramite1_.id, subtramite1_.anyo, subtramite1_.codigocatastro, subtramite1_.descripcion, subtramite1_.iddocumento, subtramite1_.idsigno, subtramite1_.numeroprotocolo, subtramite1_.numeroprotocolobis, subtramite1_.idtipo, subtramite1_.idtipodocumento
  • Inner Unique: true
  • Join Filter: (eventotram0_.idsubtramite = subtramite1_.id)
  • Buffers: shared hit=499
2. 6.186 6.205 ↓ 0.0 0 1

Seq Scan on public.eventotramitacion eventotram0_ (cost=0.00..205,706.19 rows=1 width=8) (actual time=6.205..6.205 rows=0 loops=1)

  • Output: eventotram0_.id, eventotram0_.descripcion, eventotram0_.estado, eventotram0_.fecha, eventotram0_.idsigno, eventotram0_.resultado, eventotram0_.usuario, eventotram0_.idsubtramite
  • Filter: ((eventotram0_.estado = 5) AND ((eventotram0_.fecha IS NULL) OR (NOT (SubPlan 1))))
  • Rows Removed by Filter: 19852
  • Buffers: shared hit=499
3.          

SubPlan (forSeq Scan)

4. 0.019 0.019 ↑ 1.0 1 1

Index Scan using eventotramitacion_idsubtramite_idx on public.eventotramitacion eventotram2_ (cost=0.29..9.35 rows=1 width=0) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (eventotram2_.idsubtramite = eventotram0_.idsubtramite)
  • Filter: (eventotram0_.fecha < eventotram2_.fecha)
  • Buffers: shared hit=3
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.subtramite subtramite1_ (cost=0.00..204.73 rows=7,773 width=101) (never executed)

  • Output: subtramite1_.id, subtramite1_.anyo, subtramite1_.codigocatastro, subtramite1_.descripcion, subtramite1_.idsigno, subtramite1_.numeroprotocolo, subtramite1_.numeroprotocolobis, subtramite1_.iddocumento, subtramite1_.idtipo, subtramite1_.idtipodocumento