explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ej7N

Settings
# exclusive inclusive rows x rows loops node
1. 35.715 108,750.916 ↑ 1.0 1 1

Hash Join (cost=42,595.16..120,184.48 rows=1 width=4) (actual time=625.917..108,750.916 rows=1 loops=1)

  • Hash Cond: ((g.idgestion)::integer = (m.idgestion)::integer)
2. 106,939.696 108,715.183 ↓ 1.0 42,325 1

Hash Join (cost=42,570.23..119,582.98 rows=41,931 width=648) (actual time=527.820..108,715.183 rows=42,325 loops=1)

  • Hash Cond: ((g.idtipogestion)::integer = (tg.idtipogestion)::integer)
3. 34.465 1,775.449 ↓ 1.0 42,325 1

Hash Join (cost=42,565.16..98,392.44 rows=41,931 width=16) (actual time=519.544..1,775.449 rows=42,325 loops=1)

  • Hash Cond: ((g.idestadogestion)::integer = (eg.idestadogestion)::integer)
4. 346.068 1,740.979 ↓ 1.0 42,325 1

Hash Left Join (cost=42,564.04..98,187.97 rows=41,931 width=20) (actual time=519.533..1,740.979 rows=42,325 loops=1)

  • Hash Cond: ((g.idpersonamodifica)::integer = (perm.idpersona)::integer)
5. 33.042 878.304 ↓ 1.0 42,325 1

Hash Join (cost=250.77..50,243.15 rows=41,931 width=24) (actual time=2.803..878.304 rows=42,325 loops=1)

  • Hash Cond: ((ex.idproceso)::integer = (p.idproceso)::integer)
6. 40.000 845.254 ↓ 1.0 42,325 1

Hash Join (cost=249.48..50,095.91 rows=41,931 width=28) (actual time=2.790..845.254 rows=42,325 loops=1)

  • Hash Cond: ((g.idexpediente)::integer = (ex.idexpediente)::integer)
7. 244.417 802.590 ↓ 1.0 42,325 1

Merge Left Join (cost=2.56..49,738.81 rows=41,931 width=20) (actual time=0.113..802.590 rows=42,325 loops=1)

  • Merge Cond: ((g.idpersonainicia)::integer = (peri.idpersona)::integer)
8. 55.096 55.096 ↓ 1.0 42,325 1

Index Scan using ix_fk_p_ges_400152 on t_gestiones g (cost=0.29..4,485.23 rows=41,931 width=32) (actual time=0.007..55.096 rows=42,325 loops=1)

9. 503.077 503.077 ↓ 1.0 1,208,335 1

Index Only Scan using ix_fk_p_pf_202114 on t_personasfisicas peri (cost=0.43..41,817.64 rows=1,168,012 width=4) (actual time=0.023..503.077 rows=1,208,335 loops=1)

  • Heap Fetches: 1,208,335
10. 0.997 2.664 ↓ 1.0 4,600 1

Hash (cost=190.30..190.30 rows=4,530 width=8) (actual time=2.664..2.664 rows=4,600 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 244kB
11. 1.667 1.667 ↓ 1.0 4,600 1

Seq Scan on t_expedientes ex (cost=0.00..190.30 rows=4,530 width=8) (actual time=0.003..1.667 rows=4,600 loops=1)

12. 0.003 0.008 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=4) (actual time=0.008..0.008 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. 289.753 516.607 ↓ 1.0 1,168,014 1

Hash (cost=23,150.12..23,150.12 rows=1,168,012 width=4) (actual time=516.607..516.607 rows=1,168,014 loops=1)

  • Buckets: 131,072 Batches: 16 Memory Usage: 3,596kB
15. 226.854 226.854 ↓ 1.0 1,168,014 1

Seq Scan on t_personasfisicas perm (cost=0.00..23,150.12 rows=1,168,012 width=4) (actual time=0.008..226.854 rows=1,168,014 loops=1)

16. 0.002 0.005 ↑ 1.0 5 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 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)

18. 0.017 0.038 ↑ 1.0 92 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
19. 0.021 0.021 ↑ 1.0 92 1

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

20. 0.001 0.018 ↑ 1.0 1 1

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

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

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

22. 0.002 0.013 ↑ 1.0 1 1

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

23. 0.007 0.007 ↑ 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.007..0.007 rows=1 loops=1)

  • Index Cond: ((idmovimiento)::integer = 7,344)
24. 0.004 0.004 ↑ 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.004..0.004 rows=1 loops=1)

  • Index Cond: (iddependenciajudicial = (m.iddeporigen)::integer)
  • Heap Fetches: 1
25. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

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