explain.depesz.com

PostgreSQL's explain analyze made readable

Result: juwz

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 784.726 ↑ 252.5 24 1

Hash Left Join (cost=2,783.05..7,383.15 rows=6,061 width=3,736) (actual time=784.015..784.726 rows=24 loops=1)

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

Hash Left Join (cost=2,762.71..7,145.87 rows=2,405 width=3,424) (actual time=783.795..784.490 rows=24 loops=1)

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

Hash Left Join (cost=2,760.81..7,121.13 rows=2,405 width=3,384) (actual time=783.753..784.408 rows=24 loops=1)

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

Hash Left Join (cost=2,744.52..7,098.45 rows=2,405 width=3,356) (actual time=783.664..784.306 rows=24 loops=1)

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

Hash Left Join (cost=2,742.71..7,090.19 rows=2,405 width=3,208) (actual time=783.562..784.189 rows=24 loops=1)

  • Hash Cond: ((docdeu.tipdoc)::text = (tipdoc.tipdoc)::text)
6. 0.033 784.067 ↑ 100.2 24 1

Nested Loop (cost=2,735.22..7,055.04 rows=2,405 width=3,246) (actual time=783.456..784.067 rows=24 loops=1)

7. 0.248 783.914 ↑ 100.2 24 1

Hash Right Join (cost=2,734.80..2,909.66 rows=2,405 width=3,110) (actual time=783.426..783.914 rows=24 loops=1)

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

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

9. 0.147 783.359 ↑ 133.6 18 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 47kB
10. 783.212 783.212 ↑ 133.6 18 1

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

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

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

  • Index Cond: (nit = docdeu.nit)
12. 0.029 0.087 ↑ 1.0 155 1

Hash (cost=5.55..5.55 rows=155 width=38) (actual time=0.087..0.087 rows=155 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
13. 0.058 0.058 ↑ 1.0 155 1

Seq Scan on tipdoc (cost=0.00..5.55 rows=155 width=38) (actual time=0.022..0.058 rows=155 loops=1)

14. 0.012 0.056 ↑ 1.0 36 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
15. 0.044 0.044 ↑ 1.0 36 1

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

16. 0.032 0.079 ↑ 2.3 139 1

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

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

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

18. 0.016 0.028 ↑ 1.0 40 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
19. 0.012 0.012 ↑ 1.0 40 1

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

20. 0.101 0.208 ↑ 1.0 504 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
21. 0.107 0.107 ↑ 1.0 504 1

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

Planning time : 1.758 ms
Execution time : 784.884 ms