explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cveU

Settings
# exclusive inclusive rows x rows loops node
1. 0.098 1.221 ↓ 18.1 452 1

Hash Join (cost=342.72..433.25 rows=25 width=153) (actual time=1.006..1.221 rows=452 loops=1)

  • Hash Cond: ((re12_sintetizacao_apuracoes_creditos.re12_nat_bc_cred)::text = (cd05a_base_calculo_credito.cd05a_codigo)::text)
2. 0.068 1.114 ↓ 18.1 452 1

Hash Join (cost=341.31..431.52 rows=25 width=92) (actual time=0.993..1.114 rows=452 loops=1)

  • Hash Cond: (re12_sintetizacao_apuracoes_creditos.re12_id_filial = cd00b.cd00b_id)
3. 0.266 0.266 ↑ 1.0 494 1

Seq Scan on re12_sintetizacao_apuracoes_creditos (cost=0.00..88.10 rows=494 width=36) (actual time=0.210..0.266 rows=494 loops=1)

  • Filter: ((re12_mes_competencia = 7) AND (re12_ano_competencia = 2,020))
  • Rows Removed by Filter: 2,846
4. 0.032 0.780 ↓ 12.1 169 1

Hash (cost=341.14..341.14 rows=14 width=68) (actual time=0.780..0.780 rows=169 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
5. 0.005 0.748 ↓ 12.1 169 1

Nested Loop Left Join (cost=24.51..341.14 rows=14 width=68) (actual time=0.028..0.748 rows=169 loops=1)

6. 0.036 0.067 ↓ 12.1 169 1

Hash Join (cost=23.65..30.55 rows=14 width=42) (actual time=0.020..0.067 rows=169 loops=1)

  • Hash Cond: (cd00b.cd00b_id_empresa = cd01.cd01_id)
7. 0.016 0.016 ↑ 1.0 273 1

Seq Scan on cd00b_filial cd00b (cost=0.00..5.73 rows=273 width=20) (actual time=0.003..0.016 rows=273 loops=1)

8. 0.001 0.015 ↑ 1.0 1 1

Hash (cost=23.64..23.64 rows=1 width=38) (actual time=0.015..0.015 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.001 0.014 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..23.64 rows=1 width=38) (actual time=0.013..0.014 rows=1 loops=1)

10. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on cd01_empresa cd01 (cost=0.00..1.25 rows=1 width=12) (actual time=0.002..0.003 rows=1 loops=1)

  • Filter: (cd01_numero = 2)
  • Rows Removed by Filter: 19
11. 0.001 0.010 ↑ 1.0 1 1

Nested Loop (cost=0.85..22.38 rows=1 width=34) (actual time=0.009..0.010 rows=1 loops=1)

12. 0.005 0.005 ↑ 4.0 1 1

Index Scan using pk_cd06b_id on cd06b_participante cd06b_participante_1 (cost=0.43..20.46 rows=4 width=42) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (cd06b_id = cd01.cd01_id)
13. 0.004 0.004 ↑ 1.0 1 1

Index Scan using cd06a_unq_cd06a_revisao on cd06a_participante_revisao cd06a_participante_revisao_1 (cost=0.43..0.47 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (cd06a_revisao = cd06b_participante_1.cd06b_revisao)
  • Filter: (cd06b_participante_1.cd06b_id = cd06a_id)
14. 0.099 0.676 ↑ 1.0 1 169

Nested Loop (cost=0.85..22.18 rows=1 width=34) (actual time=0.004..0.004 rows=1 loops=169)

15. 0.338 0.338 ↑ 4.0 1 169

Index Scan using pk_cd06b_id on cd06b_participante (cost=0.43..20.26 rows=4 width=42) (actual time=0.001..0.002 rows=1 loops=169)

  • Index Cond: (cd06b_id = cd00b.cd00b_id)
16. 0.239 0.239 ↑ 1.0 1 239

Index Scan using cd06a_unq_cd06a_revisao on cd06a_participante_revisao (cost=0.43..0.47 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=239)

  • Index Cond: (cd06a_revisao = cd06b_participante.cd06b_revisao)
  • Filter: (cd06b_participante.cd06b_id = cd06a_id)
17. 0.003 0.009 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=56) (actual time=0.009..0.009 rows=18 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
18. 0.006 0.006 ↑ 1.0 18 1

Seq Scan on cd05a_base_calculo_credito (cost=0.00..1.18 rows=18 width=56) (actual time=0.004..0.006 rows=18 loops=1)

Planning time : 4.320 ms
Execution time : 1.376 ms