explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ea6d

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.57..25.96 rows=1 width=101) (actual time=0.017..0.017 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
  • Buffers: shared hit=6
2. 0.013 0.017 ↓ 0.0 0 1

Index Scan using eventotramitacion_estado_idx on public.eventotramitacion eventotram0_ (cost=0.29..17.66 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

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

SubPlan (forIndex Scan)

4. 0.004 0.004 ↑ 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.004..0.004 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

Index Scan using subtramite_pkey on public.subtramite subtramite1_ (cost=0.28..8.30 rows=1 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
  • Index Cond: (subtramite1_.id = eventotram0_.idsubtramite)