explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RqM

Settings
# exclusive inclusive rows x rows loops node
1. 1.332 883.421 ↑ 1.0 1 1

Aggregate (cost=79,009.73..79,009.74 rows=1 width=8) (actual time=883.421..883.421 rows=1 loops=1)

2. 7.909 882.089 ↓ 215.0 5,805 1

Nested Loop Anti Join (cost=9,752.93..79,009.66 rows=27 width=0) (actual time=666.491..882.089 rows=5,805 loops=1)

3. 5.249 849.804 ↓ 217.6 6,094 1

Nested Loop (cost=9,752.51..78,995.26 rows=28 width=24) (actual time=666.473..849.804 rows=6,094 loops=1)

4. 25.739 826.273 ↓ 152.3 6,094 1

Nested Loop (cost=9,752.37..78,987.45 rows=40 width=32) (actual time=666.456..826.273 rows=6,094 loops=1)

5. 20.680 296.719 ↓ 7.8 38,755 1

Nested Loop (cost=9,751.81..70,581.33 rows=4,976 width=43) (actual time=79.226..296.719 rows=38,755 loops=1)

6. 25.293 102.879 ↓ 3.2 13,320 1

Bitmap Heap Scan on fin_documento findoc (cost=9,751.25..21,878.03 rows=4,139 width=24) (actual time=79.173..102.879 rows=13,320 loops=1)

  • Recheck Cond: ((cd_filial = 30) AND (id_cr_cp = 'R'::bpchar) AND (cd_empresa = 30))
  • Filter: (id_provisao = 'N'::bpchar)
  • Heap Blocks: exact=4287
7. 1.637 77.586 ↓ 0.0 0 1

BitmapAnd (cost=9,751.25..9,751.25 rows=4,139 width=0) (actual time=77.586..77.586 rows=0 loops=1)

8. 7.532 7.532 ↑ 1.7 13,386 1

Bitmap Index Scan on fin_documento_idx1 (cost=0.00..916.98 rows=22,781 width=0) (actual time=7.532..7.532 rows=13,386 loops=1)

  • Index Cond: ((cd_filial = 30) AND (id_cr_cp = 'R'::bpchar))
9. 68.417 68.417 ↑ 1.0 300,393 1

Bitmap Index Scan on fin_documento_pk (cost=0.00..8,831.96 rows=311,404 width=0) (actual time=68.417..68.417 rows=300,393 loops=1)

  • Index Cond: (cd_empresa = 30)
10. 173.160 173.160 ↓ 1.5 3 13,320

Index Scan using fin_doc_parcela_pk on fin_doc_parcela findocpar (cost=0.56..11.75 rows=2 width=27) (actual time=0.009..0.013 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[]))
11. 503.815 503.815 ↓ 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=51) (actual time=0.012..0.013 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
12. 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=8) (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[])))
13. 24.376 24.376 ↓ 0.0 0 6,094

Index Only Scan using processo_canc_pk on processo_canc procan (cost=0.41..0.51 rows=1 width=24) (actual time=0.004..0.004 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