explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FYTv : Optimization for: plan #miOf

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.048 863.513 ↑ 252.5 24 1

Hash Left Join (cost=2,764.95..7,352.21 rows=6,061 width=3,036) (actual time=860.913..863.513 rows=24 loops=1)

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

Hash Left Join (cost=2,744.61..7,114.94 rows=2,405 width=3,028) (actual time=860.622..863.206 rows=24 loops=1)

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

Hash Left Join (cost=2,742.71..7,090.19 rows=2,405 width=3,152) (actual time=860.547..863.080 rows=24 loops=1)

  • Hash Cond: ((docdeu.tipdoc)::text = (tipdoc.tipdoc)::text)
4. 0.079 862.806 ↑ 100.2 24 1

Nested Loop (cost=2,735.22..7,055.04 rows=2,405 width=3,190) (actual time=860.297..862.806 rows=24 loops=1)

5. 0.326 862.223 ↑ 100.2 24 1

Hash Right Join (cost=2,734.80..2,909.66 rows=2,405 width=3,070) (actual time=860.196..862.223 rows=24 loops=1)

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

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

7. 0.217 859.987 ↑ 133.6 18 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 47kB
8. 859.770 859.770 ↑ 133.6 18 1

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

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

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

  • Index Cond: (nit = docdeu.nit)
10. 0.036 0.114 ↑ 1.0 155 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
11. 0.078 0.078 ↑ 1.0 155 1

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

12. 0.018 0.040 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=2) (actual time=0.040..0.040 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
13. 0.022 0.022 ↑ 1.0 40 1

Seq Scan on subsegmento_itau (cost=0.00..1.40 rows=40 width=2) (actual time=0.016..0.022 rows=40 loops=1)

14. 0.089 0.259 ↑ 1.0 504 1

Hash (cost=14.04..14.04 rows=504 width=4) (actual time=0.259..0.259 rows=504 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
15. 0.170 0.170 ↑ 1.0 504 1

Seq Scan on actividad_itau (cost=0.00..14.04 rows=504 width=4) (actual time=0.032..0.170 rows=504 loops=1)

Planning time : 2.798 ms
Execution time : 863.836 ms