explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eIYW

Settings
# exclusive inclusive rows x rows loops node
1. 1,457.998 8,925.935 ↓ 146.6 352,693 1

Hash Left Join (cost=2,766.23..7,213.15 rows=2,406 width=4,148) (actual time=1,921.520..8,925.935 rows=352,693 loops=1)

  • Hash Cond: ((nits.cod_segmento_gest)::text = textin(int2out(subsegmento_itau.cls_segmento)))
2. 221.380 7,467.900 ↓ 146.6 352,693 1

Hash Left Join (cost=2,764.33..7,128.24 rows=2,406 width=3,888) (actual time=1,921.419..7,467.900 rows=352,693 loops=1)

  • Hash Cond: (docdeu.codcob_ultimo = estcob.codcob)
3. 242.894 7,246.423 ↓ 146.6 352,693 1

Hash Left Join (cost=2,748.04..7,105.56 rows=2,406 width=3,860) (actual time=1,921.292..7,246.423 rows=352,693 loops=1)

  • Hash Cond: (nits.tipo_iden = tipo_documento_itau.tip_doc_id)
4. 146.990 7,003.493 ↓ 146.6 352,693 1

Hash Left Join (cost=2,746.23..7,097.30 rows=2,406 width=3,696) (actual time=1,921.216..7,003.493 rows=352,693 loops=1)

  • Hash Cond: (sn.conspolitica = cp.consecutivo)
5. 329.983 6,856.474 ↓ 146.6 352,693 1

Hash Left Join (cost=2,742.87..7,087.49 rows=2,406 width=3,486) (actual time=1,921.154..6,856.474 rows=352,693 loops=1)

  • Hash Cond: ((docdeu.tipdoc)::text = (tipdoc.tipdoc)::text)
6. 498.118 6,526.355 ↓ 146.6 352,693 1

Nested Loop (cost=2,735.38..7,052.33 rows=2,406 width=3,460) (actual time=1,920.961..6,526.355 rows=352,693 loops=1)

7. 2,328.039 4,249.012 ↓ 147.9 355,845 1

Hash Right Join (cost=2,734.96..2,909.82 rows=2,406 width=3,248) (actual time=1,920.912..4,249.012 rows=355,845 loops=1)

  • Hash Cond: (sn.consdocdeu = docdeu.consdocdeu)
  • Filter: ((sn.conspolitica IS NULL) OR ((sn.estado_neg)::text = 'C'::text) OR (docdeu.meses_transcurridos_neg IS NOT NULL))
  • Rows Removed by Filter: 1111
8. 0.425 0.425 ↑ 2.3 1,257 1

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

9. 951.887 1,920.548 ↓ 147.5 356,710 1

Hash (cost=2,704.74..2,704.74 rows=2,418 width=3,240) (actual time=1,920.547..1,920.548 rows=356,710 loops=1)

  • Buckets: 131072 (originally 4096) Batches: 4 (originally 1) Memory Usage: 101377kB
10. 968.661 968.661 ↓ 147.5 356,710 1

Index Scan using docdeu_estado_idx on docdeu (cost=0.42..2,704.74 rows=2,418 width=3,240) (actual time=0.102..968.661 rows=356,710 loops=1)

  • Index Cond: (estado = 'A'::bpchar)
11. 1,779.225 1,779.225 ↑ 1.0 1 355,845

Index Scan using nits_nit on nits (cost=0.42..1.72 rows=1 width=220) (actual time=0.005..0.005 rows=1 loops=355,845)

  • Index Cond: (nit = docdeu.nit)
12. 0.050 0.136 ↑ 1.0 155 1

Hash (cost=5.55..5.55 rows=155 width=102) (actual time=0.135..0.136 rows=155 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
13. 0.086 0.086 ↑ 1.0 155 1

Seq Scan on tipdoc (cost=0.00..5.55 rows=155 width=102) (actual time=0.015..0.086 rows=155 loops=1)

14. 0.011 0.029 ↓ 1.2 20 1

Hash (cost=3.16..3.16 rows=16 width=222) (actual time=0.029..0.029 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
15. 0.018 0.018 ↓ 1.2 20 1

Seq Scan on condonacion_politica cp (cost=0.00..3.16 rows=16 width=222) (actual time=0.009..0.018 rows=20 loops=1)

16. 0.016 0.036 ↑ 1.0 36 1

Hash (cost=1.36..1.36 rows=36 width=184) (actual time=0.036..0.036 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
17. 0.020 0.020 ↑ 1.0 36 1

Seq Scan on tipo_documento_itau (cost=0.00..1.36 rows=36 width=184) (actual time=0.013..0.020 rows=36 loops=1)

18. 0.042 0.097 ↑ 2.3 139 1

Hash (cost=12.24..12.24 rows=324 width=36) (actual time=0.097..0.097 rows=139 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
19. 0.055 0.055 ↑ 2.3 141 1

Seq Scan on estcob (cost=0.00..12.24 rows=324 width=36) (actual time=0.011..0.055 rows=141 loops=1)

20. 0.022 0.037 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=166) (actual time=0.037..0.037 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
21. 0.015 0.015 ↑ 1.0 40 1

Seq Scan on subsegmento_itau (cost=0.00..1.40 rows=40 width=166) (actual time=0.008..0.015 rows=40 loops=1)

Planning time : 2.879 ms
Execution time : 8,967.615 ms