explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HZYr

Settings
# exclusive inclusive rows x rows loops node
1. 8.086 8.618 ↑ 1.5 6 1

Hash Left Join (cost=56.58..239.09 rows=9 width=692) (actual time=2.528..8.618 rows=6 loops=1)

  • Hash Cond: ((g.iddependenciamodifica)::integer = (depm.iddependenciajudicial)::integer)
2. 0.007 0.340 ↑ 1.5 6 1

Hash Left Join (cost=31.54..209.30 rows=9 width=609) (actual time=0.272..0.340 rows=6 loops=1)

  • Hash Cond: ((g.iddependenciainicia)::integer = (depi.iddependenciajudicial)::integer)
3. 0.011 0.145 ↑ 1.5 6 1

Hash Join (cost=6.50..184.23 rows=9 width=580) (actual time=0.081..0.145 rows=6 loops=1)

  • Hash Cond: ((g.idtipogestion)::integer = (tg.idtipogestion)::integer)
4. 0.004 0.087 ↑ 1.5 6 1

Nested Loop (cost=1.43..179.14 rows=9 width=521) (actual time=0.029..0.087 rows=6 loops=1)

  • Join Filter: ((g.idestadogestion)::integer = (eg.idestadogestion)::integer)
  • Rows Removed by Join Filter: 3
5. 0.007 0.077 ↑ 1.5 6 1

Nested Loop (cost=1.43..177.50 rows=9 width=425) (actual time=0.025..0.077 rows=6 loops=1)

  • Join Filter: ((ex.idproceso)::integer = (p.idproceso)::integer)
6. 0.004 0.064 ↑ 1.5 6 1

Nested Loop Left Join (cost=1.43..174.75 rows=9 width=361) (actual time=0.019..0.064 rows=6 loops=1)

7. 0.008 0.048 ↑ 1.5 6 1

Nested Loop Left Join (cost=1.00..98.65 rows=9 width=340) (actual time=0.016..0.048 rows=6 loops=1)

8. 0.006 0.022 ↑ 1.5 6 1

Nested Loop (cost=0.57..22.56 rows=9 width=319) (actual time=0.011..0.022 rows=6 loops=1)

9. 0.005 0.005 ↑ 1.0 1 1

Index Scan using pk_expedientes on t_expedientes ex (cost=0.28..8.30 rows=1 width=99) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: ((idexpediente)::integer = 48,764)
10. 0.011 0.011 ↑ 1.5 6 1

Index Scan using ix_fk_exp_ges_400044 on t_gestiones g (cost=0.29..14.17 rows=9 width=220) (actual time=0.005..0.011 rows=6 loops=1)

  • Index Cond: ((idexpediente)::integer = 48,764)
11. 0.018 0.018 ↑ 1.0 1 6

Index Scan using ix_personasfisicas_1 on t_personasfisicas peri (cost=0.43..8.45 rows=1 width=25) (actual time=0.003..0.003 rows=1 loops=6)

  • Index Cond: ((g.idpersonainicia)::integer = (idpersona)::integer)
12. 0.012 0.012 ↑ 1.0 1 6

Index Scan using ix_personasfisicas_1 on t_personasfisicas perm (cost=0.43..8.45 rows=1 width=25) (actual time=0.001..0.002 rows=1 loops=6)

  • Index Cond: ((g.idpersonamodifica)::integer = (idpersona)::integer)
13. 0.002 0.006 ↑ 13.0 1 6

Materialize (cost=0.00..1.19 rows=13 width=68) (actual time=0.001..0.001 rows=1 loops=6)

14. 0.004 0.004 ↑ 13.0 1 1

Seq Scan on t_procesos p (cost=0.00..1.13 rows=13 width=68) (actual time=0.004..0.004 rows=1 loops=1)

15. 0.004 0.006 ↑ 2.5 2 6

Materialize (cost=0.00..1.07 rows=5 width=100) (actual time=0.001..0.001 rows=2 loops=6)

16. 0.002 0.002 ↑ 2.5 2 1

Seq Scan on t_estadosgestiones eg (cost=0.00..1.05 rows=5 width=100) (actual time=0.002..0.002 rows=2 loops=1)

17. 0.020 0.047 ↓ 1.0 94 1

Hash (cost=3.92..3.92 rows=92 width=63) (actual time=0.047..0.047 rows=94 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
18. 0.027 0.027 ↓ 1.0 94 1

Seq Scan on t_tiposgestiones tg (cost=0.00..3.92 rows=92 width=63) (actual time=0.003..0.027 rows=94 loops=1)

19. 0.097 0.188 ↓ 1.0 732 1

Hash (cost=16.13..16.13 rows=713 width=33) (actual time=0.188..0.188 rows=732 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 57kB
20. 0.091 0.091 ↓ 1.0 732 1

Seq Scan on t_dependenciasjudiciales depi (cost=0.00..16.13 rows=713 width=33) (actual time=0.004..0.091 rows=732 loops=1)

21. 0.111 0.192 ↓ 1.0 732 1

Hash (cost=16.13..16.13 rows=713 width=33) (actual time=0.192..0.192 rows=732 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 57kB
22. 0.081 0.081 ↓ 1.0 732 1

Seq Scan on t_dependenciasjudiciales depm (cost=0.00..16.13 rows=713 width=33) (actual time=0.001..0.081 rows=732 loops=1)

Planning time : 2.111 ms