explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tbsW

Settings
# exclusive inclusive rows x rows loops node
1. 4.583 1,017.099 ↓ 181.4 5,805 1

Nested Loop Anti Join (cost=133.39..68,066.49 rows=32 width=1,003) (actual time=782.290..1,017.099 rows=5,805 loops=1)

2. 7.990 982.046 ↓ 184.7 6,094 1

Nested Loop (cost=132.98..68,049.87 rows=33 width=1,003) (actual time=782.271..982.046 rows=6,094 loops=1)

3. 39.621 955.774 ↓ 127.0 6,094 1

Nested Loop (cost=132.83..68,040.50 rows=48 width=968) (actual time=782.251..955.774 rows=6,094 loops=1)

4. 48.899 296.073 ↓ 7.6 38,755 1

Nested Loop (cost=132.28..59,407.60 rows=5,098 width=807) (actual time=5.987..296.073 rows=38,755 loops=1)

5. 29.598 34.054 ↓ 3.3 13,320 1

Bitmap Heap Scan on fin_documento findoc (cost=131.72..11,983.24 rows=4,023 width=149) (actual time=5.948..34.054 rows=13,320 loops=1)

  • Recheck Cond: ((cd_empresa = 30) AND (cd_filial = 30) AND (id_cr_cp = 'R'::bpchar))
  • Filter: (id_provisao = 'N'::bpchar)
  • Heap Blocks: exact=4282
6. 4.456 4.456 ↓ 3.3 13,320 1

Bitmap Index Scan on ale_idx (cost=0.00..130.72 rows=4,023 width=0) (actual time=4.456..4.456 rows=13,320 loops=1)

  • Index Cond: ((cd_empresa = 30) AND (cd_filial = 30) AND (id_cr_cp = 'R'::bpchar))
7. 213.120 213.120 ↓ 1.5 3 13,320

Index Scan using fin_doc_parcela_pk on fin_doc_parcela findocpar (cost=0.56..11.77 rows=2 width=658) (actual time=0.012..0.016 rows=3 loops=13,320)

  • Index Cond: ((cd_empresa = 30) AND (cd_base = findoc.cd_base) AND (seq_processo = findoc.seq_processo))
  • Filter: (id_situacao_eletronica = ANY ('{0,9}'::bpchar[]))
8. 620.080 620.080 ↓ 0.0 0 38,755

Index Scan using fin_doc_parcela_mov_idx3 on fin_doc_parcela_mov findocparmov (cost=0.56..1.68 rows=1 width=161) (actual time=0.015..0.016 rows=0 loops=38,755)

  • Index Cond: ((cd_empresa = 30) AND (cd_base_orig = findocpar.cd_base) AND (seq_processo_orig = findocpar.seq_processo) AND ((parcela_orig)::text = (findocpar.parcela)::text))
  • Filter: ((dt_movimento >= to_date('2018-10-01'::text, 'yyyy-MM-dd'::text)) AND (dt_movimento <= to_date('2019-01-04'::text, 'yyyy-MM-dd'::text)))
  • Rows Removed by Filter: 2
9. 18.282 18.282 ↑ 1.0 1 6,094

Index Scan using operacao_financ_pk on operacao_financ opefin (cost=0.14..0.19 rows=1 width=35) (actual time=0.003..0.003 rows=1 loops=6,094)

  • Index Cond: (cd_operacao = findocparmov.cd_operacao)
  • Filter: (((id_tipo_operacao)::text <> 'EP'::text) AND ((id_tipo_operacao)::text = ANY ('{BD,AD,FI,IN,EM,EP,BN,SB,TE,DV,SE,BT,PG,EC,TS,BA}'::text[])))
10. 30.470 30.470 ↓ 0.0 0 6,094

Index Only Scan using processo_canc_pk on processo_canc procan (cost=0.41..0.50 rows=1 width=24) (actual time=0.005..0.005 rows=0 loops=6,094)

  • Index Cond: ((cd_empresa = findocparmov.cd_empresa) AND (cd_empresa = 30) AND (cd_base = findocparmov.cd_base) AND (seq_processo = findocparmov.seq_processo))
  • Heap Fetches: 289