explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8qiF

Settings
# exclusive inclusive rows x rows loops node
1. 0.102 787.985 ↑ 252.5 24 1

Hash Left Join (cost=2,786.41..7,544.48 rows=6,061 width=4,442) (actual time=787.007..787.985 rows=24 loops=1)

  • Hash Cond: (nits.cod_actividad_economica = actividad_itau.cod_actividad_economica)
2. 0.071 787.635 ↑ 100.2 24 1

Hash Left Join (cost=2,766.07..7,155.68 rows=2,405 width=3,982) (actual time=786.723..787.635 rows=24 loops=1)

  • Hash Cond: ((nits.cod_segmento_gest)::text = textin(int2out(subsegmento_itau.cls_segmento)))
3. 0.028 787.533 ↑ 100.2 24 1

Hash Left Join (cost=2,764.17..7,130.93 rows=2,405 width=3,942) (actual time=786.669..787.533 rows=24 loops=1)

  • Hash Cond: (docdeu.codcob_ultimo = estcob.codcob)
4. 0.032 787.423 ↑ 100.2 24 1

Hash Left Join (cost=2,747.88..7,108.25 rows=2,405 width=3,914) (actual time=786.573..787.423 rows=24 loops=1)

  • Hash Cond: (nits.tipo_iden = tipo_documento_itau.tip_doc_id)
5. 0.028 787.363 ↑ 100.2 24 1

Hash Left Join (cost=2,746.07..7,100.00 rows=2,405 width=3,750) (actual time=786.529..787.363 rows=24 loops=1)

  • Hash Cond: (sn.conspolitica = cp.consecutivo)
6. 0.051 787.286 ↑ 100.2 24 1

Hash Left Join (cost=2,742.71..7,090.19 rows=2,405 width=3,540) (actual time=786.466..787.286 rows=24 loops=1)

  • Hash Cond: ((docdeu.tipdoc)::text = (tipdoc.tipdoc)::text)
7. 0.057 787.126 ↑ 100.2 24 1

Nested Loop (cost=2,735.22..7,055.04 rows=2,405 width=3,514) (actual time=786.329..787.126 rows=24 loops=1)

8. 0.293 786.901 ↑ 100.2 24 1

Hash Right Join (cost=2,734.80..2,909.66 rows=2,405 width=3,298) (actual time=786.284..786.901 rows=24 loops=1)

  • Hash Cond: (sn.consdocdeu = docdeu.consdocdeu)
9. 0.430 0.430 ↑ 2.3 1,257 1

Seq Scan on segui_negociaciones sn (cost=0.00..167.40 rows=2,840 width=16) (actual time=0.016..0.430 rows=1,257 loops=1)

10. 0.208 786.178 ↑ 133.6 18 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 48kB
11. 785.970 785.970 ↑ 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=91.316..785.970 rows=18 loops=1)

  • Index Cond: (estado = 'A'::bpchar)
  • Filter: (meses_transcurridos_neg IS NOT NULL)
  • Rows Removed by Filter: 356692
12. 0.168 0.168 ↑ 1.0 1 24

Index Scan using nits_nit on nits (cost=0.42..1.72 rows=1 width=224) (actual time=0.007..0.007 rows=1 loops=24)

  • Index Cond: (nit = docdeu.nit)
13. 0.048 0.109 ↑ 1.0 155 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
14. 0.061 0.061 ↑ 1.0 155 1

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

15. 0.009 0.049 ↓ 1.2 20 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
16. 0.040 0.040 ↓ 1.2 20 1

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

17. 0.013 0.028 ↑ 1.0 36 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
18. 0.015 0.015 ↑ 1.0 36 1

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

19. 0.036 0.082 ↑ 2.3 139 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
20. 0.046 0.046 ↑ 2.3 141 1

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

21. 0.018 0.031 ↑ 1.0 40 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
22. 0.013 0.013 ↑ 1.0 40 1

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

23. 0.133 0.248 ↑ 1.0 504 1

Hash (cost=14.04..14.04 rows=504 width=248) (actual time=0.248..0.248 rows=504 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
24. 0.115 0.115 ↑ 1.0 504 1

Seq Scan on actividad_itau (cost=0.00..14.04 rows=504 width=248) (actual time=0.007..0.115 rows=504 loops=1)

Planning time : 2.360 ms
Execution time : 788.190 ms