explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fc2G

Settings
# exclusive inclusive rows x rows loops node
1. 17,092.819 49,020.185 ↓ 1.0 2,993 1

Hash Left Join (cost=131.27..383,143.58 rows=2,977 width=755) (actual time=36.059..49,020.185 rows=2,993 loops=1)

  • Hash Cond: ((exp.idtipoingresoexpediente)::integer = (tie.idtipoingresoexpediente)::integer)
2. 37.192 988.712 ↓ 1.0 2,993 1

Hash Left Join (cost=130.11..60,421.48 rows=2,977 width=582) (actual time=18.797..988.712 rows=2,993 loops=1)

  • Hash Cond: ((exp.idsituacionexpediente)::integer = (se.idsituacionexpediente)::integer)
3. 65.219 951.483 ↓ 1.0 2,993 1

Nested Loop Left Join (cost=128.87..60,409.42 rows=2,977 width=550) (actual time=18.750..951.483 rows=2,993 loops=1)

4. 52.566 856.334 ↓ 1.0 2,993 1

Nested Loop Left Join (cost=128.44..40,382.88 rows=2,977 width=529) (actual time=18.742..856.334 rows=2,993 loops=1)

5. 58.138 800.775 ↓ 1.0 2,993 1

Nested Loop Left Join (cost=128.01..20,356.35 rows=2,977 width=508) (actual time=18.735..800.775 rows=2,993 loops=1)

6. 53.118 554.078 ↓ 1.0 2,993 1

Hash Left Join (cost=127.58..329.81 rows=2,977 width=487) (actual time=18.712..554.078 rows=2,993 loops=1)

  • Hash Cond: ((exp.iddependenciadefensoria)::integer = (ded.iddependenciajudicial)::integer)
7. 68.091 484.722 ↓ 1.0 2,993 1

Hash Join (cost=102.74..297.16 rows=2,977 width=458) (actual time=2.467..484.722 rows=2,993 loops=1)

  • Hash Cond: ((exp.idultimaubicacionfisica)::integer = (deuf.iddependenciajudicial)::integer)
8. 65.071 416.013 ↓ 1.0 2,993 1

Hash Join (cost=77.90..264.46 rows=2,977 width=429) (actual time=1.839..416.013 rows=2,993 loops=1)

  • Hash Cond: ((exp.idultimaradicacion)::integer = (deu.iddependenciajudicial)::integer)
9. 48.048 350.385 ↓ 1.0 2,993 1

Hash Join (cost=53.06..231.76 rows=2,977 width=400) (actual time=1.254..350.385 rows=2,993 loops=1)

  • Hash Cond: ((exp.iddependenciaalta)::integer = (dea.iddependenciajudicial)::integer)
10. 46.435 301.749 ↓ 1.0 2,993 1

Hash Join (cost=28.22..199.06 rows=2,977 width=371) (actual time=0.660..301.749 rows=2,993 loops=1)

  • Hash Cond: ((exp.iddeporigen)::integer = (deo.iddependenciajudicial)::integer)
11. 103.237 254.730 ↓ 1.0 2,993 1

Hash Left Join (cost=3.38..166.36 rows=2,977 width=342) (actual time=0.072..254.730 rows=2,993 loops=1)

  • Hash Cond: ((exp.idinstancia)::integer = (ins.idinstancia)::integer)
12. 74.289 151.484 ↓ 1.0 2,993 1

Hash Join (cost=2.31..150.35 rows=2,977 width=310) (actual time=0.058..151.484 rows=2,993 loops=1)

  • Hash Cond: ((exp.idproceso)::integer = (pro.idproceso)::integer)
13. 56.465 77.175 ↓ 1.0 2,993 1

Hash Join (cost=1.11..138.32 rows=2,977 width=278) (actual time=0.029..77.175 rows=2,993 loops=1)

  • Hash Cond: ((exp.idestadoexpediente)::integer = (ese.idestadoexpediente)::integer)
14. 20.697 20.697 ↓ 1.0 2,993 1

Seq Scan on t_expedientes exp (cost=0.00..122.77 rows=2,977 width=246) (actual time=0.008..20.697 rows=2,993 loops=1)

