explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mBvn

Settings
# exclusive inclusive rows x rows loops node
1. 30.635 68,149.329 ↑ 1.0 1 1

Hash Join (cost=42,606.64..119,697.53 rows=1 width=4) (actual time=636.678..68,149.329 rows=1 loops=1)

  • Hash Cond: ((g.idgestion)::integer = (m.idgestion)::integer)
2. 67,085.684 68,118.647 ↓ 1.0 41,271 1

Hash Join (cost=42,581.70..119,105.78 rows=41,222 width=648) (actual time=534.446..68,118.647 rows=41,271 loops=1)

  • Hash Cond: ((g.idtipogestion)::integer = (tg.idtipogestion)::integer)
3. 119.734 1,032.921 ↓ 1.0 41,271 1

Hash Left Join (cost=42,576.63..98,273.46 rows=41,222 width=16) (actual time=515.750..1,032.921 rows=41,271 loops=1)

  • Hash Cond: ((g.idpersonamodifica)::integer = (perm.idpersona)::integer)
4. 22.511 400.608 ↓ 1.0 41,271 1

Hash Join (cost=250.76..50,331.79 rows=41,222 width=20) (actual time=2.625..400.608 rows=41,271 loops=1)

  • Hash Cond: ((g.idestadogestion)::integer = (eg.idestadogestion)::integer)
5. 21.705 378.091 ↓ 1.0 41,271 1

Hash Join (cost=249.65..50,130.76 rows=41,222 width=24) (actual time=2.610..378.091 rows=41,271 loops=1)

  • Hash Cond: ((ex.idproceso)::integer = (p.idproceso)::integer)
6. 30.150 356.373 ↓ 1.0 41,271 1

Hash Join (cost=248.36..49,985.98 rows=41,222 width=28) (actual time=2.582..356.373 rows=41,271 loops=1)

  • Hash Cond: ((g.idexpediente)::integer = (ex.idexpediente)::integer)
7. 110.994 323.798 ↓ 1.0 41,271 1

Merge Left Join (cost=2.56..49,631.87 rows=41,222 width=20) (actual time=0.119..323.798 rows=41,271 loops=1)

  • Merge Cond: ((g.idpersonainicia)::integer = (peri.idpersona)::integer)
8. 29.257 29.257 ↓ 1.0 41,271 1

Index Scan using ix_fk_p_ges_400152 on t_gestiones g (cost=0.29..4,378.61 rows=41,222 width=32) (actual time=0.010..29.257 rows=41,271 loops=1)

9. 183.547 183.547 ↓ 1.0 1,207,305 1

Index Only Scan using ix_fk_p_pf_202114 on t_personasfisicas peri (cost=0.43..41,824.71 rows=1,168,483 width=4) (actual time=0.025..183.547 rows=1,207,305 loops=1)

  • Heap Fetches: 1,207,305
10. 0.989 2.425 ↓ 1.0 4,490 1

Hash (cost=189.80..189.80 rows=4,480 width=8) (actual time=2.425..2.425 rows=4,490 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 240kB
11. 1.436 1.436 ↓ 1.0 4,490 1

Seq Scan on t_expedientes ex (cost=0.00..189.80 rows=4,480 width=8) (actual time=0.003..1.436 rows=4,490 loops=1)

12. 0.008 0.013 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=4) (actual time=0.013..0.013 rows=13 loops=1)

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

Seq Scan on t_procesos p (cost=0.00..1.13 rows=13 width=4) (actual time=0.003..0.005 rows=13 loops=1)

14. 0.003 0.006 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=4) (actual time=0.006..0.006 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
15. 0.003 0.003 ↑ 1.0 5 1

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

16. 287.396 512.579 ↑ 1.0 1,167,992 1

Hash (cost=23,154.83..23,154.83 rows=1,168,483 width=4) (actual time=512.579..512.579 rows=1,167,992 loops=1)

  • Buckets: 131,072 Batches: 16 Memory Usage: 3,596kB
17. 225.183 225.183 ↑ 1.0 1,167,992 1

Seq Scan on t_personasfisicas perm (cost=0.00..23,154.83 rows=1,168,483 width=4) (actual time=0.009..225.183 rows=1,167,992 loops=1)

18. 0.022 0.042 ↓ 1.0 93 1

Hash (cost=3.92..3.92 rows=92 width=4) (actual time=0.042..0.042 rows=93 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
19. 0.020 0.020 ↓ 1.0 93 1

Seq Scan on t_tiposgestiones tg (cost=0.00..3.92 rows=92 width=4) (actual time=0.003..0.020 rows=93 loops=1)

20. 0.005 0.047 ↑ 1.0 1 1

Hash (cost=24.92..24.92 rows=1 width=4) (actual time=0.047..0.047 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
21. 0.001 0.042 ↑ 1.0 1 1

Nested Loop (cost=0.83..24.92 rows=1 width=4) (actual time=0.041..0.042 rows=1 loops=1)

22. 0.002 0.032 ↑ 1.0 1 1

Nested Loop (cost=0.55..16.61 rows=1 width=8) (actual time=0.031..0.032 rows=1 loops=1)

23. 0.015 0.015 ↑ 1.0 1 1

Index Scan using pk_movimientos on t_movimientos m (cost=0.28..8.29 rows=1 width=16) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: ((idmovimiento)::integer = 7,344)
24. 0.015 0.015 ↑ 1.0 1 1

Index Only Scan using pk_dependenciasjudiciales on t_dependenciasjudiciales dorig (cost=0.28..8.29 rows=1 width=4) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (iddependenciajudicial = (m.iddeporigen)::integer)
  • Heap Fetches: 1
25. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using pk_dependenciasjudiciales on t_dependenciasjudiciales ddest (cost=0.28..8.29 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (iddependenciajudicial = (m.iddepdestino)::integer)
  • Heap Fetches: 1
Planning time : 5.269 ms