explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vWrU

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 29.188 ↑ 1.0 1 1

Unique (cost=1.69..2,282.74 rows=1 width=261) (actual time=29.138..29.188 rows=1 loops=1)

2. 0.071 29.180 ↑ 4.0 1 1

Nested Loop Left Join (cost=1.69..2,282.74 rows=4 width=261) (actual time=29.131..29.180 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.063 29.044 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.69..2,281.36 rows=2 width=229) (actual time=29.013..29.044 rows=1 loops=1)

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

Nested Loop Left Join (cost=1.69..2,275.68 rows=1 width=213) (actual time=28.889..28.917 rows=1 loops=1)

5. 0.195 28.903 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.41..2,273.18 rows=1 width=189) (actual time=28.876..28.903 rows=1 loops=1)

  • Join Filter: ((eeg.cve_usuario_entrega)::text = (cu.c_cve_usuario)::text)
  • Rows Removed by Join Filter: 450
6. 0.005 28.479 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.41..2,255.05 rows=1 width=173) (actual time=28.453..28.479 rows=1 loops=1)

  • Join Filter: (se.id = eeg.id_tramite)
7. 0.005 0.185 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.41..14.06 rows=1 width=152) (actual time=0.159..0.185 rows=1 loops=1)

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

Nested Loop Left Join (cost=1.41..13.04 rows=1 width=141) (actual time=0.139..0.164 rows=1 loops=1)

9. 0.005 0.152 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.27..12.85 rows=1 width=97) (actual time=0.132..0.152 rows=1 loops=1)

10. 0.010 0.140 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.13..10.48 rows=1 width=88) (actual time=0.124..0.140 rows=1 loops=1)

11. 0.004 0.111 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.70..7.82 rows=1 width=76) (actual time=0.097..0.111 rows=1 loops=1)

  • Join Filter: (sd.id_solicitud = se.id)
12. 0.007 0.084 ↑ 1.0 1 1

Nested Loop (cost=0.70..6.26 rows=1 width=72) (actual time=0.072..0.084 rows=1 loops=1)

13. 0.020 0.067 ↑ 1.0 1 1

Nested Loop (cost=0.42..3.75 rows=1 width=48) (actual time=0.058..0.067 rows=1 loops=1)

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

Index Scan using idx_sol_enc_id on solicitud_encabezado se (cost=0.42..2.64 rows=1 width=41) (actual time=0.023..0.025 rows=1 loops=1)

  • Index Cond: (id = 189956)
15. 0.022 0.022 ↑ 1.0 5 1

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

16. 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)
17. 0.023 0.023 ↓ 0.0 0 1

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

  • Filter: (id_solicitud = 189956)
  • Rows Removed by Filter: 44
18. 0.019 0.019 ↑ 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.018..0.019 rows=1 loops=1)

  • Index Cond: ((se.e_cuenta = e_cuenta) AND ((se.tipo_predio)::text = (tipo_predio)::text))
19. 0.007 0.007 ↑ 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.005..0.007 rows=1 loops=1)

  • Index Cond: (id = se.id_tipo_tramite)
20. 0.007 0.007 ↑ 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.004..0.007 rows=1 loops=1)

  • Index Cond: (id = ct.id_servicio)
21. 0.016 0.016 ↑ 1.0 1 1

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

22. 28.289 28.289 ↓ 0.0 0 1

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

  • Filter: (id_tramite = 189956)
  • Rows Removed by Filter: 112201
23. 0.229 0.229 ↑ 1.0 450 1

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

24. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (eeg.id_solicitante_entrega = id)
25. 0.064 0.064 ↑ 1.0 107 1

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

26. 0.045 0.065 ↑ 1.0 7 1

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

27. 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.015..0.020 rows=7 loops=1)

Planning time : 7.575 ms
Execution time : 29.811 ms