explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vQJl

Settings
# exclusive inclusive rows x rows loops node
1. 1,400.671 7,477.749 ↓ 146.6 352,693 1

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

  • Hash Cond: ((nits.cod_segmento_gest)::text = textin(int2out(subsegmento_itau.cls_segmento)))
2. 219.674 6,077.043 ↓ 146.6 352,693 1

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

  • Hash Cond: (docdeu.codcob_ultimo = estcob.codcob)
3. 243.777 5,857.262 ↓ 146.6 352,693 1

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

  • Hash Cond: (nits.tipo_iden = tipo_documento_itau.tip_doc_id)
4. 150.316 5,613.455 ↓ 146.6 352,693 1

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

  • Hash Cond: (sn.conspolitica = cp.consecutivo)
5. 315.619 5,463.112 ↓ 146.6 352,693 1

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

  • Hash Cond: ((docdeu.tipdoc)::text = (tipdoc.tipdoc)::text)
6. 802.677 5,147.376 ↓ 146.6 352,693 1

Nested Loop (cost=2,735.38..7,052.33 rows=2,406 width=3,460) (actual time=2,006.722..5,147.376 rows=352,693 loops=1)

7. 914.453 2,921.319 ↓ 147.9 355,845 1

Hash Right Join (cost=2,734.96..2,909.82 rows=2,406 width=3,248) (actual time=2,006.659..2,921.319 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.471 0.471 ↑ 2.3 1,257 1

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

9. 1,002.272 2,006.395 ↓ 147.5 356,710 1

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

  • Buckets: 131072 (originally 4096) Batches: 4 (originally 1) Memory Usage: 101377kB
10. 1,004.123 1,004.123 ↓ 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.055..1,004.123 rows=356,710 loops=1)

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

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

  • Index Cond: (nit = docdeu.nit)
12. 0.047 0.117 ↑ 1.0 155 1

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

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

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

14. 0.008 0.027 ↓ 1.2 20 1

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

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

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

16. 0.012 0.030 ↑ 1.0 36 1

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

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

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

18. 0.037 0.107 ↑ 2.3 139 1

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

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

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

20. 0.018 0.035 ↑ 1.0 40 1

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

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

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

Planning time : 2.408 ms
Execution time : 7,517.939 ms