15. 0.005 0.013 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=36) (actual time=0.012..0.013 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.008 0.008 ↑ 1.0 5 1

Seq Scan on t_estadosexpedientes ese (cost=0.00..1.05 rows=5 width=36) (actual time=0.006..0.008 rows=5 loops=1)

17. 0.008 0.020 ↓ 1.4 13 1

Hash (cost=1.09..1.09 rows=9 width=36) (actual time=0.019..0.020 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
18. 0.012 0.012 ↓ 1.4 13 1

Seq Scan on t_procesos pro (cost=0.00..1.09 rows=9 width=36) (actual time=0.007..0.012 rows=13 loops=1)

19. 0.004 0.009 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=36) (actual time=0.007..0.009 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
20. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on t_instancias ins (cost=0.00..1.03 rows=3 width=36) (actual time=0.004..0.005 rows=3 loops=1)

21. 0.315 0.584 ↓ 1.0 711 1

Hash (cost=16.04..16.04 rows=704 width=33) (actual time=0.582..0.584 rows=711 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 55kB
22. 0.269 0.269 ↓ 1.0 711 1

Seq Scan on t_dependenciasjudiciales deo (cost=0.00..16.04 rows=704 width=33) (actual time=0.004..0.269 rows=711 loops=1)

23. 0.310 0.588 ↓ 1.0 711 1

Hash (cost=16.04..16.04 rows=704 width=33) (actual time=0.586..0.588 rows=711 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 55kB
24. 0.278 0.278 ↓ 1.0 711 1

Seq Scan on t_dependenciasjudiciales dea (cost=0.00..16.04 rows=704 width=33) (actual time=0.004..0.278 rows=711 loops=1)

25. 0.298 0.557 ↓ 1.0 711 1

Hash (cost=16.04..16.04 rows=704 width=33) (actual time=0.555..0.557 rows=711 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 55kB
26. 0.259 0.259 ↓ 1.0 711 1

Seq Scan on t_dependenciasjudiciales deu (cost=0.00..16.04 rows=704 width=33) (actual time=0.007..0.259 rows=711 loops=1)

27. 0.309 0.618 ↓ 1.0 711 1

Hash (cost=16.04..16.04 rows=704 width=33) (actual time=0.617..0.618 rows=711 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 55kB
28. 0.309 0.309 ↓ 1.0 711 1

Seq Scan on t_dependenciasjudiciales deuf (cost=0.00..16.04 rows=704 width=33) (actual time=0.013..0.309 rows=711 loops=1)

29. 0.298 16.238 ↓ 1.0 711 1

Hash (cost=16.04..16.04 rows=704 width=33) (actual time=16.237..16.238 rows=711 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 55kB
30. 15.940 15.940 ↓ 1.0 711 1

Seq Scan on t_dependenciasjudiciales ded (cost=0.00..16.04 rows=704 width=33) (actual time=0.004..15.940 rows=711 loops=1)

31. 188.559 188.559 ↑ 1.0 1 2,993

Index Scan using ix_personasfisicas_1 on t_personasfisicas pf (cost=0.43..6.72 rows=1 width=25) (actual time=0.057..0.063 rows=1 loops=2,993)

  • Index Cond: ((exp.idpersona)::integer = (idpersona)::integer)
32. 2.993 2.993 ↓ 0.0 0 2,993

Index Scan using ix_personasfisicas_1 on t_personasfisicas pfj (cost=0.43..6.72 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=2,993)

  • Index Cond: ((exp.idpersonajuez)::integer = (idpersona)::integer)
33. 29.930 29.930 ↓ 0.0 0 2,993

Index Scan using ix_personasfisicas_1 on t_personasfisicas pff (cost=0.43..6.72 rows=1 width=25) (actual time=0.006..0.010 rows=0 loops=2,993)

  • Index Cond: ((exp.idpersonafiscal)::integer = (idpersona)::integer)
34. 0.011 0.037 ↓ 1.4 15 1

Hash (cost=1.11..1.11 rows=11 width=36) (actual time=0.036..0.037 rows=15 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
35. 0.026 0.026 ↓ 1.4 15 1

Seq Scan on t_situacionesexpedientes se (cost=0.00..1.11 rows=11 width=36) (actual time=0.020..0.026 rows=15 loops=1)

36. 0.006 0.013 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=36) (actual time=0.012..0.013 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
37. 0.007 0.007 ↑ 1.0 7 1

Seq Scan on t_tiposingresoexpedientes tie (cost=0.00..1.07 rows=7 width=36) (actual time=0.004..0.007 rows=7 loops=1)

38.          

SubPlan (for Hash Left Join)

39. 86.797 125.706 ↓ 0.0 0 2,993

Nested Loop (cost=4.51..89.51 rows=9 width=4) (actual time=0.042..0.042 rows=0 loops=2,993)

40. 17.958 38.909 ↓ 0.0 0 2,993

Bitmap Heap Scan on t_incidentes i (cost=4.22..14.76 rows=9 width=4) (actual time=0.013..0.013 rows=0 loops=2,993)

  • Recheck Cond: ((idexpedienteincidente)::integer = (exp.idexpediente)::integer)
41. 20.951 20.951 ↓ 0.0 0 2,993

Bitmap Index Scan on ix_fk_exp_inc_400098 (cost=0.00..4.22 rows=9 width=0) (actual time=0.007..0.007 rows=0 loops=2,993)

  • Index Cond: ((idexpedienteincidente)::integer = (exp.idexpediente)::integer)
42. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_gestiones on t_gestiones g (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: ((idgestion)::integer = (i.idgestion)::integer)
43. 30,812.935 30,812.935 ↑ 1.0 1 2,993

Index Scan using ix_fk_exp_ges_400044 on t_gestiones g_1 (cost=0.29..18.11 rows=1 width=0) (actual time=10.295..10.295 rows=1 loops=2,993)

  • Index Cond: ((idexpediente)::integer = (exp.idexpediente)::integer)
  • Filter: ((exp.spc_f_expedientepermisos_verifica(exp.idexpediente, idgestion, ('GESTION_VER'::character varying(50))::pub.descripcion))::integer = 1)
  • Rows Removed by Filter: 0
Planning time : 6.166 ms