explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HVI : Optimization for: plan #jMue

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.006 19.042 ↑ 1.0 1 1

Unique (cost=1.69..2,304.32 rows=1 width=417) (actual time=18.997..19.042 rows=1 loops=1)

2. 0.062 19.036 ↑ 4.0 1 1

Nested Loop Left Join (cost=1.69..2,304.32 rows=4 width=417) (actual time=18.992..19.036 rows=1 loops=1)

  • Join Filter: ((cstram.id_grupo = gs.id_grupo) OR (gs.id_grupo = cs.id_grupo))
  • Rows Removed by Join Filter: 6
3. 0.043 18.900 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.69..2,302.93 rows=2 width=385) (actual time=18.868..18.900 rows=1 loops=1)

  • Join Filter: ((cs.id = sp.idservicio) OR (cs.id = ct.id_servicio))
  • Rows Removed by Join Filter: 106
4. 0.004 18.814 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..2,297.26 rows=1 width=369) (actual time=18.785..18.814 rows=1 loops=1)

  • Join Filter: (zc.id = se.id_zofemat)
5. 0.003 18.805 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..2,286.36 rows=1 width=295) (actual time=18.776..18.805 rows=1 loops=1)

  • Join Filter: (ce.id = se.id_comercio)
6. 0.010 18.792 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..2,275.68 rows=1 width=221) (actual time=18.764..18.792 rows=1 loops=1)

7. 0.124 18.778 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.41..2,273.18 rows=1 width=197) (actual time=18.750..18.778 rows=1 loops=1)

  • Join Filter: ((eeg.cve_usuario_entrega)::text = (cu.c_cve_usuario)::text)
  • Rows Removed by Join Filter: 450
8. 0.006 18.488 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.41..2,255.05 rows=1 width=181) (actual time=18.461..18.488 rows=1 loops=1)

  • Join Filter: (se.id = eeg.id_tramite)
9. 0.004 0.364 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.41..14.06 rows=1 width=160) (actual time=0.338..0.364 rows=1 loops=1)

  • Join Filter: (sp.id = sd.id_servicio_param)
  • Rows Removed by Join Filter: 1
10. 0.005 0.350 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.41..13.04 rows=1 width=149) (actual time=0.325..0.350 rows=1 loops=1)

11. 0.004 0.336 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.27..12.85 rows=1 width=105) (actual time=0.317..0.336 rows=1 loops=1)

12. 0.011 0.321 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.13..10.48 rows=1 width=96) (actual time=0.304..0.321 rows=1 loops=1)

13. 0.003 0.219 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.70..7.82 rows=1 width=84) (actual time=0.206..0.219 rows=1 loops=1)

  • Join Filter: (sd.id_solicitud = se.id)
14. 0.005 0.199 ↑ 1.0 1 1

Nested Loop (cost=0.70..6.26 rows=1 width=80) (actual time=0.188..0.199 rows=1 loops=1)

15. 0.016 0.184 ↑ 1.0 1 1

Nested Loop (cost=0.42..3.75 rows=1 width=56) (actual time=0.176..0.184 rows=1 loops=1)

  • Join Filter: ((se.estatus)::text = (est.estatus)::text)
  • Rows Removed by Join Filter: 4
16. 0.148 0.148 ↑ 1.0 1 1

Index Scan using idx_sol_enc_id on solicitud_encabezado se (cost=0.42..2.64 rows=1 width=49) (actual time=0.147..0.148 rows=1 loops=1)

  • Index Cond: (id = 189956)
17. 0.020 0.020 ↑ 1.0 5 1

Seq Scan on cat_estatus_solicitud est (cost=0.00..1.05 rows=5 width=11) (actual time=0.017..0.020 rows=5 loops=1)

18. 0.010 0.010 ↑ 1.0 1 1

Index Scan using idx_cat_pers_sol on cat_personas_solicitante cps (cost=0.28..2.50 rows=1 width=28) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (id = se.id_solicitante)
19. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on solicitud_detalle sd (cost=0.00..1.55 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: (id_solicitud = 189956)
  • Rows Removed by Filter: 44
20. 0.091 0.091 ↑ 1.0 1 1

Index Scan using idx_pad_comprob on padron padr (cost=0.42..2.64 rows=1 width=22) (actual time=0.089..0.091 rows=1 loops=1)

  • Index Cond: ((se.e_cuenta = e_cuenta) AND ((se.tipo_predio)::text = (tipo_predio)::text))
21. 0.011 0.011 ↑ 1.0 1 1

Index Scan using idx_cat_tram_id on cat_tramites ct (cost=0.14..2.36 rows=1 width=13) (actual time=0.009..0.011 rows=1 loops=1)

  • Index Cond: (id = se.id_tipo_tramite)
22. 0.009 0.009 ↑ 1.0 1 1

Index Scan using pk_servicio on cat_servicios cstram (cost=0.14..0.18 rows=1 width=48) (actual time=0.006..0.009 rows=1 loops=1)

  • Index Cond: (id = ct.id_servicio)
23. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on cat_servicio_param sp (cost=0.00..1.01 rows=1 width=19) (actual time=0.010..0.010 rows=1 loops=1)

24. 18.118 18.118 ↓ 0.0 0 1

Seq Scan on e_entregas_gestion eeg (cost=0.00..2,240.98 rows=1 width=25) (actual time=18.118..18.118 rows=0 loops=1)

  • Filter: (id_tramite = 189956)
  • Rows Removed by Filter: 112198
25. 0.166 0.166 ↑ 1.0 450 1

Seq Scan on cat_usuarios cu (cost=0.00..12.50 rows=450 width=33) (actual time=0.040..0.166 rows=450 loops=1)

26. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx_cat_pers_sol on cat_personas_solicitante sol_ent (cost=0.28..2.50 rows=1 width=28) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (eeg.id_solicitante_entrega = id)
27. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on comercio_establecimientos ce (cost=0.00..10.30 rows=30 width=82) (actual time=0.010..0.010 rows=0 loops=1)

28. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on zofemat_concesion zc (cost=0.00..10.40 rows=40 width=82) (actual time=0.005..0.005 rows=0 loops=1)

29. 0.043 0.043 ↑ 1.0 107 1

Seq Scan on cat_servicios cs (cost=0.00..4.07 rows=107 width=20) (actual time=0.012..0.043 rows=107 loops=1)

30. 0.054 0.074 ↑ 1.0 7 1

Materialize (cost=0.00..1.11 rows=7 width=12) (actual time=0.067..0.074 rows=7 loops=1)

31. 0.020 0.020 ↑ 1.0 7 1

Seq Scan on cat_grupo_servicios gs (cost=0.00..1.07 rows=7 width=12) (actual time=0.017..0.020 rows=7 loops=1)

Planning time : 15.550 ms
Execution time : 19.663 ms