explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QayK

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 4.043 ↑ 1.0 1 1

GroupAggregate (cost=513.38..515.88 rows=1 width=796) (actual time=4.043..4.043 rows=1 loops=1)

  • Group Key: s.sgd_exp_numero
  • Execution Time: 4.158 ms(30 filas)
2. 0.007 3.999 ↑ 1.0 1 1

Sort (cost=513.38..513.38 rows=1 width=732) (actual time=3.999..3.999 rows=1 loops=1)

  • Sort Key: s.sgd_exp_numero
  • Sort Method: quicksort Memory: 25kB
3. 0.002 3.992 ↑ 1.0 1 1

Nested Loop (cost=0.70..513.37 rows=1 width=732) (actual time=0.874..3.992 rows=1 loops=1)

4. 0.008 3.984 ↑ 1.0 1 1

Nested Loop (cost=0.43..513.06 rows=1 width=719) (actual time=0.867..3.984 rows=1 loops=1)

  • Join Filter: (s.sgd_srd_codigo = se.sgd_srd_codigo)
  • Rows Removed by Join Filter: 49
5. 0.001 3.969 ↑ 1.0 1 1

Nested Loop (cost=0.43..510.98 rows=1 width=189) (actual time=0.862..3.969 rows=1 loops=1)

6. 0.010 3.961 ↑ 1.0 1 1

Nested Loop (cost=0.29..510.81 rows=1 width=179) (actual time=0.855..3.961 rows=1 loops=1)

  • Join Filter: (s.depe_codi = d.depe_codi)
  • Rows Removed by Join Filter: 58
7. 0.005 3.942 ↑ 1.0 1 1

Nested Loop (cost=0.29..506.74 rows=1 width=151) (actual time=0.836..3.942 rows=1 loops=1)

8. 3.923 3.923 ↑ 1.0 1 1

Seq Scan on sgd_exp_expediente e (cost=0.00..504.44 rows=1 width=87) (actual time=0.818..3.923 rows=1 loops=1)

  • Filter: ((sgd_exp_estado <> '2'::numeric) AND (((radi_nume_radi)::character varying)::text ~~ '%2020009000003422%'::text))
  • Rows Removed by Filter: 11,086
9. 0.014 0.014 ↑ 1.0 1 1

Index Scan using idx_sexp on sgd_sexp_secexpedientes s (cost=0.29..2.30 rows=1 width=132) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: ((sgd_exp_numero)::text = (e.sgd_exp_numero)::text)
10. 0.009 0.009 ↑ 1.6 59 1

Seq Scan on dependencia d (cost=0.00..2.92 rows=92 width=33) (actual time=0.006..0.009 rows=59 loops=1)

11. 0.007 0.007 ↑ 1.0 1 1

Index Scan using "idx_UsuarioUsuaDoc" on usuario u (cost=0.14..0.16 rows=1 width=28) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: ((usua_doc)::text = (s.usua_doc_responsable)::text)
12. 0.007 0.007 ↓ 1.0 50 1

Seq Scan on sgd_srd_seriesrd se (cost=0.00..1.48 rows=48 width=530) (actual time=0.004..0.007 rows=50 loops=1)

13. 0.006 0.006 ↑ 1.0 1 1

Index Scan using idx_sbrd on sgd_sbrd_subserierd su (cost=0.27..0.29 rows=1 width=47) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: ((sgd_srd_codigo = s.sgd_srd_codigo) AND (sgd_sbrd_codigo = s.sgd_sbrd_codigo))
14.          

SubPlan (for GroupAggregate)

15. 0.024 0.024 ↑ 1.0 1 1

Index Scan using radicado_radi_nume_radi_ra_asun_idx on radicado r (cost=0.42..2.44 rows=1 width=24) (actual time=0.023..0.024 rows=1 loops=1)

  • Index Cond: (radi_nume_radi = min(e.radi_nume_radi))
Planning time : 1.293 ms