explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kDYD

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,898.818 ↓ 0.0 0 1

Limit (cost=24,470.24..86,818.48 rows=61 width=70) (actual time=1,898.818..1,898.818 rows=0 loops=1)

2. 0.000 1,898.817 ↓ 0.0 0 1

Nested Loop Anti Join (cost=24,470.24..86,818.48 rows=61 width=70) (actual time=1,898.817..1,898.817 rows=0 loops=1)

3. 0.001 1,898.817 ↓ 0.0 0 1

Nested Loop (cost=24,469.83..86,789.75 rows=65 width=94) (actual time=1,898.817..1,898.817 rows=0 loops=1)

4. 35.084 1,898.816 ↓ 0.0 0 1

Nested Loop (cost=24,469.40..86,686.62 rows=65 width=102) (actual time=1,898.816..1,898.816 rows=0 loops=1)

5. 29.108 1,039.824 ↓ 8.7 137,318 1

Nested Loop (cost=24,468.97..64,667.11 rows=15,770 width=34) (actual time=770.763..1,039.824 rows=137,318 loops=1)

6. 0.056 0.056 ↑ 1.0 1 1

Index Scan using pessoa_empresa_financ_pk on pessoa_empresa_financ pesempfin (cost=0.12..8.14 rows=1 width=16) (actual time=0.054..0.056 rows=1 loops=1)

  • Filter: (id_utiliza_juros_cap = 'S'::bpchar)
7. 245.220 1,010.660 ↓ 8.7 137,318 1

Bitmap Heap Scan on fin_doc_parcela findocpar (cost=24,468.85..64,501.27 rows=15,770 width=30) (actual time=770.702..1,010.660 rows=137,318 loops=1)

  • Recheck Cond: ((vl_saldo > '0'::numeric) AND (dt_vencimento >= pesempfin.dt_ini_rotina_jur) AND (dt_vencimento <= pesempfin.dt_fim_rotina_jur))
  • Filter: ((id_situacao_eletronica = ANY ('{0,9}'::bpchar[])) AND (pesempfin.cd_empresa = cd_empresa))
  • Rows Removed by Filter: 424
  • Heap Blocks: exact=17061
8. 8.012 765.440 ↓ 0.0 0 1

BitmapAnd (cost=24,468.85..24,468.85 rows=15,771 width=0) (actual time=765.440..765.440 rows=0 loops=1)

9. 39.553 39.553 ↑ 1.0 138,146 1

Bitmap Index Scan on fin_doc_parcela_idx2 (cost=0.00..7,509.00 rows=141,943 width=0) (actual time=39.553..39.553 rows=138,146 loops=1)

  • Index Cond: (vl_saldo > '0'::numeric)
10. 717.875 717.875 ↓ 8.7 2,228,540 1

Bitmap Index Scan on fin_doc_parcela_idx1 (cost=0.00..16,920.17 rows=255,574 width=0) (actual time=717.875..717.875 rows=2,228,540 loops=1)

  • Index Cond: ((dt_vencimento >= pesempfin.dt_ini_rotina_jur) AND (dt_vencimento <= pesempfin.dt_fim_rotina_jur))
11. 823.908 823.908 ↓ 0.0 0 137,318

Index Scan using fin_doc_parcela_transf_pk on fin_doc_parcela_transf findocpartra (cost=0.42..1.39 rows=1 width=70) (actual time=0.006..0.006 rows=0 loops=137,318)

  • Index Cond: ((cd_empresa = findocpar.cd_empresa) AND (cd_base = findocpar.cd_base) AND (seq_processo = findocpar.seq_processo) AND ((parcela)::text = (findocpar.parcela)::text))
  • Filter: (id_rever_juros_cap = 'S'::bpchar)
  • Rows Removed by Filter: 0
12. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fin_documento_pk on fin_documento findoc (cost=0.43..1.58 rows=1 width=24) (never executed)

  • Index Cond: ((cd_empresa = findocpar.cd_empresa) AND (cd_base = findocpar.cd_base) AND (seq_processo = findocpar.seq_processo))
  • Heap Fetches: 0
13. 0.000 0.000 ↓ 0.0 0

Index Only Scan using processo_canc_pk on processo_canc procan (cost=0.42..0.44 rows=1 width=24) (never executed)

  • Index Cond: ((cd_empresa = findoc.cd_empresa) AND (cd_base = findoc.cd_base) AND (seq_processo = findoc.seq_processo))
  • Heap Fetches: 0