explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TVmC

Settings
# exclusive inclusive rows x rows loops node
1. 769.619 9,409.849 ↑ 1.2 336,339 1

Hash Left Join (cost=19,162.38..358,257.91 rows=413,123 width=1,459) (actual time=837.541..9,409.849 rows=336,339 loops=1)

  • Hash Cond: (nits.cod_actividad_economica = actividad_itau.cod_actividad_economica)
2. 585.133 8,639.546 ↑ 1.2 336,339 1

Hash Left Join (cost=19,142.04..342,229.06 rows=413,123 width=1,040) (actual time=836.356..8,639.546 rows=336,339 loops=1)

  • Hash Cond: ((nits.cod_segmento_gest)::text = textin(int2out(subsegmento_itau.cls_segmento)))
3. 211.327 8,053.944 ↑ 1.2 336,339 1

Hash Left Join (cost=19,140.14..338,302.49 rows=413,123 width=1,030) (actual time=835.713..8,053.944 rows=336,339 loops=1)

  • Hash Cond: (docdeu.codcob_ultimo = estcob.codcob)
4. 244.416 7,842.351 ↑ 1.2 336,339 1

Hash Left Join (cost=19,131.43..337,181.47 rows=413,123 width=1,013) (actual time=835.343..7,842.351 rows=336,339 loops=1)

  • Hash Cond: (nits.tipo_iden = tipo_documento_itau.tip_doc_id)
5. 176.791 7,597.864 ↑ 1.2 336,339 1

Hash Left Join (cost=19,129.62..335,967.54 rows=413,123 width=972) (actual time=835.017..7,597.864 rows=336,339 loops=1)

  • Hash Cond: (sn.conspolitica = cp.consecutivo)
6. 284.978 7,420.874 ↑ 1.2 336,339 1

Hash Left Join (cost=19,124.72..334,768.46 rows=413,123 width=946) (actual time=834.695..7,420.874 rows=336,339 loops=1)

  • Hash Cond: ((docdeu.tipdoc)::text = (tipdoc.tipdoc)::text)
7. 365.908 7,135.596 ↑ 1.2 336,339 1

Hash Join (cost=19,117.18..329,080.48 rows=413,123 width=938) (actual time=834.202..7,135.596 rows=336,339 loops=1)

  • Hash Cond: (docdeu.nit = nits.nit)
8. 922.999 5,944.383 ↑ 1.2 336,339 1

Hash Left Join (cost=102.17..308,981.00 rows=413,123 width=869) (actual time=1.501..5,944.383 rows=336,339 loops=1)

  • Hash Cond: (docdeu.consdocdeu = sn.consdocdeu)
  • Filter: ((sn.conspolitica IS NULL) OR ((sn.estado_neg)::text = ANY ('{C,RC}'::text[])) OR (docdeu.meses_transcurridos_neg IS NOT NULL))
  • Rows Removed by Filter: 667
9. 5,020.230 5,020.230 ↑ 2.7 336,923 1

Seq Scan on docdeu (cost=0.00..298,543.90 rows=917,687 width=861) (actual time=0.126..5,020.230 rows=336,923 loops=1)

  • Filter: (estado = 'A'::bpchar)
  • Rows Removed by Filter: 183191
10. 0.655 1.154 ↑ 1.1 1,253 1

Hash (cost=85.41..85.41 rows=1,341 width=18) (actual time=1.151..1.154 rows=1,253 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 78kB
11. 0.499 0.499 ↑ 1.1 1,253 1

Seq Scan on segui_negociaciones sn (cost=0.00..85.41 rows=1,341 width=18) (actual time=0.013..0.499 rows=1,253 loops=1)

12. 215.459 825.305 ↑ 1.0 244,756 1

Hash (cost=15,955.56..15,955.56 rows=244,756 width=77) (actual time=825.305..825.305 rows=244,756 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 28896kB
13. 609.846 609.846 ↑ 1.0 244,756 1

Seq Scan on nits (cost=0.00..15,955.56 rows=244,756 width=77) (actual time=0.068..609.846 rows=244,756 loops=1)

14. 0.088 0.300 ↑ 1.0 157 1

Hash (cost=5.57..5.57 rows=157 width=22) (actual time=0.300..0.300 rows=157 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
15. 0.212 0.212 ↑ 1.0 157 1

Seq Scan on tipdoc (cost=0.00..5.57 rows=157 width=22) (actual time=0.089..0.212 rows=157 loops=1)

16. 0.054 0.199 ↑ 1.3 30 1

Hash (cost=4.40..4.40 rows=40 width=38) (actual time=0.199..0.199 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
17. 0.145 0.145 ↑ 1.3 30 1

Seq Scan on condonacion_politica cp (cost=0.00..4.40 rows=40 width=38) (actual time=0.093..0.145 rows=30 loops=1)

18. 0.042 0.071 ↑ 1.0 36 1

Hash (cost=1.36..1.36 rows=36 width=46) (actual time=0.071..0.071 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
19. 0.029 0.029 ↑ 1.0 36 1

Seq Scan on tipo_documento_itau (cost=0.00..1.36 rows=36 width=46) (actual time=0.023..0.029 rows=36 loops=1)

20. 0.077 0.266 ↑ 1.2 132 1

Hash (cost=6.65..6.65 rows=165 width=25) (actual time=0.265..0.266 rows=132 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
21. 0.189 0.189 ↑ 1.2 132 1

Seq Scan on estcob (cost=0.00..6.65 rows=165 width=25) (actual time=0.025..0.189 rows=132 loops=1)

22. 0.057 0.469 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=43) (actual time=0.469..0.469 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
23. 0.412 0.412 ↑ 1.0 40 1

Seq Scan on subsegmento_itau (cost=0.00..1.40 rows=40 width=43) (actual time=0.406..0.412 rows=40 loops=1)

24. 0.342 0.684 ↑ 1.0 504 1

Hash (cost=14.04..14.04 rows=504 width=65) (actual time=0.684..0.684 rows=504 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
25. 0.342 0.342 ↑ 1.0 504 1

Seq Scan on actividad_itau (cost=0.00..14.04 rows=504 width=65) (actual time=0.027..0.342 rows=504 loops=1)