explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TQDj

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 753.173 ↓ 0.0 0 1

Nested Loop Left Join (cost=2,750.20..3,008.39 rows=91 width=4,442) (actual time=753.173..753.173 rows=0 loops=1)

2. 0.001 753.172 ↓ 0.0 0 1

Hash Left Join (cost=2,749.93..2,993.33 rows=36 width=3,982) (actual time=753.172..753.172 rows=0 loops=1)

  • Hash Cond: ((nits.cod_segmento_gest)::text = textin(int2out(subsegmento_itau.cls_segmento)))
3. 0.000 753.171 ↓ 0.0 0 1

Nested Loop Left Join (cost=2,748.03..2,991.09 rows=36 width=3,942) (actual time=753.171..753.171 rows=0 loops=1)

4. 0.001 753.171 ↓ 0.0 0 1

Hash Left Join (cost=2,747.88..2,984.97 rows=36 width=3,914) (actual time=753.171..753.171 rows=0 loops=1)

  • Hash Cond: (nits.tipo_iden = tipo_documento_itau.tip_doc_id)
5. 0.000 753.170 ↓ 0.0 0 1

Hash Left Join (cost=2,746.07..2,983.06 rows=36 width=3,750) (actual time=753.170..753.170 rows=0 loops=1)

  • Hash Cond: (sn.conspolitica = cp.consecutivo)
6. 0.001 753.170 ↓ 0.0 0 1

Hash Left Join (cost=2,742.71..2,979.61 rows=36 width=3,540) (actual time=753.170..753.170 rows=0 loops=1)

  • Hash Cond: ((docdeu.tipdoc)::text = (tipdoc.tipdoc)::text)
7. 0.000 753.169 ↓ 0.0 0 1

Nested Loop (cost=2,735.22..2,971.71 rows=36 width=3,514) (actual time=753.169..753.169 rows=0 loops=1)

8. 0.227 753.169 ↓ 0.0 0 1

Hash Right Join (cost=2,734.80..2,909.66 rows=36 width=3,298) (actual time=753.168..753.169 rows=0 loops=1)

  • Hash Cond: (sn.consdocdeu = docdeu.consdocdeu)
  • Filter: ((sn.conspolitica IS NULL) OR ((sn.estado_neg)::text = ANY ('{C,RC}'::text[])))
  • Rows Removed by Filter: 24
9. 0.314 0.314 ↑ 2.3 1,257 1

Seq Scan on segui_negociaciones sn (cost=0.00..167.40 rows=2,840 width=32) (actual time=0.017..0.314 rows=1,257 loops=1)

10. 0.142 752.628 ↑ 133.6 18 1

Hash (cost=2,704.74..2,704.74 rows=2,405 width=3,290) (actual time=752.627..752.628 rows=18 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 48kB
11. 752.486 752.486 ↑ 133.6 18 1

Index Scan using docdeu_estado_idx on docdeu (cost=0.42..2,704.74 rows=2,405 width=3,290) (actual time=84.613..752.486 rows=18 loops=1)

  • Index Cond: (estado = 'A'::bpchar)
  • Filter: (meses_transcurridos_neg IS NOT NULL)
  • Rows Removed by Filter: 356,692
12. 0.000 0.000 ↓ 0.0 0

Index Scan using nits_nit on nits (cost=0.42..1.72 rows=1 width=224) (never executed)

  • Index Cond: (nit = docdeu.nit)
13. 0.000 0.000 ↓ 0.0 0

Hash (cost=5.55..5.55 rows=155 width=102) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on tipdoc (cost=0.00..5.55 rows=155 width=102) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.16..3.16 rows=16 width=222) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on condonacion_politica cp (cost=0.00..3.16 rows=16 width=222) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.36..1.36 rows=36 width=184) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on tipo_documento_itau (cost=0.00..1.36 rows=36 width=184) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Index Scan using i_estcob_codcob_key on estcob (cost=0.15..0.17 rows=1 width=36) (never executed)

  • Index Cond: (docdeu.codcob_ultimo = codcob)
20. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.40..1.40 rows=40 width=166) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on subsegmento_itau (cost=0.00..1.40 rows=40 width=166) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Index Scan using i_actividad_itau_cod_actividad_economica_cod_canasto_activida on actividad_itau (cost=0.27..0.33 rows=3 width=248) (never executed)

  • Index Cond: (nits.cod_actividad_economica = cod_actividad_economica)
Planning time : 2.242 ms
Execution time : 753.361 ms